Could not find stored procedure

Hi -
I've been advised to run a few scripts located in my SQL Install directory
(messages, sp1_serv_uni, sp2_serv_uni, sp3_serv_uni), and I'm not sure how.
When I use Query Analyzer and run 'EXEC messages.sql', I get a 'Could not
find stored procedure' error. I'm using the master database, but these
procedures are not in that (or any other) database. How can I run them'
Thanks for your help.
- JeffJeff,
You need to open the scripts to run them. File->Open, just like with any
other text editor, then you can run whatever's in the files.
"Jeff" <jeffg22@.mindspring.com> wrote in message
news:cJAdc.1884$l75.977@.newsread2.news.atl.earthlink.net...
> Hi -
> I've been advised to run a few scripts located in my SQL Install directory
> (messages, sp1_serv_uni, sp2_serv_uni, sp3_serv_uni), and I'm not sure
how.
> When I use Query Analyzer and run 'EXEC messages.sql', I get a 'Could not
> find stored procedure' error. I'm using the master database, but these
> procedures are not in that (or any other) database. How can I run them'
> Thanks for your help.
> - Jeff
>|||messages.sql is not something you can run directly from Query Analyzer. Go
out to the command line and run osql ... see Books Online for information,
but it might look something like this:
osql -E -S (local) -i c:\path\messages.sql
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jeff" <jeffg22@.mindspring.com> wrote in message
news:cJAdc.1884$l75.977@.newsread2.news.atl.earthlink.net...
> Hi -
> I've been advised to run a few scripts located in my SQL Install directory
> (messages, sp1_serv_uni, sp2_serv_uni, sp3_serv_uni), and I'm not sure
> how.
> When I use Query Analyzer and run 'EXEC messages.sql', I get a 'Could not
> find stored procedure' error. I'm using the master database, but these
> procedures are not in that (or any other) database. How can I run them'
> Thanks for your help.
> - Jeff
>|||Or, of course, as Adam suggests, open the file in QA. <sheepish grin>
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Thanks, guys -
I knew it had to be something simple!
- Jeff
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:OsV9d0lHEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Or, of course, as Adam suggests, open the file in QA. <sheepish grin>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>