question

Bugmesh avatar image
Bugmesh asked

A Launcher (Menu) to execute TSQL Queries or SP's

I have about 35 TSQL queries that I use to validate best practice on our database servers. These are used , in essence, as a pre-audit audit and as an effort to become proactive when it comes to security audits. What I would like to do is create a Launcher or Menu to execute them as needed instead of running the entire group of queries at one time. It should also be formatted like a Reporting Services report. Can this be done as a parameterized report? It would require a table to be built with a "Query_ID" and "Query_Text" columns. We do not have a Web server to use as a front end. Does anyone have another idea that I haven't processed yet? I appreciate your time and consideration
ssrssecurityaudit
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nidheesh.r.pillai avatar image nidheesh.r.pillai commented ·
"What I would like to do is create a Launcher or Menu to execute them as needed instead of running the entire group of queries at one time." Even from the launcher I assume you would want to run all the queries; right?
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Is this approaching the sort of thing you want? https://sqldbawithabeard.com/2013/09/24/the-powershell-box-of-tricks-gui/
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.