If you are on SS2005, then the only reason that I could think of for this is that they are not connecting through TCP/IP. Normally that would mean either...

Jeff Moden (1/9/2010)

---

Thanks, Barry. Always good to hear from you and I hope your back is...

Thanks Richellere, glad I could help someone ... 🙂

Paul:

Any chance you could explain your Helper class a little? (you know, a Helper Helper? :-D)

For obviously selfish reasons I am very interested in implementing it in VB.net, and although...

quackhandle1975 (1/12/2010)

---

For a very, very simplistic view of becoming a SQL Server DBA 5 stars, however in the REAL WORLD only 1 star - how many of us actually wanted...

Great article again, Jeff! You just can't beat the classics. 😀

I think that this probably comes down to two general design questions:

1) Data Representation (how should this be recorded in the database), and

2) Data Presentation...

FreeHansje (12/24/2009)

---

Hi there,

In a trigger I wish to use the DMV sys.dm_exec_sql_text to store info in a table during certain updates on a specific table. Basically I wish to know...

Glad I could help.

This is a SQL Server 2008 forum. You will probably get a better response for your question if you move it to one of the "SQL Server 7, 2000"...

Microsoft sure is using a counter-intuitive definition of the words "synchronous" and "asynchronous". In fact they're almost the exact opposite of what they mean everywhere else in...

If you are really on SQL Server 2008, then you should seriously consider using SSIS instead of DTS, its much better overall, and much better supported under 2008.

Actually, I explained exactly what you could do to make it clearer...

The Dixie Flatline (12/16/2009)

---

Grant... I saw Kentucky Fried Movie wayyyy back when .... and your comment just gave me a sudden vision of a clown with a whip... an image...

Grant Fritchey (12/16/2009)

---

You're...