Best way to track what user/logins are accessing a linked server

Question

Post reply

Best way to track what user/logins are accessing a linked server

Hello8Goodbye9

SSC Enthusiast

Points: 113
More actions
August 4, 2023 at 7:38 pm

#4253041

What is the best way to track down what users\logins are accessing my linked servers?
August 6, 2023 at 6:06 am

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 2

I Googled the following...

What is the best way to track down what users\logins are accessing my linked servers in sql server?

It came up with a lot of answers. Just for grins, I tried the following...

There are certain areas of ChatGPT an other AI that get things horribly wrong (mostly considering how to do specific things in SQL) but it seems to have done a fairly good job answering the question above complete with some simple looking steps for how to do it. Give that a try with the warning that I've not actually tried using the instructions it provided and so cannot make any comment as to the accuracy of the steps that it presented.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Hello8Goodbye9 SSC Enthusiast Points: 113 More actions · Answer 3

None of those answers coming up on g0ogle are relevant to my question. They either talk about tracking down link servers which is not my issue, or they talk about tracking logins to a SQL Server. I am trying to find out what users are accessing my linked servers.

Ken McKelvey SSCoach Points: 18843 More actions · Answer 4

Bing gave me this:

Capture Linked server queries using SQL Extended Events - Stack Overflow

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 5

Hello8Goodbye9 wrote:

None of those answers coming up on g0ogle are relevant to my question. They either talk about tracking down link servers which is not my issue, or they talk about tracking logins to a SQL Server. I am trying to find out what users are accessing my linked servers.

Like I implied, I wasn't impressed with the answers by Google. I suggest a prompt that I tried on ChatGPT and it seemed to be coherent. Did you try that?

No real need anymore, though. Looks like the link that Ken posted above might do the trick.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)