I did job that kill dormant connections

and runt every minute

This job give me temporary quite good solution of this problem

I killed this processes

It help me for 10-15 minutes

declare @SPID int, @STR varchar(50);

declare cUser cursor local static forward_only for

select spid from master..sysprocesses

where Status = 'dormant' and HostName =...

what is means of process status

Dormant ?

I have many processes in db2

with this status and with hostname

of db1

db1 usualy query db2

It dos not help me

I have web servers and db servers in the same network

and 90% of Linked Servers queries works

and 100% of ADOConnections of Web Servers

works. I don't see...

MSDTC started and running in the two sides

No errors in Event LOg

Haw can i manage MSDTC service ?

Or manage his LOG ?

I have 2 servers Win2000 standard edition sp3

And On the Each one Sql2000 sp3 standart edition (but with difference between @@Version and sp_server_info)

db1, db2

I added Linked server db2 to db1...

But in the my testServer

sp_server_info = @@Version

Thank you !

🙂

the answear to Bummi

Inthe data transform task properties

on the destination tab jast press

Define Columns and check the Binary Check box

on each long text fields.

No the SQL Server enterpise manager executing

EXECUTE master.dbo.xp_fixeddrives 2

when i do restore from backup and whant to select the backup

file it jast don't open the dialog of choose file.

the...

Why i have a problem runnig

EXECUTE master.dbo.xp_fixeddrives 2

When i run it as

EXECUTE master.dbo.xp_fixeddrives

the result is

drive MB free

----- -----------

C ...