Could you provide a sample patient id that does work, a sample one that doesn't and the exact code that executes doQuery() prcoedure. There has to be something in...

Go into Query Analyzer. From Enterprise Manager, click on Tools --> SQL Server Query Analyzer. Then type in:

sp_help patient

Post the results...

The stripping of the leading zeros actually has nothing to do with whether the field is char or nvarchar. It must have something to do with some implicit or...

Could you post some sample code that is causing the errors, as well as the DDL of the table in question? It will help to determine the problem.

Are you consolidating 2 SQL Server databases?

You can find the total length of the record by executing:

SELECT [PrimaryKeyField], (LEN([Field1]) + LEN([Field2]) ... all fields) AS "DATA_LEN" FROM [TableName]

optionally putting in...

ADO is returning the text showing recordcount return as a recordset. Put SET NOCOUNT ON in your proc.

First, make sure all statistics are updated. Second, try this instead:

select count(*) from uu_resume_ses_dummy_dummy

where not exists

(select * from iis_uu_diario_resume where substring(col018_dominio,1,30)

= substring(uu_resume_ses_dummy_dummy.dominio,1,30))

and see if it makes any...

quote:

---

Here is the error I get:

"The object you entered is not a valid recordset Property"

Run Time 7965

---