var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: CREATE PROC Question
Gurus help me:
Here's the scenario...
Have a SP in the Master DB that creates a NEW, empty DB using a name I give it on the fly.
I need to Create a SP in that NEW DB.
Everything will be called from a DTS Package.
How to do this?
Can you tell us why you are doing this...
Just seems like a very bad idea....
Are you talking about MSDE?
I'll second the notion that this sounds like a bad idea. It can certainly be done, but there are lots of things that you
can do, but shouldn't!
"Location: In front of the computer"
Moe, Larry look, it's a DBA with a sense of humor...
Why I oughtta....
It's to automate Replication (see my other posts).
We have a subjective DB name @ the Publisher that has to be acquired, then replicated EXACTLY.
This procedure will create the Subscription DB & then create the SP to complete the the subscription itself.
Clear as Mud?!?!
(BTW - GREAT reply to the recruiter. He suddenly became less verbose!)
Sounds ambitious...how many subscribers do you expect to have...
Just a single other instance...But we'll do this MONTHLY.
HOWEVER, we have to duplicate the process in reverse later on.
Ambitious pretty much hits the nail on the head!!!
I wouldn't support that kind of design, but here's your answer:
create procedure <your_procedure>...
That's a lot of effort to think outside the box....why complicate things?
Did you get it or I have to explain it?
I see where you're going, but if I want this code in a SP OR for that matter in an ActiveX module of a DTS, I can't get away with "USE".
But your only replicating monthly?
Why not dump and restore?
MAYBE 10 lines of code
You don't call this code from anywhere, you write it in QA. Since you already have the code to create a database, you won't have to worry about creating a procedure every time your ASP code creates a database, the procedure will already be there...Can you try it at least?
I'll do some more work & let you know how I fare.
(It's past 5pm here - time to blaze!!!)