How to check which SQL DB is linked with Sharepoint?

How to check which SQL DB is linked with Sharepoint?

Issue:

How to check which SQL DB is linked with Sharepoint?

AX: AX 2012 R3
OS: Windows Server 2012 R2
SQL: SQL 2014
SharePoint:

Solution:
Open SQL> Start RUN>SSMS>
Select the DB>
SELECT program_name, count(*)
FROM
Master..sysprocesses
WHERE ecid=0
GROUP BY program_name
ORDER BY count(*) desc













Now I can see the List of SQL DB which are used in SharePoint!

Happy Querying! 

Thanks & Regards,
Mail ID: pandit.umesh@hotmail.com
Skype ID: pandit.umesh

4 thoughts on “How to check which SQL DB is linked with Sharepoint?

  1. This SY0-501 dumps helped me to improve my performance and by practice test I analysed my performance. I got tremendous result in Core Solutions of CompTIA Security+ Result due to information provided by experts on this DumpsPass4Sure.

Leave a Reply

Your email address will not be published. Required fields are marked *