benjf.com

EDIT: I had two scenarios like this. The one written about here worked. The other one failed. The actual solution came from sql-ution.com. The solution is to fix the registry with the new value. And just in case his website comes offline before mine does, I'll post the code:

Tags:

The trusty "sp_who2" is a quick way to look at what's happening on your SQL instance, but you can't put a WHERE clause on that thing! You have to manually sift through the results and there could be hundreds of results.