What do you mean by #4? Take a backup from each instance? There isn't a thing as an instance-database. If you want to take a backup from each instance, you...

Does this help: http://www.somacon.com/p586.php

Is there more code for the alert? That will track status, but not alert for disabled.

It is possible that a wrong password can lock an account, check the policy on...

Did you run the SQL Server install? Did you run the SSMS install?

Do you have a service called MSSQL running?

Jeff Moden (6/29/2016)

---

GilaMonster (6/29/2016)

---

Jeff Moden (6/28/2016)

---

Steve Jones - SSC Editor (6/28/2016)

---

Jeff Moden (6/25/2016)

---

While I agree that it probably has fewer bugs...

Arrggghhhh, my idiocy here. I didn't check the box for HierarchyID.

Points awarded back.

My apologies.

manie (6/28/2016)

---

Steve, that there is my problem with Microsoft. If I develop an application...

Beatrix Kiddo (6/29/2016)

---

In the Venn diagram of the UK, all English people are British, but not all British people are English :-D. One of the best way to wind up...

Excellent

below86 (6/29/2016)

---

I had my SSC account tied to my work email, and the password was saved by IE. So when I lost my job and couldn't remember the password...

Definitely more complex, but has the advantage of not being dependent on tools in the future. It's got more places things could break, but they could also be recovered.

However, there's...

GSquared (6/29/2016)

---

The usual way to do that is to rebuild the clustered index into the new filegroup ("CREATE INDEX WITH DROP_EXISTING" is one way to do that, if I remember...

Leonard,

You're probably right in some sense. I guess it depends on how we look at grunt work. For example, we will always need someone to rack servers and move equipment.

However,...

Cheers

First, your link is broken. It doesn't matter what your SSIS process is. What we need is some test tables and DDL and data. Please create a table that mimics...