>>Hi everybody,
>>
>>Ok, I was running some selects in Query Analyzer. Then I added SET STATISTICS TIME ON at the top and ran them again (and saw some statistics). Then I switched to some other tasks. Moments later I came back, using Edit menu replaced Sm to SM and tried to run them again. No I'm getting error: Access is denied. You must be Database Administrator to proceed.
>>
>>What gives? And more importantly, how can I get rid of it?
>>
>>Thanks a lot in advance.
>
>
>What user are you connecting to the server with? Can you connect to the db with the Enterprise Manager?
When I closed Query Analyzer and re-opened it, the problem went away by itself. Weird indeed!
If it's not broken, fix it until it is.
My Blog