Nov 11 2011

Grant users trace rights to SQL 2005, SQL 2008

WOW, its been over a year since I posted anything last time… I am going to try and start investing some more time into my blog, so any readers that I still have I am sorry for the long gap – its been a busy period.

Anyways back to the help – lets start with a nice easy quick one. You might remember in SQL 2000 days to give some rights to trace you needed to give the user SYSADMIN rights, well gone are those days, while it still works lets face it, its not too secure is it!

— Use this for users that are AD based

Use Master
Go
GRANT ALTER TRACE TO [DOMAIN\USERNAME]
Go

— Use this for a SQL user

Use Master
Go
GRANT ALTER TRACE TO [SQLUSERNAME]
Go
Now that user will be able to start tracing databases using SSMS and not having to be a SysAdmin!