does stored procedures work in sql server 2000 ?

Hello.
 
Yes stored procedure work on SQL 2000.
 
A good start is to read about SQL 2000.
http://msdn.microsoft.com/en-us/library/hh995067(v=sql.10).aspx[^]
 
Sql2000 is now fairly old system and Microsoft will stop supporting in in April this year, I suggest you look at more modern alternatives, like SQL 2012 for example.
 
http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=SQL[^]
 

 
Valery.