No problem, happy to help.

The problem is with you DECLARE @CurrentDate as varchar statement...

I looked right past that before. When you declare it as a varchar for all intents it gets declared as...

Unless you can definitely order your data by something other than "that's the way it exists in the table currently", you are not going to be able to write an...

Yeah sorry, not enough coffee this mornign and I've been doing too much Front end work of late...

Replace string with Varchar(8000)

Try this. If you include the

DECLARE @CurrentDate as varchar

SET @CurrentDate = CONVERT(Varchar, GETDATE(), 103))

*/

CREATE PROCEDURE [dbo].[usp_CallStats]

@CurrentDate as Varchar

Declare @strSQL as String

As

@strSQL = 'COPY C:\SQLData\Templates\Sales.xls C:\SQLData\Exports\Sales-'...

Be very, very weary of this requirement. Saying you want this or that result because it come first is IMHO a very bad idea. Just because that's what...

You are quite right about there being nothing simple about that process.

I'd say one of the better resources you could have would be to take a look at the MS...

That looks like it should work, I'd just be cautious of the security context. Will this be executed from another application or by someone who is running it manually?

If...

There are a myriad of 3rd party tools from Idea (Diagnostic Manager), RedGate(Sql Response currently in beta), and Quest(Spotlight) all of which should have the functionality you are looking for....

Just out of curiosity, do you have auto-stats turned on? Is it not doing a good enough job for you?

You can see the following from BOL to get more...

My only recommendation as was stated above that depending on the data make use of pass-through queries for your data retrieval from an access front end. The problem with...

Thanks for the recommendation.

-Luke.

Gotta agree with Grant here. Get some CYA documentation and then just do your best to train them first for everyday occurrences, how to check logs, backups etc etc...

Like other posters I believe that if we were to expose the hidden networks, they would become less efficient for numerous reasons. Like a previous poster I feel certain...

The first thing I see in your execution plan is that you are doing a clustered index scan on the Modification table.

I'd take a look at which...