I actually didn't mean that post to seem like I was addressing you, but re-reading it, it sure does look like I was. Sorry about that. The use...

If all they are doing is queries, then dbdatareader role in the database they need to see the data in should suffice if you want to make it easy. ...

Don't put complete faith in those numbers, as they don't line up with what we pay per license...

It might be possible if you once took a full backup, and the recovery model is FULL using one of the Log Reader programs like ApexSQL Log, but these cost...

sqlcool (12/3/2008)

---

"The DR SQL Server 2005 instance is listening on IP address 9.500.12.02, port 6737,

Also, it is a named instance, so SQLDR02\SQL2005 by name or 9.500.12.02\SQL2005 by IP address....

Matt Miller (12/3/2008)

---

Just about any scalar function can be used in this way. The idea is you're creating what is called a computed column (other DB's I've worked with...

I definately agree with rbarryyoung on this. Service Broker conversations are async and will allow you to queue the work and continue processing.

Regular Expression matches and replacements, as we've discussed previously, but I have also found good utility in CLR Aggregations under specific scenarios, but the 8KB limitation in SQL 2005, kind...

Agree with Gail on that. The moderated forums and boards are great places to work for all but the most rare of exceptions that don't exist for very long...

I have yet to write a...

Jeff Moden (11/30/2008)

---

For a minute there, I thought you were taking exception to posting the BOL reference... man, am I glad I was wrong! 😀 I had to laugh at...

Gail,

The approved assembly list is in the Books Online at:

http://msdn.microsoft.com/en-us/library/ms403279.aspx

There are also some coding model restrictions that you...

Also loving the long weekend. My wife has had me moving furniture around the house consolidating the family room and living room into a single living room, and moving...

I am not beyond asking for help either. I have answered thousands of posts on various forums, but there are times where I need help, and it is rarely...

Jeff Moden (11/29/2008)

---

Jonathan Kehayias (11/29/2008)

---

I'll never understand the attitude that I see people take, when the post a simple question and someone posts a BOL reference instead of just spoon...