Or, change Mohammed's solution to:

CREATE PROCEDURE VerifyIfInvoiceExists

(@Invoice VARCHAR(50))

AS

IF EXISTS (SELECT 1 FROM IPN_received WHERE invoice = @Invoice)

 ...

The problem is with the first DECLARE in the dynamic code:

Declare @columns varchar(2000)

change that to

Declare @columns varchar(8000)

Is the result that is being truncated produced by concatenating two or more values togther? If so, can you post the actual query?

Phil cross-posted this. See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=334455

Yes, whatever login id is used to register the server in EM will be the owner of any objects created in EM.

I'm not sure what happened - I've never seen that before.

Can you create another database, and then check the owner in the database properties?

Are you use MSDE on a desktop...

One method I use occansionally is to create a log table, then insert values into that table at certain points in my code. After a run, you can peruse the log...

Although you posted in a SQL Server 2005 forum, you mentioned you used Enterprise Manager. Are you using SQL Server 2005 or SQL Server 2000?

Anyway, the Windows SYSTEM account is...

My response to the vendor would be "No way!".

Before I went that route, I'd try to find another application, or write my own.

Is your server listening on TCP/IP? Check the most recent SQL Server log. Look at the earliest times, which is the start up sequence. You should see something...

Just in case you need to enable full-text searching on the new database/server, you'll need to do something along these lines:

USE <your database>

EXEC sp_fulltext_database 'enable'

EXEC sp_fulltext_catalog '<your_FT_CatName>'...

Are you sure that query is causing the latest error? The query you posted does not use any full-text functionality.

Also, to avoid any regional issues with datetime constants, I'd suggest...

Are both tables supposed to contain the same data? How do yoo create and populate the temp table? Can you post that code?

Anyway, here's another variation:

select G.PolicyNumber AS PolicyNumInBoth

 ...

Here's a simple example of how you could do that with UPDATETEXT.  Remember that the output length of the text column when displayed in a SELECT statement in Query Analyzer is...

Unfortunately, casting to varbinary and then to string won't work as desired. In this case, "hexidecimal" means a string representation of the decimal value. Try the following function, which you can tweak...