how to copy database and use to other system in sql server.

Frnds

not copied table data only procedure n function

0

madam

follow the below procedure to take script

Choose the advance button from the bellow dialog box at the top

select schema and data from the dropdownlist in the bellow dialogbox of option

Type of data to script

0

If the SQL server versions are same then just take a backup of your database (.bak file) and retore it in the new system. OR

While generating the scripts choose "Schema With Data" option

0