Castlewood
asked on
How to set up end-users to run the SQL command?
In my SQL ERP there is a table sometimes with a blank record. As the result, the Shipping department will NOT be able to print shipping document. Whenever this issue occurs, the Shipping will call me and I will need to get into SSMS to issue a command to delete that blank record so they can print document. Now I am wondering it would be better to set up so the Shipping clerk can issue that command by themselves to clear this error without bothering me. But we don't want them to access SSMS.
Can you tell me how to set up so the end-users can issue the SQL command from her computer without SSMS?
Can you tell me how to set up so the end-users can issue the SQL command from her computer without SSMS?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
But we don't want them to access SSMS.Why not? If their logins don't have the necessary permissions they can only do what they are permissioned to.
Anyway you can install MSSQLCmdLnUtils in a client machine and create a script to be run by SQLCmd then create a batch file where you call SQLCmd with the T-SQL script as parameter.
ASKER
On the client's computer (Win 7) command SQLCMD is not available.