Do not trust any rowcount other than a Select Count(*) From table as most are based on the table statistics for performance of reporting. If your statistics are stale well...

What metrics are you basing this decision on?  CPU utilization? Disk Queuing? Why are you targeting the disk sub-system as the bottleneck?

You mentioned 80% CPU utilization, was that SQL Server...

Please include all the error message you receive besides the one in the initial post noted below.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).

Server: Msg 11, Level 16, State 1, Line 0

General network...

During the cursor test the length of @str1 and when it reaches a threshhold (7500 Bytes or so) complete the create table command and execute the statement. Then continue to build...

So you are saying the bcp worked from the asp page before Friday? Please post the bcp command used from the command line and the asp page!

I would not be so hasty to assume this is a network issue! You mention that re-starting the SQL Server corrects the problem!!!!  You mentioned backups as well, and this...

The application may be using connection pooling of some sorts.  Is this a fat client, windows service, or web application running on IIS?

Create a base table when the length reaches a threshhold and then use alter table statements to complete the task.

Exec 'STRING TO CREATE TABLE'

Exec 'STRING TO ALTER TABLE AND ADD...

Ok, please be more specific what you are trying to do. What are you trying to execute against the SQL Server? A stored Procedure? In-line SQL, a web page from...

"WMI" is the way to go.

Right, what I was getting at was ODBC is generating this error because the procedure is returning the truncation when the first paramerter is passed. So, is the text being passed...

Are the paths to the data and log for the db different from the primary to the fail over server?

The problem is probably in the procedure 'sp_update_photo' that you are calling!

All you should need is:

Select t1.location, t2.specs

From dbo.table1 t1

Inner Join dbo.table2 t2

On t1.id = t2.id

Or this:

Select t1.location, t2.specs

From dbo.table1 t1

Left Outer Join dbo.table2 t2

On t1.id = t2.id

The first query will only...

Has this connection ever worked? Is the SQL Server a default or named instance? What type of conection are you using a DNS or DNSless connection. This looks like a...