I myself feel the same way. I have been at this for over 15 years now…I have seen the bleeding edge and the not so bleeding edge of technology….I...

Have you tried:

http://www.fileviewer.com/index.html

HTH

Marty

I can send you an Access Db with all the info you need to connect.

Can you provide me with your connect statement?

Marty

A little more info on your problem....

Have you tried Lumigent Technologies - Log Explorer?

Have you tried like 'GNavn'

Have you tried the sp_send_cdosysmail?

CREATE PROCEDURE dbo.sp_send_cdosysmail

@From varchar(100) ,

@To varchar(100) ,

@cc varchar(100),

@Subject varchar(100)=" ",

@Body varchar(4000) =" ",

@BodyType varchar(100) =" ", --HTMLBODY or TEXTBODY

@MailServerName varchar(100)

AS

Declare @iMsg int

Declare @hr int

Declare @source varchar(255)

Declare...

Have you tried using SQL Profiler to capture and analyze your queries or stored procedures?

Insert into TabD (site_name,site_id,time_id,min value  ) Values (TabA.Site_Name,??,??,??)

Something like this could be written

Create Trigger tabcheck

on Tab C

For Insert

AS

Select TabA.Site_Name,TabC.Site_Name from TabA,TabC

If TabA.Site_Name=TabC.Site_Name then

Insert into TabD (site_name) Values (TabA.Site_Name)

Print'TabD has been Updated'

Something like

CREATE TRIGGER trigger_name

AFTER INSERT

    ON TABLE

    [ FOR EACH ROW ]

DECLARE

    -- variable declarations

BEGIN

    -- trigger code

EXCEPTION

    WHEN ...

    -- exception handling

END;

Hope this helps

Marty

 There are multiple ways of accomplishing this. One would be to create a trigger after insert of Tab C which could compare the vaules of Tab A then insert the ID into...

I found a workaround for my problem and it works great.

In case you needed answers to his questions:

Can your task be scheduled within the SQL Server job system? NO

Do you...

Have you tried to shorten the space between your '  ' ?

It may seem weird but sometimes the extra tab sends the flow off.