----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Gogi7735 Message 3 in Discussion hi Vinod, thanks for u r reply.we are not going for Alter table and adding Identity Column because , we have alter more than 100+ Tables in the production environment that spread across 3 locations and needs to change lot of code in application side .so we are looking at some generic solution in sql server for the oracle row id .what we are looking at sql server trigger is try to make that generic(first get the primary keys for the table and then the values inserted for the primary keys and insert them for change tracking purpose).what we have done in oracle is given oracle table name for a function in VB.NET , i am able to create trigger on it to track changes on the table.so we are looking from that point of view(insted of writing trigger for each table and get the primary key value like that). 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]
