Duplciate post, please see repsonse in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8311&FORUM_ID=7&CAT_ID=1&Topic_Title=msdtc+does+not+start&Forum_Title=Replication

I think this is the problem or at least the possible fix.

Drill thru Control Panel and Administrative Tools, there open Componenet Services MMC.

When open you should see in the left...

The best way is of course using Global variables as long as is supported by your version of SQL (SQL 2000). If so then look at this thread on how...

Phil is right, the thing with RAISERROR thou is so you can send your own custom message back which I prefer as it will be logged with your message. But...

Another way you can get better saved execution plans with what Simon states is to create multiple Procedures, 1 for each possible SELECT statement.

Then create a main Procedure with logic...

Look at DBCC CHECKDB and DBCC CHECKTABLE in BOL.

Sounds like your running into a race condition in that VB gets the connection closed message but SQL has not finished cleanup on it's end. I agree with Steve attach...

Keep in mind you have to refresh the Current Acitivty manually, it is not auto updating and does not reoccurr each time you open. You must right click on Current...

Yes, sorry, Verisign, having a brain F@$t day.

I don't believe there is a way with a decryption tool and I don't know of anything built around this particular need.

I believe this location is accurate.

Open up Enterprise Manager in MMC and click on either the "Microsoft SQL Server" node or the "SQL Server Group" node in the tree view...

But reindex should not be used too often or you need to reevaluate your fill factor for your index. Also, even with AUTO UPDATE STATS turn on I suggest unless...

Did you turn any trace flasg on in SQL Server startup?

The biggest example is of course at http://www.terraserver.com which was project with SQL 7 initially, not sure what they run now but it is in the TerraBytes of data on...

Sometimes theses errors are misleading. Check the Event Viewer Logs to see if anything more specific. Also, with the file rename it then try the backup. Most times you can...