Post reply

MSDE what''s using it?

  • May 10, 2005 at 12:03 pm

    #164382

    I've got a server that has MSDE on it. How can I tell what application is using its database?

    Thanks,

    Jerry

  • May 10, 2005 at 12:31 pm

    #557860

    Try to login it with OSQL.exe and run sp_helpdb to find out the database name.

    You can get it from EM if you have other SQL Server installations.

    Run sp_who2 to find out which machine is connecting the database.

     

  • May 10, 2005 at 12:31 pm

    #557858

    Assuming you can connect to the database use Profiler.  see http://www.sqlservercentral.com/columnists/bkelley/auditingwithsqlprofiler.asp for help setting it up.  If its a in-house developed app, the application name may not show up but you should be able to find out enought information about who is using it including the server the aplication runs on.

    Hope this helps

    Francis

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply