CODEWITHSUNDEEP
sql-servervbscripthta
Aaron Mason
Aaron Mason

Reputation: 350

Open multiple instances of a HTA from the same file

I've got a HTA that queries an MSSQL Server's sys.dm_exec_requests table to locate rogue long-running queries that may be causing speed issues in our EMS, and while it works great, I'd also like to use it for other systems.

To this end I changed it so it would accept a command line parameter for the server name. This works great, but I've found that I can't have more than one window open at a time. If I try, it uses the existing window.

Is there a way to do this without having multiple copies of the file and giving each one a unique ID (which is going to be hell for maintainability) or am I just going to eat some concrete in regards to this?

Thanks in advance

Upvotes: 0

Views: 763

Answers (1)

Jeremy J Starcher
Jeremy J Starcher

Reputation: 23863

Check your .HTA header for:

<HTA:APPLICATION  
    SINGLEINSTANCE="yes"

Change SINGLEINSTANCE to no

Upvotes: 4

Related Questions