this would be a client setting, not sure on where it is set for peoplesoft, may not be an option in that particular application.

is the mail profile you created for the service account that runs sql?

I can't find the recent posts either, I use that a ton to try and answer questions for people when I can.

I prefer to do a SQL task to delete the existing data (if that fits your needs), then do a transform task. That may be just because that is what...

it could be so many things there are almost too many to mention. Are the db's from the same backup or are they different versions? does the hardware match exactly?...

are you trying to rebuild the master or restore from a backup - kinda sounds like both?

A warning up front, this solution is not good for security reasons because you have to have xp_cmdshell enabled, but if you already have that procedure enabled, you can do...

chances are master database has the wrong ID's in the sysdatabases table. sounds like they are not connected. to verify this, try to move the mdf and ldf files to...

you need to delete all the records from the foreign key tables before you delete the rows from the primary key tables.

so if you have an order table with primary...

I don't know of any tool that will do that. you could create 2 side databases - one for old schema and one for new. then do inserts or select...

well, since you are over the 2 gig max for standard, I'm betting that it does recognize that you have enterprise edition.

Its a SQL login. I assume it would go either way, but my case happens to be a SQL login

We restore all our Dbs to our DR site daily and run a homegrown log shipping solution. This assures us our backups are working and are restorable. we also move...

that did not work from me. I found a script online that got me most of the way there. It cut off the end, so I had to do some...

Right, but they all want you to pay, the free ones only seem ot have 2000 functionality, not 2005. Anyone know of a free solution?