For my product catalog system, i'm confused between SQL server database and SQL CE. My host company just gives 200 megabytes of SQL server, as the disk space found here is 10 GB.

I've four tables with brands, items, picture and merchants. The pciture table just stores the url and never the binary data. So the number of records can this database have. May be the 200 megabytes space enough for my requirement and it is possible to method to calculate all of this

The reply is complicated and can't be very exact. Begin to see the following

Estimating the Size of a Database

This question can provide you with an awareness of the items your min, max and average record size for every of the tables is:

SELECT 
    OBJECT_NAME(OBJECT_ID) AS 'Table Name',         
    record_count,
    min_record_size_in_bytes,
    max_record_size_in_bytes,
    avg_record_size_in_bytes
FROM
    sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')

Go ahead and take max size for every row, and multiply it by e.g. 1000 and find out just how much space 1000 rows each would occupy - and move from there.