Just to throw in my 2 cents worth. Our server is a Dual 3Ghz with 2GB RAM. 

For the last few weeks we've been running out 900+ reports to PDF's via the...

I patch all our servers via Terminal Services session. Generally this is done during the day with a reboot performed as a scheduled task.

Haven't had any adverse problems yet.

I may have lead you down the garden path a bit here. Presuming your website is setup for Windows authentication only, then you can connect to SQL Server using the...

"So if a person is authorized access to my web page they are authorized to run any querries that exist in the web page... "

If the SQL Server and the...

What values do you get when you run,

SELECT TOP 1 P.RegionID, TD.SpecifiedSlump, TD.SpecifiedSecondSlump
FROM tblTruckDocket TD
LEFT JOIN tblPlant P ON TD.PlantID = P.PlantID

Then what results do you get if you...

Steve, piccy's don't work unless they're hosted somewhere.

Also, everthing I'm mentioning here is T-SQL based so therefore there is no application that is external to the database. This makes it very unlikely that things like broken connections...

1. In your current process, how do you determine how many rows to load into the cursor? You could perform a count using a similar query. Run the insert into...

This handy knowledgebase article should give you all the necessary details.

http://support.microsoft.com/default.aspx?scid=kb;en-us;263556&sd=tech

As per Books Online, you can use the EXECUTE option of the INSERT statement.

Now what are the odds of that. Exactly the same time...

Yes get rid of the cursor.

Also, don't use a # temporary table. Make it a permanent table in the database.

Using my technique the only transaction consistency you need to...

1) You'd be thinking of "SELECT <fields> INTO <new table name> FROM <table>"

2) You can use the ALTER TABLE command to disable triggers. Check Books Online for syntax and specifically...

Ok, you're forgiven because you've only just started with SQL Server

Using the sa account to connect to SQL Server is a BIG...

It sounds a lot like the functionality provided by ASPMaker.Net

Have you looked at this application? Basically you provide it with a database connection and it allows to specify what and...