GilaMonster (10/2/2011)

---

As I said, At best it'll have no effect. At worst it'll slow things down.

If you have blocking you really have 3 options:

Tune the queries (they're unlikely to...

GilaMonster (10/2/2011)

---

No. At best it'll have no effect. At worst it'll slow things down.

If you mean an indexed view (a view with a clustered index) that will potentially slow all...

bitbucket-25253 (3/31/2011)

---

Test this T-SQL and modify it for the item(s) you require.

This will work in 2005 and 2008

SELECT * FROM sys.dm_exec_connections WHERE session_id <>...

thank you very much but im actually preferring to hv a trigger to monitor bcoz we want to do it all the time 🙂

so its a long term plan bcoz...

hello,

its a very intersted topic 🙂

i normally get a phone call from someone else n use vpn to connect 🙂