Identify If Sql Server Has Linked Object Using Dbatool

Optional Parameters -SqlCredential Login to the target instance using alternative credentials. Accepts PowerShell credentials Get-Credential. Windows Authentication, SQL Server Authentication, Active Directory - Password, and Active Directory - Integrated are all supported. For MFA support, please use Connect-DbaInstance.

T-SQL query to find the list of objects referring Linked Servers One of my client reached out to me today. He was expecting a query that should return the list of objects such as Stored Procedures, Functions, Triggers and View, if it's using the Linked Server. The query returns the data in format as can be seen in the image below.

With dbatools, it is simple enough to also script out Instance level objects like logins, database mail profilesaccounts, credentials, SQL Agent objects, linked servers, Central Management Server objects, server configuration settings sp_configure, user objects in systems databases, system triggers and backup devices

Server C has copies of some of the databases from Server B, and we're migrating applications from Server B's database copies to Server C's. When I'm on Server B, I can see connections from Server A to a certain database but I don't know how to tell what procedure, task, or job from Server A is using that linked server connection to Server B.

Technically the local server is a linked server called a loopback server. I would use sys.servers though, not a procedure.

It's a wrapper for many of the Copy cmdlets e.g. Copy-DbaDatabase, Copy-DbaAgentJob, Copy-DbaLinkedServer, etc. which allows us to migrate ALL SQL Server objects, including databases, agent jobs, linked servers, and a long list of other object types from one instance to another.

Linked server objects allow one SQL server to connect to another at the database engine level. A connection is defined when creating the linked server, including the credentials that should be used for that connection. As time passes, the challenge is knowing if that old linked server object is still being utilised by something, a report or script or import somewhere. The knowledge of the

command index dbatools is a free PowerShell module with over 500 SQL Server best practice, administration, development and migration commands included. Currently, other components of SQL Server such as SSIS, SSRS and SSAS are not supported, but they are part of the overall goal.

This article came about due to a request to find if any stored procedures are using any of the linked servers. In addition to finding if any stored procedures may be using a linked server was the