No page restores this time, but now I have a good reason to convince the powers that be to let me change it to full.

We have good backups (something that...

Thanks for the reply Gail. That's pretty much what I thought, but I really appreciate the confirmation. Unforunately, this is pretty much a batch server, so we keep it in...

Thanks! The number of rows output is exactly equal to the rewinds+rebinds. I just wasn't thinking about it correctly. Thanks very much for clearing that up!

Hi Pam, I went for SQL Response knowing that the new version would be coming out pretty soon (SQL Monitor), and it's pretty nice. Another benefit was a much lower...

It's an older Dell SAN model. That's why we're moving this database to a new server. We've noticed that when we do almost anything slightly intensive with this database we...

Thanks for the replies. The database is about 550 Gb. We made a couple of strategic errors with the server, so we're looking to move this database off to another,...

Hi Lutz,

It looks like the addtl. note is actually what I needed the most. I can get a maximum of 8192 characters with that, which is enough...

I started playing around with the FOR XML, but the problem is that it cuts the data(string?) off at 256 characters. I need to get the whole thing. This is...