389 reputation
113
bio website
location New Zealand
age
visits member for 2 years, 1 month
seen Apr 13 at 20:38

Mar
28
awarded  Popular Question
Mar
6
accepted How to script data in deterministic order
Mar
5
comment How to script data in deterministic order
@KennethFisher, sorry, what table?
Mar
4
answered How to script data in deterministic order
Mar
3
comment How to script data in deterministic order
Thank you. It does not appear that opendbdiff can script data.
Mar
3
asked How to script data in deterministic order
Jan
31
awarded  Popular Question
Nov
11
accepted Is there a way to generate table create script in TSQL?
Nov
11
revised Is there a way to generate table create script in TSQL?
deleted 2 characters in body
Nov
10
asked Is there a way to generate table create script in TSQL?
Oct
25
comment How to find what prevented in getting a lock?
Run SQL profiler. Note time when timeout happens. Look at the profiler log to see what else was running at exactly the same time. If you don't have any long running locks, you should be able to identify it pretty quickly.
Sep
3
awarded  Popular Question
Aug
15
accepted How to create a trigger in a different database?
Aug
15
comment How to create a trigger in a different database?
@AaronBertrand, there are 50 databases with the same schema on the same server installed as a part of third party software package. They all have the same structure. I need to create a trigger on the same table in all of them. I need to do it in response on the database restore event, since database restores are frequent thing that the software package does. I can detect the event easily with SQL Alerts and execute a job that executes an SP in response. This part I have no problem with. But I can't figure out how to create a trigger.
Aug
15
revised How to create a trigger in a different database?
deleted 1 characters in body
Aug
15
revised How to create a trigger in a different database?
added 837 characters in body
Aug
15
asked How to create a trigger in a different database?
Aug
1
accepted is it possible to pass the message from sp_add_alert to the job?
Jul
31
answered is it possible to pass the message from sp_add_alert to the job?
Jul
30
revised is it possible to pass the message from sp_add_alert to the job?
added 40 characters in body