According to this:

If you have more than 255 UNION ALL statements, you will get the above error. There is a hotfix available and we are still on sp3a. I...

I found there was only one column in this DB, so I excluded it in the cursor until I figure something else out.

But now I get this error:

Msg 8621, Level...

I see why I am getting the error, but do you know how I can cast those datatypes dynamically in the cursor?

Thanks,

Wes

Thanks Jack,

I think I can make this work. The NULL column is always 0 because of the concatenation (I guess) but I am only concerned about the non-null fields.

When I...

SQL Server 2005, once I changed the max to 8000 it runs without error. But of course, it only gets halfway throught the first 2 tables.

The query is running against...

One of the DB's I'm looking at has 188 tables with 2516 columns. Yes I can run during off peak times, but it is actually a replicated Oracle DB, so...

Yes, exactly!

Thanks for the reply Jack,

I am looking for the actual number of fields that are not Null in every table in a database.

For example, I will need to find the...