Recent content by DaveJunior

Just had a problem this morning on our intranet. One of the files standard to the frameset we use for ALL sites was being served by the web server as a 404. I looked at the server and the file was there and could be opened but not viewed. After pausing over this for a moment, I tried a re-start...

Has anyone else got any ideas about this? It seems to be getting more frequent at the moment. I also ran a full virus check yesterday and nothing came up.

Claudek, What do you mean by "monitored your IIS" and I do not know what NIC is. I am not the adminstrator of the server, just trying to find answers in his absence. Have you got any suggestions for diagnostic software that can check for errors on the server? cheers, Dave

We are running our intranet on a Windows 2000 Advanced server and are having a few problems... Under varying circumstances (that I cannot track down) the server stops serving pages and the browsers just hang. When looking at performance monitor, there are a few things to note when this occurs...

I want a function/sub in my global.asa file that opens a connection to a database using a secure connection. I have written the function but whenever I try to use it in an ASP page it says Variable is undefined: 'OpenConnection'. I have <% OPTION EXPLICIT %> at the top of each of my ASP pages...

Hi, I am a quite new at SQL and wondered if someone could give me a hand... I am trying to pass the table name that I am searching through into a stored procedure as a variable however it gives me the error message: &quot;The variable name '@TheTable' has already been declared. Variable names...

You could have the page running constantly but only doing the ASP work at (or just after) 12... That could by either checking the date and refreshing the page every 5 mins or it could be done by refreshing the page at 12. Hope this may be of use.

I have to write an audit trail for one of my tables. Some of the fields are text fields and it isn't letting me do the audit trail - it keeps on giving me the error message: Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables. Any ideas as I cannot find anything out...

Excellent - Thank you

That works great for any view that I create on the server as DBO, however, I also have some views that were created through ADODB in ASP. These have an owner of [NT AUTHORITY\ANONYMOUS LOGON] and I cannot reference them in any of the following ways: sp_helptext myView sp_helptext [NT...

I am an ASP programmer and need to grab the SQL code for a view within a database. Can anyone tell me if this is even possible or better still, how to do it. cheers.