Viewing 2 posts - 1 through 2 (of 2 total)
I got it working by adding a 5th single quote to the line:
FROM #DBFRAGMENT where ltrim(rtrim(#DBFRAGMENT.indexname))<> ''''
Dave H
August 28, 2005 at 11:06 pm
#585740
Try
Exec master..xp_cmdshell 'Echo %USERNAME%'
and see what is returned
Dave Henderson
August 23, 2005 at 6:52 pm
#584438