RE: Multiple SP Versions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Bell (jbellnewsposts_at_bhotmail.com)
Date: 03/23/04

Next message: Hari: "Re: Copy DB,Packages etc to another computer .."
Previous message: Tibor Karaszi: "Re: db restoration via shared folder"
In reply to: Greg Bacchus: "Multiple SP Versions"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 23 Mar 2004 01:06:07 -0800

Stored procedures can contain a verson number see "; number" in http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_4hk5.asp?frame=true. I would not call the stored procedure through the application but not by using dynamic SQL everywhere.

You may well have serious maintenance issue with running more than a few versions of a stored procedure, therefore you may want to think about a more formal upgrade process.

John

Next message: Hari: "Re: Copy DB,Packages etc to another computer .."
Previous message: Tibor Karaszi: "Re: db restoration via shared folder"
In reply to: Greg Bacchus: "Multiple SP Versions"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: the most bizarre thing
... buddy (john) and i were playing a par 3 course in knoxville, ... come up on a maintenance crew on number 3 and then more workers on 18. ... at each other and he said you hollered i hit the ball and it goes over ...
(rec.sport.golf)
Re: the most bizarre thing
... buddy (john) and i were playing a par 3 course in knoxville, ... come up on a maintenance crew on number 3 and then more workers on 18. ... at each other and he said you hollered i hit the ball and it goes over ...
(rec.sport.golf)
Re: the most bizarre thing
... buddy (john) and i were playing a par 3 course in knoxville, ... come up on a maintenance crew on number 3 and then more workers on 18. ... at each other and he said you hollered i hit the ball and it goes over ...
(rec.sport.golf)
Re: Updating Image data
... As you are selectively updating the record anyhow I suspect there will ... branching in a stored procedure can cause recompilation which can be a ... > Thanks John. ... > Update Images Set ...
(microsoft.public.sqlserver.server)
Re: the most bizarre thing
... buddy (john) and i were playing a par 3 course in knoxville, ... come up on a maintenance crew on number 3 and then more workers on 18. ... at each other and he said you hollered i hit the ball and it goes over ...
(rec.sport.golf)