Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (20.3k points)

I am new to SQL, and what I needed to do was to combine 2 .mdf databases into one. I did that using SQL Server 2008 Manager - Tasks > Import/Export tables. The tables and views were copied successfully, but there are no Stored procedures in the new database. Is there any way to do that?

1 Answer

0 votes
by (40.7k points)

Follow these steps:

  • Right-click on database
  • Tasks
  • Generate Scripts
  • Select the objects you wish to script
  • Script to File

Run generated scripts against the target database

Related questions

0 votes
1 answer
0 votes
1 answer
asked Jul 19, 2019 in SQL by Tech4ever (20.3k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.6k answers


108k users

Browse Categories