Generate Serial Number In SQL Server 2005

select Row_Number() over (order by Emp_Id) as SrNo ,Emp_Id,Emp_Name
from mstEmployee