Reputation
1,913
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 14
Impact
~81k people reached

Nov
22
answered using IDENTITY column with increment -1
Nov
20
answered Response On Database Failover
Nov
20
comment SELECT Data Set Using Stored Procedure with BCP Error
Does the BCP command run if you run it direct from the command line rather than xp_cmdshell?
Nov
20
awarded  Enthusiast
Nov
20
awarded  Enlightened
Nov
19
awarded  Nice Answer
Nov
19
answered Backup SQL DataBase to C$
Nov
19
answered SQL Server 2008 R2 DDL Trigger to create DML Triggers on all new user tables
Nov
16
revised Create job to send alert using sp_send_dbmail when table value greater than x
forgot last line of answer, now added so it makes sense
Nov
16
answered Create job to send alert using sp_send_dbmail when table value greater than x
Nov
15
revised SQL Server: Simple database restore with overwrite
not happy with phrasing.....
Nov
15
answered SQL Server: Simple database restore with overwrite
Nov
14
revised How define select, if bridge pair may have 3 players?
grammer and tidied up generally
Nov
14
suggested approved edit on How define select, if bridge pair may have 3 players?
Nov
13
revised tempdb usage in SQL Server
reformatted code for clarity
Nov
13
suggested approved edit on tempdb usage in SQL Server
Nov
13
revised Restrict record to be update or deleted according to dates inside row for SQL Server 2005
fixed spelling and grammar, and hopefully made it a bit clearer.
Nov
13
suggested approved edit on Restrict record to be update or deleted according to dates inside row for SQL Server 2005
Nov
13
comment Error in SSMS when attempting to restore a database
You're welcome. And as @Marian mentions above, you'll probably want to check the other logging tables in msdb as it's likely they also contain 3 years worth of data ( sp_maintplan_delete_log , sp_purge_jobhistory and the sysmail_delete_* SPs detailed here - msdn.microsoft.com/en-us/library/ms177580(v=sql.105).aspx are probably worth investigating)
Nov
13
answered Error in SSMS when attempting to restore a database