Viens-tu du Québec / France?

codebyo (9/26/2011)

---

Ninja's_RGR'us (9/26/2011)I've not tested that way either. What I do is save the output (only errors) and if anything is inserted into the logging table then I assume...

DECLARE @demo TABLE (ID SMALLINT IDENTITY(999, -1) PRIMARY KEY CLUSTERED, sometext VARCHAR(50))

INSERT INTO @demo (sometext) VALUES ('one')

INSERT INTO @demo (sometext) VALUES ('two')

INSERT INTO @demo (sometext) VALUES ('three')

SELECT...

The same way you start this one. Browse to the correct forum and add topic.

you can set the starting value for an identity column and ask it for descending numbers.

Next time, please start a new thread for new question.

What's the error, the circumstances, what works, what doesn't? What happened when it failed.

You're still not giving us the info...

codebyo (9/26/2011)

---

Isn't it possible that at the end of the "DBCC CHECKDB" step you would choose "On failure action" as "Quit the job reporting failure" and all of the next...

prakash 67108 (9/26/2011)

---

i don't know what exactly the problem is ? actually one of my friend asked me what is the way to retrieve the table if it is crashed...

What I do here is have 1 job for each process of the beackup process.

If checkdb fails I disable the delete old backups jobs and 1-2 others.

That way you keep...

Restore from backup or redo everything you did to get it to the point where it...

I meant when you run the query and it fails to return anything.

You may have hit a bug. PSS might be your only option at this point. For only a few 100$ it might not be a bad idea to...

meelan (9/25/2011)

---

Lowell

Thank you for the reply. I will check on this matter deeply as I have seen the same issue in few SPs earlier

Jeff Moden:

I thought a UDF will improve...

The main difference is how the statements are logged. Both are logged so that they can be rolled back.

Obviously that has no effect on a previous backup.

Patti Johnson (9/25/2011)

---

Yes, this is a good one. I was thinking about a script that based on the fragmentation of the index would pick if it should reorg it...