Home Forums SQL Server 7,2000 Administration Database with bad views and procedures RE: Database with bad views and procedures
HenryTr
SSC Eights!
Points: 845
More actions
July 25, 2003 at 9:17 pm
#467169
Try a dbcc checkcatalog as well as forcing a recompile on every table, view and SP.
Also take a peek at the data in syscomments.
Good Luck
Henry