locked
Can someone please help me as I am desperate. RRS feed

  • Question

  • User1504639868 posted

    Can someone please help me as I am desperate.

     We have a Windows 2003 server running a live SQL data base.

     I do not have permissions to connect to this server.

     However I am able to write and run SQL queries from my PC using Microsoft SQL Server 2005 Studio Express

     So what I would like to know is how can I run Log Parser and interrogate the database on this server.

     The server is called Peterborough and the database is called ecommerce and the table I would like to interrogate is called incidents

     Can you someone please tell me how to construct the correct Log Parser query?

    Thursday, April 24, 2014 6:57 AM

All replies

  • User212506688 posted

    Hi,

    Do you mean LogParser that is used to analyze IIS, HTTP and Event Logs?

    I am not certain what you are asking here.

    You can ask someone for the files or copy them to a share where you have access to and then analyze them using LogParser.

    HTH, Benjamin

    Wednesday, April 30, 2014 9:28 AM
  • User1504639868 posted

    Indeed I mean LogParser that is used to analyze IIS, HTTP and Event Logs?

     

    Can the above LogParser be used to interrogate real SQL Servers, or have I got it wrong?

    Tuesday, May 6, 2014 12:01 PM
  • User-1731511703 posted

    LogParser can be used to read the SQL Error Logs but not SQL Server itself.  Don't be confused by the fact that LogParser uses Structured Query Language to read text-based log files.  Here's a blog post on how to read SQL Error Logs:

    http://www.lucasnotes.com/2010/06/querying-sql-error-log-with-microsoft.html

    Tuesday, May 6, 2014 12:31 PM