Ensure that MSDTC is properly configured as part of the cluster, right alongside MSSQL and SQLAgent.  It is necessary for distributed transactions.

-Eddie

Have you tried using an INSTEAD OF trigger instead of (the default) AFTER trigger?

  An INSTEAD OF trigger actually replaces the normal INSERT behavior, and it's up to you to...

Ditch COMPUTE, and use either CUBE or ROLLUP.

The reason it doesn't work outside of QA is that your results are not a single resultset.  Each time a compute result is...

Many MDI applications use Ctrl+Tab to switch windows.

Having never heard of your example as a 'standard', I fired up Word and Notepad to see what they did.  In both, Ctrl+Tab...

If you have the memory available, SQL Server defaults to row-level locks.  If you are locking a significant number of rows on a page, it will escalate the lock into...

The Refresh method simply reloads the list of tables into your DMO tables collection from the server.  It has no effect on the server or any object on it.

To see...

DBAhawk:  If you pick up the MCDBA, you'll be able to take an upgrade exam for MCITP: DBA (70-447) instead of the DBA tests (70-443, 70-444), and you will have...

What are your current strengths?  Are you a developer or a systems admin?  ...or not sure which of those two you'd prefer to pursue?

If you aren't now already proficient in...

"Scalable" to 50M records?  We're jamming 200M records every day into a couple SQL Server 2000 databases at my company. 

Here's the simple math:  If a company cannot afford a...

Just like VB6: set a reference to the SQL-DMO COM library.  COM-Interop will take care of the plumbing.  You may even be able to upgrade much of your VB6 project...

Try joining Inc_History just once without the condition, and use a CASE statement to separate the two types of values to sum:

To get the Incident_Bill time:

  CASE...

I've tried something similar in the past.  I don't recall my full experience, but I've got some ideas.  I think the key was using linkedserver.master.dbo.sp_executesql, and including a...

Jules,

  Common Table Expressions (CTEs) are new to SQL Server 2005, this might be a more lively thread over in one of the 2005 forums.

  From BOL:"A CTE is...

You forgot the Cell_Phone column in the temp table, between Office_Phone and Total_Contribute.

-Eddie

  IDENTITY_INSERT, as Sergiv pointed out, is quite useful, but only when you wish to disable the IDENTITY column temporarily.  Only one table may have IDENTITY_INSERT set to ON for a...