SQL 2005 SA user

Posted on 2012-09-21
Last Modified: 2012-09-24
I am not a DBA but I have been tasked (via an audit) to change our Server Authentication to Windows Authentication mode. (effectively disabling the SA user). We have a half dozen critical databases on our SQL Server and I am trying to find out the effect this would have on those Databases.

Is there a script or something that I can run that shows where/what the SA account is doing in the background? I have gone into SQL Server Profiler and set the 'Login' - LoginName to [Like sa] and the Trace does not show anything.

Thanks in advance.
Question by:minimeister
    LVL 17

    Accepted Solution

    In the SQL Profiler filter ensure to set it Like %sa%   - that is include wildcards - then maybe to a manual login using sa to ensure that the Profiler filter is working
    LVL 3

    Expert Comment

    Profiler is a good option, or you could use sp_who2 to show all processes and what account is using them.  This will also show sleeping processes that rely on that user.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now