Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
OwenW
Starting Member
11 Posts |
 Posted - 2007-02-16 : 16:23:51
|
| I am tricking a third pary app to think it is looking at a set of tables by creating views (named exactly the same as the original tables) that mimic the data the app wants to see.I have a large table that stores data for multiple projects, we'll call it 'MAIN'. Each view shows the application only the records for a single project at a time.The problem comes up when the application creates new records. Since records are being created through the view, I have to write an INSTEAD OF trigger, but I need to identify which view is being used to update the MAIN table, since the application does not natively store a Project Identifier in the new record.Thus, I need a View Identifier. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-16 : 17:42:14
|
| Is there something that you want help with?CODO ERGO SUM |
 |
|
|
|
|
|
View Identifier