First, you are saying you don't have any good backups of the database?

Second, what is the error(s) that took the full-text index offline?

Just guessing here, because you are running Activity Monitor and it accesses the server?

Pratap Prabhu (12/14/2009)

---

As mentioned its for parsing Parameters passed in to a stored proc. In a real world scenerio an app would let a user select multiple items in a...

My guess, and that is about all I can give since you haven't really provided a lot of info, would be one of two things: Parameter sniff or stale statistics.

If...

You do realize since your routine is a multi-statement TVF that the Quesry Optimizer...

And a cannon to launch them, maybe?

Hey Steve,

Got some swag for the person who posts the 10,000 post on The Thread?

Post your code, maybe someone will be able to figure out what is wrong.

Alvin Ramard (12/11/2009)

---

Lynn Pettis (12/11/2009)

---

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall...

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall be mine (or anybody...

GSquared (12/11/2009)

---

On the subject of beer, one of my favorite jokes is that the human body is the world's most efficient machine at turning European beer into American beer. ...

Okay, so it gives an error. Care to share what that might be?

Actually,...

Merry Christmas and Happy New Year to you as well. May the holidays be good to you.

mahesh.vsp (12/11/2009)

---

If that is the case, tell me whether following thing works for side - by - side upgade?

1.Install SQL 2008 with SP1

2.Restore or overwrite the system databases. i.e. master,msdb.

3.restore...