Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

This blog is for SQL SERVER developers. I am trying to publish the things that i face in my development career, so other developers can get help out of this BLOG.
Browse by Tags · View All
Tejas Shah 30
SQL SERVER 2005 11
SQL Server 10
SSIS 8
T-SQL 8
SQL Yoga 7
SSIS Task 7
SQLYoga 5
SQL Developer 5
DBA 5

Archive · View All
October 2012 5
October 2009 5
November 2012 3
December 2009 3
November 2009 3
September 2011 2
August 2010 2
April 2011 2
March 2010 2
September 2012 1

Tejas Shah's Blog

SQL SERVER: Execute Stored Procedure when SQL SERVER is started

Mar 7 2010 4:04PM by Tejas Shah   

We have a requirements to execute Stored Procedure when SQL SERVER is started/restarted and we need to start some processes. I found that SQL SERVER provides a way to call Stored Procedure when SQL services are restarted.

SQL SERVER provides this SP: “sp_procoption”, which is auto executed every time when SQL SERVER service has been started. I found this SP and it helps me to figure it out the solution for the request as following way. Let me show you how to use it.

Syntax use this SP:

EXEC SP_PROCOPTION     
	@ProcName = 'SPNAME',    
	@OptionName = 'startup',    
	@OptionValue = 'true/false OR on/off'
  • @ProcName, should be Stored procedure name which should be executed when SQL SERVER is started. This stored procedure must be in “master” database.
  • @OptionName, should be “startup” always.
  • @OptionValue, this should be set up to execute this given sp or not. If it is “true/on”, given sp will be execute every time when SQL SERVER is started. If it is “false/off”, it will not.

That’s it,

I hope this is very clear to use this feature.

Reference : Tejas Shah (http://www.SQLYoga.com)


Republished from SQL Yoga [33 clicks].  Read the original version here [32134 clicks].

Tejas Shah
135 · 1% · 364
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL SERVER: Execute Stored Procedure when SQL SERVER is started" rated 5 out of 5 by 1 readers
SQL SERVER: Execute Stored Procedure when SQL SERVER is started , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]