StackOverflow Questions for Tag: sp-msforeachdb

akmatey
akmatey

Reputation: 23

An alternative to sp_msforeachdb

Score: 1

Views: 1093

Answers: 2

Read More
Wynand Cilliers
Wynand Cilliers

Reputation: 1

DB_NAME() when looping through multiple databases

Score: 0

Views: 28

Answers: 0

Read More
Vincent Kelleher
Vincent Kelleher

Reputation: 510

Execute "sp_msforeachdb" in a Java application

Score: 2

Views: 2042

Answers: 3

Read More
Jeremiah Nelson
Jeremiah Nelson

Reputation: 89

Invalid column name using sp_MSForEachDB in SQL Server 2016

Score: 1

Views: 1143

Answers: 2

Read More
jayesh kshirsagar
jayesh kshirsagar

Reputation: 23

Reference of table in all databases of the Server

Score: 0

Views: 42

Answers: 1

Read More
Rauf Asadov
Rauf Asadov

Reputation: 113

How to exclude tempdb from sp_MSforeachdb?

Score: 0

Views: 219

Answers: 1

Read More
Michael
Michael

Reputation: 477

How to use both sp_msforeachtable and sp_msforeachdb in the same query?

Score: 5

Views: 6071

Answers: 2

Read More
InfiniteLoop
InfiniteLoop

Reputation: 93

How should I do to properly use the sp_msforeachDB to create and delete backups

Score: 0

Views: 584

Answers: 1

Read More
Stavros Koureas
Stavros Koureas

Reputation: 1472

SQL Server Sp_msforeachdb query character llimitation

Score: 4

Views: 3914

Answers: 2

Read More
ᗩИᎠЯƎᗩ
ᗩИᎠЯƎᗩ

Reputation: 2132

Use Temp Table to merge query results from different DBs

Score: 0

Views: 531

Answers: 1

Read More
Max
Max

Reputation: 17

sp_MSForeachdb inserting into declared virtual table issue

Score: 0

Views: 1554

Answers: 2

Read More
KJQ
KJQ

Reputation: 59

TSQL - Averaging a result from sp_MSforeachdb

Score: 1

Views: 75

Answers: 1

Read More
Jonathon Anderson
Jonathon Anderson

Reputation: 1200

SQL Iterate Over All Tables

Score: 1

Views: 375

Answers: 4

Read More
user3566591
user3566591

Reputation: 165

SQL Server 2012- Using sp_msforeachdb

Score: 0

Views: 770

Answers: 1

Read More
user3753769
user3753769

Reputation: 15

Running a Stored Procedure on All Databases, and Saving All Results Into A Table

Score: 0

Views: 3150

Answers: 1

Read More
Jeff
Jeff

Reputation: 882

Using a Hidden Stored Procedure

Score: 1

Views: 1035

Answers: 1

Read More
gcormier9
gcormier9

Reputation: 39

sp_helprotect on all databases using sp_MSforeachdb

Score: -1

Views: 1459

Answers: 1

Read More
lonslo
lonslo

Reputation: 3

How to specify TABLE_SCHEMA name in sp_MSforeachdb to take database offline

Score: 0

Views: 6215

Answers: 3

Read More
user2089287
user2089287

Reputation: 69

sp_msforeachdb in dataset

Score: 0

Views: 1390

Answers: 3

Read More
lonslo
lonslo

Reputation: 3

How can I omit system databases and allow SQL Server 2008 agent job to move past ERROR_NUMBER 208?

Score: 0

Views: 3504

Answers: 1

Read More
PreviousPage 1Next