I believe that sysobjects is per database for that db's objects only.  If there are objects in your DB that are not in your db's sysobject table then I don't...

I don't know about SQL-DMO but the query is SELECT * FROM sysfiles from inside the database you want...

1.  Is this a STORED-PROCEDURE or an AD-HOC QUERY?

2.  Is this using DYNAMIC SQL?

A possible reason for QA running MUCH faster is because QA is running off of the SERVER...

If you are trying to determine products that are IN Boston AND IN Chicago AND IN Denver you will need to create three DISTINCT sub-queries

FROM (SELECT Product FROM Product_Cities WHERE City...

Ron,

In answer to your Vampiric example:

How can you determine that IF his blood type IS NULL THEN NOT DELETING him is CORRECT?

Secondly, What is to stop someone from DELETE...

Have you tried researching sp_change_users_login with AUTO_FIX?

Please see below example

sp_addextendedproperty 'caption', 'One digit identifier of system.  See TimeSystem table for more information', 'user', dbo, 'table', 'Your Table Name Here', 'column', 'TimeSystemID'

GO

sp_addextendedproperty 'caption', 'up to 4 digit...

El,

Unless you have auditing enabled (created by you to track changes) then unfortunately, there is no audit trail.

Sorry

my 2 cents worth.

IF you ALLOW NULL you have to determine: Is it really NULL or did someone TYPE NULL? I have been fighting NULL for a long...

NULL is a bad idea.  I would use a DEFAULT value of '1900-01-01'.  This way you deal with either a date value or a date value and not

WHERE Field BETWEEN...

How bout

UPDATE S1 SET Price = S2.Price

  FROM dbo.Stock S1

    INNER JOIN (SELECT Product, MAX(Price) Price

                  FROM dbo.Supplier

                GROUP BY Product) S2

    ON S1.Product = S2.Product

#1.  Do you know when it's schedule is?

#2.  Do you have the source code to see what it does?

#3.  Fire up Profiler to capture the traces....

This may help

IF EXISTS (SELECT 1

             FROM dbo.Contracts

           WHERE lastpd < nextperiod AND Claim = 1)

  BEGIN

    UPDATE contracts

    Set printedpd = nextperiod,lastprinted = getdate (),nextperiod = nextperiod  ...

ILANGO,

The problem is that Evan is > just E.  If you want the E's as well have your query do < F.  Kind of like dealing with date fields...

How bout something like:

CAST(CAST(REPLICATE('0', 6 - LEN(@Field)) + @Field AS VARCHAR(6)) AS VARCHAR(6))