Home > Archive > microsoft.public.sqlserver.server > November 2002 > Extended Stored Procs





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Extended Stored Procs
Chris Wood

2002-11-29, 10:23 am

Hi,

Is there anywhere that describes all the extended stored procedures that
come with SQL2000? We would like to know if one will perform a certain
function for us.

Thanks

Chris Wood
Alberta Department of Energy
CANADA


Allan Mitchell

2002-11-29, 10:23 am

If you search on Google for "Extended Stored procedures" you will get a few
hits. Whilst I do not think they will all be covered you should see a few.
What is the functionality you want ?

--



Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org



"Chris Wood" <chris.wood@gov.ab.ca> wrote in message
news:uqohEw7lCHA.2032@tkmsftngp02...
> Hi,
>
> Is there anywhere that describes all the extended stored procedures that
> come with SQL2000? We would like to know if one will perform a certain
> function for us.
>
> Thanks
>
> Chris Wood
> Alberta Department of Energy
> CANADA
>
>



Chris Wood

2002-11-29, 10:23 am

Allan,

I'm looking for a something that will enumerate the processes currently
running on the server.

Chris

"Allan Mitchell" <allan@no-spam.SQLDTS.com> wrote in message
news:eu30g#7lCHA.1928@tkmsftngp07...
> If you search on Google for "Extended Stored procedures" you will get a

few
> hits. Whilst I do not think they will all be covered you should see a

few.
> What is the functionality you want ?
>
> --
>
>
>
> Allan Mitchell (Microsoft SQL Server MVP)
> www.SQLDTS.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
>
>
> "Chris Wood" <chris.wood@gov.ab.ca> wrote in message
> news:uqohEw7lCHA.2032@tkmsftngp02...
> > Hi,
> >
> > Is there anywhere that describes all the extended stored procedures that
> > come with SQL2000? We would like to know if one will perform a certain
> > function for us.
> >
> > Thanks
> >
> > Chris Wood
> > Alberta Department of Energy
> > CANADA
> >
> >

>
>



Gert E.R. Drapers

2002-11-29, 5:23 pm

select name from master.dbo.sysobjects where type = 'X'

GertD@SQLDev.Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2002 All rights reserved.

"Chris Wood" <chris.wood@gov.ab.ca> wrote in message
news:uQXrJI8lCHA.2800@tkmsftngp04...
> Allan,
>
> I'm looking for a something that will enumerate the processes currently
> running on the server.
>
> Chris
>
> "Allan Mitchell" <allan@no-spam.SQLDTS.com> wrote in message
> news:eu30g#7lCHA.1928@tkmsftngp07...
> > If you search on Google for "Extended Stored procedures" you will get a

> few
> > hits. Whilst I do not think they will all be covered you should see a

> few.
> > What is the functionality you want ?
> >
> > --
> >
> >
> >
> > Allan Mitchell (Microsoft SQL Server MVP)
> > www.SQLDTS.com
> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org
> >
> >
> >
> > "Chris Wood" <chris.wood@gov.ab.ca> wrote in message
> > news:uqohEw7lCHA.2032@tkmsftngp02...
> > > Hi,
> > >
> > > Is there anywhere that describes all the extended stored procedures

that[
color=darkred]
> > > come with SQL2000? We would like to know if one will perform a certain
> > > function for us.
> > >
> > > Thanks
> > >
> > > Chris Wood
> > > Alberta Department of Energy
> > > CANADA
> > >
> > >

> >
> >

>
>[/color]


Allan Mitchell

2002-11-30, 2:23 am

To look at processes I generally use sp_who2

--



Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org



"Chris Wood" <chris.wood@gov.ab.ca> wrote in message
news:uQXrJI8lCHA.2800@tkmsftngp04...
> Allan,
>
> I'm looking for a something that will enumerate the processes currently
> running on the server.
>
> Chris
>
> "Allan Mitchell" <allan@no-spam.SQLDTS.com> wrote in message
> news:eu30g#7lCHA.1928@tkmsftngp07...
> > If you search on Google for "Extended Stored procedures" you will get a

> few
> > hits. Whilst I do not think they will all be covered you should see a

> few.
> > What is the functionality you want ?
> >
> > --
> >
> >
> >
> > Allan Mitchell (Microsoft SQL Server MVP)
> > www.SQLDTS.com
> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org
> >
> >
> >
> > "Chris Wood" <chris.wood@gov.ab.ca> wrote in message
> > news:uqohEw7lCHA.2032@tkmsftngp02...
> > > Hi,
> > >
> > > Is there anywhere that describes all the extended stored procedures

that[
color=darkred]
> > > come with SQL2000? We would like to know if one will perform a certain
> > > function for us.
> > >
> > > Thanks
> > >
> > > Chris Wood
> > > Alberta Department of Energy
> > > CANADA
> > >
> > >

> >
> >

>
>[/color]


Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net