Reputation
414
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 6 15
Impact
~35k people reached

Apr
9
comment Cross-database call fails in a job but succeeds in SSMS
Thank you for this, but you seem to be just repeating my answer in different words. Is there anything different in what you are saying that I missed?
Feb
22
awarded  Notable Question
Feb
20
awarded  Notable Question
Feb
18
awarded  Popular Question
Jan
20
awarded  Yearling
Jan
15
awarded  Famous Question
Jul
15
awarded  Notable Question
Jul
2
awarded  Curious
Jun
5
awarded  Notable Question
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.