It's not a guaranteed solution (ie. you can't guarantee it will hit ALL SP's), but you could use profiler to record the activity on the live DB for a period...

Would the easiest solution not be to do a DISTINCT on the original query and then sum as usual?

I think Erik is right, this is probably due to the fact that the IIS service is running under a user account which doesn't have privelages on the DB.  Try...

Creating a load of jobs may be overkill, depending on how many you create it may be best to log to a table the SP that needs to be run,...

We have a system here which requires that jobs be performed periodically.  I created a scheduling engine and a web interface for it which allows multiple schedules to be defined. ...

Wargames has to win over The Matrix, simply becuase The Matrix is way too cool to be classed as geeky

Tron will always hold...

You say that you would like to 'separate some Databases into the new instance'.  This implies that each instance of your applications accesses a different database on this single server. ...

Might also be worth taking a look at the actual execution plan to see if you can identify any bottlenecks there.

Tony

If this were purely a locking issue, then surely the queries would return in sequence, based on the locking order.  You don't say whether all the queries are taking the...

Razvan raises a good point, and one that reinforces the suggestion that a data layer is a good idea.  It's much easier to prevent SQL Injection and the like in...

The trailing zero's get truncated (or rather not displayed) by VB as it does not see them as significant figures.  When you look at the definition for the primitive data...

Surely you could return the field formatted as a string but use the original numeric in the ORDER BY?  Or is the sorting being performed client side?  In which case...

I've also worked on a similar system recently.  I implemented a mail queue in a sql server table then used a stored procedure with a cursor to iterate through the...

As a developer I understand their enthusiasm, and don't get me wrong, I wasn't saying the .NET solution was the wrong one, just throwing up options.

In your earlier posts you...

Barton

I'm not sure exactly what you mean by 'flexibility in dealing with nulls'? I think C#'s IsDBNull method is pretty much as close as a language (strongly typed or otherwise)...