Displaying disk space information about a table

sp_spaceused

Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or SQL Server 2005 Service Broker...

Check server's error log where a corresponding entry will be written.

The key to the message is the 'State' which the server will accurately set to reflect the source of...

using Visual Source Safe.

check the following link

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1093178,00.html

Mostly the naming conventions, usage of variables and logic building and style of coding

If your getting the problem in select statement i am sure there will be an varchar data in the filed. Check the data.

You can use DTS to copy the table into other database