>Hi everybody,
>
>I guess the answer is NO, but just in case - is there any way in SQL 2000 (or SQL Server 2005) to script actual insert statements for the table if there are only few rows?
>
>Or what is the easiest way to update tables from one computer to another?
>
>Thanks in advance.
Instead of scripting, wouldn't it be easier to detach or take offline from source and attach at target?
I use it to carry the db between work and home computer (provided it's not huge for carrying on USB stick or something like that).
-Detach
-Zip data files
-Attach
On target:
-Unzip
-Attach
Instead of scripting SQL server itself use this one or data as csv files to bulk load on target via a script. You may check SQL2008 CTP sample databases from codeplex.
Cetin