Identity whithout identity column

Hi!
Please help!
Is there a function in SQL Server that returns "ROWID" from any table
(without identity column) or how to get that number?
Regards, MarkoThere is no internal rowid in SQL Server (such violated the relational model). If you say what you
would need it for, we can suggest alternatives.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Marko Kopaè" <marko.kopac@.mais.si> wrote in message
news:%23Gp%23PYngDHA.2484@.TK2MSFTNGP09.phx.gbl...
> Hi!
> Please help!
> Is there a function in SQL Server that returns "ROWID" from any table
> (without identity column) or how to get that number?
> Regards, Marko
>

Identity Insert

How do I turn on IDENTITY_INSERT for a table in SQL 2005?
--
Regards,
Fred Chateau
fchateauAtComcastDotNetSET IDENTITY_INSERT yourschema.yourtable ON
GO
eg
SET IDENTITY_INSERT dbo.Customers ON
GO
HTH,
Paul Ibison
(btw BOL has all of this in good detail).