I tried to add SomeUser using command

net group SomeGlobalGroup SomeUser /domain /add

But I am getting error message as below

The request will be processed at a domain controller for domain domainname.System...

For adding logins to BUILTIN\Administrators through Query analyser

I came across below commands

1)xp_cmdshell "net user sampleaccount /ADD"

2)xp_cmdshell "net localgroup Administrators sampleaccount /ADD"

For finding if member is added to BUILTIN\Administrators...

Product version is 9.00.3054.00

service pack sp2

I am using .BAK extension only

you could also execute below xp

exec xp_msver

Very good scripts.

Ken, you made my task so much easier.

I am on migration project. This article was very useful to sync up the logins.

I thought we could try this as well along with Jack's input

DBCC opentran Database_name

This gives info about the oldest active transactions.

I tried what you suggested in a test server. That is, changed the master to full recovery mode and then changed the sa password. Could you please help me identify...

I ran the script on my local sql 2005. Could you please explain briefly what this means. Is there anyway we could map these id's to the processes from sp_who2

record_id...

Sorry typo.

I thought we couldn't use this column updatedate all the time to check when the password was changed. It would change when new privileges were added to the login...

I thought we couldn't this column updatedate all the time to check when the password was changed. It would change when any privilege was given to the login or if...

Please share your inputs if you are able to analyse DBCC PERFMON.

What exactly we need to check. What are the values which shouldn't be high etc? Thanks.

Deepak, Basit

Thanks a lot for the invaluable inputs

Regards,

Moinudheen

Please advise how to check service account whether it is domain or local in sql2k5. When I right click on

server->properties->security->Server proxy account->

I don't see any proxy account but...

Thank you all for the instant response. Awesome really.

Best regards,

Moinudheen 🙂

Sorry. correction. this is the script

CREATE procedure sp_checkdbaccess

AS

/*Copy the output of this sp and run it on query analyser*/

/*This sp is for finding logins with database access*/

declare @db_name varchar(25)

declare @db_status...