How do I test a Table-Valued Function in SQL Server Management Studio?

you want to use FROM

E.g :

select ...    FROM fn_GetConfigurationByProfile('DEFAULTPROFILE')

sql sql-server user-defined-functions

try this

SELECT * FROM dbo.fn_GetConfigurationByProfile('DEFAULTPROFILE')

sql sql-server user-defined-functions

SELECT *FROM dbo.fn_GetConfigurationByProfile('DEFAULTPROFILE')

CodeHunter