Welcome to WebmasterWorld Guest from 126.96.36.199
Googlebot will still keep trying to spider these urls - sometimes for over ayear - but with decreasing frequency. Addtionally, if you want to see those 404 or 410 status urls completely dropped from search results quiuckly, you can easily request that and have it happen. Not so with a 500 error.
'This code assumes your SQL connection is open and the
'object is named "objado". You also need to have page buffering enabled in the IIS Manager or at the top of the page do a response.buffer=true
set rs = objado.execute(insert-sql-statement-here)
if rs.eof or rs.bof then
response.status = "404 - Page not found" 'or 410 - Gone your choice
response.write "insert your friendly HTML error code here"
'clean up open object references
set rs = nothing
set objado = nothing
'do your normal recordset processing here