Yes, several times...

If it may help, this is results for sp_configure for the server and create statement for the database:

name ...

My mbsII database is a large DB (~7Gb), has lots of user tables. It returned:

"Record Counts for database mbsII

DB,rows,name"

It works so for most of my databases 🙁

The event Lock:acquired along does all this (no matter locally or on net), events like Lock:timeout or Lock:deadlock work fine.

I really need column ObjectName or at least ObjectID to be...

Also noticed, that when running the trace locally or on network the %Processor time counter goes down from 50% to 30%, the average disk queue length is tiny, users cry...

"Page Faults/sec is the overall rate faulted pages are handled by the processor. It is measured in numbers of pages faulted per second. A page fault occurs when...

Is it possible to defect a target server without master server, from itself?

To login as other user I need to know the password...

Forgot to say: it is MS SQL 2000 SP3

I found this out:

'INSERT INTO ##all_logins SELECT name,'''+ @server_name +''' FROM ' + @sys_table )

For this I get:

INSERT INTO ##all_logins SELECT name, saturn FROM saturn.master.dbo.sysxlogins WHERE CONTAINS(name,'Ivanov')

and an error:

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name 'saturn'.

But I need:

INSERT INTO...

This worked! Thanx. 🙂

But how can I insert server name where the login was found?

First change the table of course:

CREATE TABLE

tempdb.##all_logins

([UserID] [int] IDENTITY (1, 1) NOT NULL ,

[UserName] [varchar]...

It is SQL 2000. So it is not possible... 🙁

So, if a deadlock happens on a distribution database on distributor server, such data loss is possible?

As for filters, the table where problem was noticed, has all columns and all rows to replicate. There are some filters on other tables used for replication that might...