hi,

i want to get the schema for a file on a function, I use to have this on other SP as following:-

DECLARE @RESULT VARCHAR(100);SET @RESULT=''
DECLARE @mpq int;SET @mpq=0
DECLARE @FILENAME VARCHAR(40);SET @FILENAME='parm'
SELECT @RESULT =SCHEMA_NAME((SELECT SCHEMA_ID FROM SYS.TABLES WHERE NAME=@FILENAME)+'.'
SELECT @MPQ = SELECT MPQ FROM @RESULT + 'PARM'

Thanks for any help.



Best Regards