Thursday, January 15, 2009 3:19 PM tonyrogerson

SQL 2005 Publisher and push Subscription to a SQL Server 2008 box

My client has SQL Server 2005 and needs to publish SQL data to me, I'm running SQL Server 2008 Express.

I installed SP3 of SQL 2005 so I could connect to SQL 2008.

Could I get SQL 2005 to set up the subscription - could I heck! Well, not with the GUI anyway.

Fix: Using SQL Server 2008 Management Studio to do it - worked like a charm.

May be having a Friday moment on a Thursday; I even tried using ODBC but couldn't get that going either :)

Tony. 

 

Filed under: , ,

Comments

No Comments