huer
asked on
Cannot create publication on sql 2008 when the attached DB is created on sql 2005
Hello, expert,
I detached a db from sql 2005 and attached it to sql 2008 server. Then i want to create a replication for this db on sql 2008. When i create a publication with the Wizard, i got this error message.
Please help me,
Thanks,
huer
TITLE: New Publication Wizard
-------------------------- ----
New Publication Wizard encountered one or more errors while retrieving publication names.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22&EvtSrc=Microsoft.SqlServer.Management.UI.PubWizardErrorSR&EvtID=CantGetPubNames&LinkId=20476
-------------------------- ----
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne ctionInfo)
-------------------------- ----
Invalid column name 'originator_id'. (Microsoft SQL Server, Error: 207)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
-------------------------- ----
BUTTONS:
OK
-------------------------- ----
I detached a db from sql 2005 and attached it to sql 2008 server. Then i want to create a replication for this db on sql 2008. When i create a publication with the Wizard, i got this error message.
Please help me,
Thanks,
huer
TITLE: New Publication Wizard
--------------------------
New Publication Wizard encountered one or more errors while retrieving publication names.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22&EvtSrc=Microsoft.SqlServer.Management.UI.PubWizardErrorSR&EvtID=CantGetPubNames&LinkId=20476
--------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne
--------------------------
Invalid column name 'originator_id'. (Microsoft SQL Server, Error: 207)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
--------------------------
BUTTONS:
OK
--------------------------
have you tried to upgrade the database to a sql server 2008 database?
ASKER
I removed the sql 2005 and installed sql 2008.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No, i didn't. What is that for?
ASKER
That solved my problems. Thanks.