meta user
network profile
| bio | website | |
|---|---|---|
| location | Brisbane, Australia | |
| age | ||
| visits | member for | 1 year, 9 months |
| seen | 2 hours ago | |
| stats | profile views | 6 |
|
May 13 |
awarded | Caucus |
|
Jan 8 |
awarded | Popular Question |
|
Nov 22 |
comment |
Audit user queries on SQL Server 2005 Thanks @Marian. I have used trace events at least in the short term, because it can capture the cache insert and cache miss events. As we're primarily worried about ad hoc queries, this will presumably capture at least the first instance of the query being run. If the hit rate is too low we'll bump it up to server side traces. |
|
Nov 22 |
accepted | Audit user queries on SQL Server 2005 |
|
Nov 15 |
asked | Audit user queries on SQL Server 2005 |
|
Nov 8 |
accepted | Audit 'sa' login in SQL Server 2005 |
|
Nov 8 |
comment |
Audit 'sa' login in SQL Server 2005 Thanks Mike, I was ignorant of logon triggers. I agree with everything you have mentioned, but unfortunately don't have control of version upgrades or changing the 'sa' password, which is why I'm in the situation that this needs to be auditted. |
|
Nov 8 |
awarded | Commentator |
|
Nov 8 |
comment |
TSQL Trigger Incorrect Syntax Your insert into syntax also appears to be incorrect - you may want to review the syntax on Books On Line. |
|
Nov 8 |
comment |
TSQL Trigger Incorrect Syntax Have you tried removing the semicolons after the option (maxrecursion 1000) ? |
|
Nov 8 |
answered | Reset all IDs in a Large Table |
|
Nov 8 |
asked | Audit 'sa' login in SQL Server 2005 |
|
Aug 2 |
awarded | Yearling |
|
Jul 13 |
revised |
“Prelogin failure” when attempting to run stored procedure across linked server added 186 characters in body |
|
Jul 13 |
asked | “Prelogin failure” when attempting to run stored procedure across linked server |
|
Jul 12 |
comment |
I run sp_who on the database, and there is a “TASK MANAGER” process. What is it? AFAIK Task Manager as it's a system SPID would not take up a user connection to the DB. Someone more knowledgeable than me may be able to confirm this. Do you have sql server agent running on this instance? From memory this counts as a 'user connection' and can interfere with single user mode. |
|
Jun 27 |
awarded | Revival |
|
Jun 15 |
asked | Lock timeout on user tables traced back to system processes |
|
Jun 8 |
awarded | Constituent |
|
Jun 8 |
awarded | Caucus |
