One possibility

Using SSMS

1. Right clicked on System Databases

2. Selected the Restore option

And then entered the information for a user DB

Now I have not tested the above, not...

Discusman (2/9/2012)

---

bitbucket-25253 (2/9/2012)

---

Rather than use the Express Edition, which is extremely limited I would suggest purchasing the DEVELPER EDITION available from Amazon.com for less than $50 U.S. Dollars. It...

Our thanks to you to let us know we did assist even if in some small fashion.

Koen Verbeeck (2/9/2012)

---

Revenant (2/9/2012)

---

L' Eomot Inversé (2/9/2012)

---

MysteryJimbo (2/9/2012)

---

HowardW (2/9/2012)

---

MysteryJimbo (2/9/2012)

---

Interesting fact: Historically, it used to be in the UK that people drank more beer than water as it was sterile...

Sean Lange (2/9/2012)

---

My guess is you have something else in your code that is running slow. I have used his parsing function in all sorts of ways and places and...

Rather than fuss with your splitter code why not use an excellent splitter developed by Jeff Moden and tested by many and know to work.

May I suggest reading this:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

jcrawf02 (2/9/2012)

---

Seems timely on the heels of Lynn's news, a big THANK YOU to everyone who sent good thoughts my way a few weeks ago, I was nervous because....we're having...

Rather than use the Express Edition, which is extremely limited I would suggest purchasing the DEVELPER EDITION available from Amazon.com for less than $50 U.S. Dollars. It is equivalent...

SQLKiller

I really aplogize to everyone out there, i am a newbie to this community i just gone to the links you mentioned i felt so bad about my request.

i...

I had hoped that the question would make people aware of the "hidden problems/dangers" that can occur when using...

At first figured that either "you cannot add a salt", or the correct answer. Flipped a coin and well ... lost the point ... teach me not to gamble.

In...

Thanks .. I hope it is now corrected

I would suggest, to get a tested answer to your question, that you post the table definition(s) along with sample data and required results in a readily consumable format. ...

ronmoses (2/8/2012)

I work for a small software company whose desktop app runs off a small SQL Server 2005 backend. Typically 2005 Express is installed on the user's machine. We...

john.arnott (2/8/2012)

---

bitbucket-25253 (2/8/2012)

---

sathishkumar.k (2/8/2012)

---

Great question... Is that mean when any object with SP_ prefix used in combination with if (as in this case) would be searched in the current DB...