Recent content by apcapc

Please can someone advise what this actually means Event Type: Warning Event Source: W3SVC Event Category: None Event ID: 1013 Date: 19/05/2008 Time: 11:42:49 User: N/A Computer: OXFORD12 Description: A process serving application pool 'AppPool #1' exceeded time limits during shut down. The...

Our web developer is having problems setting up virtual folders on her local machine (laptop). She is pointing to a share on our NAS box - This server is not running IIS. Our web server can connect to this virtual folder perfectly fine but the laptop cant. The server is running IIS 6.0 and her...

We received a number of alerts yesterday evening for all four of our switches (example below) Is anyone able to advise what might be causing these to be sent? From device 3Com SuperStack 3 (10.23.155.22): Authentication Failure Many Thanks Andy

Thanks for that but it gives me exactly the same message as before, my view field is actually called customer_lastinvoicedate Any other suggestions? Please

USE customer IN 0 SHARED USE invoiceheader IN 0 SHARED If I open the two views with the above code and then try to run the below code I get the error message at the bottom Any advice would be welcome replace customer_lastinvoicedate WITH invoiceheader_invoicedate all Variable...

I can select from a view when I have it open in my data session but what I want to do is write a program that can be reused again and again. If I was to do it with a table I would write the following use c:\mytable.dbf in o shared but I can't do this with a view can I? All I basically want...

Apologies, still getting used to Tek Tips layout

Thanks for that, I can select from a view when I have it open in my data session but what I want to do is write a program that can be reused again and again. If I was to do it with a table I would write the following use c:\mytable.dbf in o shared but I can't do this with a view can I? All I...

Does anyone know if you can select views in a program as you would tables and if so what the correct code to use would be Many Thanks Andy

I have made progress with this in terms of setting up which fields are updateable but I am still unable to get this working, does anyone know anything about updating remote access tables through views? If you could point me in the right direction at all it would be hugely appreciated Many...

I have two access tables that I am trying to update through FoxPro views but the changes I make in the view do not update the base tables Please could anyone who has encountered this problem advise what they did in order to get past it Many Thanks Andy

I am fairly new to SQL Server and have been given the job to import our Foxpro database into SQL Server 2000, I have been using the DTS and importing the data fine but have only just realised that the tables I have been creating have not copied the indexes from FoxPro, please could anyone who...

I have scheduled a DTS Package to run as a job overnight but I get the following e-mail saying the job has failed with no indication of why, please can anyone advise what they think could be wrong Many Thanks Andy JOB RUN: 'SAS Live Import - Administrator' was run on 9/22/2004 at 7:00:00 PM...

I am new to SQL server database admin so apologies if this is a stupid question but when importing a FoxPro database into SQL do you lose all indexes? Many Thanks Andy

Can someone please advise what dates are supported by smalldatetime Thanks Andy