Dear all,

Thanks for your replies.  However, the problem is much more simple than it was initially speculated.  My WinZip 11 Pro along with the WinZip Command-Line Utility was not properly...

Dear Ian,

What I am trying to achieve is to generate the SQL code for tables, views, SPs, triggeres, etc.  I have already done so with EM but I am looking for...

Job well done!!!

Thanks a lot.

Andreas

Dear Joseph,

I have already tried this.  It looks like the permissions that my users have are very limited and I think that  have to GRANT EXECUTE permission for the specific...

Dear Ray,

Indeed, there is a reason for not using Windows Authentication.  I am not the Network Adminastrator and as far as I know, the environment (password-wise) is not the "most" secure...

Dear Kenneth,

I have checked all positions and indeed all there was there was spaces.  It seems, as you have already mentioned, that bcp treats these values in a strange way...

To Kenneth:

It does not contain a CR or LF character.

To David:

The actual value is spaces.  Somehow the user entered spaces for this field and the front end application did not trim...

Dear Kenneth,

I have tried your suggestion but unfortunately it does not work.  Please have in mind that the field in question is of type NVARCHAR.  Also, the codepage used is...

It looks like I cannot avoid using a temp table.  Therefore, I will go ahead with the proposed solutions.  Thanks guys.

Regards,

Andreas

Thanks Steve but unfortunately this does not work.  It returns "1" for every record.

Regards,

Andreas

Dear Ryan,

Thanks for your reply but this does not really help me as I am trying to get the mentioned result from a single statement.

Regards,

Andreas

Dear Noel,

Unfortunately, I do not know how to enable DTC for network access.  The 2 boxes are not on the same domain.  MSDE box dials an ISP and tries to...