You're right, but in my case. I know for sure they are authenticated on a WinNT4 PDC.

Is there any other way to find more information on the users connected to...

I need to query the sysprocesses table and store this info into 1 central server, to check who is connected to my remote servers (± 500)

No reason ... except for historical inheritance 😉 And is impossible to change this 🙁

thx !

Is there any way fo still collect this data. Or should I write a Custom Extended Stored Proc who could collect this data ?

Frank,

But if I use "Named Pipes", it can show this info !

Jan

I'm trying to upgrade my 6.5 DB to 2000. First I BCP out the data and later I BCP the data back in. But with bcp the TimeStamp columns are...

I'm currently using SQLMatcher (http://www.berryware.com) which does the work. Even supports my older 6.5 databases. And has some nice batch options.

Hi,

You CAN replicate user defined defaults. You have to do two things :

- make sure the UDD already exist on the subscriber (I always create them in the Model Database,...

Thanks. But before I start the sp_reinitmergesubscription I already start the SnapShot Agent. And afterwards I start the Merge Agent.