Search This Blog

Google Website Translator Gadget

Sunday, November 4, 2018

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
By at
Labels:
Location: Delhi, India

2 comments:

  1. AnonymousAugust 27, 2019 at 4:12 AM

    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.

    ReplyDelete
  2. Azure DevOpsSeptember 11, 2020 at 10:05 AM

    Thanks for Sharing.
    Windows Azure Admin Online Training

    ReplyDelete

Subscribe to: Post Comments (Atom)

Cost to use Microsoft Dynamics 365 by Umesh Pandit

Cost to use Microsoft Dynamics 365 by Umesh Pandit Understanding the cost of using Microsoft Dynamics 365 can be complex, as it depends on v...

Labels

MSDynamicsAXtips by Umesh Pandit (80) Umesh Pandit AX Blog (80) microsoft Dynamics 365 (3) AX 2012 EP Errors (2) AX 2012 R3 (2) Assembly containing type Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.DmfEntityProxy is not referenced (2) Dynamics AX 2012 R3 (2) Microsoft Dynamics AX 7 (2) Microsoft Dynamics AX Videos (2) Microsoft Dynamics AX build numbers (2) Step by step import with Data Migration Framework in AX 2012 (2) 'C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\Bin\XppIL\xml\AppObjects1.xml' is denied. (1) 20% off on Microsoft Dynamics Certification (1) 70-339 Dumps (1) A call to the Microsoft Dynamics AX SRSFramework Service failed (1) A new AX development book (1) A user session on the server could not be created (1) AOS Troubleshooting Tips and Techniques in Microsoft Dynamics AX 2009 (1) AX 2012 Development Virtual Training (1) AX 2012 Hands on Labs (1) AX 2012 Installation & Configuration (1) AX 2012 Model Management (1) AX 2012 R3 CU8 (1) AX 2012 R3 CU8 Supports Microsoft Visual Studio 2013 (1) AX 2012 kernel crash hotfixes (1) AX 2012 posting profile (1) AX Admin Interview Questions (1) AX Administrator Interview Questions (1) AX Configuration for Production (1) AX Scribe Services (1) AX Setup issue (1) AX for ERP: Multiple exchange rates for consolidating entities (1) AX kernel crash hotfixes (1) AX2012R3 (1) AX2012R3 Report Server and Analysis Server Step by Step Installation and Configuration (1) Allow non-administrators RDP Access to Domain Controller (1) An unexpected error has occurred while opening the workflow (1) Apps for Microsoft Dynamics AX (1) AxBuild.exe for Parallel Compile on AOS of X++ (1) Axapta Build Numbers (1) CONVERGENCE 2014 (1) Can multiple instances of Analysis Services be installed in multiple AOS (1) Cannot delete a record in Batch job (BatchJob) (1) Cannot delete batch jobs in the executing or cancelling state (1) Cannot find one or more components SQL Server 2014 (1) Cannot insert multiple records in Security user role (SecurityUserRole). The record already exists (1) Clear cache for AX 2012 via script (1) Complete list of KBs for AX (1) Could not load file or assembly 'Microsoft.Dynamics.AX.DMF.PreviewGrid (1) Could not load file or assembly 'Microsoft.Dynamics.AX.Framework.Tools.DMF.PreviewGrid (1) Create user groups (1) Create user groups in AX 2009 (1) Culture=neutral (1) Customer Driven Upgrade (1) DAX CONVERGENCE 2014 (1) Data Migration Framework in AX 2012 (1) Delete a model file (1) Deleting the Users in the AX 2012 of other domain (1) Deploy the AX client by using Group Policy (1) Developing SSRS Reports for Dynamics AX by Mukesh Hirwani (1) Difference Between AX 2012 R2 and AX 2012 R3 for Developers (1) Difference between Hotfixes Cumulative Update and Service Pack for AX 2012 (1) Disconnected from the AOS (1) Dynamics AX Administrator Interview Questions (1) Dynamics AX exams 20% off (1) E-learning Courses on AX 2012 R3 (1) E-learning on AX 2012 (1) E-learning on AX 2012 R3 (1) EP AX 2009 (1) EP Opening in Notepad issue (1) Enterprise Portal Forms authentication (1) Error System.Security.Permissions.EnvironmentPermission while running report (1) Error in SSRS AX 2012 R3 (1) Exception from HRESULT: 0xC0048021 at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.ShowPreview(Boolean isComposite) (1) Export a model file (1) Export and Import Models and Model files in AX 2012 (1) Failed to create a session$ confirm that the user has the proper privileges to log on to Microsoft Dynamics (1) Field Fixed) (1) Fixed Field Relation in AX 2012 (1) Free E-book Enterprise Cloud Strategy- (1) Free ebook: Introducing Microsoft SQL Server 2016! (1) Get Your 15% MCP Exam Discount Code (1) Hands on lab on AX 2012 (1) How do you setup visual studio SSRS Report to point it to production server (1) How many maximum numbers of users per AOS for Microsoft Dynamics AX 2009? (1) How to Create a New Role Center in Dynamics AX 2009 (1) How to Import/Export Model on correct AOS (1) How to Install AX 2009 on windows 7 without Domain (1) How to Install AX 2012 on windows 8 without Domain (1) How to Log in as different domain user in Microsoft Dynamics AX 2012 (1) How to Log in as different user (1) How to Move Dynamics AX database to different Domain (1) How to Move Dynamics AX database to different Machine (1) How to Move Dynamics AX database to different Server (1) How to Open Visual Studio with a Specific Configuration AX 2012 (1) How to Remove (Uninstall) a Model in AX 2012 R2 (1) How to Reset production order status as created in AX 2012 (1) How to Retail Server Configuration (1) How to Set up the Business Connector proxy user (1) How to Set up the Business Connector proxy user in AX 4.0 (1) How to Setup excel add-in in office 2013 (1) How to Show User Name in startup message (1) How to be MCP (1) How to change sign in url of authentication provider (1) How to check Import-AXModelStore conflict ID details in AX 2012 (1) How to clear cache for AX (1) How to clear cache for AX 2012 R2 in Windows Server 2012 (1) How to clear the transaction log in AX 2012 R3 (1) How to determine the version of Microsoft Dynamics 365 (1) How to drop multiple table from SQL when there is Sync Error (1) How to generate a welcome message while opening the AX 2012 (1) How to get Microsoft certified (1) How to get the SID for AX (1) How to get the SID for AX 2012 (1) How to get the SID for Windows Server 2012 R2 (1) How to import Data with Data Migration Framework in AX 2012 (1) How to install AX client in multiple computers (1) How to install AX client in multiple systems (1) How to install CU7 (1) How to install CU7 for Microsoft Dynamics AX 2012 R2 (1) How to install Retail Server Installation (1) How to install and setup ax 2012 excel add-in in office 2013 (1) How to install multiple instances of Analysis Services on multiple AOS (1) How to learn AX (1) How to set up auto logout in Microsoft Dynamics AX (1) How to setup Report Server and Analysis Server in AX2012R3 (1) How to solve The CIL generator found errors and could not save the new assembly (1) Import Model Store AX 2012 by Creating the Temporary schema (1) Import Model Store in AX 2012 R2\R3by Creating the Temporary schema (1) Import a model file (1) Importing Data to Microsoft Dynamics AX 2012 using Excel Add-in (1) Infrastructure as a Service (1) Initialize-AXModelStore (1) Initialize-AXModelStore Needed for CU8 (1) Install AX 2012 R3 client in Linux (1) Install AX 2012 R3 client in Macbook (1) Introducing Digital Badges for Microsoft Certified Professionals! (1) Invalid class error in SQL SSRS (1) Invalid class error in SQL SSRS AX 20012 (1) Job Description of Microsoft Dynamics AX Administrator (1) Job roles of Microsoft Dynamics AX Administrator (1) Job roles of Microsoft Dynamics AX Functional (1) Job roles of Microsoft Dynamics AX Technical (1) LCS for AX 2012 (1) Layers in AX 2012 (1) Learning MS Dynamics AX 2012 Programming by Mohammed Rasheed Erlend Dalen (1) License information in Dynamics AX 2012 (1) Lifecycle Services for Microsoft Dynamics AX 2012 (1) Lifecycle Services for Microsoft Dynamics User Guide (1) List of Companies Working on AX in India (1) List of Companies Working on Axapta in India (1) List of MNC Working on AX (1) List of New Modules in Microsoft Dynamics AX 2012 R3 (1) List of table in AX 2012 should be taken backup while restoring the database (1) MB6-705 Dumps (1) MB6-705 Microsoft Dynamics AX 2012 R3 CU8 Installation and Configuration (1) MCP Exam Discount Code 2014 (1) MS Dynamics AX 2012 (1) Mainstream support for Microsoft Dynamics POS 2009 (1) Making Advanced Analytics Simple and Scalable : SQL Server 2016 R Services (1) Management Reporter Videos (1) Management Reporter has not yet been configured on the server.within the Management Reporter Configuration Console. (1) Managing Microsoft SharePoint Server 2016 Dumps (1) Measuring Complexity In X++ Code by Anders Tind Sørensen (1) Microsoft Azure (IaaS) Cost Estimator Tool Step-By-Step (1) Microsoft Azure Enterprise Cloud Strategy- Free E-book (1) Microsoft Cloud (1) Microsoft Dynamics 365 version (1) Microsoft Dynamics 365 will end jobs of Microsoft Dynamics AX Administrators (1) Microsoft Dynamics AX Infrastructure Planning (1) Microsoft Dynamics AX 2009 AOS Troubleshooting tips (1) Microsoft Dynamics AX 2012 (1) Microsoft Dynamics AX 2012 Installation Guide (1) Microsoft Dynamics AX 2012 Layers (1) Microsoft Dynamics AX 2012 Posting Profile Concept (1) Microsoft Dynamics AX 2012 R3 CU8 (1) Microsoft Dynamics AX 2012 R3 Development Cookbook (1) Microsoft Dynamics AX 2012 R3 Development Cookbook.pdf (1) Microsoft Dynamics AX 2012 R3 Support Extension Announcement (1) Microsoft Dynamics AX 2012 R3 will no longer be available for new customers (1) Microsoft Dynamics AX 2012 Reporting Cookbook by Kamalakannan Elangovan (1) Microsoft Dynamics AX 2012 Reporting extensions (1) Microsoft Dynamics AX 2012 Security How-To by Ahmed Mohamed Rafik Moustafa (1) Microsoft Dynamics AX 2012 Services (1) Microsoft Dynamics AX 2012 System Requirements (1) Microsoft Dynamics AX 2012 in Windows Azure (IaaS) (1) Microsoft Dynamics AX 2015 (1) Microsoft Dynamics AX 4.0 Implementation Guide (1) Microsoft Dynamics AX Community (1) Microsoft Dynamics AX Configuration for Production (1) Microsoft Dynamics AX Growth rate (1) Microsoft Dynamics AX Mobile Capabilities (1) Microsoft Dynamics AX Scope (1) Microsoft Dynamics AX Session Types (1) Microsoft Dynamics Axapta (1) Microsoft Dynamics Community (1) Microsoft Dynamics Community Site Enhancements (July 2014 Release) (1) Microsoft Dynamics NAV Training and Certification Details (1) Microsoft Dynamics RMS (1) Microsoft DynamicsAXInfrastructure (1) Microsoft Exam 70-339 Dumps (1) Microsoft Exam 70-339 Managing Microsoft SharePoint Server 2016 (1) Microsoft Products Full-featured evaluations at no cost (1) Microsoft Rainier (1) Microsoft SQL Server Management Studio Opening Error (1) Microsoft SharePoint 2010 is not installed or running. Please run the prerequisite utility for more information. Operation is not valid due to the current state of the object. (1) Microsoft Timeline (1) Microsoft dynamics AX 2012 R3 training (1) Microsoft training courses Dynamics 365 (1) Model Management in AX 2012 (1) New Microsoft training courses for Dynamics 365 (1) New Modules in AX 2012 R3 (1) Object Server 01: Fatal SQL condition during login. Error message: "The internal time zone version number stored in the database is higher than the version supported by the kernel (8/7). (1) Overview of AX kernel crash hotfixes (1) Parallel Compile on AOS of X++ (1) Parallel Compile on AX (1) Prerequisites for Dynamics AX 2012 R3 (1) PublicKeyToken=31bf3856ad364e35 (1) Publish-AXReport –Id SSRSConfigID (1) Quality Assurance for Dynamics AX (1) Query to clear logs in AX 2012 (1) Rainier AX (1) Recover a database that is in the "restoring" state (1) Related Field Fixed (1) Responsibilities Related to Microsoft Dynamics AX Administration (1) Restore the DB Form Source to Destination in Microsoft Dynamics AX 2012 R3 (1) Retail Server Installation and Configuration (1) Retake Microsoft Certification Exam for Free Microsoft (1) Run AX as different user for AX 2012 (1) Run as Administrator (1) SSRS Subscriptions cannot (1) SSRS Subscriptions cannot be created because the credentials used (1) SSRS subscription via email (1) Script to Clear the cache for AX 2012 R3 CU8 via Script (1) Secure your Dynamics AX 2012 environment Umesh Pandit AX Blog (1) Set a startup message in AX 2009 (1) Set a startup message in AX 2012 (1) Setting up Email Subscriptions in SSRS (1) Shortcut keys in AX 2012 (1) Shortcut keys in AX 2012 R2 (1) Shutdown AX application (1) Slipstream updates in AX (1) Slipstream updates in AX 2012 R3 CU8 (1) Slow less in AX 2012. (1) Soar to New Heights with Dynamics AX 2015 (1) Step by Step installation of AX 2009 on Stand Alone System (1) System.Web.Services.Protocols.SoapException: An attempt has been made to use a data extension 'AXADOMD' (1) Table Relations (Normal (1) Table Relations Normal Related Field Fixed Field Fixed in AX 2012 (1) The 'Metadata' property is read-only and cannot be set (1) The Growing ERP Microsoft Dynamics AX (1) The Microsoft Timeline (1) The Model Store Has Been Modified - AX2012 R3 CheckList (1) The corresponding AOS Validation failed. (1) The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://tempuri.org/:queryBuilderArgs. (1) The report server installation is not initialized. (rsReportServerNotActivated) in AX 2012 (1) The slips treaming process in AX 2012 R3 CU8 (1) The target principal name is incorrect in SSRS AX 2012 R3 (1) The user or group name 'umeshp\AX2012R3' is not recognized while publishing the report via powershell (1) The user or group name is not recognized Error in SSRS AX 2012 R3 (1) Things to consider for Microsoft Dynamics AX Infrastructure (1) Things you did not know about Microsoft Dynamics AX 2012 R3 (1) Things you did not know about Microsoft Dynamics AX 2012 R3 - Dynamics AX Expert Opinion - Microsoft Dynamics AX (1) This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms (1) Today I Passed the Microsoft Exam 70-533 Implementing Microsoft Azure Infrastructure Solutions (1) Today I Passed the Microsoft Exam 70-534 Architecting Microsoft Azure Solutions (1) Top 10 New and Improved Features of Project Accounting Module in Microsoft Dynamics AX 2012 (1) Unable to deploy AX 2012 Reporting Extensions on SQL Server 2012 Reporting Server (1) Unable to preview the report install the Business Intelligence Development Studio feature of Microsoft SQL Server For more information (1) Unable to shrink the transaction log in AX 2012 R3 (1) Understanding Opportunities in AX2009 – CRM Module (1) UserInfo (1) Version=6.2.0.0 (1) Version=6.3.0.0 (1) Visual Studio 2010 connection to Dynamics AX 2012 (1) Visual Studio 2013 Dev Tools selection for AX 2012 R3 CU8 (1) Visual Studio Tools AX 2012 R3 CU8 (1) What are AX Build Numbers (1) What are Axapta Build Numbers (1) What is CDU in Microsoft Dynamics 365 (1) What is Microsoft Dynamics AX (1) What is Microsoft Dynamics AX (Microsoft Axapta) (1) What is Microsoft Timeline (1) What is Model File in AX 2012 R2 (1) What is Model Store in AX 2012 R2 (1) What is R3 in AX 2012 (1) What is the between Differences Dynamics CRM and Dynamics AX CRM (1) What is the between Similarities in Dynamics CRM and Dynamics AX CRM (1) What is the maximum number of Client per AOS? (1) What's the difference between importing model store versus model file (1) Whats new in AX 2012 R3 (1) Which Microsoft certification will give job (1) Which is best Microsoft Dynamics AX or SAP (1) Which table store License information in Dynamics AX 2012 (1) Why AX Is Slow (1) Why Freshers Should get microsoft certification (1) Why choose Microsoft Dynamics AX over SAP (1) WiFi not working on Windows Server 2012 R2 (1) Windows 8 Apps for Microsoft Dynamics AX (1) Windows Server 2012 (1) Working with Models in AOT (1) You Do not hold Employment in the current legal entity. New Documents cannot be created. (1) an unexpected exception for report AutoReport in ax 2012 R3 (1) auto logout in Microsoft Dynamics AX (1) autorun.hta is not a valid win32 application (1) configure WiFi for Windows 2012 R2 Server OS installed on Laptop (1) difference between Business User Developer Administrator in AX 2012 R3 Installation (1) e- procurement in AX 2012 (1) how to Import Data to Microsoft Dynamics AX 2012 using Excel Add-in (1) how to add users in Domain Controller for RDP access (1) how to run as administrator for ax 2012 client (1) info.shutDown(true) (1) kill AX user session (1) microsoft Dynamics 365 where to start (1) microsoft Dynamics 365 where to start by umesh pandit (1) restoring database issue in AX2012 (1) service unavailable http error 503 in AX 2012 R3 (1) shutdown AX automatically (1) shutdown axapta automatically (1) slipstream process in AX 2012 R3 CU8 (1) ssrs subscription setting for email (1) umes (1) umesh (1) ​Support is extended to provide Microsoft Dynamics AX 2012 R3 (1) “Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics” (1)