Do all your base tables have clustered indexes?

Check your registration credentials.  If you have registered the server using a SQL user name and password, make sure the server is running in mixed mode (SQL Server and Windows)...

Excellent!  That is exactly what I was looking for. 

Thank you!

Ian

Is there any chance you have shadow copy running on the server?

http://www.microsoft.com/windowsserver2003/techinfo/overview/scr.mspx

Earlier versions of Crystal Reports (8.5) allowed you to build "libraries" that simplified database schema for users doing adhoc reporting.  As the administrator, you would control what and how much...

Thanks Mike. 

But it works using the same user and pass through query analyzer.  That's why I suspect it has to do with the connection.

Ian

Double check the (default) database name in the coldfusion administrator. 

Also, I've seen an issue in coldfusion MX where the connection gets stuck in the wrong database.  I didn't have...

Thanks again to all. 

Yes, Max() works fine.  Something like this:

(select CallTopic from CallLog where ID = (select max(id) from CallLog where....))

Also note, you still get the error...

Thanks to all for your replies. 

This all started when I had a rather large view that had a sub-query to return the top 1 as a column result.  I...

One trick I've used is save all the scripts in a folder and use the Windows Search "Containing Text" option.  As above; search for delete, truncate, drop, alter, etc.

Have you tried using the sp_change_users_login to see if there are orphaned users?  Also sp_validatelogins for the domain users.

Make sure you have a global catalog server set up at your domain.  It’s my understanding that it will provide authentication services for both domains.  I suspect SQL Server is...

For what it's worth, I started by making a copy of the table in question.  It exhibited the same problem.  I then added the clustered index to the new table...

Adding a clustered index immediately resolved the problem. 

It’s interesting that the problem only surfaced on this one of so many identical servers.  It’s nice to have a documented case...

Thanks to all for the comments and suggestions. 

My vb app is using oledb, not odbc.  I've found it to be the most reliable in any situation.  Not sure what...