'Insight.database executing sql function
To execute sql function or procedure Insight database in the guts executes a query to get info about stored procedures or function and its parameters. But in the case of sql function query returns the first parameter name empty.
for example:
exec sp_executesql N'SELECT ParameterName = p.Name, SchemaName = s.name, TypeName = t.Name
FROM sys.parameters p
LEFT JOIN sys.types t ON (p.user_type_id = t.user_type_id)
LEFT JOIN sys.schemas s ON (t.schema_id = s.schema_id)
WHERE p.object_id = OBJECT_ID(@Name)',N'@Name nvarchar(4000)', @Name=N'dbo.FuncName'
This query returns parameters list, but first parameter is empty. In this case Insight.Database fails to execute query.
Is there a way to resolve it without using adapter?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
