I know, I know, using client variables is not the best practice ever realy but we are trapped by third party application and they are married to them.
We recently saw this happening on our cfmx server environment -------------------- Operation failed on the data source named "ClientVar". Reason of failure "[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'CDATA'." -------------------- Now our systems guy thinks that it had to do with the fact that there were 25000 records that is until he saw production and noted that there were over 100000 records in the clientVars database. Any thoughts on workarounds or means to make this better. or what may be causing it. Thanks in advance Joshua O'Connor-Rose -All is Good ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227726 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
