467 reputation
313
bio website
location Brisbane, Australia
age
visits member for 2 years, 11 months
seen 7 hours ago

Jul
22
awarded  Popular Question
Jul
2
awarded  Curious
Jan
22
awarded  Popular Question
Jan
17
comment SQL Server auto-trim of varchar value in equal comparison but not like comparison
Great answer, thanks. Did not come across that first source when trying to track this down.
Jan
17
accepted SQL Server auto-trim of varchar value in equal comparison but not like comparison
Jan
16
asked SQL Server auto-trim of varchar value in equal comparison but not like comparison
Dec
8
comment Audit user queries on SQL Server 2005
Unfortunately this isn't available in SQL Server 2005, and as I mentioned I was unable to upgrade the version of SQL Server. It seems like the link only includes SQL Server 2012 functionality also. As much as I wanted to upgrade the version it wasn't an option !
Aug
2
awarded  Yearling
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