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?

You could use an index on tsdt if the range is selective enough

Why are there so many char() fields? Varchar is usually smaller

The problem is when the query returns multiple records

@KOD_1 can contain only one value

John Kandrovy (1/22/2008)

---

Hi we are having a problem on our live server.... whenever we run a query on one of our major tables in Enterprise Manager, it creates locks in...

Not sure where you can download the personal edition

The enterprise evaluation edition (120 days) can be downloaded from:

http://www.microsoft.com/downloads/details.aspx?familyid=d20ba6e1-f44c-4781-a6bb-f60e02dc1335&displaylang=en

Upgrading evaluation to retail:

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

Hello,

I've currently 3 different stored procedures with the same generic layout

EXECUTE master.dbo.USP_BACKUP_DATABASE @DatabaseNaam='MYDB'

EXECUTE master.dbo.USP_BACKUP_DATABASE_DIFF @DatabaseNaam='MYDB'

EXECUTE master.dbo.USP_BACKUP_DATABASE_LOG @DatabaseNaam='MYDB'

Currently redesigning it for controlled restores.

Someone posted an artikel about custom logshipping about a...