Me 2... it depends on the sql server version as well which was not specified in the question. ...

Jeff Moden (12/2/2010)

---

Ninja's_RGR'us (12/1/2010)

---

pspeagle (12/1/2010)

---

I have read that using the SELECT column list INTO #tablename syntax to create temp tables holds locks in tempdb (create object locks) for the entire...

johnf_amic (12/2/2010)

---

A 'correct' answer is one that matches the exact set of correct choices. No partial credit,...

Christian Buettner-167247 (12/2/2010)

---

jeff.mason (12/2/2010)

---

It is not only that. Constraints should prevent invalid data updates no matter where...

jeff.mason (12/2/2010)

---

It stumps you because you wouldn't want to do that. Pure...

Yup, but without factoring for...

I'm not sure you guys are talking about the same thing :

Rebuild is used to make a copy of the index and drop the old one (which 100% defrags...

97% wrong answers??? Maybe there's something not quite correct with the question.

More to the point. If my column needs to contain NULL, I'm not going to fiddle around...

Please post the create statement for both the table and indexes and the drop statement you are trying to execute.

pspeagle (12/1/2010)

---

I have read that using the SELECT column list INTO #tablename syntax to create temp tables holds locks in tempdb (create object locks) for the entire duration of the...

Shawn Melton (12/1/2010)

---

I don't see the confusion on why the only acceptable answer would be the 3rd option. Of course I might think differently than others.

1) Retrieves the name of...

Ann Cao (12/1/2010)

---

And Ninja's_RGR'us, could you tell me a little bit what problem you have when you applying service pack to SSRS?

I never have an experience of applying sp to...

Reposting msg from other thread :

chris.s.powell (12/1/2010)

---

We recently just performed this exact scenario as we were wanting to add new hardware but keep the server name and SQL version....

Moved here. plz no further posts in this thread.

http://www.sqlservercentral.com/Forums/Topic1028810-146-1.aspx

That's one of the reasons I wanted to see when it failed... my next questions would have been what's the error and what else is taking a lot of ressources...