So if he gets to the coincidentally correct answer on the basis of incorrect data then he can avoid a round trip by assuming that he got something right and...

vsamantha35 (8/12/2015)

---

Gail, you are absolutely spot on. But what kind of information do I need to share with the AD admins?

I mean what kind of conversation do I need to...

What are actual performance results of running these three scenarios?

An often overlooked security aspect of using a linked server relates to access to statistics for the purpose of generating an accurate query plan.

On a local server, any process with...

Thanks Grant, that sounds a very comprehensive workaround. I'll take a look at this approach.

Thank you for your replies.

What I am trying to do with this is to identify databases which are never connected to by means of auditing user connections. (Logon Triggers...

Ed Wagner (6/8/2015)

---

graham.day 53003 (6/8/2015)

---

Hi, the old way of obtaining database context from a session id (e.g. the code inside sp_who2) was to use something like

SELECT dbid FROM master..sysprocesses WHERE...