My thought exactly. Your backup drive is full.

I assume that the need to compare arises out of your other post where the migration is failing to move constraints along with the data. If you restore your...

Instead of using import/export wizard (which is really DTS) to migrate the databases, you should be taking a backup from the source server and restoring the backup on the destination...

Thanks, Rudy. I had not seen this before. What a convenient resource!

My suggestion is to create two DTS packages on the main server.

The first package would check the record count and send an emaill if the record count exceeded...

My personal favorite the the newbie who put in an urgent request for someone to do his late homework assignment.

Are the tables that you want to monitor high-traffic tables? In other words, is the number of transactions run on the tables that you want to track high (thousands/minute?...

You said that you added a new table to the published database, but did you actually update the publication and add the table to it? Until you do this,...

You can also simply return int pass/fail codes like follows:

create procedure myproc ()

declare @err int

begin

set @err = 1

return (@err)

end

sample call:

declare @return int

exec @return =...

Is SQL EM open while you are attempting to restore in QA and sql server is in single user mode? If so, close SQL EM. If not, then...

First, you need to add the new article (the new table) to the publication. Then you will need to reinitialize the subscriptions to the publisher.

It's like reading the fine print in a contract. Easy to miss, has big bite.

BOL will tell you that you cannot execute insert/update/delete from within a function unless you are operating on a TABLE VARIABLE.

Log shipping will not work because the server requires an exlusive lock on the database to apply transaction logs. If you have people in the database generating reports, then...

Here is is another example using single quotes:

select

from

where name = 'john doe''s'