This data

accountno transaction amount date

==========================================

A-123 Cr 4500 13-jan-08

E-23455 Cr 8000 13-hjuly-09 ===>actaul table

R-747 Dr 8900 02-apr-12

L-64646 Dr 9300 06-apr-12

Does not equal this data

a1223 chenn 5677 000 -950000(entire sum of 2008...

Table definition and sample data which fits your expected outcome?

How do you know its the same project as for as that data set is concerned everyone could be a different project or the same project

But based on the sample...

What is the logic behind removing the two rows?

No one will do anything until you provide us with consumable DDL, sample data, expected results and what you have used so far.

Again as with the other topics follow the...

How many topics do you need to start for the same question

http://www.sqlservercentral.com/Forums/Topic1332708-392-1.aspx

http://www.sqlservercentral.com/Forums/Topic1332029-392-1.aspx

http://www.sqlservercentral.com/Forums/Topic1332694-392-1.aspx

Keep everything in the same topic,

Do not start new topics for the same question, you get fragmented replies

SSRS is Windows based authentication only, you will need to use something like impersonation or custom authentication providers to do something like that.

Deploy all reports to a folder which is locked down so the end users cannot see the folder.

Then create a linked report to the primary report in a folder where...

Server wide DDL triggers, traces, extended events etc etc.

Depends what you want to track.

Please elaborate furthre for a more consise answer.

I would extract the dtsx files from the filesystem and load them into MSDB and change the job to point to the database instead of the fileserver. But thats...

Hi.

This is primarily an English speaking site.

I have done a Google translate and it seems like you are having errors with DTS in SQL 2000 when running as a job.

Can...

SSIS is not cluster aware.

Always save to MSDB and never to the file system, that way the packages move with the SQL service and dont stay on disk.

In the BINN folder is MsDTSSrv.ini.xml, open that in notepad and where it sales file system it should have storepath as somethng like ..\packages, that will tell you where the...

You would need something like AD Change Auditer from Quest to get that sort of information. http://www.quest.com/changeauditor/

There is no way in SQL or via AD that I am aware to...

error in the parameters used to drive the report, error in the data, error running the report, error creating the file, permission errors?

can you run the report manually for all...