Firstly, wrong place to post, the topic Try Catch block is not available in SQL Server 2000.

I have not heard/read anything such as TRY SUCCESS in SQL Server.

BEGIN TRY block is there to write your code if there is not exception / errors which means, the code placed in Begin Try and End Try will run when when no errors are encountered.