pdo::lastInsertId() error with SQL Server

["Sady Marcos" <smarcos@xxxxxxxxxxxxxxx>]

hey..
I am not obtaining use the function pdo::lastInsertId() with sql
My code:

$db = new PDO("mssql:host=host;dbname=database","user","password");
$sql = "INSERT INTO users(name,status) VALUES('username','1)";
$db->query($sql);
$db->lastInsertId();

Error:

SQLSTATE[IM001]: Driver does not support this function: driver does not 
support lastInsertId()

This is true?
The only way would be executing query "SELECT @@IDENTITY as Id" ?

Thanks for help 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php