For Audit Table we store table Name to identify each table and we will delete older data for one day.

Audit Table will be only one and it will be deleted for older data of one day back.

This option will not be viable for us, As our data is already there inside the SQL server.

Actually I am working over Drilling Software which insert 1 row a into a table after five second. We Pass Some columns as parameter to a SP for Each row....

It is the business requirement to call the SPs against each Row. I am thinking to Call After trigger on each row insert and implement Service Broker Queue to call...

Thanks This help me.

I used WMI Event watcher Task available in SSIS with infinite loop.

Explained well in link below.

http://microsoft-ssis.blogspot.com/2010/12/continuously-watching-files-with-wmi.html

Thanks for your help, your idea really work for me, I further change the query and get my required result.

Declare @SaoHeader AS Table (SAOID int,SAODate DateTime,City varchar(50),State varchar(50))

insert into @SaoHeader(SAOID...

To implement a new Fact table, You need to maintain loading process twice, I think you should attach new dimensions with existing fact Table if you convince your Lead other...

Actually, when we define primary key on a table, data is stored in the physical order of primary key, We can't have two physical order in a table. This is...

Is Tabular model is supported in SSAS 2008?

Is there any way to bring whole cube in memory.

no,

would you please give me any clue of merge.

Backup and restore will not work b/c when I will shift DB at new server then I have to stop users activities at server1 and shift it to Server2.