Sql server has some great built-in commands procs that can help you script server or database wide commands. sp_MSForEachTable and Sp_MSForEachDb<\/p>\n
When first looking at a database , I sometimes like to run the following:
\nexecute sp_MSforEachTable @command1=\u2018Print \u201d?\u201d; Select Count(*) as [? – (count)] from ?;Select Top 10 * from ? \u2018<\/p>\n
I used the sp_MSforeachDB just the other day to set all the non-system
\ndatabases on a test server to Simple Recovery mode.Just made a quick stored procedure that I passed the ? value and filter out the system databases ( Master, Model, Tempdb and MSDB).<\/p>\n
For More Information Checkout :<\/p>\n
November 30, 2004 Sql server has some great built-in commands procs that can help you script server or database wide commands. sp_MSForEachTable and Sp_MSForEachDb When first looking at a database , I sometimes like to run the following: execute sp_MSforEachTable @command1=\u2018Print \u201d?\u201d; Select …<\/p>\n
\nSQL Server Undocumented Stored Procedures sp_MSforeachtable and sp_MSforeachdb
\nBy Gregory A. Larsen
\nhttp:\/\/www.databasejournal.com\/features\/mssql\/article.php\/3441031<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"