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

Scripts with tag sp_msforeachtable Rss

Search for any content tagged sp_msforeachtable

Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   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 | 524 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,412 reads
   Items 1 to 2 of 2