how to get Top 1 row in sql server 2000 version

Question

Hello All,

 

How to get Top 1 rows in Sql server 2000 version we are using for your production server.

I need to get First row with out using Rowcount is there any option to bring to bring Top 1 row and Top 1 is not working in sql server 2000.

 

SET ROWCOUNT 1

SELECT errorcode,errordescription,name,logdate FROM msdb.dbo.sysdtspackagelog

WHERE WHERE[name] = 'ProjectModel_xfer2'

ORDER BY logdate

SET ROWCOUNT 0

 

Please help me.