SQL Server Profiler file won't open trace fileAdd a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerHow to concatenate text from multiple rows into a single text string in SQL server?LEFT JOIN vs. LEFT OUTER JOIN in SQL ServerUpdate a table using JOIN in SQL Server?How do I UPDATE from a SELECT in SQL Server?Find all tables containing column with specified name - MS SQL ServerHow to Delete using INNER JOIN with SQL Server?
Bullying boss launched a smear campaign and made me unemployable
What is required to make GPS signals available indoors?
Finding the error in an argument
Night of Shab e Meraj
How many wives did king shaul have
How to compactly explain secondary and tertiary characters without resorting to stereotypes?
Can I hook these wires up to find the connection to a dead outlet?
ssTTsSTtRrriinInnnnNNNIiinngg
Unlock My Phone! February 2018
What is the most common color to indicate the input-field is disabled?
Is this draw by repetition?
Does int main() need a declaration on C++?
Can compressed videos be decoded back to their uncompresed original format?
Is this answer explanation correct?
What is a Samsaran Word™?
Notepad++ delete until colon for every line with replace all
What historical events would have to change in order to make 19th century "steampunk" technology possible?
OP Amp not amplifying audio signal
What are the G forces leaving Earth orbit?
Mathematica command that allows it to read my intentions
Venezuelan girlfriend wants to travel the USA to be with me. What is the process?
Is it a bad idea to plug the other end of ESD strap to wall ground?
Where would I need my direct neural interface to be implanted?
What is the opposite of "eschatology"?
SQL Server Profiler file won't open trace file
Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerHow to concatenate text from multiple rows into a single text string in SQL server?LEFT JOIN vs. LEFT OUTER JOIN in SQL ServerUpdate a table using JOIN in SQL Server?How do I UPDATE from a SELECT in SQL Server?Find all tables containing column with specified name - MS SQL ServerHow to Delete using INNER JOIN with SQL Server?
I talked a customer through running a Profiler trace and have them
send it to me.
But of course, even though we're both running 2014, I can't open it. Profiler complains it can't open files from before 2006. So then I tried the recommended trick:
SELECT *
FROM fn_trace_gettable('C:xyztrace.trc', default);
And that says it can't connect to the database. Yes, there is a file in that location.
Is there any canonical solution to this problem?
sql-server edited Mar 7 at 21:30
marc_s
584k13011241270
asked Mar 7 at 21:24
Maury MarkowitzMaury Markowitz
3,89172865
|
show 1 more comment
I talked a customer through running a Profiler trace and have them
send it to me.
But of course, even though we're both running 2014, I can't open it. Profiler complains it can't open files from before 2006. So then I tried the recommended trick:
SELECT *
FROM fn_trace_gettable('C:xyztrace.trc', default);
And that says it can't connect to the database. Yes, there is a file in that location.
Is there any canonical solution to this problem?
sql-server edited Mar 7 at 21:30
marc_s
584k13011241270
asked Mar 7 at 21:24
Maury MarkowitzMaury Markowitz
3,89172865
2
Is that file on the server machine at that specified location? A remote SQL Server machine cannot just access your local `C:` drive (and that's a good thing!)
– marc_s
Mar 7 at 21:30
2
Surely your client isn't running SQL Server 2005, as that might imply though, either, right?
– Larnu
Mar 7 at 21:37
Try inserting it into a temp table first...SELECT * INTO temp_trc FROM fn_trace_gettable('C:xyztrace.trc', default);See if that gets you what you want.
– WEI_DBA
Mar 7 at 22:12
@Larnu - the client is running 2014, as mentioned.
– Maury Markowitz
Mar 8 at 19:29
1
@WEI_DBA - that did it! If you post it as an answer I'll accept it.
– Maury Markowitz
Mar 8 at 19:46
|
show 1 more comment
I talked a customer through running a Profiler trace and have them
send it to me.
But of course, even though we're both running 2014, I can't open it. Profiler complains it can't open files from before 2006. So then I tried the recommended trick:
SELECT *
FROM fn_trace_gettable('C:xyztrace.trc', default);
And that says it can't connect to the database. Yes, there is a file in that location.
Is there any canonical solution to this problem?
sql-server edited Mar 7 at 21:30
marc_s
584k13011241270
asked Mar 7 at 21:24
Maury MarkowitzMaury Markowitz
3,89172865
I talked a customer through running a Profiler trace and have them
send it to me.
But of course, even though we're both running 2014, I can't open it. Profiler complains it can't open files from before 2006. So then I tried the recommended trick:
SELECT *
FROM fn_trace_gettable('C:xyztrace.trc', default);
And that says it can't connect to the database. Yes, there is a file in that location.
Is there any canonical solution to this problem?
sql-server sql-server edited Mar 7 at 21:30
marc_s
584k13011241270
asked Mar 7 at 21:24
Maury MarkowitzMaury Markowitz
3,89172865
edited Mar 7 at 21:30
marc_s
584k13011241270
asked Mar 7 at 21:24
Maury MarkowitzMaury Markowitz
3,89172865
edited Mar 7 at 21:30
marc_s
584k13011241270
edited Mar 7 at 21:30
marc_s
584k13011241270
edited Mar 7 at 21:30
marc_s
584k13011241270
584k13011241270
asked Mar 7 at 21:24
Maury MarkowitzMaury Markowitz
3,89172865
asked Mar 7 at 21:24
Maury MarkowitzMaury Markowitz
3,89172865
asked Mar 7 at 21:24
Maury MarkowitzMaury Markowitz
3,89172865
3,89172865
2
Is that file on the server machine at that specified location? A remote SQL Server machine cannot just access your local `C:` drive (and that's a good thing!)
– marc_s
Mar 7 at 21:30
2
Surely your client isn't running SQL Server 2005, as that might imply though, either, right?
– Larnu
Mar 7 at 21:37
Try inserting it into a temp table first...SELECT * INTO temp_trc FROM fn_trace_gettable('C:xyztrace.trc', default);See if that gets you what you want.
– WEI_DBA
Mar 7 at 22:12
@Larnu - the client is running 2014, as mentioned.
– Maury Markowitz
Mar 8 at 19:29
1
@WEI_DBA - that did it! If you post it as an answer I'll accept it.
– Maury Markowitz
Mar 8 at 19:46
|
show 1 more comment
2
Is that file on the server machine at that specified location? A remote SQL Server machine cannot just access your local `C:` drive (and that's a good thing!)
– marc_s
Mar 7 at 21:30
2
Surely your client isn't running SQL Server 2005, as that might imply though, either, right?
– Larnu
Mar 7 at 21:37
Try inserting it into a temp table first...SELECT * INTO temp_trc FROM fn_trace_gettable('C:xyztrace.trc', default);See if that gets you what you want.
– WEI_DBA
Mar 7 at 22:12
@Larnu - the client is running 2014, as mentioned.
– Maury Markowitz
Mar 8 at 19:29
1
@WEI_DBA - that did it! If you post it as an answer I'll accept it.
– Maury Markowitz
Mar 8 at 19:46
2
2
Is that file on the server machine at that specified location? A remote SQL Server machine cannot just access your local `C:` drive (and that's a good thing!)
– marc_s
Mar 7 at 21:30
Is that file on the server machine at that specified location? A remote SQL Server machine cannot just access your local `C:` drive (and that's a good thing!)
– marc_s
Mar 7 at 21:30
2
2
Surely your client isn't running SQL Server 2005, as that might imply though, either, right?
– Larnu
Mar 7 at 21:37
Surely your client isn't running SQL Server 2005, as that might imply though, either, right?
– Larnu
Mar 7 at 21:37
Try inserting it into a temp table first...
SELECT * INTO temp_trc FROM fn_trace_gettable('C:xyztrace.trc', default); See if that gets you what you want.– WEI_DBA
Mar 7 at 22:12
Try inserting it into a temp table first...
SELECT * INTO temp_trc FROM fn_trace_gettable('C:xyztrace.trc', default); See if that gets you what you want.– WEI_DBA
Mar 7 at 22:12
@Larnu - the client is running 2014, as mentioned.
– Maury Markowitz
Mar 8 at 19:29
@Larnu - the client is running 2014, as mentioned.
– Maury Markowitz
Mar 8 at 19:29
1
1
@WEI_DBA - that did it! If you post it as an answer I'll accept it.
– Maury Markowitz
Mar 8 at 19:46
@WEI_DBA - that did it! If you post it as an answer I'll accept it.
– Maury Markowitz
Mar 8 at 19:46
|
show 1 more comment
1 Answer
1
active
oldest
votes
Try inserting it into a temp table first...
SELECT * INTO temp_trc FROM fn_trace_gettable('C:xyztrace.trc', default);
This should get you what you want.
answered Mar 8 at 20:47
WEI_DBAWEI_DBA
1,6921613
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55053012%2fsql-server-profiler-file-wont-open-trace-file%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try inserting it into a temp table first...
SELECT * INTO temp_trc FROM fn_trace_gettable('C:xyztrace.trc', default);
This should get you what you want.
answered Mar 8 at 20:47
WEI_DBAWEI_DBA
1,6921613
add a comment |
Try inserting it into a temp table first...
SELECT * INTO temp_trc FROM fn_trace_gettable('C:xyztrace.trc', default);
This should get you what you want.
answered Mar 8 at 20:47
WEI_DBAWEI_DBA
1,6921613
add a comment |
Try inserting it into a temp table first...
SELECT * INTO temp_trc FROM fn_trace_gettable('C:xyztrace.trc', default);
This should get you what you want.
answered Mar 8 at 20:47
WEI_DBAWEI_DBA
1,6921613
Try inserting it into a temp table first...
SELECT * INTO temp_trc FROM fn_trace_gettable('C:xyztrace.trc', default);
This should get you what you want.
answered Mar 8 at 20:47
WEI_DBAWEI_DBA
1,6921613
answered Mar 8 at 20:47
WEI_DBAWEI_DBA
1,6921613
answered Mar 8 at 20:47
WEI_DBAWEI_DBA
1,6921613
answered Mar 8 at 20:47
WEI_DBAWEI_DBA
1,6921613
1,6921613
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55053012%2fsql-server-profiler-file-wont-open-trace-file%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Is that file on the server machine at that specified location? A remote SQL Server machine cannot just access your local `C:` drive (and that's a good thing!)
– marc_s
Mar 7 at 21:30
2
Surely your client isn't running SQL Server 2005, as that might imply though, either, right?
– Larnu
Mar 7 at 21:37
Try inserting it into a temp table first...
SELECT * INTO temp_trc FROM fn_trace_gettable('C:xyztrace.trc', default);See if that gets you what you want.– WEI_DBA
Mar 7 at 22:12
@Larnu - the client is running 2014, as mentioned.
– Maury Markowitz
Mar 8 at 19:29
1
@WEI_DBA - that did it! If you post it as an answer I'll accept it.
– Maury Markowitz
Mar 8 at 19:46