Determining the size

[CodeNoobster]

Hi everyone, is there any way to determine the size(How many items exist) of a particular database table similar to using the "Array.GetLengt h" Method?

Or am I restricted to only using the count() function in sql?

any article and resource links and recommendations would be greatly appreciated.

[pod]

Try this blogger's solution

SQL Server–HOW-TO: quickly retrieve accurate row count for table