Dedicated server config

Could someone direct me to a good online resorce for
configuring a server which will be a dedicated SQL
Server 2000 machine? I'm going for performance.
Thanks,
Andrewhttp://www.sql-server-performance.com
--
David Portas
--
Please reply only to the newsgroup
--
"Andrew" <a@.b.com> wrote in message
news:2781c01c38f76$65d7f2f0$a601280a@.phx.gbl...
> Could someone direct me to a good online resorce for
> configuring a server which will be a dedicated SQL
> Server 2000 machine? I'm going for performance.
> Thanks,
> Andrew
>

Debugging Stored Procedure

Hi Folks,

I'm using SQL Server 2005 Express and I need to debug my stored prodedure. I've been reading online that it can be done in the Express edition but no one explains how to do it. There's plenty of instructions online on how to debug stored procedure in the other versions of SQL Server 2005. Do any of you know how to do it?

Thanks in advance

As in SQL Server 2000 , we can not debugg the SP from SQL ENV in SQL 2005. u have to debugg from Visual studio Env.

Check this

http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005

Madhu