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

thanks!

On Oct 18, 11:50 am, traceable1 <thham... [at] gmail.com> wrote:
> 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

Thank you!!


On Oct 18, 3:56 pm, Steve215 <stephen.mer... [at] comcast.net> wrote:
> On Oct 18, 11:50 am, traceable1 <thham... [at] gmail.com> wrote:
>
> > 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

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

Newsgroups: microsoft.public.sqlserver.server
From: "Tibor Karaszi"
<tibor_please.no.email_kara... [at] hotmail.nomail.com>
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... [at] gmail.com> wrote in message


news:1192722595.538697.92480 [at] y27g2000pre.googlegroups.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... [at] hotmail.nomail.com>
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 =D6nsoy" <ek... [at] btegitim.com> wrote in message


news:1890C2B6-7DD2-40AE-AF10-01981F3ABD51 [at] microsoft.com...


- Hide quoted text -
- Show quoted text -

> Alternatively you can create a job to run your stuff which starts when SQ=
L Server Agent starts...
> (may not be as good as Tibor's suggestion :) but I already said, it's jus=
t an alternative)

> --
> Ekrem =D6nsoy


> "traceable1" <thham... [at] gmail.com> wrote in message
> news:1192722595.538697.92480 [at] y27g2000pre.googlegroups.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... [at] 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... [at] hotmail.nomail.com> wrote:
> Actually, one can claim that your alternative, Ekrem, is a cleaner soluti=
on than mine. I.e., it
> might feel better to have a client app (Agent) execute whatever TSQL comm=
ands 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.asp=
http://sqlblog.com/blogs/...


> "Ekrem =D6nsoy" <ek... [at] btegitim.com> wrote in message


> news:1890C2B6-7DD2-40AE-AF10-01981F3ABD51 [at] microsoft.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 j=
ust an alternative)


> > --
> > Ekrem =D6nsoy


> > "traceable1" <thham... [at] gmail.com> wrote in message
> >news:1192722595.538697.92480 [at] y27g2000pre.googlegroups.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... [at] hotmail.nomail.com>
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... [at] gmail.com> wrote in message


news:1192739683.702442.18160 [at] k35g2000prh.googlegroups.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... [at] hotmail.nomail.com> wrote:
> Actually, one can claim that your alternative, Ekrem, is a cleaner soluti=
on than mine. I.e., it
> might feel better to have a client app (Agent) execute whatever TSQL comm=
ands 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://sqlblo g.com/blogs/.=
..=2E


> "Ekrem =D6nsoy" <ek... [at] btegitim.com> wrote in message


> news:1890C2B6-7DD2-40AE-AF10-01981F3ABD51 [at] microsoft.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 j=
ust an alternative)


> > --
> > Ekrem =D6nsoy


> > "traceable1" <thham... [at] gmail.com> wrote in message
> >news:1192722595.538697.92480 [at] y27g2000pre.googlegroups.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... [at] comcast.net> wrote:
> On Oct 18, 11:50 am, traceable1 <thham... [at] gmail.com> wrote:
>
> > 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