That's great thanks. Very comprehensive and pleased I asked the question. I will have a go tonight when I get back from work.

Yes, thats the way I would do it.

I would use a config file and pass it when I call the packages.

wldhrs (7/10/2009)

---

Steve Newton (7/10/2009)

---

All too often with security issues on Production environments or time constrained developments, they will be fixed by adding the application user account to Local admin on...

Soft referencing is growing in popularity and I can see its appeal. Googling yourself is always quite interesting when you haven't given it much thought!

Given you can't ask someones...

All too often with security issues on Production environments or time constrained developments, they will be fixed by adding the application user account to Local admin on the SQL Server...

Sounds to me like you scr*wed up and don't want to admit to someone that has a backup stored where you can't get it.

My recommendation....... Own up, take it...

Sorry for the duplicate posts Steve. Forum had a mare.

The production database has to have all the records in it, so partitioning doesn't work as you would have to restore the same config ie the same size to other...

You dont have any backups???

We have a mixed environment and ODBC works fine in both. Have you checked the security and setup is the same on the 64 bit server?

Anybody? Do I need to clarify anything to help explain it?

Slightly confused, so you may need to clarify. If the users exist in the database on the primary server then they will exist in the database on the secondary....

The minimum size is just that due to having data in there. Using Data files as an example, if you have data in that file equating to 10gb, then...

What about your other drives?