Installing Stored Proceedures

Hi,
Im interesting in usung the Simple log Shipping (SLS) tool that is included
as part of the SQL2000 Resource Kit. Within the document that is provided, i
t mentions that i need to 'SLS requires two stored sproceedures to be instal
led' Recommended for the ma
ster database.
I have the query files .SQL but i dont know how to install these.
I could just use the create stored proceedure wizard and paste the text from
the file's into ii but is this the same ' I've never come across the term
installing a stored proceedure.
Any advice would be much appreciated.
Kind Regards,
ChrisHi Chris
You're right, it is strange to say 'installing' a stored procedure. You just
'create' a stored procedure. You should be able to use the Create Stored
Procedure Wizard and copy and paste the text.
You might also get familiar with the Query Analzyer tool, which allows you
to enter and run any TSQL statement, including CREATE PROCEDURE.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Chris Welbourne" <Chris Welbourne@.discussions.microsoft.com> wrote in
message news:1ED96BC8-17C4-48F7-8417-05407E570669@.microsoft.com...
> Hi,
> Im interesting in usung the Simple log Shipping (SLS) tool that is
included as part of the SQL2000 Resource Kit. Within the document that is
provided, it mentions that i need to 'SLS requires two stored sproceedures
to be installed' Recommended for the master database.
> I have the query files .SQL but i dont know how to install these.
> I could just use the create stored proceedure wizard and paste the text
from the file's into ii but is this the same ' I've never come across the
term installing a stored proceedure.
> Any advice would be much appreciated.
> Kind Regards,
> Chris
>|||Kalen,
Thank you. Its certainly cleared that problem for me. :-)
Kind Regards,
Chris.
P.S. Well done on the Inside SQL Server 2000 Book, im currently reading thro
ugh it.
"Kalen Delaney" wrote:

> Hi Chris
> You're right, it is strange to say 'installing' a stored procedure. You ju
st
> 'create' a stored procedure. You should be able to use the Create Stored
> Procedure Wizard and copy and paste the text.
> You might also get familiar with the Query Analzyer tool, which allows you
> to enter and run any TSQL statement, including CREATE PROCEDURE.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Chris Welbourne" <Chris Welbourne@.discussions.microsoft.com> wrote in
> message news:1ED96BC8-17C4-48F7-8417-05407E570669@.microsoft.com...
> included as part of the SQL2000 Resource Kit. Within the document that is
> provided, it mentions that i need to 'SLS requires two stored sproceedures
> to be installed' Recommended for the master database.
> from the file's into ii but is this the same ' I've never come across the
> term installing a stored proceedure.
>
>|||Thanks, Chris!
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Chris Welbourne" <ChrisWelbourne@.discussions.microsoft.com> wrote in
message news:89EB0AEE-7484-4DB4-9128-51095422D8D5@.microsoft.com...
> Kalen,
> Thank you. Its certainly cleared that problem for me. :-)
> Kind Regards,
> Chris.
> P.S. Well done on the Inside SQL Server 2000 Book, im currently reading
through it.[vbcol=seagreen]
>
> "Kalen Delaney" wrote:
>
just[vbcol=seagreen]
you[vbcol=seagreen]
is[vbcol=seagreen]
sproceedures[vbcol=seagreen]
text[vbcol=seagreen]
the[vbcol=seagreen]