Thanks for the question.

This should be good to help people understand how ISNUMERIC works...

Paul White NZ (9/25/2010)

---

That can make a difference, yes. It used to be the case that SQLCLR functions that accepted a MAX data type could not use (SQL Server)...

bitbucket-25253 (9/22/2010)

---

bbsr

Might I make a suggestion.

1. Purchase the developer edition of SQL SERVER 2005 - Cost less than $50 USD.

2. Restore a back up of your 2000 DBs...

Brian McGee-355525 (9/24/2010)

---

I need help with setting up permissions in SQL Server. There are just two different levels of permission required:

(a) The ability to *just* execute existing stored procedures,...

learningforearning (9/24/2010)

---

creat a group and give 'Grant exec' to that perticular group. Later on you...

Tim Parker (9/25/2010)

---

Locking the SYSOBJECTS table down for an extended period of time is about as worse performance as you can get.

If you do a SELECT * INTO...

Stan Kulp-439977 (9/25/2010)

---

All you have to do is change "put" to "get."

You're path has to be pointing to a file that actually exists on the remote server, but that's about...

Paul White NZ (9/24/2010)

---

...but have you tested if there is much of a performance difference if the CLR didn't handle UNICODE characters? (Would it be better to have two versions,...

Perfect, I will have to try that out....

What CU if...

In my case I develop on...

Paul White NZ (9/24/2010)

---

Not right now. If I get a minute...

No problem, I agree it seems to be a step backwards. I like...

markmeiller (5/11/2010)

---

Good article. I have in the past used a simalar solution with Winscp, however we recently change some of our poliacys and the SSIS packagewas moved to a...

If you can provide the whole query I suspect that someone could help you solve this problem. (My guess is that you have given an alias to the #TUploadTo...