Do you compare the execution plan after the change?

Try configure SQL Server production to run without parallel.

sp_configure 'allow updates', 1

go

reconfigure with override

go

sp_configure 'max degree of parallelism', 1

go

reconfigure with override

go

sp_configure 'allow updates', 0

go

reconfigure with override

How many CPUs does your test server have? What are the difference in execution plans betwen production and test servers? Can you post sp_configure's results from bth server here?

Sure you can.

create table #T1 (file_info varchar(255))

insert into #T1 exec master..xp_cmdshell 'dir *.*'

drop table #T1

Can you decrase the "min memory per query" even further to 512KB to see whether same issues occur less frequent than before?

When same problem happens again, Try to removes all cached...

Check http://www.sqldev.net/xp/xpsmtp.htm#Usage for sample of "using variables".

setup.exe /qn sqlrun01.msi INSTANCENAME="MYMSDE" /l*v c:\msde2000_setup.log

I see some ERP application does that to some of tables. But you really have to resolve the deadloacks from application/database re-design.

BUILTIN\Administrators (Not BUILTIN\Administrator) is group account being granted to access SQL Server with 'sa' privilege by default. Anyone in local adminstrators group willl inherite 'sa' right.

Which service account do you...

No way you can guarantee the linked server is alive when your users  access it at anytime. You may log it as alive everytime you check it but users still complain about inaccessable...

If the solution of changing registry doesn't work, Restore the master database to another SQL Server, shutdown it, copy the master.mdf and mastlog.ldf to your original server.

I would simply detach the database, rename the MDF, NDF and LDF files and reattach with new database name.

The alter database you mentioned is used for rename the database logical...

Mike Vessey,

"with client network you can create an alias for TCP/IP, but only for a port number - you can't specify the IP it listens on....

both cards have different...

How much memory do you have in the server and configued to SQL Server? Do you run it in active/active or active/passive? Do you use Full Text search service? What...