I'm more used to "funny" denormalization cases. Busy fixing a bunch of performance problems caused by an EAV structure right now.

In your case, it sounds like your bitmapping the...

Create a group called something like "LibraryExecutors" (sounds bad, you might think of a better name), put everyone in it, grant that group execute rights in your library database. ...

You won't be able to do text data (varchar) in the same column as binary data (image/varbinary).

It'll either need to be two separate datasets (some front end applications can deal...

You mention declaring Tag_image as image. Not sure what you mean. Do you have a variable or column named Tag_image, and you want to use the Image datatype...

Will the input value always be a formatted phone number with a 3-digit extension?

If so, you can brute-force it pretty easily:

DECLARE @Input CHAR(22) = '(915) 676-9090 ext 303', @Output CHAR(22);

SELECT...

Yes, but if there are two (or more) rows in the...

You'll need to dig into Kerberos in your case. It's definitely a double-hop issue.

Most often, Kerberos issues are handled by network admin personnel, not by the DBA. I...

L' Eomot Inversé (1/13/2012)

---

Divine Flame (1/13/2012)

---

L' Eomot Inversé (1/12/2012)

---

edit: I haven't looked at the posting history - just the the thread referenced here and the first thread it references -...

When you click Add Reply to a thread, there's an option at the bottom of the screen for what subscription you want. It sets that as your default when...

jez.lisle (1/13/2012)

---

The MERGE has been working very well now, which is great 🙂

One thing I do have a question on is this

I get this error below

Msg 8672, Level 16, State...

L' Eomot Inversé (1/12/2012)

---

Grant Fritchey (1/12/2012)

---

GilaMonster (1/12/2012)

---

I just had a...

I looked around a bit, and it seems the most common solution is to put a button on the page hosting the report, and have the button call a .NET...

In production code, I always use meaningful names, and avoid collision explicitly. I've never tried using temp tables with the same names in the same scope. I just...

L' Eomot Inversé (1/12/2012)

---

I disagree with you...

Do I need to run file 04 before running 05, or are they separate processes?

I may have misread it. I thought 04 and 05 were two versions of getting...