Recently I ran into the difference between UNION and UNION ALL. Pity you don't mention that.

I encountered that a query result of (say) 300 records UNION'd with a query result...

Did you read my question??

Of course I tried that and that's exactly what I intend to do, among some 20+ other database info items like BuildClrVersion, Collation, CollationID, ComparisonStyle, etc....

Jack,

Thanks for the response. I finally found out what the problem is!

The case is as follows:

- I had (have) 2 different versions of the EnterpriseLibrary on my PC. The one...

When I do it, it's all done locally: The SQL db and the web-interface are both hosted on my PC.

When the client does it both the web-interface and the SQL...

I am terribly sorry, Sugesh ... but I don't understand one little bit what you mean to say. Could you please be a little bit more clear?

I got no stored procedures and\or views stored in SQL, they are all stored in a different database. We only use SQL to accommodate the data.

BUT! ... thanks for the...

I got it solved!

I had the original database scripted into a create script, had some Find and Replace actions executed, ran the script and got myself a new database. The...

Thanks Greg,

That did it for me, I completely worked it out now. I prefer to pre-create the table because of the reserved lengths, etc. If I correct afterwards it's almost...