Barry, my apologies for not providing more details. I meant to have a more general question, since I feel this is more of an XML issue than a SQL...

My job at present is very feast-or-famine; I've worked for a month or two coding furiously, then had nothing new to do in the way of coding for a similarly...

Actually, it's somewhat exposed to the outside world. It's cloud-hosted, and several other clients are on the same server instance as us. If we choose to upload data...

Ah, I understand now, Perry. The application is certainly a Windows-based application, then. There is no text validation present that I can discern, though; all special characters that...

I'm not sure what the distinction is there, Perry; I'm assuming Windows form would mean something coded in a language such as Java, C#, C++, etc.? Either way, I...

Thanks, Gail, both for correcting my misunderstanding on spotting SQL injections and for verifying my concerns about the new problems I found. Our business will probably veer away from...

Hrm. Upon looking further into their coding, I've stumbled upon this:

SET NOCOUNT ON;

DECLARE @whereClause2 nvarchar(1000)

SET @whereClause2 = @whereClause

set @whereClause2 = ISNULL(@whereClause2,'')

declare

Thank you for the replies.

Lynn, the software vendor does not give us the option to set up the application in our own environment. It's a cloud-hosted SQL server with...

Not sure when the thread starter will be back to the thread, but it seems that the link is messed up somehow; it points to Flickr, but appends SSC's URL...

Hrm. Seems like the previous solution may or may not have worked. I'm still getting reports of connection timeouts, but the majority users aren't saving the details of...

Excellent suggestion, Stephanie. Your comment reminded me to check the ODBC administration settings, and I discovered that connection pooling was on for SQL Server, as I'd thought; however, it...

Hm. I'd considered that possibility previously; searches I've done suggested that a look at the NIC card and the general networking setup could be necessary also. Would these...