This line is removing spaces from your options:

SET @tempItemList = REPLACE (@tempItemList, ' ', '')

However, rather than fixing that, I recommend replacing the whole function. Here's an article on...

Jayanth_Kurup (7/18/2011)

---

Having just tried it , i noticed something that might be of interest.

If SQL is already compressing the backup then using winzp or winrar doesnt do a great job...

Whether you care about SQL Agent being up or not depends on what you have it doing, and how important those jobs are to you.

How about simply denying them permission to access that database through normal SQL Server security practices. The DDL trigger to log database events will need to have permission to...

Brandie Tarvin (7/14/2011)

---

May I just mention that many people in this debate are forgetting that historically speaking, there is a predecessor to paying taxes. It even predates feudalism.

It was...

I didn't answer the part about how much I would pay because again, it is overly simplistic. We don't operate in a vacuum. I need input to determine the correct...

Sounds normal to me.

I have to ask: Why are you worried about a table being dropped? Why is it okay if other tables get dropped?

Can you post the code for the UDF (dbo.Split)?

Stefan Krzywicki (7/14/2011)

---

jcrawf02 (7/14/2011)

---

Stefan, we have the luxury of contributing because we choose to (anticipating the mutual benefit), but that benefit was hard-won by those who did it because they...

Stefan Krzywicki (7/14/2011)

---

GSquared (7/14/2011)

---

Stefan Krzywicki (7/12/2011)

---

GSquared (7/12/2011)

---

Unless you define a social contract as "anything two or more people agree to, even if the agreement is coerced", you can't call the...

Tom.Thomson (7/14/2011)

---

GSquared (7/12/2011)

---

The idea that "law" and "non-coerced social contract" are synonymous, or even in agreement with each other, is based on a very small sample of a few laws...

If you need to do it at the database server, a CLR proc/function will do it much more efficiently than T-SQL.

Stefan Krzywicki (7/12/2011)

---

GSquared (7/12/2011)

---

Unless you define a social contract as "anything two or more people agree to, even if the agreement is coerced", you can't call the laws of pre-Magna...

How are the stats on buffer hits and plan reuse?