Deactivated?

Merge replication.
Push New Subscription.
Immediately after I click "finish" in the wizard (push new subscription),
the subscription status shows deactivated. The merge agent runs and
completes then shows status has failed. error = "the subscription to the
publication pub_name is invalid. The remote-server is not defined as a
subscription server. 14010"
Your problem is that the remote server is not enabled as a subscriber. I'm
not trying to be flippant, but this might take a little back and forth to
fix.
First off - all publications/subscriptions are marked as deactivated until
the snapshot agent runs. So this status is not problematic in your case.
To enable your subscription server as a subscriber, go to tools,
Replication, Configure Distributor, Publishers, and Subscribers, click on
the subscriber tab, locate your subscriber or register it.
You might also want to review this pdf -
http://www.nwsu.com/lowres_replication_ch02.pdf
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:%23cKdOIoAFHA.904@.TK2MSFTNGP12.phx.gbl...
> Merge replication.
> Push New Subscription.
> Immediately after I click "finish" in the wizard (push new subscription),
> the subscription status shows deactivated. The merge agent runs and
> completes then shows status has failed. error = "the subscription to the
> publication pub_name is invalid. The remote-server is not defined as a
> subscription server. 14010"
>

DDL of an existing cube

Hi!

Is there a way to get the DDL of a cube created with the AS wizard.

Thinks and regards.

You can get the DDL of any AS object, including a cube, very easily by connecting to your server in SQL Server Management Studio, right-clicking on the object and selecting one of the items under the 'Script <object> as' menu item.

HTH,

Chris

|||

Also, if you do not have the cube already deployed to AS2005, but you only have the BI project on which you created a cube with the wizard, you can right click on the cube item (in Visual Studio) and use 'View Code' option to see the XML.

Adrian Dumitrascu.

|||

Hi

I think i've to install a full version of SQL Server 2k to get access to SQL Server Management Studio.

Actually i've installed AS only and i'm using an Oracle DB as DWH.

TVM Chris for reply

Regards

|||

Hi

How Can i browse AS cubes within Visual Studio ( 6 ? .Net ? 2005?)

PS i'm using SQL2K AS

TVM for reply Adrian

Regards

|||

If you have Analysis Services 2000, then our suggestions won't work. Analysis Services 2000 doesn't have DDL scripts as Analysis Services 2005.

SQL Management Studio only works with AS2005, but not AS2000 (Analysis Manager remains the admin client for AS2000).

The same for BI projects (that you can create and edit in Visual Studio): they are a feature of AS2005 only. So there isn't a feature out of the box to browse AS2000 from Visual Studio.

Adrian Dumitrascu.

DBO Thing Doesn't Appear by Table Name

Hi, we are trying to simply import an existing MS Access 2003 table to MS SQL. I've gone through the export routine (the "upsizing" wizard in Access), but my Coldfusion app does not recognize the resultant MS SQL table as a real database object. It doesn't even include DBO next to the table name like all the other "real" tables that were made directly from within MS SQL. Is there something else I'm supposed to do? Thanks - and yes, I'm new at this. ;)
You can post your response here but feel free to drop me a direct reply at my website (which should hopefully be included in this message).For anyone that's interested, it appears that DBO may actually stand for Database Owner, not Database Object as I had previously speculated. Not sure how that helps resolve my issue per se, but there you have it. If anyone can offer a pointer on the original post it would be great, thanks!
Dave|||Hi,

dbo does stand for database owner. To help you determine what is going on with your application use SQL Server Profiler to trace the the queries that your application is issuing against the server. You can then copy the queries from Profiler to Management Studio and then run them manual to determine exactly why the query is failing.

Keep in mind for the owner of the object, if the owner of the object is not specified in the query, SQL server will search for dbo first.

If you have specific questions, please let us know.

Peter