Just think about the fact that your sp will run dynamic sql ! (privileges)

Stop searching, the "problem" is solved. The application developer actualy defined a table-column to short for the data that would be placed into it.

Thanks anyway for all your efforts.

🙁 these...

This is described at "FIX Enterprise Manager Returns Unexpected Error on Table or View" (Q273472)

Check this query to get a view on what soundex is doing :

select 'bijnens', soundex('bijnens')

union all

select 'bainens', soundex('baainens')

union all

select 'beinens',soundex('beinens')

union all

select 'beijnens', soundex('beijnens')

union all

select 'bynens', soundex('bynens')

union all

select 'bijnans', soundex('bijnans')

union all

select...

Building on this I got it to work in VB6 with the folowing code :

'declaration STDERR-file

Dim FileSysSTDERR As FileSystemObject

...

There's an example-application on this issue shipped with sql-server.

check "C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\sqldmo"

didn't you make a carthesian product in your first query (the join-predicate is missing) ?

Could you check the mdac version. My sql7-servers using mdac 2.6 have enormous VM-sizes which are nomore visible after instaling mdac 2.6 sp1.

... change an sa-password without even blinking an eye

... keep a server up and running without even being consulted by the rest of the world

... make a backup-copy of your...

In Tsql the "show [estimated] accesspath"-options are great to check if they match whatever you've supposed it was going to do. This works fine for single query tuning. When using...

I've just noticed that my VMsize seems a bit high. (700mb memusage / 1100mb VMsize)

Still searching why.

Jobi