SP upgradation?

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

Eric,

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

Thanks, Kothan.

-- Anonymous, April 20, 2000

Answers

Kothan,

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,

Eric

-- Anonymous, April 20, 2000


Eric,

Thanks you so much.

Kothan.

-- Anonymous, April 22, 2000


Moderation questions? read the FAQ