There is not enough details about your network, but a VPN user would be connected to your internal network and would could be given local AD accounts to access the...

I agree, this will work out the answer.

I had a very similar issue and would suggest you look into this which fixed my issues. I was calling Stored Procedures in my SSRS reports and by adding...

Hmm, not had this issue and sounds very frustrating. This sounds like SPN/Kerberos related and I would keep looking at this area.

The fact it works on default and not...

I have no requirement to ever do this but we have stored credentials on some of our env so it doesn't care who logs in. I would set the...

We experienced this in 2005 because we had a domain policy which restricted users. Have you tried running it on the client as an admin?

edogg's solution is fine. It depends how many times you need to restore the backups. If its regular then you should schedule it.

If Network traffic is an issue...

Performance Point has already been pulled into Office so I wouldn't spent too much time or money on it. I would spend more time and money on the core...

If you must have it stored on the app machine, I would have the app work this out and then pass it into the stored procedure. You can then...

Hi, are you setting up the parameter properly so you are sending the correct value through to the SQL Parameter in the where clause? You could drop the value...

I found an article which refers to a schedule which is running very frequently and has a start date some time in the past.

Try putting the start date...

Thanks, will give that a go and take note of your comments.

Works a treat thanks.

My next problem is with an insert into a temp table. It doesn't like insert into #temp without the select.

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER procedure [dbo].[getbookings]

@datefrom...

No sorry, completely ignores it on both.

No idea, but I am curious. Why are you doing it this way?