Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to do a Trace without being SA(sql2000)
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00537354
Message ID:
00537489
Vues:
17
This message has been marked as a message which has helped to the initial question of the thread.
From BOL:

With Windows Authentication mode, the user account that runs SQL Profiler must be granted permission to connect to an instance of SQL Server. The login account also must be granted permissions to execute SQL Profiler stored procedures.

One of those stored procedures is sp_trace_create which, according to the BOL, requires the caller to be a member of the sysadmins group.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform