My question is how to copy (import or export) store procedure from one data base to another with SSMS. My research showed that I can create a script and run this script at the destination database with query analyzer. I believed that I successfully created the script but I'm not sure how to execute the script with SSMS. FS
Try looking at this kb article. http://support.Winhost.com/KB/a694/publishing-your-sql-2008-database-to-Winhost-sql-2008-server.aspx Or if you can obtain a backup of the database you can use the Restore/Backup feature to get your database on our sql server. http://support.Winhost.com/KB/a771/how-do-i-generate-or-restore-a-backup-of-my-database.aspx
Ray, Thanks, I tried and it did what I want it to do. I saw the instruction but it was not click to me before I read your replied. FS
