Link to home
Start Free TrialLog in
Avatar of huer
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.ConnectionInfo)

------------------------------

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
------------------------------
Avatar of momi_sabag
momi_sabag
Flag of United States of America image

have you tried to upgrade the database to a sql server 2008 database?
Avatar of huer
huer

ASKER

I removed the sql 2005 and installed sql 2008.
ASKER CERTIFIED SOLUTION
Avatar of momi_sabag
momi_sabag
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of huer

ASKER

No, i didn't. What is that for?
Avatar of huer

ASKER

That solved my problems. Thanks.