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...

Why would you do this? It is a bad idea and there's real reason to do it. Each time the trigger ran it would create a new table, which...

off the cuff:

set rowcount 1

select @i = col1, @j-2 = col2, @k = col3

from mytable

where intcol is null

if exists( select intcol from mytable

...

I think if you set a role in msdb for them and grant execute on sp_startjob, they can do it.

Alternatively, create a job that queries a table (some new one)...

I agree with Yelena. You're playing with fire here.

Don't say horse. Got enough horses, too many horses, shoveling too much as it is.

I didn't see a great map when searching on Google.

Plus I liked this one

Not sure I agree we'll fail in the US. We might not employ the most IT people as I can see China or India giving us competition there, but high...

Is this a generic program or specifically for your databases? If specific, figure out the hierarchy and load it from an xml/ini file.

If generic, license the depends code from Red...

Write the stored proc. You'll do it once and it will work. Even if you need to write 50 procs, it's small compared to the issues you might face with...

Search sp_helprevlogin on Technet and use that to move the logins you need to the new server.

I'm not sure I understand. Is this what happens?

1. Start server in single user mode

2. connect and run proc.

3. Another user attempts to connect and gets the errir

4. You think...