This was a fun read! Thanks.

Thank you all for the replies. We tried the script above and found that there were no entries for

on our server at the customer site. So it's back...

My point is the code doesn't work in a stored procedure, and I hoped someone might know why... Are you trying to say my table name is wrong? ...

If you will look closely, you will see there are two methods in my script. One is commented out. Both return NULL. It...

I may have another problem, but it most certainly isn't the table name. As I said, I made the script into a stored procedure:

[font="Courier New"]

/****** Object: StoredProcedure [dbo].[usp_GetTableRowCount]...

I also get NULL as the result when I run this procedure.

I have set this procedure up to run as a stored procedure which takes TableName as a parameter to...