There isn't a "proper" way to do this. There are better and worse ways depending on what you are doing.

You can store the date, like the beginning of quarter (1/1/08)...

I'm not sure what changed in SP4. If there are structural changes in the database files, then you are stuck with the long process of scripting out schema and permissions...

Yes, you do. Permissions are stored in the database, not the server.

That is strange. Connection pooling maybe keeping old sessions live?

I'd check server settings, maybe query timeout. Is that set to 0? Not sure what else this would be. Are you...

Matt has some good ideas. I'm not sure how easy this is to spell out in a contract, perhaps by system?

I've typically had to "train" people about what is...

Yes, there will be. The latest CTPs come in x86, x64 and IA64.

However that might be the last version. I have heard rumors that Windows 2011 (or whatever comes next)...

MS clustering is better in 2005, but it's still fairly simple in terms of what/why you failover.

I've seen polyserve demo'd and it looked very, very cool. It allows multiple failover,...

You can also check the data export wizard.

Do you mean execute a stored procedure through an HTTP call?

You can do this in SQL Server. Books online has information about SOAP endpoints, which will do what you are...

This sounds like homework.

Please ask a specific question and show that you have done some research or work yourself.

Fair enough, I will reword the question.

There is one under the Data Warehousing as DTS is really an ETL tool.

http://www.sqlservercentral.com/Forums/Forum19-1.aspx

I tend to agree with what Grant wrote, but I've had a couple of different scenarios.

1. No on call pay. You get called, you work. That was not much fun...

It looks like you performed a striped backup and then tried to restore one file. At least that's what it seems.

Did you restore the same files through T-SQL? I might...

If it exists, check to see if that user has rights.