1) Is there away I can get the size of my database? Maybe use the schema or something?

2) Anyone know of away to enforce relational integraty on a table where one field could be the key for multi tables? I.E. PictureOwnerGUID could be the key for a product, contact, quote, logo, message, or 00000-00... for none. I wanted to allow delte cascade and not have to worry with a transaction because I've never done a transaction in SQL Server.

3)Transactions, Rollback, and Commit. I understand the concept, but could anyone show me the SQL and asp.net code for a simple say 3 part Transaction or whatever. Nothing super complex or anything. Just a real basic one. I know it has to execute on the same connection. That if you call rollback everything goes back to before the transaction started, and when Commit is called everything is saved. I just haven't seen one for sql server or the .net code before.

Hope you guys can help. I can get a book for a few days.