Any option to validate the transactionlog before applying?

(RESTORE VERIFYONLY .... )

As far I know linked servers don't expose sublinked servers.

Linkedserver1 with sublinkedserver3

Server 2 can't query Linkedserver1.Sublinkedserver3.dbo.table1.

Linked server1 could create a view MyView based on sublinkedserver3.dbo.table1

I'll try to answer this on Tuesday.

Does a basic query works?

It could be that distributed transactions ain't configured correctly.

(Are the server machines windows 2003?)

*spGetNewExhibitJSubContractorsDetails is located on the external system...

*If your checkpoint is barely 5%, it won't help to set it longer. If you set it longer, it will take longer to bring your database online.

*My primary reason of...

At the initial snapshot, the tables at the subscribers will get dropped to ensure a match with the publication.

The drop is prevented by the foreign key. Either remove the table...

Haven't found the option yet, and the clearing is by design

http://support.microsoft.com/kb/252434

Enterprise manager Query Analyzer

http://databases.aspfaq.com/database/which-tool-should-i-use-enterprise-manager-or-query-analyzer.html

*I assume the query is run against the internal system because openquery requires a linked server connection.

*Strange that you repeat the server name in the openquery

I would expect

OPENQUERY(XYZ,'Select DepartmentName From...

KILL 54 WITH STATUSONLY

gives

--This is the progress report.

spid 54: Transaction rollback in progress. Estimated rollback completion: 80% Estimated time left: 10 seconds.

although it tends to stick at 100% for...

Does it help if you exclude that particular table from the replication and add it back later after checking for errors (DBCC CHECKTABLE)

We have architecture like

Oracle 10g Application

||

INTERNAL SYSTEM

...

The switches are only really helpfull with +4GB of ram

With defaults, 2GB is reserved for applications (like sql server) and 2GB for the OS.

With the /3GB boot.ini switch it allows...

I would reduce the batchsize.

Any particular table where the snapshot halts?

We have a 39-hour working scheme, similiar to the one of P Jones with "gliding" hours. Start between 8 and 9 am, stop between 4 and 5.30 pm.

With flexibility for...

We haven't got issues with databases of 100 gb, although we are thinking about data management to migrate readonly historical data. One of the side effects will be keeping the...

What security context is set for the linked server?