Viewing 5 posts - 1 through 5 (of 5 total)
Thank you for the advice. I am well aware of the risks SQL Profiler poses to production servers. I also prefer to use Extended Events whenever possible. However, this was...
April 27, 2018 at 9:36 am
Why not restore the database nightly and have them place their code in another database on the same instance. Then you would only need to create a database role on...
April 26, 2018 at 10:21 am
Will this get you what you are looking for? :
select fk.name as FKName,
object_name(fk.object_Id) as TableName,
object_name(o.object_id) as REFName
from sys.foreign_keys fk
...
October 20, 2015 at 12:10 pm
You can turn off quotes for the specified column and use ActiveX in your Transform Data task to place quotes around data and no quotes around null fields.
September 7, 2005 at 11:22 am
Viewing 5 posts - 1 through 5 (of 5 total)