SQL Server Connection

[atmosphere1212]

Hey

 

Does anyone know if its possible to distribute a SQL Server database?

 

If not, is it possible to create an SQL Server database on the fly?

 

Thanks

[bri189a]

You can't think of a SQL Server database as an Access database, it's whole 'nother animal. Get yourself MSDE from Microsoft (it's a free download). After working with it a bit you'll have answered a lot of questions. SQL Server creates new, imports, and exports. To do it through code requires TSQL knowledge, however you might be able to do it with simple, but equivelant Execute-Non-Query statements - I've never tried to be honest, but you will need to still worry about the connection and login, and the server still has to exist at some location regardless of how you do it.

[PlausiblyDamp]

You can always detach a sql database (sp_detach_db), copy the .mdf .ldf (and any .ndf if they exist) to the new server and can then attach them there (sp_attach_db) Edited September 25, 2004 by PlausiblyDamp

[atmosphere1212]

You can always detach a sql database (sp_detach_db)' date=' copy the .mdf .ldf (and any .ndf i9f they exist) to the new server and can then attach them there (sp_attach_db)[/quote']

 

What are these sp_attatch_db and sp_detach_db u speak of?

Also, im not to familar in this whole subject. do you think you could explain a little more. ie, im not sure what servers my users are going to have, so do i have to make a new one? how?

[PlausiblyDamp]

sp_attach_db and sp_detach_db are two stored procedures that are part of a standard SQL server install.

If you use a tool like Query Analyzer to execute them they will allow you to copy the physical DB files from one location to another and then re-attach the database to the new server - effectively allowing you to copy a DB between PCs.