Can someone please help me as I am desperate.

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?

Answer 1

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

Answer 2

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?

Answer 3

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