<div>
You can use EXEC with a server link to execute remote.
</div>


You can use EXEC with a server link to execute remote.

<div>
Qlemo <br />
could you show me an example of what you are suggesting?
</div>


Qlemo
could you show me an example of what you are suggesting?

<div>
<pre><code id="code-20-40769343-1">declare @name = nvarchar(100)
set @name = 'whoever'
exec ('ALTER LOGIN ' + @name + ' DISABLE') at LinkedServerName</code></pre>
You can code the user name literally into the command, of course, if you don't need it to be variable.
</div>


declare @name = nvarchar(100)
set @name = 'whoever'
exec ('ALTER LOGIN ' + @name + ' DISABLE') at LinkedServerName

You can code the user name literally into the command, of course, if you don't need it to be variable.

<div>
is there any other way with out creating a linked server?
</div>


is there any other way with out creating a linked server?

<div>
I am planning on creating the connection string dynamically and then run the alter on the &nbsp;server that needs the change.
</div>


I am planning on creating the connection string dynamically and then run the alter on the  server that needs the change.

<div>
You can use OPENDATASOURCE. The complete guide to this command is <a href="https://technet.microsoft.com/en-us/library/ms179856(v=sql.110).aspx" rel="ugc">here in MSDN</a>.
</div>


You can use OPENDATASOURCE. The complete guide to this command is here in MSDN [https://technet.microsoft.com/en-us/library/ms179856(v=sql.110).aspx].

<div>
this worked with my original script very well thank you.
</div>


this worked with my original script very well thank you.

<div>
<div class="content wysiwyg-content">
is it possible to do an 'ALTER LOGIN [loginname] DISABLE' using either openrowsource or opendatasource?<br />
<br />
And if so how can i do this?<br />
<br />
I have a list of servers that i need to change all users with a specific name to disabled.
</div>
</div>


is it possible to do an 'ALTER LOGIN [loginname] DISABLE' using either openrowsource or opendatasource?

And if so how can i do this?

I have a list of servers that i need to change all users with a specific name to disabled.

Alter logins accross many servers without cms

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.