441 reputation
1410
bio website
location Grand Rapids, MI
age 30
visits member for 3 years, 1 month
seen Sep 11 at 14:33

MCITP: Database Developer 2008

Sr. Database Developer

Hockey Goalie

Soccer Goalie


Jul
31
comment Can I force a user to use WITH NOLOCK?
If you trust your users not to change it, there is a setting in SSMS which will set the Transaction Isolation Level for a connection - you could have them set that to READ UNCOMMITTED
Nov
9
comment Unable to delete SQL Server 2008 R2 login
Not a problem, glad I could help.
Nov
9
comment Unable to delete SQL Server 2008 R2 login
I have updated my answer to include how to delete a job.
Nov
9
comment Unable to delete SQL Server 2008 R2 login
+1 for help with remapping users & general good answer. Nice work Shark, as usual it seems :)
Nov
9
comment Unable to delete SQL Server 2008 R2 login
You will have to first change ownership of the job, or delete the job, before you are able to delete the login.