3 node sql2000 on win2003 cookbook?

Can some point to a doc (cookbook) for building a 3 node sql2000 cluster on
win 2003.
thanks,
JR
You can take a look at the following link
http://support.microsoft.com/?id=260758. It deals with FAQ and also has
links on how to install SQL2000 on Win2003 Cluster. Your experience should
not vary on the number of nodes on the cluster.
Sandeep Sutari
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"jr" <jr@.jr.com> wrote in message
news:%23iyGdVQOEHA.904@.TK2MSFTNGP12.phx.gbl...
> Can some point to a doc (cookbook) for building a 3 node sql2000 cluster
on
> win 2003.
> thanks,
> JR
>
|||Sandeep, can you point to similar information on the Active / active clustering, not failover? i seems to find a lot about fail over but having hard time locating faq or a how to on configuring it as multiple active nodes to share the processing load.
Thank you
-- Sandeep Sutari [MSFT] wrote: --
You can take a look at the following link
http://support.microsoft.com/?id=260758. It deals with FAQ and also has
links on how to install SQL2000 on Win2003 Cluster. Your experience should
not vary on the number of nodes on the cluster.
Sandeep Sutari
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"jr" <jr@.jr.com> wrote in message
news:%23iyGdVQOEHA.904@.TK2MSFTNGP12.phx.gbl...
> Can some point to a doc (cookbook) for building a 3 node sql2000 cluster
on[vbcol=seagreen]
> win 2003.
> JR
|||I don't think active/active means what you think it does here. :-) That's a
term that was used in SQL Server 7.0 to indicate that both nodes in your
Failover Cluster were running a installation of SQL Server that was being
accessed by users. Those instances do not share databases between them, they
were completely stand-alone. SQL Server 2000 does not allow multiple nodes
to access the same database at the same time either.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael" <anonymous@.discussions.microsoft.com> wrote in message
news:538CE54C-0C3B-48B9-AD24-3E23CF18B54D@.microsoft.com...
> Sandeep, can you point to similar information on the Active / active
clustering, not failover? i seems to find a lot about fail over but having
hard time locating faq or a how to on configuring it as multiple active
nodes to share the processing load.
> Thank you
> -- Sandeep Sutari [MSFT] wrote: --
> You can take a look at the following link
> http://support.microsoft.com/?id=260758. It deals with FAQ and also
has
> links on how to install SQL2000 on Win2003 Cluster. Your experience
should
> not vary on the number of nodes on the cluster.
>
> --
> Sandeep Sutari
> Microsoft Corp.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Use of any included script samples are subject to the terms specified
at[vbcol=seagreen]
> http://www.microsoft.com/info/cpyright.htm
> "jr" <jr@.jr.com> wrote in message
> news:%23iyGdVQOEHA.904@.TK2MSFTNGP12.phx.gbl...
cluster[vbcol=seagreen]
> on
sql

2147467259 ongoing headache

I am receiving the -2147467259 error randomly when building a large temp
table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
I'm using MSDE SP4, all forms known to me of security, virus protection etc
have been shut down or removed Error log includes:
Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
Any comments would be appreciated
Message posted via http://www.droptable.com
This is probably a bug. Since you are on the most current service pack, you
should probably open a call to PSS...($249, but not charged if they confirm
the bug.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rod via droptable.com" <forum@.nospam.droptable.com> wrote in message
news:3263c6b7795a4036a2614c3c8878758a@.droptable.co m...
>I am receiving the -2147467259 error randomly when building a large temp
> table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
> anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
> I'm using MSDE SP4, all forms known to me of security, virus protection
> etc
> have been shut down or removed Error log includes:
> Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
> Any comments would be appreciated
> --
> Message posted via http://www.droptable.com

2147467259 ongoing headache

I am receiving the -2147467259 error randomly when building a large temp
table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
I'm using MSDE SP4, all forms known to me of security, virus protection etc
have been shut down or removed Error log includes:
Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
Any comments would be appreciated
Message posted via http://www.droptable.comThis is probably a bug. Since you are on the most current service pack, you
should probably open a call to PSS...($249, but not charged if they confirm
the bug.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rod via droptable.com" <forum@.nospam.droptable.com> wrote in message
news:3263c6b7795a4036a2614c3c8878758a@.SQ
droptable.com...
>I am receiving the -2147467259 error randomly when building a large temp
> table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
> anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
> I'm using MSDE SP4, all forms known to me of security, virus protection
> etc
> have been shut down or removed Error log includes:
> Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
> Any comments would be appreciated
> --
> Message posted via http://www.droptable.com

2147467259 ongoing headache

I am receiving the -2147467259 error randomly when building a large temp
table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
I'm using MSDE SP4, all forms known to me of security, virus protection etc
have been shut down or removed Error log includes:
Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
Any comments would be appreciated
--
Message posted via http://www.sqlmonster.comThis is probably a bug. Since you are on the most current service pack, you
should probably open a call to PSS...($249, but not charged if they confirm
the bug.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rod via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:3263c6b7795a4036a2614c3c8878758a@.SQLMonster.com...
>I am receiving the -2147467259 error randomly when building a large temp
> table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
> anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
> I'm using MSDE SP4, all forms known to me of security, virus protection
> etc
> have been shut down or removed Error log includes:
> Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
> Any comments would be appreciated
> --
> Message posted via http://www.sqlmonster.com

2005 Stored Procedure Question - How to pass in additional LIKEconditions

Hi Paparush,

I believe the problem is because you're mixing up dynamic SQL with
static SQL.
The @.SearchTerm variable that you are building up can not be used to
specify additional LIKE criteria for the Subject column, each LIKE
condition needs to be individually coded into your static SQL.

The alternative is to build the entire SELECT as dynamic SQL. This
provides additional flexibility, but there are performance and
security implications when doing this (google SQL injection).

Good luck!
JOn Dec 17, 10:33 am, jhofm...@.googlemail.com wrote:

Quote:

Originally Posted by

Hi Paparush,
>
I believe the problem is because you're mixing up dynamic SQL with
static SQL.
The @.SearchTerm variable that you are building up can not be used to
specify additional LIKE criteria for the Subject column, each LIKE
condition needs to be individually coded into your static SQL.
>
The alternative is to build the entire SELECT as dynamic SQL. This
provides additional flexibility, but there are performance and
security implications when doing this (google SQL injection).
>
Good luck!
J

Hi J,
Thanks for the reply.

Yes..the dynamic SQL is the approach I've been trying all morning and
I've gotten it to work. I have to build the entire SELECT string in
my app's code, based on the search term the user enters and then stuff
this into @.SearchTerm and pass this string into the code below.

declare @.SearchTerm nvarchar(max)

EXEC sp_ExecuteSQL @.Search