exec sp_executesql 
 @statement=N'EXECUTE AI.USP_GetCodeObjects @I_ObjectList',
 @params=N'@I_ObjectList AI.UDT_StringArray readonly', -- Should include schema name
 @I_ObjectList=@p3

exec sp_executesql 
 @statement=N'EXECUTE AI.USP_GetCodeObjects @I_ObjectList',
 @params=N'@I_ObjectList UDT_StringArray readonly', -- Missing schema name
 @I_ObjectList=@p3

-- Create a schema other than dbo
CREATE SCHEMA AI;
-- Create a UDT in the AI schema
CREATE TYPE AI.UDT_StringArray AS TABLE(
 [Name] [sysname] NOT NULL
);
-- Create a stored procedure that uses the UDT
CREATE PROCEDURE AI.USP_TestProcedure
 @InputList AI.UDT_StringArray READONLY
AS
BEGIN
 SELECT Name FROM @InputList;
END

import * as sql from 'mssql';
async function testTVPBug() {
 const config = {
 user: 'your_username',
 password: 'your_password',
 server: 'your_server',
 database: 'your_database',
 options: {
 encrypt: true,
 trustServerCertificate: true
 }
 };
 try {
 const pool = await sql.connect(config);
 const request = pool.request();
 // Create TVP with schema-qualified name
 const tvp = new sql.Table('AI.UDT_StringArray');
 tvp.columns.add('Name', sql.NVarChar(128), { nullable: false });
 tvp.rows.add('TestValue1');
 tvp.rows.add('TestValue2');
 // Add TVP parameter - this is where the bug occurs
 request.input('InputList', tvp);
 // Execute the stored procedure
 const result = await request.execute('AI.USP_TestProcedure');
 console.log('Success:', result);
 } catch (error) {
 console.error('Error:', error.message);
 // Error: Cannot find data type UDT_StringArray
 }
}
testTVPBug();

// Approach 1: Using sql.TVP
request.input('InputList', sql.TVP('AI.UDT_StringArray'), tvp);
// Approach 2: Using explicit type
const tvpType = new sql.TVP('AI.UDT_StringArray');
request.input('InputList', tvpType, tvp);

const valuesList = names.map(name => `(N'${name.replace(/'/g, "''")}')`).join(',');
const query = `
 DECLARE @InputList AI.UDT_StringArray;
 INSERT INTO @InputList (Name) VALUES ${valuesList};
 EXECUTE AI.USP_TestProcedure @InputList;
`;
const result = await request.query(query);