Hello, I have problem with this command in Ms sql sever 7. It was working under MS sql server 2000 but now doesn’t work in 7.
set rs=Server.CreateObject("ADODB.Recordset")
rs.open "select IDENT_CURRENT("mytable") AS ID","Dsn=project;uid=;pwd=;"
It gives error message saying:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]‘IDENT_CURRENT’ is not a recognized function name.
And I want to make it so that it can always get the latest ID in m table. So could any one give some suggestion how to make it in other ways or I can still use the command of “IDENT_CURRENT” but change my code?
Thanks very much in advance!