We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Cannot create publication on sql 2008 when the attached DB  is created on sql 2005

Medium Priority
2,447 Views
Last Modified: 2012-05-06
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
------------------------------
Comment
Watch Question

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

Author

Commented:
I removed the sql 2005 and installed sql 2008.
did you try to run
sp_vupgrade_replication

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
No, i didn't. What is that for?

Author

Commented:
That solved my problems. Thanks.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.