Ok, go ahead and take the next 2 days off. 😛

I'm a little confused by the sql statement as it doesn't appear to be referencing the table at all but I am guessing that you are within the function. What...

Making some great assumptions as I still don't have queries but if you are going to be retrieving 2 years of data (is that what you were stating?) then you...

That all depends on table design and access patterns. Being that you are on 2000 you could use a partitioned view to bring the multiple table scenario into one "table"...

You can review the following article on MS for help in the login migration. http://support.microsoft.com/kb/918992

Hope that helps.

Thanks Gail. The question was phrased in a way that it appeared to be a follow-up post which made me suspicious. 🙂

If you are just looking to copy a table then backup / restore is a bit heavy. Try right clicking on the database, select Tasks, Select Import / Export Data...

Matt - my mistake. Do the developers need to update the database? If so, scratch my other two posts. Ack, bad David....

You can actually use the secondary server for querying. See BOL;

You can reduce the load on your primary server by using a secondary server for read-only query processing. To do...

Thanks Steve! We had kind of considered that but determined it wouldn't work right in our situation. Hopefully we can hear of some other solutions!

Matt,

Sorry for the late reply to this (don't get to check the site very often, a bit busy) but something else to consider is that your transaction log files...

Manu,

You would have to run the restore from a connection to server B pointing to the backup file on server A. So, from SSMS connected to server B run...

From a performance perspective it is going to depend on the utilization of the databases however, if that is the disk availability that you have I would recommend splitting it...

Agreed, the questions are definitely getting worse, and that most recent one that Jeff responded to is right up there on the scale of BAD.

So, the question is what...

No, you would need to have the permissions established. One question though, you had stated...