It needs the local admin permission, and sometimes it also needs Lan Admin permission

Sometimes, restart will help u to make a decision

Thanks for reply. About 30G. It is a good soultion, anything else?

Thanks for the good question.

2 solutions:

1> Remove the trigger.

Alter the query as

Update UPDATE resource_personalization

SET value = @P0,

...

Better to run the same edition as your living SQL server

It is best to complete the DDL jobs on production and testing server only by DBA.

BOL: backup and restore

sp_defaultlanguage is for login.

And you could use "SET LANGUAGE" or reconfigurate the setting of server properties to reset the server level language environment.

Hi, there,

Normally, we only backup the system databases and user databases to tape devices through the ARCserver or other netbackup software. It does not need to back up the SQL...

dbcc shrinkdb also can help u. Check BOL

select the best as you can.

First, SQL profiler.

maybe it will help u

http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.asp

Edited by - simon_hyan on 10/28/2003 2:17:23 PM

Implement the network security and block the server IP and ports to public.

How much is the total size?