Using a sql server table in a non sql server machine

[yaniv]

I understand that you can use a sql server based tables on a machine with out sql server using msde engine, and i have a lot of samples that show how to create the sql strings.

what i cant understand is how do i copy the table to the clinet machine- i have built them using the enterprise manager, and i know how to copy them to another enterprise manager, but how do i put them on a machine without one?

 

[Robby]

You need to write a script which will create your database and tables. Using Enterprise manager simply right-click on the object and select Generate Script (or so).

 

[yaniv]

thanks robby.