September 23, 2008 at 12:39 pm
Is there an easy way of copying views from one database to another? I cannot seem to find a method for this
September 23, 2008 at 1:34 pm
Right-click on the view in Object Explorer and script as CREATE to new query window. Change the connection or database in the query window to the system\database where you want to create the view - execute.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 23, 2008 at 6:04 pm
Works great. Thankyou very much!
September 24, 2008 at 7:27 pm
Glad I could help
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 24, 2008 at 8:26 pm
Also - if you want to do a bunch at a time...Right-click on the DB name, Tasks, Generate Scripts, pick the objects you want and voila. Play around a little with the scripting options, and you can literally recreate any number of objects in a single script.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply