June 16, 2005 at 4:05 pm
In EM, I could select multiple SPs and script it so that I could run it on a different instance of SQL Server using QA. This was very convenient for me as I could quickly create multiple SPs. In Management Studio, I want to be able to do the same but I can't seem to select multiple SPs.
June 16, 2005 at 10:22 pm
(In Object explorer pane) try right clicking on the DB in question, then from the context menu select Tasks|Generate Scripts. This then fires a wizard (yeehaw) that will do what you're wanting (ie select sprocs, tables etc etc for scripting).
Cheers,
Steve.
June 17, 2005 at 9:12 am
I tried that. I get "Operation not supported in version 8". This is probably because my DB is still SQL 2000 and not 2005. I guess in case of 2000 I still have to use my good old EM/QA combo.
June 18, 2005 at 5:43 am
Is there anything special about your stored procs? I just tried this against a SQL2K (sp3) DB via SSManagement Studio (June CTP) and it worked fine both to query window and text file.
Steve.
June 18, 2005 at 7:59 am
There is nothing special. It works when I try to run it or try to create it individually. I don't get an error. It is only when I want to copy multiple SPs over to a new server.
June 18, 2005 at 10:37 am
yaip, are you on the June CPT or April?
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
June 18, 2005 at 10:41 am
april. i didn't even know there was a june ctp.
June 18, 2005 at 6:15 pm
I tried to install June CTP and ran into problems. On the screen where it expects either a default instance or a named instance, I chose default instance and then I got an error.
I already have the April CTP installed. What am I not having if I don't install the June CTP? If I do have to install the June CTP, do I have to completely uninstall the April CTP before proceeding with the June CTP install? All I would be interested in the client tools. I still will have SQL Server 2000 as my database.
June 20, 2005 at 6:43 am
I had to all but reformat my drive in order to get the June CTP installed. You will need to, at the least, uninstall the April CTP first.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
June 20, 2005 at 9:28 am
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply