Did you create (or already have) the user in the database before you gave them permissions? That's the usual sequence.

Revenant (4/12/2012)

---

GSquared (4/12/2012)

---

GilaMonster (4/12/2012)

---

Today's example:

SELECT <stuff> FROM

Table1

inner join (SELECT <more stuff> INTO #Temp FROM AnotherTable) ON <join clause>

inner join (....repeat...

Important note: Don't start shrinking files till you've done a few more steps to prep for that. I mentioned shrinking files, and don't want you to get ahead of...

It won't free up disk space directly. You'd have to either delete files or shrink files for that.

Log backups, in Full recovery, will usually free up space inside the...

Log backups would be a good place to start for that.

But if the databases were in Simple recovery, and they're full anyway, that won't help. You'll need to expand...

GilaMonster (4/12/2012)

---

Today's example:

SELECT <stuff> FROM

Table1

inner join (SELECT <more stuff> INTO #Temp FROM AnotherTable) ON <join clause>

inner join (....repeat several more...

Steve Jones - SSC Editor (4/12/2012)

---

Both printers here are acting up. One doesn't want to inject ink on the the paper. The other keeps sending offline messages to the...

GilaMonster (4/12/2012)

---

I'm getting very frustrated (and very saddened) by the (apparently) increasing number of people who seem to feel that writing T-SQL is about throwing code segments together at random...

Lynn Pettis (4/12/2012)

---

GSquared (4/12/2012)

---

Eugene Elutin (4/12/2012)

---

...

It's entirely possible someone with better C#/VB.NET skill than mine can make a CLR function that's faster, but the options I found online for...

If you want to test equality conditions, you can do this:

Where @Parameter in (Col1, Col2, Col3)

That will find any column that is equal to the parameter value.

Can't do that so...

Grant Fritchey (4/12/2012)

---

Not much. There'd just be a few more unchallenged...

I just ran another speed test. 23,028 rows needed phone numbers cleaned. Took 734 milliseconds total, 733 ms CPU time.

Eugene Elutin (4/12/2012)

---

...

It's entirely possible someone with better C#/VB.NET skill than mine can make a CLR function that's faster, but the options I found online for that were all...

dwain.c (4/12/2012)

---

GSquared,

Thanks for pointing out an issue with the ampersand REPLACE I was doing. I corrected my post accordingly.

Now as to performance, I'm curious why you think the version...

If you want a more efficient version, that doesn't require as much pre-processing, any CLR, etc., try something like this:

CREATE TABLE #T (String VARCHAR(100)) ;

INSERT INTO #T -- Sample...