Not 100% sure but I am almost certain that the Highlighted code is preventing the Connection to be closed Properly:

ret = SQLAllocHandle (SQL_HANDLE_DBC, henv1, &hdbc1);

 if (ret != SQL_SUCCESS && ret...

you could instead use:

DATABASEPROPERTYEX( database , 'Recovery' )

it is simpler and you are not touching system tables

your sever (Agent Account) needs to be a 'domain account' to have access to a network resource.  --> 'local system'  can't

sysdatabases

and it all comes down to combinations of the 'status column' values of 4 and 8

It is simple to come up with the logic to determine which is which...

sqldba,

Lets step back for a minute. The important part of the script I posted was not the Multi user part , that is an after the fact feature.

I don't know who is...

Try a GO between the two statements and by the way don't for get to put it backl  to multiuser after the restore

Alter...

Sorry to be the carrier of the bad news but ALL users in SQL Server can (Must) access master and tempdb by design. You will find that there is a guest...

Well the error is Self Explanatory... When you've seen it more than oce

You need to remove all the user conections on the DB.There are...

Well, I guess that you can use that, and then use  data/rows to get the avgbytes per records

Good Call

There should be a SLA with your software vendor (this applies mostly to the smaller vendors).  This insures that the delivered software is of high quality, and just not pushed out...

Definitely you are leaking handles!

Make sure that whatever is using the COM object is closing the handle. in case of sp_OA* you need to ensure that sp_OADestroy gets called...

I can't argue with that

I am not 100% sure on how your data looks like but I could take the guess that some of the desired state ID may be null for certain combinations...

SELECT

a1.account,

a1.disease_prog,

a1.confirm_flag,

a1.consent_flag,

a1.opt_out_reason_code

FROM ah_member_flags a1

WITH (nolock)

inner join ah_member_flags a2

on a1.account = a2.account

and a1.company = a2.company

and a1.disease_prog = a2.disease_prog

WHERE

a1.confirm_flag = 'y'

and

a1.consent_flag = 'y'

and

(

  (

   a1.disease_prog = 'HFCCIP'

  ...

You are correct! I forgot about the Filtering of ConsultancyID

It happens to me when doing multiple stuff at once