Not so much as a policy, but that could be handled with a DDL trigger.

Not sure what the problem is and not really going to look. Looks like you are using an older version of Jeff Moden's DelimitedSplit8K routine. Replace what you...

Mighty (1/18/2013)

---

Dave62 (1/18/2013)

---

Mighty (1/18/2013)

---

Dave62 (1/18/2013)... I was interested and curious about why the message (1 row(s) affected) was being returned. It would appear that some have confirmed my suspicion...

dwain.c (1/17/2013)

---

dwilliscp (1/17/2013)

---

Thanks I will try and see what I get, but not sure that it will show much if I am just checking for deadlocks. All the job (at...

Evil Kraig F (1/17/2013)

---

*facepalm* sorry about the earlier code. Try this again:

Alternatively:

SELECT

*,

CASE WHEN column2 <> 'AP' THEN 1 ELSE 0 END AS APtest,

CASE WHEN column3 <> 'U' THEN 1...

Try this:

DECLARE @MaterialsID [nvarchar](50),

@MaterialName [nvarchar](150),

@Width2 varchar(255),

...

Check the differential backup process for the database. It may have a truncate log in it just before the differential backup. Not something I'd want being done.

Jim P. (1/15/2013)

---

No. I just expect them to know the DML verbs at...

dwain.c (1/15/2013)

---

Lynn Pettis (1/15/2013)

---

dwain.c (1/15/2013)

---

Thought I'd resurrect this thread which has now gone dormant for nearly 24 hours to say:

Woooohoooo!!! My 2000th post! Time to celebrate!

Good grief! ...

SQLRNNR (1/15/2013)

---

Lynn Pettis (1/15/2013)

---

dwain.c (1/15/2013)

---

Thought I'd resurrect this thread which has now gone dormant for nearly 24 hours to say:

Woooohoooo!!! My 2000th post! Time to celebrate!

Good grief! ...

dwain.c (1/15/2013)

---

Thought I'd resurrect this thread which has now gone dormant for nearly 24 hours to say:

Woooohoooo!!! My 2000th post! Time to celebrate!

Good grief! Seems like only...

Is it wrong to be picky when it's wrong?? :unsure:

Still, I should have caught the simpler method. Good work!

dwain.c (1/15/2013)

---

Lynn Pettis (1/15/2013)

---

dwain.c (1/15/2013)

---

Lynn Pettis (1/15/2013)

---

dwain.c (1/15/2013)

---

Lynn Pettis (1/15/2013)

---

Does this mean you have looked at...

Except, I don't...

Can't believe I missed such an easy solution. I guess that's what I get for making things harder than the need to be at first.