Ok, I figured out my issue.  The test user still has to be assigned to the public role in DB1 & DB2.  It doesn't have to have any further privileges. ...

This doesn't seem to be true when dealing with the default domain policy.  I tried disabling it on the OU but it still prompted me for the complexity policy when...

On this website:  http://www.specopssoft.com/products/specopspasswordpolicy/ they state the following:

" A severe disadvantage with the built in password policy is that there can only be one policy per domain affecting all the...

Anders,

Our sysadmin is saying that the group policy over-rides everything including individual flags on accounts.  Would you happen to know where I could find documentation to support what you are...

The service accounts are already within their own OU.  He said group policy would not allow you to exclude any OUs.  I think he honestly does not how to do...

Hi Jason,

If it were me, I would keep it fairly simple.  2 disks in a Raid 1 configuration for your log files.  The other 8 disks in a Raid 10...

Couldn't they have just delayed the release of SP2 a couple more weeks & included these hotfixes in it?  It is getting tiring to download a new hotfix every other...

wyliec2,

You need to call out the 32 bit dtexec as opposed to the 64 bit.  It is located here if you installed to the default location: 

"C:\Program Files (x86)\Microsoft SQL...

You want to separate your data & log files from your OS.  We have a raid 10 for our data files & raid 1 for our log files.  We also...

David,

Try this & see if it gets what you want:

SELECT

masterregis.lastname,

masterregis.ssn,

masterregis.

Thanks Kathi!  I will be registering in a little bit so I will look for the ticket.

John

Betty,

You would have to ask Red Gate.  I didn't think there was professional & standard edition of SQL Compare.  There is for their SQL Backup.  Send them an email.  They...

We use Red Gate's SQL Compare & Data Compare tools to do this exact thing in our environment.  It seems to work very well.  Much easier than keeping track of...

Roy,

Excellent article. 

Can this script be run for multiple servers?  Can I set the strComputer variable multiple times similar to the multiple databases?

Thanks,

John

Yeah, it does do quite a bit of stuff.  I didn't have any issues on the 12 servers I had to run it on.  It has to be done if...