So do not set the owner to the user....make this say sa.

Add the user then (only give them db_owner if they want to do backups, etc)...otherwise

get them db_datareader, db_datawriter.

They need...

Make sure the login exists on the remote server

SERVERA (could be sa here)

SERVERB (put the login thats exists in here).

Then you can have sa and then impersonate...

Have a look at this thread.

http://duartes.org/gustavo/articles/Lock-Down-SQL-Server-2005.aspx

Let me know if you implement anything i would like to do this too.

Just not got around to this yet.

(When adding new database the guest...

So - what do you feel is the best policy to use

I guess i do not understand

1. If i added user without making it the...

--Some lady helped me work on this which is one of MS threads so credit to her also.

--This script creates a job and a alert for reporting deadlocks

--Change SystemADM to...

The min and max being same i.e min should be 49 GIG and MAX 50 GIG

Hmmm thats interesting.

I have just experienced the same problems with the messages of paing in sql.

64 GIG RAM and the paging when to 32 GIG after one DBCC CHECKDB on 40 gig...

Here is a little tool http://www.sqlsolutions.com i downloaded tried it out its very easy and 2 minutes set up the deadlock and you do not have to worry about anything.

I...

Just do backup and restore to SQL 2005 then set mode of database 90 on SQL 2005.

I had this once where you could not view the tables when someone was running a hugh update statement and then i could not view the tables. Is any...

Hi adam yes that view is great i use it all the time.

You got one for SQL 2005 .........sp_now 😀

Thats great.

Oh is this for SQL 2000 sorry thought it was for SQL 2005.

I could not get the handles to work in SQL 2000

Try this for SQL 2000 (This is...

Thats the word dependencies could not think without looking at it.

Look at the cluster.log (may give you some reason here).

Hmm then not so sure why nothing comes out.

Try this one

------------------------------------------------------

--Get just one details from the spid (A)

------------------------------------------------------

SELECT r.session_id, r.status, r.start_time, r.command

FROM sys.dm_exec_requests r

------------------------------------------------------

--Get SPID then pass back FROM...