Viewing 5 posts - 1 through 5 (of 5 total)
Thank you for your help everyone!
This was much appreciated!
Great Forum!
November 7, 2007 at 8:09 am
Ok, Thanks, It worked with the command
" ALTER DATABASE mydatabase SET TRUSTWORTHY ON "
But I still have one little problem... This is only working when my user is...
November 6, 2007 at 1:28 pm
So I can ONLY see my process when I expect to see all the process...
So the Execute as 'dbo' don't work like it should... do you have an idea why?
Thanks
November 6, 2007 at 8:30 am
>> I tried using "CREATE PROCEDURE [dbo].[ ]
WITH EXECUTE AS 'dbo'" but Select on sys.SysProcesses always return an empty rowset...
Sorry, for Select * from sys.SYSPROCESSES
the rowset is not empty......
November 2, 2007 at 8:21 am
>> If you're using SQL Server 2005, you should get away from using the sysusers table >>and other system objects from SQL Server 2000 as they are deprecated.
Since they are...
November 2, 2007 at 8:03 am
Viewing 5 posts - 1 through 5 (of 5 total)