Phil,
I gave it a go (created a new registered server with a weird colour and exported the servers to get the code and then searched for that in my...

Nice thought Phil, but unfortunately these aren't registered servers (I did use them for a while but my database names are different on most servers so I couldn't make a...

@below86, that's a nice simple solution which I think I can make use of in my shop. Thanks for the idea.
I could investigate GitHub, Subversion or Monitoring...

Most of those tables are vendor created which means I shouldn't be touching them. This...

Jacob Wilkins (4/25/2016)

---

You'll either need to look at simplifying the query (maybe explicitly querying the underlying tables from the view that you need instead of forcing the optimizer to figure...

Also, why are you using NOLOCK here? That hint might be ok but all too often I see it as a "go faster" option without regards to the other issues...

This doesn't help much, but I'm running Windows 7 Pro x64 and am regularly using SSMS from SQL 2008 R2 and I don't have the reported issue.

Conclusion: I don't think...

Seems like the consensus is that if sa is to be left enabled (preferably not) then individual passwords should be used. These individual passwords should be long and strong and...

I think that you're suggesting that I Google my problem. I've tried that and have been unsuccessful, hence my post here. Perhaps my Google powers are weak today and I'm...

I'm not sure I understand your response.

If I have two SQL instances on different servers (InstanceA and InstanceB). I know, because I've looked, that InstanceB has a Linked Server configured...