Article ID: 914781 - View products that this article applies to.
BUG #: 403914 (SQLBUDT)
Consider the following scenario. You upgrade an instance of Microsoft SQL Server Desktop Engine (MSDE) 1.0 or an instance of SQL Server 2000 Desktop Engine (MSDE 2000) to SQL Server 2005 Express Edition (SQL Server Express). On the upgraded instance, you try to create a new subscription by using one of the following methods:
There are other scenarios where you may experience similar symptoms, such as attaching or restoring a replicated database from an instance of MSDE to an instance of SQL Server Express.
Server: Msg 207, Level 16, State 1, Procedure sp_MSupgrade_subdb_security_metadata, Line 162 Invalid column name 'step_uid'.
This problem occurs because the msdb database is not upgraded when you upgrade from MSDE to SQL Server Express. Replication or subscription in SQL Server Express expects the upgraded schema for the msdb database, but no match can be found.
Service pack informationTo resolve this problem, obtain the latest service pack for Microsoft SQL Server 2005 Express Edition. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/913089/ )How to obtain the latest service pack for SQL Server 2005
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft SQL Server 2005 Express Edition Service Pack 1.
For more information about replication in SQL Server Express, visit the following Microsoft Developer Network (MSDN) Web site:
Article ID: 914781 - Last Review: May 11, 2007 - Revision: 3.2
Contact us for more help