• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2282
  • Last Modified:

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
------------------------------
0
huer
Asked:
huer
  • 3
  • 2
1 Solution
 
momi_sabagCommented:
have you tried to upgrade the database to a sql server 2008 database?
0
 
huerAuthor Commented:
I removed the sql 2005 and installed sql 2008.
0
 
momi_sabagCommented:
did you try to run
sp_vupgrade_replication
0
 
huerAuthor Commented:
No, i didn't. What is that for?
0
 
huerAuthor Commented:
That solved my problems. Thanks.
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now