Did you enter the correct password? Does that login have rights in the server?

What's the State listed for the error? (Error 18456, Severity 14, State ??)

Run a checkdb over that database, see if it gives any errors.

NT Authority\System is the username for any account that runs as LocalSystem

Generally the sQL services should not be running as local system. They should ahve their own domain accounts.

If you...

In SQL 2000, I don't think you can. You can encrypt the procedures, but it's a fairly trivial procedure to decrypt them

Tried google?

I can't see anything in that script that would allow the user to modify stored procs. They'll be able to generate the edit script, but running the alter should fail.

There is nothing in that script which will allow modification of stored procs. You'd be able to script them, but not actually run the alter procedure statement?

I notice that...

fyz (5/26/2008)

---

Hi,

If necessary, I think you can try a utility called Advanced Access Repair to repair your Access MDB file. It works rather well for my corrupt Access MDB...

Grant the user EXECUTE rights on the stored...

What permissions do you have in that DB? Are you sysadmin or db owner?

Please don't cross post. It just wastes people's time and fragments replies.

Direct replies to the following thread please:

http://www.sqlservercentral.com/Forums/Topic505786-8-1.aspx

A better solution would be to keep transactions short so that fancy locking hints aren't necessary.

You don't need to change the server name.

When you made the backup, there's a box on the backup window that lists the backup destinations. If there is more than one...

GSquared (5/23/2008)

---

(The detailed analysis of my results on the test basically said, in a somewhat diplomatic manner, that the only thing I'm good for is being the office...

If you have a true deadlock, then you won't need to kill processes. SQL has a deadlock detector that will notice a deadlock condition, pick one of the participants and...