Re: Recompile SP

Article View: borland.public.interbase.sql

Article #11141

Back to borland.public.interbase.sql Previous Next

#11141

From: Phil Shrimpton
Date: Tue, 03 Dec 2002 14:33

13 lines
1379 bytes

In article <3dec7964$1@newsgroups.borland.com>, Frank Gruber says...

Hi,

> Does it mean that if I recompile a SP during maintenance time
> (nobody is connected to the db) I don't need to recompile
> dependent SP's ?

Yes, that normally works.  What we do when updating meta data is to do a 
backup/restore after the update, which although not required, makes me 
feel better that everything is in place <g>

Phil

Technical Details

Message-ID: <MPG.1856a10e2f3cd0b39896b0@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<3deb7cbc@newsgroups.borland.com> <3deb7e66@newsgroups.borland.com> <MPG.1855762b84f8224a98a2af@newsgroups.borland.com> <3dec7964$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,3206af6518bf1270
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-03 06:39:28 PST
From: Phil Shrimpton <phil@nospam.co.uk>
Newsgroups: borland.public.interbase.sql
Subject: Re: Recompile SP
Date: Tue, 3 Dec 2002 14:33:21 -0000
Message-ID: <MPG.1856a10e2f3cd0b39896b0@newsgroups.borland.com>
References: <3deb7cbc@newsgroups.borland.com> <3deb7e66@newsgroups.borland.com> <MPG.1855762b84f8224a98a2af@newsgroups.borland.com> <3dec7964$1@newsgroups.borland.com>
X-Newsreader: MicroPlanet Gravity v2.50
NNTP-Posting-Host: 213.123.214.81
X-Trace: newsgroups.borland.com 1038926020 213.123.214.81 (3 Dec 2002 06:33:40 -0800)
Lines: 13
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message