Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harpreetkaur
Starting Member
14 Posts |
 Posted - 2007-02-16 : 00:18:17
|
| I am using the SQLCMD function to execute a particular storded procedure every minute. The task schedular calls this batch file to run the stored procedure every minute. The issue is it opens up a command window every minute and is annoying. How can i run this job using sqlcmd and still not have the window pop up. Is there a way to create a service that can run the batch files without the user knowing that it is running. I am trying to replicate what sql server agent used to do wth msde. i am using sql server express now. |
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2007-02-16 : 12:26:17
|
| This is really a question better asked in a scripting forum since you're trying to hide a windows component, but I found a few resources that may get you started.http://www.microsoft.com/technet/scriptcenter/resources/qanda/may06/hey0519.mspxhttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1186606&SiteID=1Hope these help.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
 |
|
|
krishnasarala
Starting Member
1 Post |
Posted - 2010-01-07 : 02:56:48
|
| how to hide stored procedures from userssv |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-07 : 03:46:16
|
quote:
Originally posted by krishnasarala
how to hide stored procedures from userssv
Please dont hijack treads. please post as a new thread in future. That will increase visibility and you'll get quick solutions also.Now answer to your question, you can encrypt the procedure to hide from users. |
|
|
|
|
|
|
Hide command window