TechQA.

Question

DB_NAME() when looping through multiple databases

score 48 · Answer 1 · 2023-02-06T07:01:08.953000

0

Answer

48

Views

DB_NAME() when looping through multiple databases

48 views Asked by Wynand Cilliers At 06 February 2023 at 07:01

score 1007 · Answer 2 · 2021-01-19T05:55:07.993000

Invalid column name using sp_MSForEachDB in SQL Server 2016

1k views Asked by Jeremiah Nelson At 19 January 2021 at 05:55

score 41 · Answer 3 · 2020-06-23T18:06:03.330000

Reference of table in all databases of the Server

41 views Asked by jayesh kshirsagar At 23 June 2020 at 18:06

score 213 · Answer 4 · 2019-09-11T06:40:45.817000

How to exclude tempdb from sp_MSforeachdb?

213 views Asked by Rauf Asadov At 11 September 2019 at 06:40

score 503 · Answer 5 · 2019-05-23T16:09:58.290000

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

503 views Asked by InfiniteLoop At 23 May 2019 at 16:09

score 1006 · Answer 6 · 2019-03-11T16:27:26.697000

An alternative to sp_msforeachdb

1k views Asked by akmatey At 11 March 2019 at 16:27

score 523 · Answer 7 · 2017-10-11T09:10:03.750000

Use Temp Table to merge query results from different DBs

523 views Asked by ᗩИᎠЯƎᗩ At 11 October 2017 at 09:10

score 3547 · Answer 8 · 2017-08-10T08:35:59.533000

SQL Server Sp_msforeachdb query character llimitation

3.5k views Asked by Stavros Koureas At 10 August 2017 at 08:35

score 1513 · Answer 9 · 2017-06-07T14:00:10.360000

sp_MSForeachdb inserting into declared virtual table issue

1.5k views Asked by Max At 07 June 2017 at 14:00

score 71 · Answer 10 · 2016-11-22T14:28:48.850000

TSQL - Averaging a result from sp_MSforeachdb

71 views Asked by KJQ At 22 November 2016 at 14:28

score 687 · Answer 11 · 2015-04-30T23:40:03.943000

SQL Server 2012- Using sp_msforeachdb

687 views Asked by user3566591 At 30 April 2015 at 23:40

score 5667 · Answer 12 · 2014-12-02T14:36:42.453000

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

5.6k views Asked by Michael At 02 December 2014 at 14:36

score 363 · Answer 13 · 2014-10-22T18:47:58.663000

SQL Iterate Over All Tables

363 views Asked by Jonathon Anderson At 22 October 2014 at 18:47

score 2798 · Answer 14 · 2014-06-18T20:20:34.803000

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

2.7k views Asked by user3753769 At 18 June 2014 at 20:20

score 1425 · Answer 15 · 2013-07-04T22:35:26.990000

sp_helprotect on all databases using sp_MSforeachdb

1.4k views Asked by gcormier9 At 04 July 2013 at 22:35

score 6167 · Answer 16 · 2013-04-23T23:23:12.193000

How to specify TABLE_SCHEMA name in sp_MSforeachdb to take database offline

6.1k views Asked by lonslo At 23 April 2013 at 23:23

score 1368 · Answer 17 · 2013-03-19T18:39:46.830000

sp_msforeachdb in dataset

1.3k views Asked by user2089287 At 19 March 2013 at 18:39

score 1933 · Answer 18 · 2013-02-04T15:49:52.693000

Execute "sp_msforeachdb" in a Java application

1.9k views Asked by Vincent Kelleher At 04 February 2013 at 15:49

score 3499 · Answer 19 · 2013-01-14T15:00:37.783000

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

3.4k views Asked by lonslo At 14 January 2013 at 15:00

score 5131 · Answer 20 · 2012-12-16T20:49:38.690000

"Looping" through databases with sp_MSforeachdb and returning 1 data set

5.1k views Asked by DavidStein At 16 December 2012 at 20:49

TechQA.

List Question

DB_NAME() when looping through multiple databases

Invalid column name using sp_MSForEachDB in SQL Server 2016

Reference of table in all databases of the Server

How to exclude tempdb from sp_MSforeachdb?

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

An alternative to sp_msforeachdb

Use Temp Table to merge query results from different DBs

SQL Server Sp_msforeachdb query character llimitation

sp_MSForeachdb inserting into declared virtual table issue

TSQL - Averaging a result from sp_MSforeachdb

SQL Server 2012- Using sp_msforeachdb

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

SQL Iterate Over All Tables

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

sp_helprotect on all databases using sp_MSforeachdb

How to specify TABLE_SCHEMA name in sp_MSforeachdb to take database offline

sp_msforeachdb in dataset

Execute "sp_msforeachdb" in a Java application

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

"Looping" through databases with sp_MSforeachdb and returning 1 data set

Popular Questions

Trending Questions