Reg:Tables data changes auditing

Hi,

I have more than 1100 tables in my databse. From existing application data will insert into Database tables. I need to track the tables module wise when data inserting/Updating into these tables.

One way is, I have to write the triggers for each table[1100 tables with auditing]. In my case this is not possible to write like that.

Is thesre any other solution to find the updated,inserted tables when data is changing from application without doing bulk changes.

Regards

Hanu

unfortunately SQL Server can not do this until unless we have our own mechanism.

Madhu

Reg: Table data changes auditing

Hi,

I have more than 1100 tables in my databse. From existing application data will insert into Database tables. I need to track the tables module wise when data inserting/Updating into these tables.

One way is i have to write the triggers for each table[1100 tables with auditing]. In my case this is not possible to write.

Is thesre any other way to find the updated,inserted tables when data is changing from application.

Regards

Hanu

hi,

You may get more help posting it in

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1

SQL Server Database Engine forum

Although i maybe wrong

Good luck

Matt

Re-Engineer an Existing CUBE

Is it possible to bring a deployed CUBE into Visual Studio.NET?

My CUBE is deployed on SQL 05 Analysis Services. It is the "Portfolio Analyzer" CUBE shipped with Project Server 07.

|||

You can do it one of two ways:

1. File... Open... Analysis Services Database

2. File... New... Project... Business Intelligence Projects... Import Analysis Services 9.0 Database

You might see the Project REAL recommendations regarding your different options under the "Three Ways to Interact With Analysis Services" section of: http://www.microsoft.com/technet/prodtechnol/sql/2005/realastd.mspx

|||I can bring it into VS.NET but the measures are not associated with any Data Source views. Any idea?|||

Hmm. Maybe the cube is processed via push-mode? But even then, I thought you still had to tie a measure to a column in the data source view. So you don't see any data source views in the project?

After you do the Import command I mentioned, look on disk and open up the .cube and .partitions file in Notepad and do a search for "select " (that's select <space>) and see if you can see any out-of-line bindings. That might be how they do it.