using your code:

declare @StoreKey int

select @StoreKey = 1

IF ((exists (select * from SYCFStore s WHERE s.Store_Key = @StoreKey AND s.Store_Inactive_Flag = 'N') AND

(exists (select...

BTW...

SYCFStore can have many records, SYCFSystem can have only one record.

ok...the SQL above is used as a filter for building the menu for our software

and if the result of the query is 'Y', the menu is filtered out and...

These tables are not related and contain no foreign keys to each other.

Anyone else have anything to say here?

Well, I forgot to mention that we are installing SQL2005Express on our client's systems.

DID YOU EVER THINK OF THAT?

I was asking about the security context for Agent, do you have...

I do not intend to allow the deletion to occur because of the child records.

I just want to show the custom error message.

Seems I'm getting error code: -2146824580

"Parameter object is improperly defined.

Inconsistent or incomplete information was provided."

Goo call, John, it looks like the indexes were the culprit. We reworked

the SP to not use in-memory temp tables, too.

Check BOL for BCP perhaps?

Don't really know but will check it out.

OK, I have found the problem as to why it doesn't work. I found an old type lib file

on my system that was for version 7. SQL2K uses version...

D7 and SQL2000 SP4. I have a vbs script that works flawlessly.

I just can't get this to work correctly usign Delphi because we have a utility to script out our...

Problem with using sp_helptext is that it will not get the full text of large procedures. I think the limit is 8K.

The Script method is the same thing used by...