Be sure tempdb is not growing under the load. While it grows, writes and work stop in that db, which can lead to non-response on the other dbs that use...

How are you addressing the server? If the server is ServerA at IP 10.10.10.10, do you specify IP, ServerA, or ServerA.MyCompany.Com at the client?

Can you connect by IP as specified...

Alexander, you bring up some good points, but that's a rather naive view of the world.

Let's say you are Oracle selling your ERP system, or attempting to sell it, to...

I think you'r need to set this as a job and start the job.

There are a couple articles on the site dealing with this subject

http://www.databasejournal.com/features/mssql/article.php/3521101

http://sqljunkies.com/HowTo/705F07C3-69FE-4CAF-8CF8-CADBF145F372.scuk

http://sqljunkies.com/HowTo/705F07C3-69FE-4CAF-8CF8-CADBF145F372.scuk

There might be orphaned users with the restore. sp_change_users_login will fix that.

Check and see if any of your users in the db are not mapped to logins and then use...

Thanks for the followup, Kathi, and this is an interesting one. And a bug for MS to fix in SP5 and just grant those rights when you change the service...

Since tempdb is used for scratch space for worktables, ordering, groups, etc. it's size really depends on the queries and loads that you throw at it. There's no good tool...

I'll think about it. Not sure how hard that is until I dig into the code. Part of it is we're looking at rewriting some sections in the next few...

We never added that functionality in there, but it's a good idea. You can email the author, or send a private message.

How are you transferring the data? I suspect that some tasks may not work, but I'd think a simple data transfer will work.

How are the clients connecting you SQL? Protocol and addressing?

SQL is not dependent on the Internet, but perhaps you have some name resolution or something that is.

Thanks for the complements and apologies for the delay in responding.

I think that using a separate account for each service is a pain. A real admin pain, but it's a...

OK, we are looking at this differently. The question asks "which of these accounts", not which type or if there is a better 5th answer not given.

Limited Service is not...

Profiler won't really give you a load. Follow John's advice and track some counters. A single day isn't really that good a test, more like a whole week or 4-5...