Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

About alter statement Expand / Collapse
Author
Message
Posted Tuesday, June 03, 2008 12:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, August 09, 2009 11:55 PM
Points: 24, Visits: 76
About alter statement

We have rolled out a new version of an application.
We used alter statement to modify some of our stored procedures.
When we viewed them in production it is looking like modified one.
But when application is executing, its referencing old SP only
I guess the older version is still referenced.
Can someone help us on this?
Post #510425
Posted Tuesday, June 03, 2008 12:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 03, 2010 2:32 AM
Points: 1,249, Visits: 400
Maybe your new procedures arent compiled?
Post #510427
Posted Tuesday, June 03, 2008 12:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 02, 2009 9:20 PM
Points: 1, Visits: 12
First check whether u have alter rights,

then check with the procedures correctly that the changes made by u were reflected in it, by taking the SP from database.
if not alter the procedure again,

check whether u have made some changes in talbe or triggers, if so do that changes too...

Hope it will work fine now.

Thanks - Raja
Post #510430
Posted Tuesday, June 03, 2008 12:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 03, 2010 2:32 AM
Points: 1,249, Visits: 400
try sp_helptext, this will give you the procedure as it is on the database
Post #510432
Posted Tuesday, June 03, 2008 12:32 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 11:47 AM
Points: 41,525, Visits: 34,442
Make sure the app is pointing at the right database.
Make sure that you don't have 2 copies of the procedure in different schemas



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #510433
Posted Tuesday, June 03, 2008 5:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:59 AM
Points: 14,796, Visits: 27,270
And in addition to making sure the App is pointed at the right database, make sure you are.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #510571
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse