>>>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!


Wierd, Im glad its working for you now.