Viewing 15 posts - 42,766 through 42,780 (of 49,552 total)
Ok, so you need the users, with their database and server roles and with the permissions that they have directly on database objects.
One database or all?
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 30, 2008 at 11:48 am
So you want to display users who are members of database and/or server roles? With the roles they are members of?
You're not interested in permissions that users may have directly...
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 30, 2008 at 11:22 am
Lynn Pettis (11/30/2008)
declare @inscnt int; -- INSERTED row count
select @inscnt = count(*) from INSERTED;
if @inscnt > 0
begin
trigger code -- trigger code goes here
end
...
Or, preferably, since the...
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 30, 2008 at 11:19 am
Jonathan Kehayias (11/30/2008)
I was completely floored when I got that kind of response the first time.
I think I've seen just about everything. From that to the "Who are you to...
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 30, 2008 at 11:00 am
Use either DBCC INPUTBUFFER or fn_get_sql in conjunction with sysprocesses. There's no simple, easy way of getting the commands on SQL 2000 though.
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 30, 2008 at 10:42 am
Jonathan Kehayias (11/30/2008)
The approved assembly list is in the Books Online at:
Thanks. I'm more asking out of curiosity. I don't tend to write CLR.
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 30, 2008 at 9:47 am
You can also read this post. I don't know if there's more info than in BoL though.
http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/
The links after each section go to the blog of one of the SQL...
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 30, 2008 at 9:36 am
You can query the sysprocesses system table.
As with many of the system tables, it's well documented in Books Online, including what each of the columns mean.
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 30, 2008 at 9:33 am
Jeff Moden (11/30/2008)
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 30, 2008 at 9:32 am
GilaMonster (11/30/2008)
Change trackingChange Data Capture
SQL Audit
Just to be clear, those are three new features in SQL 2008 that can remove the need for triggers for auditing, depending what you want...
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 30, 2008 at 9:30 am
Per Books Online:
sp_trace_setstatus [ @traceid = ] trace_id , [ @status = ] status
Arguments
[ @traceid = ] trace_id
Is the ID of the trace to be modified. trace_id is int,...
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 30, 2008 at 9:27 am
You don't have to specify a mirror, but you can. It was the same in SQL 2005. No changes in that area.
Books Online SQL 2005:
The data-access provider, whether SQL Native...
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 30, 2008 at 7:25 am
barb.wendling (11/30/2008)
I was not able to delete the trace files after the trace was stopped. Can you explain why/how to remove these files?
If the trace is stopped and closed (not...
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 30, 2008 at 6:49 am
mike (11/29/2008)
I cant see the temp table in management studio?
Temp tables are local to the connection that creates them, they cannot be affected by anyone else and they are...
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 30, 2008 at 3:52 am
Hmmm.....
I know there were some issues with the maintenance plans in SP2. They were fixed in a re-release of SP2, but you've got the initial release of the service pack....
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 30, 2008 at 3:51 am
Viewing 15 posts - 42,766 through 42,780 (of 49,552 total)