You're kind of stuck. There's no way to simply modify the column. You can recreate the table, which is what the GUI is trying to do for you, or you...

The basic syntax is like this:

CREATE TABLE x

(MyIdColumn int identity(1,1))

And the TSQL syntax is to add REPLACE to the WITH clause of the backup.

Jeffrey Williams-493691 (2/28/2011)

---

There is a very small possibility that you could be in the middle of a transaction log backup - and the drive becomes unavailable just at the right...

If you just put a delay in the transaction log backups during that period you can avoid the issue. That's what I'd do. Otherwise, no, I don't think a driving...

It kind of depends on the type of log backup failure, but yes, some of them will break the recovery chain. You'll pretty much know the next time you go...

Even though the database is in 80 compatibility, I'm pretty sure you can capture the exec plans from cache, so if the bad plan happens, snag it quick, jsut before...

Just a side comment, frequently when dealing with UNION, UNION ALL is a way of speeding things up, not slowing things down. If you're hitting problems, it must have to...

Not seeing the full plan, I can't guarantee my answer, but, if the operator accessing the cluster says that it's a key lookup operation, deferred or not, that's what it...

Glitch. Edited.

I find the deadlock graph in Trace can sometimes not provide enough information to really figure out what's up with some deadlocks. You might be better off using the data...

In terms of queries, the most important thing would be to write them well to begin with. I'd take a look at Itzik Ben-Gan's TSQL Querying book. There are some...

It's not a "known problem" it's a particular behavior. I'm not sure why some of the logs thought that there wasn't a full backup, but it's a switch that gets...

dixon_dwayne (2/27/2011)

---

DNA_DBA (2/26/2011)

---

You shouldn't really need to shrink your transaction log files; the database has worked hard to make them the size they are to accommodate the work that is...

wildfairy1 (2/27/2011)

---

OK i will definitely avoid looping , thanks for your suggestion. One more thing that i wanted to know about is the Count function in T-SQL. I did...