sp_msforeachtable

ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2011-11-14 (first published: 2011-09-19)

689 reads

Finding no. of Rows in all tables of a datbase in one line of script

Consider you have 100+ tables in your database, you want to find a quick way to find no. of rows in each table

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(15)

You rated this post out of 5. Change rating

2011-01-11 (first published: 2010-12-22)

2,469 reads

This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...

In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

Comments posted to this topic are about the item Can You Really Downgrade from...

Comments posted to this topic are about the item What is CPU Usage?

Comments posted to this topic are about the item Limiting Checkpoints

If I use the -k parameter with a number after it, what does this change in SQL Server?