the using definition is your friend here.
using that will automatically destroy your object for you once they go out of scope:
change those two lines for your object to...

I use a version of the query below every M-F:
it returns all jobs who's LAST status is failed.
that means jobs that execute every x minutes,and experienced a hiccup,...

any chance you edited the Script task template itself?
i got the same error, but I knew it was me.
i edited the template for Visual Studios C# Script task,...

the data can have none to many rows in sys.logins. the statement is just building the commands dynamically, really.

remember you can run multiple commands, and the recommendation is...

this generates the sql and potentially kicks off the command:
what would setting the local password length do? isn't it overwritten by the domain password policy anyway? i think that...

note that when it comes to SQL Server administration, not a lot has changed; if you find a class/book/blog on administration in general, from 2012 and later, say, you would...

proc parameters can only assigning values you cannot concat values or use functions int he assignment.
you simply  pre-assemble the value before assigning it.:
USE Alarms

DECLARE...

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...