As far as I know, Clustering is the only high availability solution which offers anything close to "instant" failover.  Log Shipping and replication both require manual failover.

Greg

In DTS Designer, when you select Package -> Save, you can choose a location of SQL Server, structured storage file, or VB file.  If you choose to save in SQL...

There is role in MSDB called TargetServersRole that allows members to view jobs.  It's undocumented and subject to change in future releases and service packs, but it works now.

Greg

I don't think there is an Enterprise personal edition and a Standard personal edition.  The personal edition distributed with either is the same.  According to MS here: http://www.microsoft.com/sql/evaluation/overview/default.asp, personal...

Nice script, rubbercow.  I tried it this morning and it worked great.  A good way to write a bunch of local packages to files.

Thanks,

Greg

Query Analyzer has a debugger that you can use to step through a stored procedure.  See Transact-SQL Debugger in BOL for details on how to use it.

Greg

What's happened is the database users were created with the database, but they aren't associated with a login on the new server.  You can use sp_change_users_login to associate them.  Look...

You'll need to start the agent using a windows login to do anything outside of SQL Server, even if it's on a local drive.  SQL Server logins have no meaning...

I'm not sure I understand what your question is.  Are you asking how to deploy DTS packages to another server?

If that's what you want, you can either backup backup msdb...

Probably security.  Scheduled packages run in the security context of the account used for SQL Server Agent.  Search on this site for "scheduling dts" and you'll find more than you...

Do you have log backups scheduled on the destination database?  I agree with Francis in that dropping and creating a stored procedure won't truncate the log.  It may be a...

Start by opening the package in DTS Designer and executing each step individually.  Also, enable package logging and, if you're using Transform Data tasks, enable logging for the tasks.

Greg

Here's a script that we use to list the hierarchy of foreign keys in a database and  generate 'DROP' and 'ADD' statements.  Just run it in Query Analyzer.

/******************************************************************************

This script will...

I don't use maintenance plans to set up backups so I don't have any personal experience with this.  Here are a couple of Knowledge Base articles that might help you...

I just read your second post.  Do any of the jobs backup system databases?

Greg