Hi,

As these are non - critical tables I can afford to delete the table and re-script it and then run my DTS packages to populate the table.

My concern was why...

Unfortunately the table has now been dropped!! So unable to test, hopefully this will work ok tomorrow!! If not, will indeed try this.

Table now re-created, just importing the data via...

Hi all,

OK, sorted it out!

You can do the following for INSERT / UPDATE & DELETE triggers to maintain identical data between two tables!

*** INSERT TRIGGER ***

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER...

If I do the following it works perfect on an INSERT.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[TR_Insert_tblSymbolTrackingOld] ON [dbo].[tblSymbolTrackingOld]

FOR INSERT

AS

BEGIN

SET NOCOUNT ON;

SET IDENTITY_INSERT [dbname].[dbo].[tblSymbolTracking] ON;

DECLARE @symbol_id int;

DECLARE @company nvarchar(10);

DECLARE...

If I remove this portion:

SET IDENTITY_INSERT ON [dbo].[tblSymbolTracking] ON;

GO

I get a warning:

A explicit value for the identity column in table ... can only be specified whena column is used...

It worked perfect thank you all!

Great stuff...

Mike

🙂

I got you now, LOL!!

I have now modified my tblPage to include a keyword field ntext(), added the words in here also as well as maintaining a unique list of...

Hi Terry,

I have these triggers on by customer table based upon what people type uin to correctly format the data, it may help you!

INSERT

CREATE TRIGGER TR_Insert_tblAddress ON dbo.tblAddress

   FOR INSERT

     ...

Hi Christoper,

No problem what so ever, I probably explained myself badly!

I have read Anders reply many times and still trying to get a picture of how it will work!!

Scenario

If...

In this example I have 1 x url http://www.anywebsite.com and on that page it has two words, 'hello' and 'goodbye'

If I do a SQL query for both words i.e....

Thanks tried that, still looks like a logical OR!

Beginning to think I'm going about this the wrong way!

Word table is approx 6000, occurrence is approx 35,000

Hi again,

I managed to get it to work and execute fine now, however, don't you just hate it when somebody says that!

exec usp_SimpleSearchEngine @xmlKeywords