A script - row number

[emmim44]

I need a cf script that finds out the total row count of a sql database...Any idea?
The reason I need is to compare our current db (on SQL05) with the new one that will be attached to the SQL 05....

[Newsgroup_User]

I don't know about a CF script, but a pretty damn simple SQL script is:

SELECT count(*)
FROM aTable

[emmim44]

I have found a stored procedure that does what I need... thank you all
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER PROCEDURE [dbo].[listTableRowCounts]
AS
BEGIN
SET NOCOUNT ON

DECLARE @SQL VARCHAR(255)
SET @SQL = 'DBCC UPDATEUSAGE (' + DB_NAME() + ')'
EXEC(@SQL)

CREATE TABLE #foo
(
tablename VARCHAR(255),
rc INT
)

INSERT #foo
EXEC sp_msForEachTable
'SELECT PARSENAME(''?'', 1),
COUNT(*) FROM ?'

SELECT tablename, rc
FROM #foo
ORDER BY tablename,rc ASC

DROP TABLE #foo
END