473,230 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,230 software developers and data experts.

Run SQL script on Instance Startup


Is there a way I can set up a SQL script to run when the instance
starts up?
SQL Server 2005 SP2

thanks!

Oct 18 '07 #1
3 11250
On Oct 18, 11:50 am, traceable1 <thham...@gmail.comwrote:
Is there a way I can set up a SQL script to run when the instance
starts up?
SQL Server 2005 SP2

thanks!
This link describes the use of 'Automatic Execution Stored Procedures'
than may fit the bill for what you are looking for.

http://msdn2.microsoft.com/en-us/library/ms191129.aspx

Oct 18 '07 #2

Thank you!!
On Oct 18, 3:56 pm, Steve215 <stephen.mer...@comcast.netwrote:
On Oct 18, 11:50 am, traceable1 <thham...@gmail.comwrote:
Is there a way I can set up a SQL script to run when the instance
starts up?
SQL Server 2005 SP2
thanks!

This link describes the use of 'Automatic Execution Stored Procedures'
than may fit the bill for what you are looking for.

http://msdn2.microsoft.com/en-us/library/ms191129.aspx

Oct 18 '07 #3


Tibor Karaszi View profile
More options Oct 18, 10:58 am

Newsgroups: microsoft.public.sqlserver.server
From: "Tibor Karaszi"
<tibor_please.no.email_kara...@hotmail.nomail.co m>
Date: Thu, 18 Oct 2007 17:58:37 +0200
Local: Thurs, Oct 18 2007 10:58 am
Subject: Re: Run script on Instance Startup
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
Put it in a stored procedure and mark the proc as an autostart proc
(sp_procoption).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"traceable1" <thham...@gmail.comwrote in message
news:11*********************@y27g2000pre.googlegro ups.com...
- Hide quoted text -
- Show quoted text -
Is there a way I can set up a SQL script to run when the instance
starts up?
SQL Server 2005 SP2
thanks!


Reply Reply to author Forward Rate this post: Text
for clearing space



You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before
posting.
You do not have the permission required to post.

Tibor Karaszi View profile
More options Oct 18, 1:27 pm

Newsgroups: microsoft.public.sqlserver.server
From: "Tibor Karaszi"
<tibor_please.no.email_kara...@hotmail.nomail.co m>
Date: Thu, 18 Oct 2007 20:27:45 +0200
Local: Thurs, Oct 18 2007 1:27 pm
Subject: Re: Run script on Instance Startup
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
Actually, one can claim that your alternative, Ekrem, is a cleaner
solution than mine. I.e., it
might feel better to have a client app (Agent) execute whatever TSQL
commands you want to run
instead of the database engine. (Of course, if one only start the
engine and not Agent, then the
script will not be executed.)

Good thinking. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"Ekrem Önsoy" <ek...@btegitim.comwrote in message
news:18**********************************@microsof t.com...
- Hide quoted text -
- Show quoted text -
Alternatively you can create a job to run your stuff which starts when SQL Server Agent starts...
(may not be as good as Tibor's suggestion :) but I already said, it's just an alternative)
--
Ekrem Önsoy
"traceable1" <thham...@gmail.comwrote in message
news:11*********************@y27g2000pre.googlegro ups.com...
>Is there a way I can set up a SQL script to run when the instance
starts up?
SQL Server 2005 SP2
>thanks!


Reply Reply to author Forward Rate this post: Text
for clearing space



You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before
posting.
You do not have the permission required to post.

traceable1 View profile
More options Oct 18, 3:34 pm

Newsgroups: microsoft.public.sqlserver.server
From: traceable1 <thham...@gmail.com>
Date: Thu, 18 Oct 2007 20:34:43 -0000
Local: Thurs, Oct 18 2007 3:34 pm
Subject: Re: Run script on Instance Startup
Reply | Reply to author | Forward | Print | Individual message | Show
original | Remove | Report this message | Find messages by this
author
Thank you so much for your feedback!
So how exactly would I set up the script to run when the Agent
starts?
On Oct 18, 1:27 pm, "Tibor Karaszi"

- Hide quoted text -
- Show quoted text -

<tibor_please.no.email_kara...@hotmail.nomail.comw rote:
Actually, one can claim that your alternative, Ekrem, is a cleaner solution than mine. I.e., it
might feel better to have a client app (Agent) execute whatever TSQL commands you want to run
instead of the database engine. (Of course, if one only start the engine and not Agent, then the
script will not be executed.)
Good thinking. :-)
--
Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
"Ekrem Önsoy" <ek...@btegitim.comwrote in message
news:18**********************************@microsof t.com...
Alternatively you can create a job to run your stuff which starts when SQL Server Agent starts...
(may not be as good as Tibor's suggestion :) but I already said, it's just an alternative)
--
Ekrem Önsoy
"traceable1" <thham...@gmail.comwrote in message
news:11*********************@y27g2000pre.googlegro ups.com...
Is there a way I can set up a SQL script to run when the instance
starts up?
SQL Server 2005 SP2
thanks!- Hide quoted text -
- Show quoted text -


