Only in 2005 its disabled by default for security reasons.
In 2000 you need to have sysadmin fixed role to use it.
Pls see the below link
http://msdn.microsoft.com/en-us/library/aa260689(SQL.80).aspx
----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]