Grady,

How did you manage to prepend the "0x" to your columns to get this to work correctly?

SUBRAHMANYA HEDGE (3/23/2009)

---

If your database is not configured for Replication or Logshipping you can use following command to shrink your databse log file to death:

backup log with truncate_only...

RBAR? How so?

Heh... Amen Mr. Leach.

Agh... the code above needed a tweek... sorry about the error... it failed one scenario so I fixed it.

Michael Valentine Jones (3/22/2009)

---

The thread on the link below is a good example of a way not to generate a Next ID. I had thought about this method myself,...

Heh... see? Someone already started working on your stuff since you made it easy...

Giovanni (3/21/2009)

---

Jeff,

you were perfectly correct with the file extension issue. I was missing the "reverse" approach with T-SQL and that lead us to think of using CLR to be...

Heh... you either...

Lynn Pettis (3/21/2009)

---

We also need the proper "business" scenario. Could be something based on our past experience or something similiar. I guess we should come up with some...

Ashok (3/19/2009)

---

Thanks GSquared,

Exactly thats what I'm looking for :-).

And Steve, I suggest you to...

I actually did this because Phil sent me an email...

Matt (3/21/2009)

---

Alrighty, I've put in code to sop the parameter sniffing and that alone seems to have had a positive effect, I've also scheduled in a job to run in...

There're a couple of problems with that statment... first, there are disappointingly few programmers and a lot...

Heh... this is a pretty simple problem and I'd try to help but you keep posting data in that absolutely useless JPG format. I'm not going to copy from...