Storing BLOBs in SQL Server, or an RDBMS is not really fun. The SQL Server 2000 Resource Kit has an example (Bii.exe) that is useful for an example. As well...

I found database journal had some good into lessons such as: http://www.databasejournal.com/features/mssql/article.php/1429671

or

http://www.databasejournal.com/features/mssql/article.php/1497971

The best way to learn it to use your own data, as you will find the biggest obstacle...

First you should look at your data types in Access. Access can store some non-standard dates and times. For example Access can store a time as 4:55:02 AM SQL Server...

I have the same issue with some web portal products. I just do it and don't tell the vendor. It is dishonest, but anytime I need tech support from those...

Great idea. I usually find it better to use the information_schema views so I altered your stored procedure as follows

select

o.[table_name] as 'table_name',

c.ordinal_position as 'column_order',

c.[column_name] as 'column_name',

e.value as 'column_description',

C.DATA_TYPE as...