Reputation
471
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 4 10
Newest
 Yearling
Impact
~26k people reached

  • 0 posts edited
  • 2 helpful flags
  • 83 votes cast
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.