-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Gogi7735
Message 1 in Discussion
hi,
In oracle ,I have the ROWID , to identify a record in the table along with
primary key.is there any similar kind of functionality in sql sever to uniquely
identify a record in the table along with the primary key?one solution I could
find is the adding a new IDENTITY column in Sql Server table ,this is
not feasible for us because we have to change the Production database,is there
any other solution for this in SQL Server?
My requirement is
when ever record inserted / updated / delete on the sql server table I
have to keep track of this.I am trying to track the changes in another
table with a trigger on the source table where I can put the
recordNo and the Table Name in the tracking table.but the issue comes when
identifying the inserted value(in this case I have to write separate
trigger for each table to get the primarykey value of the table) .I am
looking at generic solution for all tables.
Regards
-Srini
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
