Only 1 record written to temptable at a time.

Its written to meet the possibility of having several inserts made to temptable. Thus the ID is saved so that when propagation is done the record with the ID is...

USE [SkiesHO]

GO

/****** Object: Trigger [dbo].[ADDINSERTEMP] Script Date: 06/24/2011 09:43:15 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE TRIGGER [dbo].[ADDINSERTEMP] ON [dbo].[Temptable]

FOR INSERT, UPDATE

AS

declare @strCon varchar(25)

declare @NewMDDate as smalldatetime

declare...

Yes this is almost the entire code.

- The trigger is in the table TempTable.

- First select is to retieved the ID of the 1st record in the temptable.

- 2nd is...

Hi Lynn, thank for your attention.

Pasted the code

set @ID = (SELECT TOP 1 ID FROM TempTable WHERE Name = 'Products')

set @NewMD = (SELECT TOP 1 NewCol2 FROM TempTable WHERE Name...

Thank you guys for your tips. Will look into them and hope we can come up with one that meets our need.

We tried to get to the DB by way of the security suggestion but to no avail. We then installed a version of 2000 and trtied to access the db....

What did u mean by " or you would need to make sure the SQL 2008 database service account has read/write access to the current folder. There is a group...

Hi, thanks for giving my issue your attention.

I get an error 5 or not have the proper security when I tried to attach or restore, not sure which is...