brentmaxwell

SELECT
        [TableName] = so.name,
        [RowCount] = MAX(si.ROWS)
FROM
        sysobjects so,
        sysindexes si
WHERE
        so.xtype = 'U' AND
        si.id = OBJECT_ID(so.name)
GROUP BY so.name ORDER BY so.name

brentmaxwell

namespace System
{
    public static class UnixTimeExtensions
    {
        public static long ToUnixTime(this DateTime datetime)
        {
            return (long)(datetime.ToUniversalTime() - new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds;
        }

        public static DateTime FromUnixTime(long time)