Thanks for the help. We did get things going again. We started over (deleted C drive and re-restored it). To avoid the storage space error we unfortunately did two things...

That is what I thought. We uninstalled SQL Server, rebooted, and tried to re-install it but the install fails with the same Microsoft Management Console error that we got with...

Let me simplify the problem for you.

update contact2

set udefcon =

( SELECT 1

     FROM

  contact2, contact1

WHERE contact1.accountno = contact2.accountno)

The above should still fail with the same error. The reason...

Same question, different context. Our QA box had a duo drive failure (both sides of a mirror) and we had to replace the drives. We installed a new OS to...

Actually, his complaint was that it didn't interleave the query with the results. He had already tried that setting unsatisfactorily.

I can't see your hard drive, so the image doesn't show, but the screen does take a few seconds to fill in (about 6 seconds for me). What I see...

One thing I figured out is that you can use STATISTICS PROFILE to interleave the access plan in text form. You would, of course, have to have Query Analyzer in...

You need to left click on the database name first before the View menu appears. The reason is that it is not an action, but a view setting for the...

You may also try the following. It's geared more for change management, but I think it could possibly accomodate your needs. I simply found it doing a quick Google search,...

This is due to implicite type conversion. The order by expression has to resolve into a single "column" of some type just as if it were in the select portion....

I have a couple queries that I just got done rewriting that had the same issues. The original was all Dynamic SQL (dynamic columns, joins, where clause, and order by),...

It seems to me that this would work best as a join.

SELECT CRM_MTL.Whatever

            , RIGHT(Amount1.CM_SADE,5) - RIGHT(Amount2.CM_SADE,5) AS Difference

            , ( RIGHT(Amount1.CM_SADE,5) - RIGHT(Amount2.CM_SADE,5)) /  RIGHT(Amount1.CM_SADE,5) AS Percentage

      FROM CRM_MTL

              LEFT JOIN...

First of all, I suspect that Bob has the correct solution, that being to deal with presentation in the presentation layer. If you really need the rows inverted you could...

Databases can be configured to automatically shut down when all connections to it have been dropped. Based on your first post it sounds like the BDECO database is configured in...

I can't really help you with a primer. My knowledge is from a wide variety of sources over time.

First, keep the PK composite or not. Performance tweaks should never compromise data...