are you sure that sql services runs under network service i just had a reading that few service account gets changed on SP installation. check if the account remins same...

DROP CREDENTIAL mycredential

this just drop any credentails that you have created and will not delete the folder which is sql server default and that cant be deleted.

Just revoke permissions for the users on those sytem views so that they will not be able to use those.

Is the major_id same for everytime you run the query. If not it might be any dynamic objects that sql server creates on startup.

You can find when the cahnge has happened by querying the syslogins and looking for modified date. Who has performed this can't be tracked unless you have profiler or other...

Ok no probs Andrew. good to hear that the solution was working for  you.

Check what is the type of lock held by the blocking SPID. You can set your isolation level to read committed so that select statements can avoid locks.

I hope the machine is hitting a memory dump. check for the sql server error log files and the eventvwr to get more clue on what is exactly happening at...

yes it's good to certify yourself with 2005 than 2000. With 2008 to be in market in next year go for new technologies than the older ones.

To add some light to what Brain has told if you have added the user to the windows it doesn't mean that you have given him access to sql server...

SQL Server 2000 64-bit software is available only for 64-bit IA opeating systems and you can't have that installed in 32 bit machines.

SQLService is a local user in the server running your sql server. With this kind of setup your sql server will not be able to access resources in network and...

Replication can be a good alternative you can have snapshot replication implemented since you say its just 4GB database. Snapshot replication is almost like your full database backup and restore...

bhavin,

if you give datareader/writer role they will be able to perform insert, update,select and delete but they will not have execute permissions in SPs or functions. Since you have posted...

Michael,

He says that his SQLAgent services does not show that it depends on MSSQLSERVER service. Actually what he says is right SQLAgent depends on MSSQLServer services but MSSQLServer does not...