Search results for query: *

I have a script which uses transact sql with an access database. The script has stopped working online, and the host says the only change they have made is to upgrade to Windows 2003 SP1. It is definately the transact SQL which is causing the problem: I have just uploaded a test script which...

I've been trying to get full text search enabled on a SQL Server 2000 server. I've checked that Microsoft search is running (and I enabled Index server for good measure), but I cannot enable full text search. I managed to find one site with full instructions...

This is possibly a silly question! Is it possible to create an HTML form in such a way that it can be used as stationary in Outlook with all the form fields working. To make that clear: I currently create a form in HTML complete with roll-downs and inputs. The idea is that I will install this...

I need to get asp to create an MS Word doc (rather than a text file). I have got as far as instantiating the Word application object but I get a memory error whenever I try to create a document. Anyone done this? Any good sites I can look at for tips?

Hi We're trying to set up a demo server in our office which will allow clients to view test versions of their asp sites / intranets. Obviously since the machine is on our local network, security is paramount and different users need to be able to access different folders (we don't want clients...

Hi I'm posting this here as I can't think of where it should really be posted - I've also left a message in the asp forum. Anyway: I'm the webmistress (can you say that?) for a small but code heavy site that we need to move onto a new server at a new host (various problems). However, though...

Hi I'm posting this here as it's my favourite forum and I hope some of you can help me. I'm the webmistress (can you say that?) for a small but code heavy site that we need to move onto a new server at a new host (various problems). However, though the web connection appears to be fine in the...

This may be a strange question - we've had problems with AMD's reliablity with Windows in the past, but now the only host I can find for my dedicated web server only offers AMD Athlon chips (they'll be 750s so I guess that's a K7 and not an xp - couldn't find out more as AMD's site was down)...

Hi I've had an ongoing problem with my Win2000 web server for a while now. It's running IIS5 and SQL Server (which I initially thought was the problem but am almost sure now that the problem is in the Windows configuration). Anyway my problem is that after being online for a couple of days...

Hi I have an ongoing server configuration problem involving SQL Server (which helps itself to large amounts of memory). When the memory is used up and SQL Server starts paging to disk, it runs painfully slow - much much slower than my test server does. One difference between the test and the...

I have a Compaq web server that is currently running IIS5 (obviously) with SQL Server. I know that running SQL Server on the same machine as a web server is not ideal, but the site is still fairly small and the budget doesn't extend to 2 servers yet. Anyway when I restart the box everything...

I have a web server that is currently running IIS5 (obviously) with SQL Server. I know that running SQL Server on the same machine as a web server is not ideal, but the site is still fairly small and the budget doesn't extend to 2 servers yet. Anyway when I restart the box everything runs fine...

I'm running SQL Server on the same machine as my web server (IIS5/win2000 server), but when the site is live and the database is being accessed regularly it causes a substantial memory leak. I've eliminated all other processes, and tried simplifying all of my SQL (and I don't use any stored...

Hi I have a table - Subscribers - which contains 42000 entries, 30000 of which match a certain criteria. I want to select all these results in groups of 10000 (so that my scripts don't timeout). Obviously I can select TOP 10000, but how do I get the other 2 groups? I've added an identity...

Hi I have a table which contains a field that can be set to either a or b (it may be expanded in the future so it's not a bit field). I want to select the count of the occurances of each- eg. for this particular username there are 3 a's and 1 -in one SQL query b (currently I'm using 2). Can...

I feel like I should know how to do this, but: I have to write some sql to add an entry to a table. I want the sql to check first that the entry does not exist though and I cannot get this to work. This is the sql I've been using, but it doesn't work - can anyone tell me what I've missed (I...

This problem has been driving me mad for months: Everything on my computer is set to British English, including my SQL Server and the regional settings in Windows 2000 - all dates appear as dd/mm/yyyy Whenever I use "Date()" in VBscript though (this is in ASP running on IIS) I get an...

I have two related tables in a database. One stores the names and descriptions of various email lists people can subscribe to, and the other stores the email addresses. So that the system is fully flexible, there is a separate row in the second table for every email address (containing listname...

Hi I've been thrown in at the deep end with server configuration a bit, but I've got this far: I have IIS 5.0 running and need part of our site to be secure. I have a certificate from Verisign and have installed it - From the web site properties I can view the certificate and all seems fine...

I've been trying to retrieve files from a SQL server database (using ASP) having searched on a date field (generated by the database using GetDate). I know that SQL server should be able to convert a string to a date field with no problems, but I always get the error: resulting date out of...