Azure SQL Database on Central US region.
If you take some of the SQL presented in these samples and put them inside a SP:
CREATE PROCEDURE vector_sample AS
BEGIN
DROP TABLE IF EXISTS dbo.Products;
CREATE TABLE dbo.Products (
Id int PRIMARY KEY,
EmbeddingVector vector(1536) -- Native vector type
);
DROP INDEX IF EXISTS IX_Products_EmbeddingVector ON dbo.Products;
CREATE VECTOR INDEX IX_Products_EmbeddingVector
ON dbo.Products(EmbeddingVector)
WITH (METRIC = 'COSINE');
END;
...you will get the following error:
Query 1 ERROR at Line 1: : Msg: 2571, Line 13, State: 3, Level: 14
User 'dbo' does not have permission to run DBCC TRACEON.
Msg: 42234, Line 13, State: 1, Level: 16
DiskANN vector index build failed with an internal error 200.
Seems to be an issue creating vector indexes on Azure SQL via stored procedures.
Azure SQL Database on Central US region.
If you take some of the SQL presented in these samples and put them inside a SP:
...you will get the following error:
Seems to be an issue creating vector indexes on Azure SQL via stored procedures.