Max degree of recursion

Hi Everyone
As I understand it the maximum call stack level of recursive stored
procedures is 32. Is there at way around this limitation?
I want to make a procedure that traverses a tree structure in my database to
discover if a given node is above the input parameter. Ex:
CREATE TABLE Nodes
(
NodeID int,
ParentNodeID int
)
DECLARE @.MyNodeID int
DECLARE @.ParentNodeID int
DECLARE @.IsParent bit
SET @.MyNodeID = 42
SET @.ParentNodeID = 13
EXEC spIs_Parent @.MyNode, @.ParentNodeID, Is
... What is the best way to implement such a procedure?
--
Yours sincerely
Thomas Kejser
M.Sc, MCDBADo it the sloppy way without using recursion.
Do you have the code?
--
Tony Rogerson
SQL Server MVP
http://www.sqlserverfaq.com?mbr=21
(Create your own groups, Forum, FAQ's and a ton more)

Max count of logins

Hi!
SQL 2000 has a limitation of approx. ~ 16000 SQL Server logins.
(Don't know the exactly number yet, but the limitation is there...)
Did anyone know if SQL Server 2005 still has a limitation regarding the
number of possible SQL Server logins?
Thanks in advance.
Thomas
www.sqlscripter.com
Hi
Any that is a problem?
What is your scenario that you need so many logins?
How do you manage such a number?
Are you not using NT/AD groups and giving the groups access to he DB?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Thomas" wrote:

> Hi!
> SQL 2000 has a limitation of approx. ~ 16000 SQL Server logins.
> (Don't know the exactly number yet, but the limitation is there...)
> Did anyone know if SQL Server 2005 still has a limitation regarding the
> number of possible SQL Server logins?
> Thanks in advance.
> Thomas
> www.sqlscripter.com
>
|||Thanks for your feedback.
We need that for a Self Service system, i know that using NT (groups) we
will not have these problems ...
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Any that is a problem?
> What is your scenario that you need so many logins?
> How do you manage such a number?
> Are you not using NT/AD groups and giving the groups access to he DB?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Thomas" wrote:

Max count of logins

Hi!
SQL 2000 has a limitation of approx. ~ 16000 SQL Server logins.
(Don't know the exactly number yet, but the limitation is there...)
Did anyone know if SQL Server 2005 still has a limitation regarding the
number of possible SQL Server logins?
Thanks in advance.
Thomas
www.sqlscripter.comHi
Any that is a problem?
What is your scenario that you need so many logins?
How do you manage such a number?
Are you not using NT/AD groups and giving the groups access to he DB?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Thomas" wrote:

> Hi!
> SQL 2000 has a limitation of approx. ~ 16000 SQL Server logins.
> (Don't know the exactly number yet, but the limitation is there...)
> Did anyone know if SQL Server 2005 still has a limitation regarding the
> number of possible SQL Server logins?
> Thanks in advance.
> Thomas
> www.sqlscripter.com
>|||Thanks for your feedback.
We need that for a Self Service system, i know that using NT (groups) we
will not have these problems ...
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Any that is a problem?
> What is your scenario that you need so many logins?
> How do you manage such a number?
> Are you not using NT/AD groups and giving the groups access to he DB?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Thomas" wrote:
>

Max count of logins

Hi!
SQL 2000 has a limitation of approx. ~ 16000 SQL Server logins.
(Don't know the exactly number yet, but the limitation is there...)
Did anyone know if SQL Server 2005 still has a limitation regarding the
number of possible SQL Server logins?
Thanks in advance.
Thomas
www.sqlscripter.comHi
Any that is a problem?
What is your scenario that you need so many logins?
How do you manage such a number?
Are you not using NT/AD groups and giving the groups access to he DB?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Thomas" wrote:
> Hi!
> SQL 2000 has a limitation of approx. ~ 16000 SQL Server logins.
> (Don't know the exactly number yet, but the limitation is there...)
> Did anyone know if SQL Server 2005 still has a limitation regarding the
> number of possible SQL Server logins?
> Thanks in advance.
> Thomas
> www.sqlscripter.com
>|||Thanks for your feedback.
We need that for a Self Service system, i know that using NT (groups) we
will not have these problems ...
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Any that is a problem?
> What is your scenario that you need so many logins?
> How do you manage such a number?
> Are you not using NT/AD groups and giving the groups access to he DB?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Thomas" wrote:
> > Hi!
> >
> > SQL 2000 has a limitation of approx. ~ 16000 SQL Server logins.
> > (Don't know the exactly number yet, but the limitation is there...)
> >
> > Did anyone know if SQL Server 2005 still has a limitation regarding the
> > number of possible SQL Server logins?
> >
> > Thanks in advance.
> >
> > Thomas
> > www.sqlscripter.com
> >sql