Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag sp_msforeachtable Rss

   Items 1 to 2 of 2   
 

sp_MSforeachtable:Add SQL objects to multiple database on a server.

ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.  Read more...
By Mehernosh 2011/11/14 | Source: SQLServerCentral.com | Category: sp_msforeachtable
Rating: |  Discuss |   Briefcase | 533 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  Read more...
By Abid Malik 2011/01/11 | Source: SQLServerCentral.com | Category: sp_msforeachtable
Rating: |  Discuss |   Briefcase | 2,420 reads
   Items 1 to 2 of 2   
 
Tags
all databases (1)    
database (1)