November 19, 2007 at 1:44 pm
Is that a database- or server-level permission?
TIA,
Barkingdog
November 19, 2007 at 3:13 pm
Best I can tell it is a server level permission.
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
November 19, 2007 at 11:55 pm
It's a server-wide permission. Traces aren't database objects, they trace the entire instance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 20, 2007 at 5:49 pm
The Permissions topic lists all the potential permissions in a useful chart. It includes permissions like ALTER TRACE (object: server, as previously mentioned) which you won't find in the Permissions Hierarchy.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply