>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
File?
What file?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.