I would recommend that if you can use SSIS for this, that you go that route. SQLCLR can do it, that is for sure, but you may not have...

Exactly my thinking... This requirement makes absolutely no sense. It's like saying you have to use a hammer to...

Yep, its basically manual log shipping. I've never used log shipping to accomplish this task because databases in my environment...

daeguboog (6/18/2009)

---

Good article, very informative. You might want to spell check your article the next time you submit one. Justifiably or not, it can hurt your credibility if you submit...

Look for missing indexes causing lots of table scans or clustered index scans in the execution plans. That is one of the most common drivers for high CPU. ...

You don't need CLR to do this. TSQL is the best way to accomplish this task just using standard DML triggers.

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/a3c372a4-d8f0-47b5-a45b-a7529e6eaa81/

No problem.

Charles Hottle (6/5/2009)

---

I stand corrected and am happy to find out about this before we have to migrate this functionality to a new 64 bit server. Does anyone know...

Here is a documented hack that uses SQL Express 32 bit in a double hopped link:

http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html

You can't do it with x64 and this is a known problem. There is no support for JET in 64 bit by Microsoft. See the following connect items:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125117

https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=90562

https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=123311

It isn't uncommon to have sleeping spids sitting on your servers. If you use something like MOSS 2007, it has hundreds of sleeping spids at any given point in...

To start with, stop looking at sysprocesses and start using the DMV's to look at your problems.

The first one to look at is sys.dm_os_waiting_tasks which will hold all the waiting...

BTW, the same type of setup can be used with SQL 2005 for learning.

I am personally working on learning Clustering with SQL 2008 by building my own cluster using ESXi and 4 virtual machines. I am slowly blogging about it on my...

A stored procedure only executes when called by your code. What do you mean by registers a socket server and why are you doing this from a SQLCLR stored...