Well, you can't schedule the wizard.  You have to save as a package then schedule that.

Greg

I know there are plenty of people who upgrade from SQL 2000 to SQL 2005 in place (don't uninstall SQL 2000 first), but I've always preferred to install a separate...

Stuart,

I get the impression that you're using a full database backup.  Real point-in-time recovery is only possible if you are taking log backups in addition to full backups.  So, if you...

It's kind of hard to pinpoint the reason for that error.  Take a look at this and see if any apply to what your job

was doing: http://support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&1033comm=1&spid=2852&query=error+3624&pwt=false&title=false&kt=ALL&mdt=0&res=20&ast=1&ast=2&ast=3&ast=4&ast=7&ast=10&ast=12&mode=a&adv=1

Greg

In SSMS, right-click on database name, then select Tasks and Generate Scripts.

Greg

"sp_change_users_login does create a login if it is missing"

But, again, only if the user and login have the same name.

Greg

I've found that it's easier to create a DTS package that includes tasks that drop FK constraints, copy data, and recreate FK constraints.  The wizard doesn't give you any way...

...and automate it by putting the import (SSIS or BCP) into a scheduled job.

Greg

You can't do it with BACKUP DATABASE.  You could export objects with SSIS, but I wouldn't consider that a backup.  What parts of a database do you want to backup?

Greg

...and a domain account?  The hex error code translates to "MAPI_E_LOGON_FAILED" so maybe the profile being used can't connect to the Exchange server.

Greg

You can either use a Data Driven Query task to compare the data as it's imported or import the data from Excel to staging tables and use T-SQL code in...

Could be permissions.  Are you using a domain account which is a member of sysadmin or db_owner in master?

Greg

Yes, the sp_help_revlogin procedure in this article makes it easy to script logins: http://support.microsoft.com/kb/246133/en-us.  I've used it many times.  Logins only need to be transferred when a new one...

Yep.  Expand the table in Object Explorer, right-click Constraints, choose New Constraint.  Fill in the expression, designate the column, etc., save the constraint.

Greg

Thanks.  I don't think it's very obvious that a job can have multiple schedules so a lot of people overlook the possibility.

Greg