you want to run this restore while you are connected to the Master database, not the one you are restoring.

The log is always written to first, before data changes are made. So if the log is slow, meaning the I/O channel, then performance can suffer.

These look like C# of VB.NET questions, not SQL Server.

You can test these, write a loop to build 10,000 of each one, look at the cost/time of each.

Which choices?

I'm not sure this is the right place to ask this question. Are you programming something? You might want to post this on a more appropriate site.

You have someone connected to the database, perhaps even you. You need to remove everyone from the database before you can restore.

There's not enough information for us. What does a log in or log out mean? Where do you keep the data? You are getting the cartID or the sessionID, but...

Congrats Grant and Gail as well!

I'm an alternate, fine by me. Jeff, any word for you?

OK, I have finally updated the database and corrected the question to say "SQL Server, and "unicode characters" as well as awarded points back.

My apologies for this.

No idea on security here, but we have one login for the web app, in a role, basic db security.

There are roles in the db tables, so I assume they...

you should be able to connect to 2000 from SSMS. I'm not sure about the Express version, but I wouldn't expect it to fail.

I have SSMS here, SQL 2005, SP1...

How did you define the temp table? Did you add a collation to the DDL?

I don't think you can change the priority of a single DTS process. What you can do is build checks into those processes, perhaps at places, and query to...

That's interesting. I'd say 1,000/sec is high, but that's just a guess. It's been some time since I tracked this. I ought to see what SSC does.

There's some nHibernate in use here in the admin tools. When it became problematic to add columns to a page (related table) or change the queries for particular pages, I...