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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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