Reply Reply to author Forward



You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before
posting.
You do not have the permission required to post.

Tibor Karaszi View profile
More options Oct 18, 3:59 pm

Newsgroups: microsoft.public.sqlserver.server
From: "Tibor Karaszi"
<tibor_please.no.email_kara...@hotmail.nomail.co m>
Date: Thu, 18 Oct 2007 22:59:38 +0200
Local: Thurs, Oct 18 2007 3:59 pm
Subject: Re: Run script on Instance Startup
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
Create an Agent job with one or several job steps containing your TSQL
(or whatever) code. Schedule
this job to be executed when Agent starts.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"traceable1" <thham...@gmail.comwrote in message
news:11*********************@k35g2000prh.googlegro ups.com...

Thank you so much for your feedback!
So how exactly would I set up the script to run when the Agent
starts?
On Oct 18, 1:27 pm, "Tibor Karaszi"

- Hide quoted text -
- Show quoted text -

<tibor_please.no.email_kara...@hotmail.nomail.comw rote:
Actually, one can claim that your alternative, Ekrem, is a cleaner solution than mine. I.e., it
might feel better to have a client app (Agent) execute whatever TSQL commands you want to run
instead of the database engine. (Of course, if one only start the engine and not Agent, then the
script will not be executed.)
Good thinking. :-)
--
Tibor Karaszi, SQL Server
MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/....
"Ekrem Önsoy" <ek...@btegitim.comwrote in message
news:18**********************************@microsof t.com...
Alternatively you can create a job to run your stuff which starts when SQL Server Agent
starts...
(may not be as good as Tibor's suggestion :) but I already said, it's just an alternative)
--
Ekrem Önsoy
"traceable1" <thham...@gmail.comwrote in message
news:11*********************@y27g2000pre.googlegro ups.com...
Is there a way I can set up a SQL script to run when the instance
starts up?
SQL Server 2005 SP2
thanks!- Hide quoted text -
- Show quoted text -


On Oct 18, 3:56 pm, Steve215 <stephen.mer...@comcast.netwrote:
On Oct 18, 11:50 am, traceable1 <thham...@gmail.comwrote:
Is there a way I can set up a SQL script to run when the instance
starts up?
SQL Server 2005 SP2
thanks!

This link describes the use of 'Automatic Execution Stored Procedures'
than may fit the bill for what you are looking for.

http://msdn2.microsoft.com/en-us/library/ms191129.aspx

Oct 18 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Stephen | last post by:
I have code which checks whether a datagrid is empty and if it is it shows a panel on my page. If its not empty then Im using the server.transfer to go to another page so as im able to use the...
6
by: Hemant Shah | last post by:
Folks, I need to move HOME directory of an instance to another directory. What is the best way of doing it? Is changing password file enough? or dies DB2 store this info in it's own config? ...
2
by: Cheng Wei-Chao | last post by:
hi: i have a button, when i click it i want to store data to database and open a new window in general we use java script to open new window but how to call java script function after i...
8
by: Fabrizio Cyber | last post by:
Hi all, I want to use a .js into a visual basic project. How can I do it ? I've tried to open the script code into my project....and then ??? I see the code but I don't jnow how to make it...
10
by: Bernie Hunt | last post by:
This is probably a silly question, but I've gotten myself confused. My app has two forms, form1 and form2. form1 is the start up object in the propers. An event in form1 instantiates form2. ...
0
by: Stealth3si | last post by:
I hope this is the right thread /forum to place this topic in. I'm trying to execute a .vbs file (double-click) on Windows 2000 Advanced Server with Service Pack 4 (on administrator account) and...
2
by: Slawek | last post by:
I would like to run a script at startup under SuSE 9. I read and figured out that it can be done using chkconfig and setting the proper run level. The problem I have currently is that I depend on...
2
by: jcor | last post by:
Hi, I'm running Ubuntu 7.04. I Have a perl script. I want it to be running all the time. The way it is working, I must start my script, so when someone turns off the computer it doesn't run...
5
by: rpelletier | last post by:
Good morning....As you will see when you view the script I am fairly new to Java. All I am trying to accomplish with this script is to navigate to the static URL listed in the script, however, one of...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.