you are basically trying to avoid locking and blocking, so here is another idea:

you could also consider inserting the desired 10K rows into a new table, amybe in...

ok, this looked fun, so i combined and modified a couple of techniques:

DROP TRIGGER TR_PopulateExendedEventOnEachObject
ON DATABASE
GO
--Our Trigger to limit our role:
CREATE...

i think the [Domain\dbc_agent] login issue the query finds is a separate issue than the process logging in as sa, i would look at the Error/Severity columns to confirm.

you could run it from any machine on the network, so no difference; DNS is DNS from any machine.
the IP resolves to some server name, which i think you...

using ping -a will return the machine name, i like it better than nslookup..
then you can check the machine itself for either applications, or windows tasks, or even a...

Yes, I do something exactly like that against my own CMS servers.

I create a SQL connection manager, and in expressions, I point the servername property to a user...

if there is no server name, then it is implied that the database exists on the local server; is that how it was set up originally? if you can find...

Classic ASP often made use of include files, so as Sue_H suggested, you just need to search the files for the database/server name and zoom in on possible locations to...

Brandie I've always done something like this to keep it Sarg-able; does that help? it's an OR, i know, but it would allow indexes to be used if they exist...

ok  more info for everyone.
I scanned all 100+ sql instances in my Central Management Servers.
I have seven servers that have a variance of over one day. one is...

That is the funny part of this dilemma Sue;
I also found references that systeminfo can be incorrect.
in this case, it is the value from sys.dm_os_sys_info that is incorrect.

these...

here's an explicit string array declaration example for powershell:
MyServers=@("VMSQL01","VMSQL02\SQL2016","AnotherSrver\ETL")

it's not a one line query, unfortunately.
SSMS opens a query to each server, executes it, and aggregates the results.
You will have to do the same, and it's a...

I do something similar, where i loop through a table full of queries, execute them on a server, and capture the results in a dataset, which is then pumped out...

ALTER ANY DATABASE expects a [login] as the target, and not a database(user) role.