The trick is: you need to drag the pane around to whichever corner you want to dock and you will see where is dockable when you drag it around.:-D

I just found the trick, the designer is really naughty on this.

math martinez (2/15/2013)

---

Yeah ur right you need a front end, i already encounter what you need to do and me i used vb.net. The flow of my application is this...

I know how to create the csv and send it as attachment using the sp mentioned above, I am just worrying if there might be any privilege restriction

Thank you, that's the point

I found the cause: I have another debugging process running, once that one stops, this one works.

Thank you all for the replies

Problem identified, removing prefix in FROM AOR.[dbo].[fnGetAllClassificationRanking]() c resolves the issue

Thank you, I will try to fix it myself

If you don't mind, here is the sp, thank you very much.

USE [Pergamum]

GO

/****** Object: StoredProcedure [dbo].[spGetDeviationReportNew2] Script Date: 11/06/2012 09:54:34 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- Stored...

Goodness me! Thank you so much for so detailed reply.

I changed varchar to nvarchar for @sql and @due, it throws me more errors:

Msg 102, Level 15, State 1, Line 1

Incorrect...

GSquared (11/6/2012)

---

You'd have to define the variable inside the scope of the Exec command in order to do it that way. You're better off using sp_executeSQL instead.

EXEC sp_executeSQL 'Select...

I fixed the problem, caused by a missing privilege grant on one table that the sp is refering to.

Thanks for all viewers.

Here is my new finding:

I started profiler, I got different trace for

EXECUTE AS user = 'testbns\AOR'

EXECUTE spDashboardByCategoryID 1

REVERT

GO

EXECUTE spDashboardByCategoryID 1

Please see the attached screenshot: the top line and the...

Got a new finding here:

I tried to run the sp as the identity:

EXECUTE AS user = 'testbns\AOR'

EXECUTE spDashboardByCategoryID 1

REVERT

It DOESN'T return any data and no any error message.

I tried to...