Noel,

The Publisher tables have more than single primary keys.

For example: Table A has

...

Noel,

The problems are resolved. I updated the @sync_method = 'native';

Thanks for your help.

Edwin

Hi Noel,

I created two index views:

-- t_Table_A_FirstView

-- t_Table_A_SecondView

on the Publisher database instance.

Next, I create a test publications with one article.

Then, I...

Hi Noeld,

The Publisher table with (367 Columns) has several primary keys.

Would you please check my t-sql code below:

CREATE VIEW dbo.t_TurbDataMWT92_FirstView WITH SCHEMABINDING AS

SELECT

--The Primary Keys SiteID,...

Noel,

I have setup a pull subscription.

Enclosed is my t-sql script to setup my remote distribution:

---Create an entry on the sysserver tables, mark it as the Distributor

--- and stores...

Jayco,

Thanks for your t-sql. It works.

Bravo solutions 🙂

There is no sys.columns in SQL Server 2000.

I executed the following t-sql:

SELECT COUNT(*) from dbo.syscolumns

where object_name([object_id]) = 'Table_A' no dbo.

Invalid column name 'object_id'

Hi Noeld,

I’m not familiar with indexed view logbased. Can you give me some hint?

How to implement the indexed view logbased?

Thanks in advance.

Edwin

I executed the following T-sripts;

SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS

Where TABLE_NAME = ‘dbo.Table_A’;

Go

Result:

0

SA

The MEMORYCLERK_SQLBUFFERPOOL (Node 0)

VM Reserved 1594872KB

VM Commited 8064KB

AWE Allocated...

Tim,

Again, thanks a lot for your valuable advice and help.

The MEMORYCLERK_SQLBUFFERPOOL (Node 0)

VM Reserved 1594872KB

VM Commited...

Tim,

The SQL logs indicated "Address Windowing Extensions is enabled. This is an information message only; no user action is required"

How can I confirm that my configuration are completed and fully...

SA,

The SQL logs indicated " Adderess Windowing Extension is enabled. This is an informational message only; no user action is required"

Did my 2003 Window and SQL 2008 ready to take...

Yes, I found on the previous sql log. The SQL logs " Address Windowing Extensions (AWE) requires the 'lock page in memory' privilege which is not currently present in...

Tim,

I updated my boot.ini and performed gpedit.msc.

Did I need to re-run my t-sql scripts?

Thanks,

Edwin