Re: How to DTS SQL Files to update Procs?

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 04/09/04 

Date: Fri, 9 Apr 2004 08:50:41 +0100

OK so from what you mention you want to keep SPs on one system in sync with
the SPs on another. You can easily do this using SQLDMO. You would script
them out to text file, change the CREATE to ALTER and then replay the file
using OSQL (Look in BOL) 

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"JDP@Work" <JPGMTNoSpam@sbcglobal.net> wrote in message
news:%23xYUmbaHEHA.2580@TK2MSFTNGP12.phx.gbl...
> If there is an easier way, please advise.
>
> Here's what I want to do.
>
> Say I have 30 stored procedures that I want to be sure are up to date and
expect
> changes to in the development system.  I then want to update in the live
system.
>
> I'm happy going thru the scripts one at a time as needed, and I'm
confident that
> no changes have been made in the dev system, but not in production where
there
> are many hands turning the handles.
>
> So, I would like to create a folder called "Finals" that is sub to the
stored
> proc's folder.
>
> I'd like to read each proc found in the folder and run them to update all
30
> procs in one step via DTS.
>
> What components do I need?
>
> For example I'm thinking that I need FSO, but I'm stummed at the next
steps,
> starting with how to read an SQL file and execute it.
>
> TIA
>
> JeffP...
>
>

Relevant Pages

  • Re: Sharepoint as a way of managing projects
    ... SQL Server 2K but nothing for WSS) and thus not at the price levels of SPS. ... The WSS newsgroup is microsoft.public.sharepoint.windowsservices ... > involved (contact details, task lists, documents, specifications, ...
    (microsoft.public.sharepoint.portalserver)
  • Re: error: "Failed to generate a user instance of SQL Server due to a failure in starting the proces
    ... time the user creates a User Instance connection, ... Files\Microsoft SQL Server] directory. ... folder to the Microsoft supposed "default" folder, ... I've checked the permissions and found that the ASPNET user not listed on ...
    (microsoft.public.sqlserver.connect)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I granted the SQL Server Service Account "Full Control" over ... the Snapshot Folder and the job has been running successfully ever since. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)
  • Re: install/configure SQL Server 2000, SQL Server CE for merge rep
    ... I was wondering what the significance is to sharing the snapshot folder. ... Does the Pocket PC directly access the shared folder? ... >> check the replication monitor in SQL Server 2000 Enterprise Manager ...
    (microsoft.public.sqlserver.ce)
  • How can I create a content index for a single SPS site?
    ... I want to provide a programatic search of a particular folder in an SPS 2003 ... Created a new Content Index called Test with a Source Group called Test. ... SharePoint Portal Server Site Directory and specified the same site but it ...
    (microsoft.public.sharepoint.portalserver)