Possible Solution.

Looks like the problem has been fixed by switching the websync subscriptions from the Slow Link Agent Profile to Default Agent Profile.

After testing with MS Profession Support (thanks Ling...

Update 2...

Have simplified the replication schema by doing away with the republishing subscribers and adding a static publication for each state. However, as soon as I started adding data...

Update...

Ran the sync without using Web Synchronization and the messages are more helpful, from:

Enumerating deletes in all articles (generation batch 1)

Enumerating inserts and updates in article '[an article name]' (generation...

As you are restoring between versions (i.e. 2000 to 2005) try the following command:

[font="Courier New"]sp_restoredbreplication @srv_orig='SVR2000NAME', @db_origin='dbName', @perform_upgrade=1[/font]

The @perform_upgrade parameter is marked as for internal use only in BOL,...

That looks like one of the View designer layout settings. It just stores the layout of the table panel in the View designer and can be removed if you...

For Access SQL use either the IIF( <condition>, <true expression>, <false expression> ), which can be nested (that is the condition or the true/false expresssions can also be IIF's), ...

Hi JC,

You could try the following:

1. Install a new instance of SQL Server 2000 (or install it on another machine).
2. Use the Copy Database Wizard to transfer the objects and data to...

This routine should work with messages created by PRINT statements, so you don't need to RAISERROR().  It's just that in ADO it is confusingly named the Errors collection.

Reads to me like Hector wants the Procedure to return the data.  Also I'm assuming that we are returning data to a T-SQL routine or stored procedure.

Another way of doing it...

Functions in SQL Server 2000/2005 can return tables.

For example:

CREATE FUNCTION dbo.udf_ReturnsTable()

RETURNS @tblTest

TABLE([Value] int)

AS

BEGIN

        -- Insert some values

        INSERT INTO @tblTest([Value]) VALUES(1)

        INSERT INTO @tblTest([Value]) VALUES(2)

        INSERT INTO @tblTest([Value]) VALUES(3)

        INSERT INTO...

I'm not a Delphi programmer, but you should be able to use the ADO Connection's Error collection to catch your messages.

In VB you could use the following routine, which I’m...

I've tried to install the SQL Server 2005 Sept CTP on a server running VS 2005 Beta 2, and it didn't like that either.  The documentation states that the Sept...

Your stored procs are fine - the problem is with Access 2000 - there is a bug in the original release.  If you install Service Pack 1 or later for...

In my experience there you cannot directly restore data from SQL 2005 into a SQL 2000 database (although you can do this the other way...

Well, your getting beyond my experience with Analsysis Services, but I would recommend Downloading the SQL 2005 June CPT (http://www.microsoft.com/sql/2005/productinfo/ctp.mspx) and experimenting with your cubes in AS2005.  I would be...