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?
RobbieDCan 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!
-PatP|||"Location: In front of the computer"
LOL
Moe, Larry look, it's a DBA with a sense of humor...
Why I oughtta...|||Hey Brett:
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:
use model
go
create procedure <your_procedure>...
go|||Just 1?
That's a lot of effort to think outside the box...why complicate things?|||Got any suggestions?|||Did you get it or I have to explain it?|||Sorry rdjabarov:
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
Done!|||robbied111,
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?|||THANKS All.
I'll do some more work & let you know how I fare.
RobbieD
(It's past 5pm here - time to blaze!!!)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment