It won't be listed...

sunandas (12/10/2008)

---

I need to do reindexing as the tables are very big and if I wont do reindexing then locking in objects and for which the agent's system are hanged...

Thread continues: http://www.sqlservercentral.com/Forums/Topic616816-1291-1.aspx

Why did you delete the post with the table and index definitions? Please post them again. I can't suggest indexes without having the table definition at the very least.

Means that the corruption was present in that backup. Do you run checkDB regularly?

If this is 2005, check the error log for the startup messages. As SQL brings the DBs...

Unlike in Oracle, SQL doesn't require the from clause or a table to...

Chris seems to have the query sorted. I'll take a look when I have...

Is that the only index?

There's isn't a 'dual' table in SQL. What do you need it for?

Kishore.P (12/10/2008)

---

How, if the proc has been written over?

madhu.arda (12/10/2008)

---

Hi Jeff,

Iam curious to know why the available space for the database was showed as zero in enterprise manager and negative value when I ran sp_spaceused before running DBCC...

arup_kc (12/10/2008)

---

I have a notion than "SELECT D.Label" will take more system resources than "SELECT 1". And since EXISTS works on boolean value, hence no difference between the two but...

Have you got any other backup tools than litespeed? That looks like the kind of messages that a 'snapshot' backup tool would generate. They work by asking SQL to temporarily...

Find a backup of the DB that has the version of the proc that you want. Restore that alongside the existing DB and then script out the procedure

Why?