I assume that you have granted the report user execute permissions on the procedure. Then you need to setup the Linked Server to either use a specific user on...

I would recommend that you check out this article[/url] as well. It addresses several problems that I have seen on forums around triggers.

I think this will do what you want:

SELECT

O.OBJECTID,

O.PostCode

FROM

OBJECT AS O JOIN

PostCodeRange AS PCR ON

...

Cursors and looping are going to cause performance problems. If you cannot remove the cursors and looping you should look at how you are handling transactions. Are you...

What controls (table, list, textbox) are you using on the report?

Are you backing up directly to tape? Can you post the Backup command?

Are these data changes or schema changes?

In my experience the best way to handle this is to "split" the delimited list into a table and join to it. Check out this article[/url] on the most...

From BOL (bolding mine):

ALTER COLUMN

Specifies that the named column is to be changed or altered. ALTER COLUMN is not allowed if the compatibility level is 65...

Are the credentials used by SSRS the same as the ones you are using in SSMS?

Can you use OpenQuery in SSMS? The first error looks like Ad Hoc Distributed...

I'd recommend looking at the execution plan for the stored procedure and tuning it first. I'd also verify the statistics are up to date for the tables included in...

Please read this article[/url]. Then if you have specific questions post back here.

In your stored procedure you need to delete the child rows first (Honorar), then delete the parent row or rows (Vraboten). Something like this:

Begin Transaction

Delete

From

Honarar

Where

...

The "new" code with the file number removed should load all the files for the specified trace. On my laptop, which I reboot somewhat regularly, and does not have...

JJ,

The length of a post is not why I would skip one. It is the coherence and readability of a post that matters to me. I'll scroll through...