I have a problem with my SQL 2005 Express server that I have installed yesterday on XP SP2. Everything was working fine up to an hour ago, but now not even a select * from is successful. I have no idea what I did to make this happen.
I want to use xp_cmdshell in a trigger. In SQL 2005 you have to activate this before you can use. So I clicked the check box in SQL Server Surface Area Configuration tool. Then I got an access denied for xp_cmdshell. Searching the net I found the following code and tried to run it:
GRANT EXECUTE ON sys.xp_cmdshell TO MyUser;
I received: Cannot find the user 'MyUser', because it does not exist or you do not have permission ( I am logged in as 'sa').
Then I ran: GRANT CONTROL SERVER TO MyLogin; which seemed to be successful.
But now I can't even do a simple SELECT * FROM tablename or SELECT * FROM dbo.tablename. I always receive:
Invalid object name '<tablename>'.
I have no clue, what to do to make the server work again.
Any help would be greatly appreciated. Thanks in advance!