If you really want to dig, take a look at the table master.dbo.spt_datatype_info. Probably will be easier if you look at the information schema view Columns.

Andy

You wouldnt think it would happen, schema locks would seem to be there to prevent this. I know I've seen errors occur when modifying an index live - a pain!

Andy

You can turn on auditing which will write it to the event log. If you'd rather have it in a table you could run a server side trace (though you...

I documented a shortcut I use - I think you'll like it better than backup/restore!

http://www.sqlservercentral.com/columnists/awarren/20010425205439_1.asp

Andy

Mine are also small enough and the time window sufficient that I use a daily full plus a demand driven log backup (based on log size). Differential really starts to...

Is your DTC running?

Andy

You need either a cursor or a while loop - and xp_sendmail. I'd recommend experimenting with xp_sendmail in QA until you know you have the syntax working, then work it...

There is a trace flag that will return "pretty" output - but still if you're using XML, use the stream.

Andy

Didnt do Transcender for this test - probably should have!

Andy

Sure...but each has its own little tricks. Not sure I want to have to learn ALL the .Net languages core syntax to stay afloat!

Andy

Certainly the limit is higher than 200 records!

Andy

Great! Better chance someone will stumble across it there.

Andy

Interesting. I will look around some more.

Andy

Steven, just got around to reading your post - is the 1G thing documented, or something you have discovered?

Andy

Have you added this to our script library?

Andy