SQL Server jobs have the option to email, page, or net send a message when the job completes. Look at Notifications in the job properties.

Greg

Not with native SQL Server backup and restore. You can script tables in Enterprise Manager or Query Analyzer and run the script to create tables without data or you...

'GO' is the batch terminator that tells whatever utility you're using (QA, sqlcmd, osql) to send the statements before it to SQL Server. Your stored procedures executed with or...

EdVassie (11/27/2007)

---

You can script all of your packages out of SQL 2000 and script them in to SQL 2005. This forum has examples, or look up Nigel Rivett's examples.

However,...

Please clarify which SQL Server version you're working with - 2000 or 2005. My suggestion would be different for each.

Greg

Wanting to take advantage of new features is probably one of the most popular reasons for upgrading. Some, editor Steve Jones of this site included, have suggested waiting for...

Open it in DTS Designer and save it as a structured storage file, preferably somewhere other than the server that hosts the SQL Server instance.. I haven't done an...

It's actually the step names that are listed in the log and the only way to rename them is in Disconnected Edit in DTS Designer. You can't give steps...

I would also guess that the package was created using the Import/Export wizard. It names connections "Connection 1" , "Connection 2", etc. and it creates an Execute SQL task...

You won't like this:

No database files and no backups means no way to recover.

That is quite a mistake as it takes a bit of effort to restore one database over...

I chose the FOR ATTACH answer for the same reason as Derek. I figured a drive crash didn't indicate a clean shutdown.

Greg

There doesn't appear to be anything that prevents creating diagrams for an 8.0 database. Do the developers get an error when they try to open or create a diagram?

One...

There are a lot of references to this message in Microsoft's Knowledgebase (http://support.microsoft.com/search/?adv=1&spid=2852). You might try searching for articles that fit your particular version and patch level.

Greg

Michael,

Enable package logging in the DTS package and look at the log after the package fails next time. You'll get much better messages than you get from the job...

Is the database you're trying to restore the default database of the login you're using? If so, try changing your default database to another (master is a good one;...