I opened SSMSexpress and attached to my sql 2005 database and automatically created the scripts for creating all the object in a SQL 2000 DB. The objects seem to be created but I did get script messages. Are these messages harmless?
thanks
Milton
Msg 208, Level 16, State 1, Procedure Requestview, Line 3
Invalid object name 'dbo.requests'.
Msg 15135, Level 16, State 1, Procedure sp_validatepropertyinputs, Line 147
Object is invalid. Extended properties are not permitted on 'dbo.Requestview', or the object does not exist.
Msg 15135, Level 16, State 1, Procedure sp_validatepropertyinputs, Line 147
Object is invalid. Extended properties are not permitted on 'dbo.Requestview', or the object does not exist.
Extended Properties are not in 2000 and the question is why do you need them, it is not simple to move database from 2005 to 2000 so check out the long instructions in the thread below. Hope this helps.
http://forums.asp.net/thread/1494094.aspx
|||Not all extended properties are necessary for an database object, for example description for a object is also a kind of extended property. In SQL2000 you can usesp_addextendedproperty system procedure to add extended procedures, and the properties information will be stored in sysproperties system table.
No comments:
Post a Comment