Could you post the view create statement and the create statements for your indexes?

But just for my own edification, how long do you expect the server to take to deliver the...

The string you are building to execute has a variable in it.  Proc variable aren't available to the executing string so I don't think this method will work.

Why worry about...

declare @x int

declare @hr int

declare @min-2 int

select @x = datediff(mi,'2005-05-16 15:02:33.347', '2005-05-17 09:23:30.813')

select @hr = @x / 60

select @min-2 = @x % 60

select @hr as...

Hmmmm..

The code I sent worked on my system.  sp_spaceused with no arguments only returns one result set for me.     

Well, that sorta puts the whole thing into 'Let's try this and see ...' mode.  I'd have to admit that I haven't seen this before.

I'd add the ROWTERMINATOR = '\r\n' and...

So, if you look at that first row in a hex editor it ends in '0D0A'?

That is puzzling.  Does it behave the same way if you use the bcp command...

Hmmmmm...

I wouldn't think that the column delimiters mattered as much as the row delimiter.  Does the row that has the column headings end with a '\r\n'?

The only time I've seen this happen is when the row with the column headings has a row delimiter that doesn't match the row delimiter in the format file.  It...

The result set should only have one format, depending on the object type you pass into sp_spaceused.  This works for a utility I used in a previous life.  The #tdb...

Option 1.  Normalize the tables.  It's more flexible, more true to the relational model, easier to enforce integrity upon, and will save you a lot of work if the business...

You might try running profiler to see what SQL the server is trying to run when EM closes.  Are you running the EM from your desktop or from the server? ...

Is there anything in the event log of the server or the error log of the SQL Server that might give a clue?  Can you check the properties of the...

There's a generic parsing script in the scripts archive on this site that could be modified to fit your need.

http://www.sqlservercentral.com/scripts/contributions/1445.asp

If you have the option of bringing this data in...

why not

    GST =(Sum(Fields!Valuation.Value * 65/100) * 125/1000)

OK, instead of guessing, let's isolate the problem.

Get the execution plan for the proc and for each of the component queries.

Put some prints in the proc to get the wall...