Further on Jacob's excellent suggestion, check for the existence of the pattern before the substring, as you could have false positives when the pattern is not found.

😎

GilaMonster (11/3/2015)

---

No spare time this week, but given the...

Resender (11/3/2015)

---

ChrisM@Work (11/3/2015)

---

Resender (11/3/2015)

---

In the meantime 123883 tables (yes 30 new tables got added) the total recordcount is

89,372,968,620

I wish I knew but I'm...

sraghunandana.6 (11/2/2015)

---

Hi Team,

I have taken a compressed online backup of one database. The database size came from 360GB to 190GB.

Now i want to restore the compressed backup which should replace...

Lynn Pettis (11/2/2015)

---

It was awesome to get to meet some of the denizens of The Thread last week. Too bad Jeff Moden wasn't able to be...

rohan1424 (11/1/2015)

---

Hello .

I have a prod server running SQL 2012 Standard which host our DB which is about 50 GB . We have enabled logshipping on a secondary sever which...

IIRC I did this in the passed with a start-up macro, which fired a code that added the protection when the spreadsheet was opened.

😎

coolchaitu (11/1/2015)

---

Good morning Everyone,

I have 4 instances on a box. How can i find which instance is causing memory pressure? Also, how to find which instance is consuming more memory?...

Brandie Tarvin (10/30/2015)

---

Someone needs to have a talk with that David Burrows guy. He's talking crazy in another thread. Like suggesting I could use SQL Server tables to solve a...

Brandie Tarvin (10/30/2015)

---

Someone needs to have a talk with that David Burrows guy. He's talking crazy in another thread. Like suggesting I could use SQL Server tables to solve a...

jasona.work (10/30/2015)

---

Brandie Tarvin (10/30/2015)

---

Someone needs to have a talk with that David Burrows guy. He's talking crazy in another thread. Like suggesting I could use SQL Server tables to solve...

Thank you all for giving this a try;-)

😎

(mis) Quoting William Edward Hickson

Tis a lesson you should heed:

Try, try, try again.

If at first you don't succeed,

Try, try, try again.

that's 15...

Piling on, this is a perfect case for TRY_CONVERT, unfortunately not available before 2012

😎

Further on Luis's fine answer, works fine and unless there is something else affecting the code that we don't know of, then there isn't much to do;-)

😎

You can add some...

Ed Wagner (10/29/2015)

---

That's pretty slick, Eirikur. I appreciate how you use string replacement using the rows in sys.databases to generate the final SQL to fire. I've noticed that...