yes it is possible. Occasionally SQL server will find it necessary to spawn off a new thread if it thinks it will be more optimal.

Thanks for finding that article.

GilaMonster (5/7/2010)

---

Here's the Oracle-SQL conversion problem. Maybe stay out for now, we're getting nowhere fast and I don't think adding more people nagging for table defs is going to help.

http://www.sqlservercentral.com/Forums/Topic915299-145-1.aspx...

b.noof (5/5/2010)

---

In Oracle it's a structure

but after i migrate from oracle to sqlserver it come a like u see it

i do the migrate with swiss its a soft...

Here is a document that goes through how to do that.

http://msdn.microsoft.com/en-us/library/ms187929.aspx

Hugo Kornelis (5/7/2010)

---

CirquedeSQLeil (5/7/2010)

---

Paul White NZ (5/7/2010)

---

CirquedeSQLeil (5/6/2010)

---

Though I got this correct, it appears there is a typo in the correct answer. My version had the last two flip-flopped...

Nice article. Thanks for sharing.

PaulB-TheOneAndOnly (5/7/2010)

---

CirquedeSQLeil (5/7/2010)

---

PaulB-TheOneAndOnly (5/7/2010)

---

eric_russell 13013 (5/7/2010)

---

This discussion just underscores why it's imporatant to always have at least 2 admins and 2 developers who know your database, just in case someone...

PaulB-TheOneAndOnly (5/7/2010)

---

eric_russell 13013 (5/7/2010)

---

This discussion just underscores why it's imporatant to always have at least 2 admins and 2 developers who know your database, just in case someone steps in...

At this juncture, I would certify in 2008 over 2005. The 2005 certification is becoming old. Much of the information is transferable up to 2008, and you would...

Jeff Moden (5/7/2010)

---

CirquedeSQLeil (5/7/2010)

---

eric_russell 13013 (5/7/2010)

---

This discussion just underscores why it's imporatant to always have at least 2 admins and 2 developers who know your database, just in case someone...

eric_russell 13013 (5/7/2010)

---

This discussion just underscores why it's imporatant to always have at least 2 admins and 2 developers who know your database, just in case someone steps in front...

Gail, now that you are more active in the forums again, does this mean that you are done with school for a bit?

I recommend you read that article that Gail posted. If you still have questions, come back and ask them.

I would take him any day over Jay Cutlass.