Friday, March 9, 2012

List of Packaged XP's

Hi All
Can somebody point me to where i can find a list (including what they do
with parameters) of all the Sp's and XP's that come with SQL 2000
Thanks
RegIn Books Online, look in the index for "system stored procedures, listed".
There are more SPs and XPs shipped with SQL Server than are listed there,
but these undocumented procedures can change without warning with a new
version, service pack or hotfix and use is at your own risk.
--
Jacco Schalkwijk
SQL Server MVP
"Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
news:JO-dnQYtM7TTyhyiU-KYhw@.is.co.za...
> Hi All
> Can somebody point me to where i can find a list (including what they do
> with parameters) of all the Sp's and XP's that come with SQL 2000
> Thanks
> Reg
>|||Probably the best reference for this is SQL Server Books
Online. Just go through the help file's index reviewing
sp_xxx and xp_xxxx.
-Sue
On Mon, 6 Oct 2003 13:53:49 +0200, "Reg Besseling"
<reg.usenet.nospam@.epic-sc.com> wrote:
>Hi All
>Can somebody point me to where i can find a list (including what they do
>with parameters) of all the Sp's and XP's that come with SQL 2000
>Thanks
>Reg
>|||Thanks - I was searching for xp_qv
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:elkk$cAjDHA.1956@.TK2MSFTNGP12.phx.gbl...
> In Books Online, look in the index for "system stored procedures, listed".
> There are more SPs and XPs shipped with SQL Server than are listed there,
> but these undocumented procedures can change without warning with a new
> version, service pack or hotfix and use is at your own risk.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
> news:JO-dnQYtM7TTyhyiU-KYhw@.is.co.za...
> > Hi All
> >
> > Can somebody point me to where i can find a list (including what they do
> > with parameters) of all the Sp's and XP's that come with SQL 2000
> >
> > Thanks
> >
> > Reg
> >
> >
>|||Some information about xp_qv courtesy of Microsoft employee Gert Drapers:
"xp_qv, hosted in xpsqlbot.dll is a wrapper around functionality in
sqlboot.dll, which returns information about the SKU type, licensing etc
It is not documented that is why you can not find a reference.
I should be getting called very infrequently and as far as I know it only
visits the Registry"
Jacco Schalkwijk
SQL Server MVP
"Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
news:_cudnaOFzsXY5ByiU-KYiQ@.is.co.za...
> Thanks - I was searching for xp_qv
> "Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
> news:elkk$cAjDHA.1956@.TK2MSFTNGP12.phx.gbl...
> > In Books Online, look in the index for "system stored procedures,
listed".
> >
> > There are more SPs and XPs shipped with SQL Server than are listed
there,
> > but these undocumented procedures can change without warning with a new
> > version, service pack or hotfix and use is at your own risk.
> >
> > --
> > Jacco Schalkwijk
> > SQL Server MVP
> >
> >
> > "Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
> > news:JO-dnQYtM7TTyhyiU-KYhw@.is.co.za...
> > > Hi All
> > >
> > > Can somebody point me to where i can find a list (including what they
do
> > > with parameters) of all the Sp's and XP's that come with SQL 2000
> > >
> > > Thanks
> > >
> > > Reg
> > >
> > >
> >
> >
>|||Thanks for the prompt help
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:ux78ncBjDHA.2336@.TK2MSFTNGP11.phx.gbl...
> Some information about xp_qv courtesy of Microsoft employee Gert Drapers:
> "xp_qv, hosted in xpsqlbot.dll is a wrapper around functionality in
> sqlboot.dll, which returns information about the SKU type, licensing etc
> It is not documented that is why you can not find a reference.
> I should be getting called very infrequently and as far as I know it only
> visits the Registry"
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
> news:_cudnaOFzsXY5ByiU-KYiQ@.is.co.za...
> > Thanks - I was searching for xp_qv
> > "Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
> > news:elkk$cAjDHA.1956@.TK2MSFTNGP12.phx.gbl...
> > > In Books Online, look in the index for "system stored procedures,
> listed".
> > >
> > > There are more SPs and XPs shipped with SQL Server than are listed
> there,
> > > but these undocumented procedures can change without warning with a
new
> > > version, service pack or hotfix and use is at your own risk.
> > >
> > > --
> > > Jacco Schalkwijk
> > > SQL Server MVP
> > >
> > >
> > > "Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
> > > news:JO-dnQYtM7TTyhyiU-KYhw@.is.co.za...
> > > > Hi All
> > > >
> > > > Can somebody point me to where i can find a list (including what
they
> do
> > > > with parameters) of all the Sp's and XP's that come with SQL 2000
> > > >
> > > > Thanks
> > > >
> > > > Reg
> > > >
> > > >
> > >
> > >
> >
> >
>

No comments:

Post a Comment