Solved

How to list the database name alongside the current corresponding query results

Posted on 2016-08-08
2
50 Views
Last Modified: 2016-08-08
Heyas,

I have the following query:

DECLARE @command varchar(1000)
select @command = 'USE ?; select default_schema_name
, type_desc
, name
, create_date
from sys.database_principals
order by default_schema_name
, type_desc'
EXEC sp_MSforeachdb @command

Works fine.

My query is how to list the corresponding database for each of these existing result tests.

Any assistance is appreciated.

Thank you.
0
Comment
Question by:Zack
2 Comments
 
LVL 24

Accepted Solution

by:
chaau earned 500 total points
ID: 41746758
use DB_NAME():

DECLARE @command varchar(1000)
select @command = 'USE ?; select DB_NAME(), default_schema_name
, type_desc
, name
, create_date
from sys.database_principals
order by default_schema_name
, type_desc'
EXEC sp_MSforeachdb @command 

Open in new window

0
 

Author Closing Comment

by:Zack
ID: 41746765
Thank you just saved me a few hrs :). If you are able can you offer any insight into this query:

https://www.experts-exchange.com/questions/28961401/Configuring-a-maintenance-plan-or-scheduled-jobs-to-via-rules-set-by-the-resource-governor-Error-OLE-DB-error-code-0x80040E4D-Login-failed-for-user-'SQL-RG-MP-User'.html 

I have scoured google but I can't any meaning insights into my query.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Job - date manual 1 35
SQL DATEADD 10 71
Inserting data into database 10 36
Where on a calculated field 1 23
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question