Newbie q Making databases downloadable

[partymong]

Hi,
I hope someone can help me, I'm new to SQL server.

What I want to do is make the databases I have on my server downloadable via the web. I have IIS installed.

I can get a list of all the databases querying the sql server master database, but can't make them downloadable because the SQL server has them attached/open.

Would I have to create backups and make them available?

Any help would be appreciated.

Thanks

P

 

[nigelrivett]

Probably best to backup the database and then zip the file and allow the zipped backup to be downloaded.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.