How to run a VS Solution [or SSMS script] without giving the end-user access to either tool

[FL-Propeller-Head]

Hello;

An end-user can do a lot of damage with unfettered access to SSMS and/or VS. Someone once showed me how to "package" a VS solution or a SQL script; and, I think he executed the VS solution with a DBCC command; but, I've forgotten.

I know I can use sqlcmd command from the command line or PowerShell; but, the DBCC [I think] seemed much cleaner.

Does anyone know how to "package" a VS solution or an SSMS script so that it can be run from the command line without giving the user access to either SSMS or VS.

Thanks!

Continue reading...