Who or what is taking the backups? (sql jobs or third party)

If you run a dbcc check... with allow repair data loss, then there can be dataloss. In your case probably 2 records.

With

use mydb

select OBJECT_NAME(.....) you can find out what...

If your transaction log is full, the whole last transaction will rollback.

Please disregard my previous post, i have no experience with web security.

You could build minor security checks (login valid,..) in the stored procedures before they do their intented job to...

I would go with a webservice.

1)It provides abstraction in case

*you want to alter the stored procedure, change db, ...

2)No login "visible", the security context of the webservice calling...

After you change the recovery to Full, do you take a full backup/differential backup before taking the transaction log backup?

or you could use a script that uses

the stored procedure sp_start_job

if there are no dependencies.

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...