Since y'all have been immensely helpful (and my most grateful thanks) a couple times recently, I will try sending my current Biggest Problem to the list.
I am publicly hosted. There is a query-timeout value which a number of my on-site pages(reports) are now exceeding. To see if I could bring the time down, I added some indexes to the table, which has 50,000 records, and attempted to delete a bunch of old records to make the table smaller. If I run a regular delete statement, the query times out. So I can't even delete records. When I tried to make it a stored procedure, it chronically error'd, even when my server rep himself attempted to make it (everyone assures me this is 'easy' and nobody can do it, why is that...); when I implemented a code suggestion from this list, the system then told me my table didn't exist. My rep says this means I don't 'own' the table, but I'm using owner "dbo" value in the SP and do have the DS name, which I was told is all proper. So I have this table and I can't do a damned thing with it. I can't delete records to make it smaller; I can't run reports on it because apparently it is too big, if even the simplest delete statement times out. Alleged experts can't get get a 6-word query to work as a SP on it. And I have customers (college instructors) ranting because they can't get reports on what their students are doing. I have no idea what to do at this point. Any suggestions would be greatly appreciated. Palyne ~~~~~~~~~~~~~~~~~~~~~~~~~~~ Palyne Gaenir Science Horizon Web Media www.sciencehorizon.com [EMAIL PROTECTED] cel 918.533.3765 tf 877.316.0763 ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
