"I learned my lesson here. If I wanted a "real time" mirror as a DR backup I will not configure the mirror with a witness."

Please remember that mirroring is not...

Just been through this pain with Microsoft and whichever way you try to wriggle they have thought of it and you pay. We looked at all permutations of core +...

LDAP queries?

If it's not windows 2008 you will need to set the offset also for the drive.

Mirroring won't protect you from data corruption / loss but backups can.

Seems that you are using machine names for accounts so the error 'Login failed for user xxx\machinename$' relies on the old machine which doesn't have rights on the new server....

You are correct Jeff I did mean staging tables. Does become a pain when trying to create a multi key index.

Plus i've been databasing since dbase 3+ and SQL 6.5...

Has anybody come across the CADIS Enterprise Data Management product?

Where I work they always insist that any import tables for third party text data are nvarchar(4000) and there is no...

Remember Windows 2008 does partition alignment for you 😉

Have you tried using the same service account for both instances of SQL? We set the delegation at the AD account level for our double hops.

Glad to see i'm not the only one who has been drinking at lunch.

Can we all play nicely please.

Just seems an antiquated way of getting drive statistics when WMI is available.

Most shops / auditors require that is locked out even though they don't understand it can be secured.

Hey...

People still use xp_cmdshell :w00t:

For our SQL Express 2008 R2 databases I wrote the script below which is run via a scheduled task .BAT file which is also below. Would be easy to modify...

I personally loop through a list of linked servers and pick up the job and error logs. Collate them all and then attach to an email and send. Traditionally we...