SQL Guy 1 (10/10/2012)

---

Here is my scenario: I backup a production database and restore it to dev environment. But after the database is restored, I don't want to have...

yogi123 (10/10/2012)

---

Hello Everyone

I Have one task, in that there are two tables,

one has student testing dates

and other has student enrollment dates.

CREATE TABLE #TestDates

(

iSchoolYearCode int NOT NULL,

dtStartDate DATETIME NOT NULL

)

insert into...

Jeff Moden (10/3/2012)

---

XMLSQLNinja (10/3/2012)

---

In the same article he does recommend, for example, using a CLR for regexs (he includes a couple in the article). He tests the regex CLR vs...

p.s. thanks jeff for the link... I am still reading that (very long) thread. Great stuff.

bteraberry (10/3/2012)

---

The Dictionary.com definition of kludge:

I would...

deebabat (10/3/2012)

---

Ok. We're getting somewhere.

Re: missing tables-You will need to create a subscription to the second publication to get those tables. Each subscription can only subscribe to one publication.

Re:...

... one other...

Ok. We're getting...

Are you getting all the tables from one publication and not the other?

Eugene Elutin (10/1/2012)

---

A couple of us just went through all of this on another thread a couple of months ago and the LIKE expressions blew the doors off the RegEx...

Jeff Moden (9/28/2012)

---

XMLSQLNinja (9/28/2012)

---

bteraberry (9/28/2012)

---

Microsoft invested a huge amount of effort/time/money into CLR to give us tremendous capabilities. I have been told by someone close to the SQL dev...

Jeff Moden (9/28/2012)

---

XMLSQLNinja (9/27/2012)

---

Hogwash. There is nothing "high cost" about a well written CLR.

Avoid this kludge if you...

bteraberry (9/28/2012)

---

Microsoft invested a huge amount of effort/time/money into CLR to give us tremendous capabilities. I have been told by someone close to the SQL dev team at MS...

Hogwash. There is nothing "high cost" about a well written CLR.

There's nothing "kludgy"...

no problem. 😀