Solved

Query to default sql2008 trace file  failed

Posted on 2013-05-28
9
269 Views
Last Modified: 2013-10-10
My query to defualt trace file failed due to some space issues, question here is how do I query using a function below, the issues now with folder "Microsoft SQL Server" where have space in between wordings


SELECT * INTO #temp_trc FROM
::fn_trace_gettable('E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\log_515.trc', default)
0
Comment
Question by:motioneye
  • 4
  • 3
  • 2
9 Comments
 
LVL 9

Expert Comment

by:MattSQL
ID: 39200536
What is the error that you get when you run this query?
0
 

Author Comment

by:motioneye
ID: 39200808
Hi,
Got following error messages:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '#temp_trc
go
SELECT * INTO #temp_trc FROM
::fn_trace_gettable('.
Msg 105, Level 15, State 1, Line 4
Unclosed quotation mark after the character string ', default)
0
 
LVL 9

Accepted Solution

by:
MattSQL earned 500 total points
ID: 39200831
What happens if you just run:

SELECT *  FROM
fn_trace_gettable('E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\log.trc', default)
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39213289
There is no problem whatsoever using a path with a space in it.
0
 

Author Comment

by:motioneye
ID: 39243935
Hi,
I will check it again and get back to you guys if I have the same issues
0
 
LVL 9

Expert Comment

by:MattSQL
ID: 39316190
Has this been resolved?
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39316249
The author has been MIA for over a month and has 5 abandoned questions, so I would not hold your breath.
0
 

Author Comment

by:motioneye
ID: 39328089
Hi,
sorry I was very very busy for past few month, I will again run the query ..
0
 

Author Closing Comment

by:motioneye
ID: 39563170
I'm sorry I still have no times to test.. hopefully in another day soon...
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

772 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