HTH .

Yup : DDL = data definition language.

Sounds like we may use this code for the same purpuse .

USE SSC

GO

CREATE TABLE #Results (txtResult varchar(2000) NULL)

INSERT INTO #Results (txtResult)

EXEC master.dbo.xp_cmdshell 'DIR D:\*_BACKUP_*.*'

SELECT...

I'm not sure I'm following and I don't want to guess at this one.

Can you post the tables ddl for the 2 tables concerned, some sample data from both tables...

I recall the best way to solve this one as I've never worked with server generated identities (other than identity column).

I'll see what other dbas have to offer.

PS May I...

This is the main problem

Where exists(Select * From apvend   Where fvtype = 'MD')

It will always return true or always return false because fvtype = 'MD' will also be true...

I would assume that more than one row are being inserted... causing the error. Can you verify that?

The case statement should look like this :

CASE WHEN Col001 NOT LIKE 'NULL' THEN[Col001] ELSE NULL END,

But it can be shortened up with this :

NULLIF(Col001, 'NULL') to get the...

This is one of the dirtiest trick in the book, but it looks like it was made for this problem :

PS This solution cannot safely be implemented on the...

The only solution I can give is to make sure that the query returns as little rows as humanly possible.  Try converting the left joins to inner join where possible.

Can...

Too many disks IO on the server

Too many indexes to reorder

Not enough memory

Temdb too small or on a slow disk (or the same disk as the insert and transaction log).

That's...

I'm working as a freelancer as well.  So I would assume I would be at the low end of the scale on that point (only 45 can $/ hour).  But...

I think we'll need the actual problem to help you.

In the you presented you just don't need the trigger.  When changing the name of the food, you should also change...

Thanx for the details.  I don't have anything else to offer to you.

One last thing I may propose is to make sure that "everyone" has "full control" on the directory...

This is where you can see the cached plans :

Select * from master.dbo.syscacheobjects

As to know when they are corrupted, I would clear the cache, run the proc in question...