I am having the same issue that started last week. If I order by sAMAccountName, sn or uSNCreated the query fails after retrieving 19,901 records, yet when I order by...

Ross McMicken (3/18/2013)In a perfect world, that would be true. Unfortunately, many of us work with systems that are rewrites of rebuilds of something that was converted from a mainframe...

In addition to the earlier suggestions made, I played around with searching other data types as well:

Declare @keytosearch varchar(max), @numtosearch varchar(max), @datetosearch varchar(25), @Database_Selected varchar(50)

set @keytosearch = null

set @numtosearch =...

Yes, unfortunately, it does have db_owner rights. As the application is a...

Thank you for this thread...I have been dealing with this problem for years without resolution. Just to make sure I understand the gist of the problem:

1. The log...