Midtown Computer Systems Enterprise

Convenient web based access to our favorite computer related Usenet groups.
MCSE.MS is not affiliated with Microsoft corporation, Cisco corporation, Oracle, CompTIA or any other vendor.
Check our Computer Hardware forum | Cell Phones reviews

Go Back  MCSE > Microsoft software reviews > Microsoft SQL server reviews > Microsoft SQL Server Programming


Microsoft SQL Server Programming microsoft.public.sqlserver.programming

 
 
Thread Tools Display Modes
  #1  
Old 03-25-04, 09:27 AM
Peter
Store Procedure - Profile
Hello,

As I understand it there is an undocument store procedure
that moves a profile trace file on the hard disk to a
database table.

Can anyone shed any light where it is ?

Thanks
Peter
  #2  
Old 03-25-04, 10:23 AM
Sue Hoegemeier
Re: Store Procedure - Profile
There is a documented function in SQL Server 2000 that does
this. Check fn_trace_gettable in books online. You can find
an example of loading the trace file into a table in the
following article:
HOW TO: Programmatically Load Trace Files into Tables
http://support.microsoft.com/?id=270599

-Sue

On Thu, 25 Mar 2004 06:09:21 -0800, "Peter"
<anonymous@discussions.microsoft.com> wrote:

>Hello,
>
>As I understand it there is an undocument store procedure
>that moves a profile trace file on the hard disk to a
>database table.
>
>Can anyone shed any light where it is ?
>
>Thanks
>Peter


  #3  
Old 03-25-04, 11:25 AM
Peter
Re: Store Procedure - Profile
Thanks Sue, thats exactly what I wanted.

Peter


>-----Original Message-----
>There is a documented function in SQL Server 2000 that

does
>this. Check fn_trace_gettable in books online. You can

find[color=blue]
>an example of loading the trace file into a table in the
>following article:
>HOW TO: Programmatically Load Trace Files into Tables
>http://support.microsoft.com/?id=270599
>
>-Sue
>
>On Thu, 25 Mar 2004 06:09:21 -0800, "Peter"
><anonymous@discussions.microsoft.com> wrote:
>
procedure
>
>.
>

 


Popular forums
A+ (A Plus) Windows 2000 Active directory Exchange 2000 information store
Network+ Windows XP Security Exchange 2000 server administration
MCSE .NET Web services SQL Server
Cisco certification ASP .NET SQL 2000 Programming
Windows 2000 Registry .NET XML Viruses


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie: using asp.net 2.0 profile in an ASP.NET web service Navin MishraASP .NET 4 10-31-06 05:29 PM
Windows XP login profile Help needed signeedshelp1Windows XP Help and Support 1 10-31-06 05:06 PM
Unable to unlock restricted profile tdehoffShared Access of Microsoft Software 2 10-31-06 04:10 PM
How do I copy the Windows XP owner profile? Z HespeltWindows XP Accessibility 4 10-31-06 03:39 PM
new administrator profile ArnoldWindows 2000 General 7 10-31-06 03:08 PM


All times are GMT -5. The time now is 03:03 AM.


Powered by vBulletin Version 3.6.2
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Copyright MCSE braindumps 2003-2006