Home Forums Programming General batch file to call a procedure from sql RE: batch file to call a procedure from sql

  • Hi sunil,

            If you think of executing the Stored Procedure(SP) during the Windows startup then it is wrong thing to do. B'coz the SQL Server has to start for running your SP.

           But don't worry there is a solution for running the Stored Procedure when you start the Microsoft® SQL Server™.

          Use "sp_procoption" for setting up the SP for Autoexecution. This will make the SP to execute every time the SQL Server Starts up.

          I think you will find more help for "sp_procoption" in MSSQL Books Online.

          Still you are not clear about this reply me.

    Thanks and Regards,

    Ankush

    ankush.choudera@slk-soft.com