SQL Server runs as service in machine. With the commands I provided, You can start SQL Server in any remote machines. Does it help you?

Ceate share drive in your client's PC and change the drive to UNC path like \\yourclientpcname\share\....

Option 1. sp_detach_db / sp_attach_db

OPtion 2. Backup / Restore

You can use EM to do both but option 1 is the simplest in your situation.

See BOL for details.

BOL is Book Online...

Try to recreate the SP with recompile option to force new execution plan to be generated each time it is called.

Which server pack of SQL Server do you have?

There are other commands you can use to start the service.

NET Start - It comes from your Windows

SC.exe - Get it from Windows Resources Kit

NetSvc.exe- - Get it from Windows...

Just curious why you want to run it like this way?

We need you examine following logs for any possible errors before telling you what are the causes and how to resolve it.

1. server application log

2. server system log

3. SQL Server...

http://support.microsoft.com/kb/888799/

http://support.microsoft.com/kb/888800/

http://support.microsoft.com/default.aspx?scid=kb;en-us;884525

Retaining people is not just the money, There are something else like apprecaition, trust and resonable fair.

What is your original owner, dbo or someone else?

sp_changeobjectowner 'oldowner.sp', 'newowner'

Have you tried to use "UPDLOCK" hint or "NOLOCK"?

Quoted from BOL below.

"Use update locks instead of shared locks while reading a table, and hold locks until the end of the...

How many processors your server has? It could be query optimizer generating different execution plans due to statistcs changes that results in large number records inserted/updated/deleted.

Why can't he use view? What blocking issues did you notify?

1. Make sure Distributed Transaction Coordinator (DTC or MSDTC) on all servers that are involved in the distributed transaction are started.

2. Check the return value of the system function @@SERVERNAME...