Thanks for the links.  Sorry about the lack of detail.  I am on the phone end of this error and have no access yet to get more information.

When I try to execute SQL code of not (value) or not @variable, I get syntax errors.  All our routines check for @bbit = 0 for false  and @bbit = 1...

If you have some kind of index value in the row, you can remove them directly.  For example, if there is an ID or an entry date associated with the...

The BIT datatype is described as an "Integer data type" - see BOL.  I do not believe the syntax "not @bbit" will be accepted in the SQL code.

Guarddata-

I would try to get the contents of the temporary tables being used.  My guess would be that they do not hold the same information in both databases at this...

Jack - I agree with you completely.  I actually changed my routines to just have a view with rights so I don't open up everything.  Thanks for making the point...

Ahh - it was so simple - Thanks

Guarddata-

If there is more to the value so you cannot depend on it being INT, BIGINT, etc.  You could  do something like

select REPLACE( LTRIM( RTRIM( REPLACE( ErrMessage, '0', ' '...

Hehe - Pretty hard to find people that know more than the responses I have seen here.  Give it a try right here.

Guarddata-

Yeah - you don't want to use IDENT_CURRENT because of multi-user problems.  I would follow the suggestions and use the @@IDENTITY or SCOPE_IDENTITY() in the first stored procedure and pass the...

You could just create a view that does the replace commands and run your DTS job using the view.

Guarddata-

I'm with Frank.  There must be some need where this column is now going to store more than just date information.  If the concern is formatting, that should probably be...

Kevin,  Some questions to help me understand the environment more...

1) When you say dynamic SQL, do you mean there are different tables involved, different columns, or just different selection criteria?

2)...

We generally do DROP and CREATE...  However, we have found it useful on some occasions to have "empty" procedures to avoid the warnings of "procedure not found".  When this happens,...

I don't remember the source immediately...so take this with a grain of salt.

The performance of string comparisons has been greatly enhanced to the point...