Sean Lange (10/22/2013)

---

polkadot (10/22/2013)

---

According to your rules neither of these is accurate. They will both allow columns with the string literal 'NULL'. If you are ok with ignoring rule #3...

The only way to get rid of the case expression would be to build a table that contains a cross-map of the values.

Then in your query you would join (outer...

SUSER_SNAME() does check AD and will return the user information if found.

In addition to which drive backups are performed - I really need to be able to block someone from taking native backups on some of my systems.

I have and use...

The only way to have two servers up and available with the same name is to have 2 domains. The production domain and the DR domain.

In order for that...

SQLKnitter (9/26/2013)

---

I checked with the company that installed the server. He says " the server has two instances of SQL, one database in each."

I hope that is a good...

Your script will also fail on any named instances. The -S parameter is the SQL Server instance and you need to specify the correct instance name.

For clusters, you don't...

If it is working well - why would you want to change it?

For a little twist - I have a requirement to create a reporting copy of the database to be refreshed on a nightly basis. The database must be available...

Jeff Moden (9/23/2013)

---

2Tall (9/20/2013)

---

Be careful with killing SPIDs. I forget the URL for the CONNECT item on this but you could easily end up with a CPU consuming 0%...

In order to insert data into a date data type - you need a valid date or string that can be converted into a date.

If you are looking for random...

Here is what I use:

Select r.command

, s.text

, r.start_time

, r.percent_complete

...

Greg Charles (9/23/2013)

---

You can't restore a differential after restoring a log backup. The order of restores must be:

1. Restore full backup

2. Restore differential backup

3. Restore log backup

So, in your...

CptCrusty1 (8/26/2013)

---

Steve Jones - SSC Editor (8/26/2013)

---

You could parameterize this path, so the package reads something from the local instance at runtime. That way if you have the local instance...

Jack Corbett (8/26/2013)

---

Any backup product that uses Volume Shadow Copy Services (VSS) cause this to happen so that they can get a consistent backup. This blog post,...