Thanks Roy and Florian.

Roy, I will try to look into the PowerShell.

Florian, we are trying to have any other simple solution rather than using Service Broker. The usage of...

OK Thanks for the information.

Thanks Abhijit,.. I will check the rules once.

Thanks vikas.

Its working fine..

Hi Elliot,

Thanks for reply.

For the previous data, we can maintain another table like an audittrail and it stores the data of all the previous records.

Dependent fields can be modified internally...

Thanks Jack and Monster 🙂

Hi jeff,

We can do with distributed Partitioned Views, if we dont find any other solution(for previous one).

But I guess in this scenario, SSIS will become over head.

Thanks

Deepak

Hi Jeff,

To generate a SSRS Report, i cant call a SSIS package first and then inserting the data into a table,then fetch the data from that table.

And my activity is...

Thanks for the Reply Paul.

We had a thought about SSIS packages.But that would hamper my performance.

If we are not going to combine the output, multiple resultsets will be generated.

.Net Front End can combine the Multiple record sets and show the output in the one output.

But...

Hi Paul,

I have just given this name 'sp_GetClientLists' for example.

I cant post my the actual names of databases,tables and SP names.

Thanks

Deepak

Thanks for the Replies.

We need to access same SP on different databases (which are on different servers ) using it on the Linked Servers.

we can do it like this:

INSERT INTO...

Thanks,

We have got another solution and we have implemented it already.