SP upgradation?

greenspun.com : LUSENET : SQL Server Database Administration : One Thread


Can a SP which has Insert and Delete statements upon system table be upgraded?

Thanks, Kothan.

-- Anonymous, April 20, 2000



As far as I know, if the system table, the columns that you are referencing in it, and the data type of those columns are the same in SQL 7.0, then the upgrade should work. Of course, the system tables belong to Microsoft and MS has made many changes, so double check before upgrading. Be careful, in particular, of inserts that have not explicitly listed the columns. These inserts will fail if the number of columns changes.

Good Luck,


-- Anonymous, April 20, 2000


Thanks you so much.


-- Anonymous, April 22, 2000

Moderation questions? read the FAQ