Viewing 5 posts - 1 through 5 (of 5 total)
From the SQL Server Standard magazine:
"Generally the use of the sp_OA stored procedures are avoided whenever possible because their improper use can lead to access violations or memory leaks or...
June 2, 2004 at 5:05 am
Hi Victor,
Very good article.
But I have one question: this scripts run on the database server, isn't it? I know that this store procedures (sp_trace_xxx) use less server resources than does...
June 13, 2003 at 11:33 am
No, he isn't sysadmin. He is dbowner of test database. He don't have any permission on master.
March 21, 2003 at 1:28 pm
That's what I have done.
Sorry about the mistake, one should read deny instead of revoke in my previous post!!!
March 21, 2003 at 9:46 am
Do not Deny access in an Clustered Instance because you also will deny the cluster service account that you have to add. Just remove the group BUILTIN\Administrator.
March 14, 2003 at 10:44 pm
Viewing 5 posts - 1 through 5 (of 5 total)