Reputation
252
Top tag
Next privilege 300 Rep.
Create new tags
Badges
3 11
Newest
 Critic
Impact
~8k people reached

  • 0 posts edited
  • 0 helpful flags
  • 17 votes cast
Mar
5
comment How to see the value of a variable being used in an sql statement during a server trace?
Here is the code I used to test this sp in SSMS: declare @@oldcust_id varchar(10) set @@oldcust_id = 'daf' exec sp_trace_generateevent 82, N'@oldcust_id', cast(@oldcust_id as varbinary(8000));
Mar
5
asked How to see the value of a variable being used in an sql statement during a server trace?
Mar
5
asked Find old linked servers on a restored copy of master/msdb db
Feb
9
answered Is it possible to view the maintenance plans created in SQL Server 2000 in SSMS 2005?
Feb
9
asked Is it possible to view the maintenance plans created in SQL Server 2000 in SSMS 2005?
Nov
21
accepted Do I trace an Active Directory group based database login the same way as an AD user based login on SQL Server?
Nov
21
comment Do I trace an Active Directory group based database login the same way as an AD user based login on SQL Server?
Thanks Brian. I did two simultaneous traces, one for the group and the other for one of the users in the group and the results are consistent with your answer. Group returned nothing, but there were activities on the user login. Thanks for the suggestion as well, though I'd change the example from 'domain\groupname', 'all' to 'domain\username', 'all'. What I am gonna do is to trace a typical user in the group and base the permissions on that user.
Nov
21
awarded  Supporter
Nov
21
awarded  Student
Nov
21
asked Do I trace an Active Directory group based database login the same way as an AD user based login on SQL Server?
Oct
17
awarded  Scholar
Oct
17
accepted How do I change the text in the export format dropdown on SQL Reporting server
Oct
14
awarded  Editor
Oct
14
revised How do I change the text in the export format dropdown on SQL Reporting server
deleted 2 characters in body
Oct
14
answered How do I change the text in the export format dropdown on SQL Reporting server
Oct
13
asked How do I change the text in the export format dropdown on SQL Reporting server