Viewing 15 posts - 46,411 through 46,425 (of 49,571 total)
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 ??)
May 26, 2008 at 7:29 am
Run a checkdb over that database, see if it gives any errors.
May 26, 2008 at 5:44 am
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...
May 26, 2008 at 4:56 am
In SQL 2000, I don't think you can. You can encrypt the procedures, but it's a fairly trivial procedure to decrypt them
May 26, 2008 at 4:52 am
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.
May 26, 2008 at 3:48 am
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...
May 26, 2008 at 3:20 am
fyz (5/26/2008)
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...
May 26, 2008 at 3:12 am
Steve Vos (5/26/2008)
!!!!user x can execute stored procedures, but not modify. ==> I would realy like to enable this one.
Grant the user EXECUTE rights on the stored...
May 26, 2008 at 3:08 am
What permissions do you have in that DB? Are you sysadmin or db owner?
May 26, 2008 at 3:06 am
Please don't cross post. It just wastes people's time and fragments replies.
Direct replies to the following thread please:
May 26, 2008 at 3:03 am
A better solution would be to keep transactions short so that fancy locking hints aren't necessary.
May 26, 2008 at 2:54 am
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...
May 26, 2008 at 12:13 am
GSquared (5/23/2008)
May 24, 2008 at 2:34 pm
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...
May 24, 2008 at 2:22 pm
Viewing 15 posts - 46,411 through 46,425 (of 49,571 total)