InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 11:12:25 GMT20http://www.sqlservercentral.com/Forums/Topic1188226-265-1.aspxi remember that SQL 2000, via enterprise manager, it is possible to use the GUI to change the [b]text [/b] of the procedure, but without [b]executing [/b]that new definition , so you could have a definition that is different than the compiled body of the proc.so you are seeing effectively the same issue in 2008? i thought that was addressed by SSMS always scripting it out? or are you looking at a 2000 server that that effect may have occurred?Tue, 11 Oct 2011 04:22:26 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1188226-265-1.aspx[b]In a SQL 2000, I have 2 stored procedures[/b]sproc1sproc2and using sp_helptext to see the SQL definition of that object[b]exec sp_helptext sproc1[/b]returns:...create procedure sproc1...[b]exec sp_helptext sproc2[/b]...create procedure sproc1 -- That is not a typo ....sproc1...[b]I also tried a query like:[/b]syscomments inner joined with sysobjects to return:syscomments.textsysobjects.nameThere are a few rows of syscomments.text...create procedure sproc1...[b]for both stored procedure object.[/b]yet when I [b]use SSMS & right-click modify[/b] / alter / drop and create...... procedure sproc1 or sproc2 -- depending where the right click was done...BTW-the same result happened in SQL 2008 (not R2) SQL Server.Let me please ask the questions:How could the right click (modify / alter / drop and create) be correct yet a query on the system tables or system stored procedures return in-correct?Does this mean that the system tables of the user database are corrupt?Is there a way to fix this? DBCC CheckDB?[b]Thank you for your time and any ideas to fix this system table corruption?[/b]Tue, 11 Oct 2011 00:51:51 GMTron_leg