The first thing I would suggest is you try to split that up into smaller procedures. First, it'll make it more likely for the thing to get an optimal plan,...

Please post the deadlock graph that traceflag 1222 produces.

So you want the lowest unused value from an identity column? Not a...

Can you describe your scenario in more detail please? Are you restoring a backup, trying to attach a database, something else?

Do you have a clean, uncorrupted backup of this database?

Can you be more specific? Primary keys don't have to be sequential, so the concept of 'highest unused' isn't something that applies to all primary keys.

I believe the highlighted name should be the logical file names, not the...

How about optimising the database query? That will...

That'll do it.

If you're rebuilding all indexes on all tables than you are 'changing' every row in the database. Index rebuilds are fully logged in full...

Sybase and SQL split...

winston Smith (1/8/2009)

---

im thinking the optimizer will pick the (string, dt, id) index as it has less rows to return with the string, max of 100, rather than 5000 or...

Why are you storing and modifying large pieces of xml in a database? Why are these claims not in their own table?

When's the last log backup from before the full? Full backups don't truncate the log, so you have to look at the activity from the last tran log.

Full recovery? Bulk...

Please don't edit your questions away. It just makes it confusing for everyone who reads it afterwards.

It's also polite to let us know if the solutions worked or not.

crfenix (1/8/2009)

---

but unfortunetly this approach isn't handle ALL error types and some times somethig wrong happens in the middle of the execution and there is no rollback with the...

I hate it...