User With Sysadmin fixed server role

[karthik555]

Hi!
I need to create a user with Sysadmin fixed server role(so that the user can use SQL Profiler). However I want to prevent the user from creating and dropping databases. Is that possible?

Thanks in advance
Karthik

 

[osjohnm]

Hi

I don't think that you will be able to achieve this as any member of the sysadmin server role can do anything in sql server.

Maybe you can look at some of the other fixed server roles that might allow you to run profiler without being in the sysadmin role.

Hope that helps

John

 

[karthik555]

Thanks John.

But the error message of Profiler is very clear.
"In order to run a trace against a SQL Server you have to be member of sysadmin fixed server role"

Any way let me try something else.
Thanks for your reply.
Karthik