The one which I attached above is an individual report. I did have installed VS 2010 shell and able to view the datasets and upon trying to view the report...

Hi,

Many thanks for your response. Attached is one of the reports (RDL file) that fails..

Can you please take a look and respond if you notice any errors?

Cheers

Hi,

Didnt exactly get 🙁 am very very poor in programming and doing this for the first time...

Can you please put up some logic and share it here 🙂

Thank you for...

Hi,

I just edited the job and ran this below command:

SELECT * INTO trace_table1 FROM ::fn_trace_gettable('C:\PWB_Test\T.trc', 1)

The job went fine....and also deleted my T.trc file from folder...

But how do I do...

Hi there,

Yes there are files like 'T.trc', 'T_1.trc' and so on...

But when my job step 2 which is to load the data into the table is run using any of...

Hi there,

Thanks for your response, below is the script generated from Profiler and I've been using this which generates a rollover file like 'T.trc', 'T_1.trc','T_2.trc' and so on..

I've not included...

Hi,

Thank you so much for your response... I'm able to set the trace and run and it does creates multiple files but I'm unable to load all of the .trc...

Had checked the rollover option as it is by default but no use...job still fails..

Ok if I have to run this 24/7 and need to keep the data for not...

Can you please help me to edit this:

-------------------------------------------------------------------------------------------------------------------------

USE [Audit]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE proc [dbo].[TraceScript]

@DBNamesysname = null

as

set nocount on

declare @rc int

declare @TraceID int

declare @maxfilesize bigint

set @maxfilesize = 5

exec...

Message

Executed as user: NT AUTHORITY\SYSTEM. Cannot create a new trace because the trace file path is found in the existing traces. [SQLSTATE 42000] (Error 19067). The step failed.

Fails with...

Hi All,

I'm new to this forum and want to learn and develop SQL Server 2008 R2 Reporting services which is one of the utmost requirement to sustain my job :(......