SQL Query to List all tables with their Row counts in a Database

Hi there...

I was in need to analyze a database. This SQL Query to List all tables with their Row counts in a Database was pretty much useful.

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

2 DESC

Hope it helpz
Fauzi

The list is too large to save as a template. The size of a template cannot exceed 10485760 bytes.

Hi,

When you try to save a MOSS 2007 List as a template with "Include Content" check box checked (In order to save the list with the available contents), the following message will be shown...

The list is too large to save as a template. The size of a template cannot exceed 10485760 bytes.

To increase the maximum size of list template you can run the following command:

stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 50000000

from the following location in server : C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN

Seems you can increase up to 500 MB.

After running the command, just press CTRL+F5 to view the results :)

Regards
Fauzi

Asp.Net Open Source Applications list

Hi,

Found this useful link which lists well know Asp.net open source applications & their respective url's to download.

http://www.blogfodder.co.uk/post/2008/07/List-Of-Free--Open-Source-ASPNET-Web-Applications.aspx

Hope it is helpful :)

Regards
Fauzi