What are you trying to do?
>
>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
--sb--