Jim

It appears it's the Check Database Integrity task that's failing. Can you show us the error message for that, please?

John

Also, for the failure to open the specific database, is the database you're moving the default database for the user you're connecting as? You need to change this to...

Also, don't back up to the same disks that your databases are on, if you can avoid it. If you lose the disk, you've lost the backup as well...

Lowell, I think you're confusing bits with bytes.

Chris, is Byte 0 the eight most significant (highest value) bits, or the eight least significant? I think you need an "OR"...

Surely a UNIQUE constraint on the column is the way to go here?

John

There's plenty of information out there. Use your favourite search engine to search for "sargable predicates".

John

Steve, I don't think that's even permitted, certainly not in...

Phil Brammer (3/1/2012)

I suspect there are client aliases set up, or the port has not been changed. SSMS will always try to connect to 1433 for default instances unless...

Actually, I need to know exactly what the package does, please. Does it have Execute SQL tasks? Script tasks? Data flows? What does each one do?

John

I can't really think of any cons, provided you're not moving to an inferior disk (smaller, slower or shared with another app). You'll want to use this opportunity to...

Mmmm... that's not too helpful. Try running the proc from the SSMS so that the messages don't get truncated.

You'll find the proc in the EDMDefault database. Expand the...

Yes, you read me right. Sysadmin is sysadmin, and has irrevocable god-like powers on the instance.

John

Krishna

This could be something to do with the package running under a different user when you run it through SQL Server agent, or running from a different computer from when...

Since none of us are looking over your shoulder, please will you post the stored procedure definition and the error message?

Thanks

John

Yes, of course it will - it will mean the databases will be on a different drive from where they started.

Excuse the flippant reply... can you be more specific about...