Where does Profiler store its temporary data in SQL Server 2005 ?

Posted by Bharathi Cherukuri on 6/6/2012 | Category: Sql Server Interview questions | Views: 4011 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Profiler store its temporary data in the directory stored in the system variable TEMP.
The Profiler uses the location specified for the TEMP system variable.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Explain about the command line tool SQLCMD ?

Next > : How will you copy the structure of a table without ...

Comments or Responses

More Interview Questions by Bharathi Cherukuri

How will you copy the structure of a table without copying the data ?
What are the differences between const and readonly keywords ?
Do interface have accessibility modifier ?
In what instances you will declare a constructor to be private ?
How do you split a string based on a character without using string.sp ...
Can an object be instantiated using const keyword?
What are the drawbacks of collections in .net ?
What is the ideal size of a cookie ?

Latest Interview Questions

In what are the different ways a WCF Metadata can be accessed ?
Where the #Table is stored???
Which is the base class of all validation controls in asp.net ?
Validation Controls in Asp.Net are available in which namespace ?
Define Stored Procedure with Example?
How to load an Object(Image, Document,... Etc.,) into SQL Server Table ...
How to Alter constraint in sql server?
Can you drop a Parent Table with out affecting its child tables?
More ...