CREATE TRIGGER [dbo.GLTRANSBATCH_Dept_Change_Ins]

ON [dbo].[GLTRANSBATCH]

with encryption

FOR INSERT NOT FOR REPLICATION AS

-- your trigger logic...

What error you have?

Try this:

1. make a sql file "mysql.sql". Inside the sql file, include your sql statement.

2. make batch file "mybatch.bat".

3a. If use stored procedure, do this:

...

Yes, you can. After adding a new article, "The Distribution Agent or Merge Agent then copies the schema and data for the new article to the Subscriber (it does...

I applied 2187 but no use. Finally opened a case with MS.

KB http://support.microsoft.com/?id=916653 applies to our case. Either performance optimization or hotfix 2189. ...

Where did you get this error?

Is this link related to your case?

http://www.cryer.co.uk/brian/sqlserver/disagnt_cnidkriowui.htm

BOL mentioned this error in details: http://technet.microsoft.com/en-us/library/ms151779.aspx

Well, more than logins. Take a look here:

"Managing Metadata When Making a Database Available on Another Server Instance"

http://technet.microsoft.com/en-us/library/ms187580.aspx

It is "Database (user DB) mirroring" not a database...

Thank you Deepak for sharing this article. It is good to have something from MS for "Moving SQL2005 db to SQL2000 db".

I used Red Gate SQL Data Compare to sync...

Critical Update for SQL Server 2005 Service Pack 2:

http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en

Download and apply to your SQL2k5 client tools (your own desktop/workstation).

I had this problem before. It works after this...

Kalen Delaney “Inside SQL Server 2005” is a good choice. And check her recommendation for books here:

http://www.insidesqlserver.com/recommended/recommended.htm

"SQL Server 2005 Books Online" is an essential e-book. "How...

Seems like a network related problem. May need to check with your network admin to set up monitoring.

Here is a post similar to the error you have.

You may start from application/database server inventory first. Make a list, plan, and checklist, etc. Dependency should be included as well.

Check this post, may give you some tips.

Ops...Just realized your KeyID is system generated.

After T1 is loaded, may try to select all the newly inserted KeyID and save to a column within the excel spreadsheet....

Why not do one more insert into T2 table?

insert into T2

select * from some excel spreadsheet (what ever columns needed for T2).

Add an index or an identity column?

Take a look here: SQL Server 2005 Books Online - Replicating Identity Columns

Note:

Adding an identity column to a published...

How big is your dataset (6 months data volume for replication)? Estimate how long it will take for snapshot.

Does the user needs view the replicated data in real time...