Solved

Need to know where SQL 2005 creates its log files

Posted on 2007-11-24
4
153 Views
Last Modified: 2010-04-21
I know this is easy for many of you so I will assign the full 500 points to the first correct answer.  I am having a security problem with logging into my SQL Database from an application I wrote.  I need to know where SQL 2005 stores its log files so I can determine the details of the login problem.

Thanks
Kenny
0
Comment
Question by:kwh3856
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
PaultheBroker earned 500 total points
Comment Utility
C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG
0
 
LVL 55

Expert Comment

by:Jaime Olivares
Comment Utility
In fact the "MSSQL.2" portion can vary depending on your database instance.
0
 

Author Closing Comment

by:kwh3856
Comment Utility
Thank you very much
0
 
LVL 6

Expert Comment

by:PaultheBroker
Comment Utility
cool - thanks for the info Jamie.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 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

15 Experts available now in Live!

Get 1:1 Help Now