I found where the bottleneck is:

My JOIN with [CreditSpreadCurve] view.

One of the tables there is 63 million records.

I figured it out.

Apparently my Total column, the one I was trying to change, was binded with a previous column.

So when I changed the width for that previous column my...

I changed "H:\" drive to "\\tocs2001\Ope$\"

and it worked;

So it looks like SQL Server cannot properly see mapped drives.

I did a test on my local SQL Server instance.

I changed MSSQLSERVER account to my domain account that has "WRITE" access to

the network "H:\BK" folder.

So I run this script:

BACKUP DATABASE...

Just some clarification.

'NA\TRMR' account has all the roles: sysadmin,securityadmin,etc.

Scenario 1

----------

I am sysadmin. When I run backup script with Windows Authentication:

--------

It...

OK.

After some research it looks like

it only can be implemented if you Export to XML and then create XSLT file

and specify it in

Report Properties/

Data Output/

Data Transform:/

See this article...

I tried it with Sub Reports

and it's the same problem.

Regardless how you name your subreports, tables

you still end up with "Sheet2", Sheet2".

But I would like to control those Sheet names.

unknown_sql,

We're on SSRS 2005.

Do you think we still can try this approach?

Nate, Thank you for a quick response.

I thought about this option.

But then in your output Excel your Sheets

would be named "Sheet1", "Sheet2",etc.

There is no control over naming. Users will not...

Based on

Hierarchy parameter a list of

Business Entity gets refreshed.

But the same process is in all those reports.

And more to that.

Even when you select a Date from Calendar

it takes...

I found a simpler solution.

I just loaded trace file into multiple tables:

TraceResults_1

TraceResults_2

TraceResults_3

TraceResults_4

TraceResults_5

etc.

broken by StartTime values.

INSERT INTO TraceResults_1

(TextData, Duration, Reads, Writes, CPU, StartTime)

SELECT TextData, Duration/1000, Reads, Writes, CPU, StartTime

FROM fn_trace_gettable('E:\20090505-203736.trc',1)

WHERE StartTime...

I have a physical table:

ReportServer.Catalaog

ReportServer.ExecutionLog

But I'd like to display the IDENTITY RowNumber.

You can do it only using "SELECT INTO".

So I don't have a choice. I have to INSERT it into...

I found this topic on MSDN:

http://msdn.microsoft.com/en-us/library/ms189034.aspx

(but it's about SQL Server 2008 so it might not work in 2005)

It says:

...meets or exceeds the specified maximum file size, you are...

Gail! Help!

has been running for 8.5 min and

set transaction isolation level

read uncommitted

begin transaction

select count(*)...

It looks like it's a heavily used OLTP system.

But what exactly is generating so much SQL we don't know.

They suspect it's some custom services+.NET application.

But I need to find out...