Try changing this to:

DECLARE

@sqlQuery NVARCHAR(MAX),

@finalQuery NVARCHAR(MAX)

DECLARE @q CHAR(1) = ''''

or

DECLARE

@sqlQuery NVARCHAR(MAX),

@finalQuery NVARCHAR(MAX),

@q CHAR(1)

SET @q = ''''

The trace we ran confirmed that the code that was executing was not what we expected to be executing. Further analysis found (quite shockingly) human/process err.

The check of "Is...

Lowell (6/24/2013)

---

does the proc insert potentially multiple rows?

is the proc generating a unique key value? a bad join in a SELECT statement could pass the not exists, but ...

Korn shell?  On windows?  That's being a glutton for punishment.

FYI - If you are using app role security with reporting services, you need to use a custom data extension on the reporting server.  I've got some sample C#...

There is a way to reset permissions (in 2005) sp_unsetapprole.  It does take some careful coding to make sure it is always called before returning connections to the app_pool, but it...

Why would it use the ASP.NET acount for non-local browser connections, and correct windows identity information on local  browser connections?  The web site is set to not allow anonymous authentication,...

I'm not passing in login information.  I'm using integrated windows security.  (Which worked fine in RS2K in similar scenarios)

I tried all the things that you suggested with no improvement.

 

One new thing I notice is that the log files record the following on each failed attempt to pull a...

I'm doing them both because I don't know any better.  What is a better solution?  Only reorganize?  Reorganize daily and reindex once a month?

So if C is what the explanation says, why isn't it the correct answer?

I enjoyed this article a lot, because I happen to be getting ready to present a 2-hour bit to a group of 20 enterprise DBAs on exactly this topic.  I...

This is probably the most ambiguous question I've seen in QOD for a while.  It makes the COMPLETELY INACCURATE assumption that a RAID level is always (or even morst of...

Is Snapshot Isolation turn on in your database?  If so, are you actually using it, or did you just turn it on because it is a new feature?

Using Snapshot isolation...

Firstly, Microsoft DOES release gobs of high quality code, and has for years.  Have you missed the Starter Kits that they have been publishing for years?  So, the point...