Home Forums SQL Server 2008 SQL Server Newbies How make procedure of below requirement in sql server 2000? RE: How make procedure of below requirement in sql server 2000?

  • I believe the IDENT_CURRENT Function did exist in Sql Server 2000 but do bear in mind that it will return the last identity value generated for a specified table in ANY session or scope so it may not be what you are after.

    Clarify if you are working with SQL Server 2000 or 2008 here as there may be alternative ways to do what you want.