Click here to Skip to main content
15,904,926 members
Home / Discussions / Database
   

Database

 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pin
jojoba20117-May-12 17:37
jojoba20117-May-12 17:37 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pin
JohnPayton7-May-12 18:10
JohnPayton7-May-12 18:10 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen8-May-12 0:17
professionalEddy Vluggen8-May-12 0:17 
QuestionRe: Read LFD(log ) file SQLserver 2008 Pin
jojoba20119-May-12 17:52
jojoba20119-May-12 17:52 
AnswerRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen10-May-12 0:07
professionalEddy Vluggen10-May-12 0:07 
QuestionRe: Read LFD(log ) file SQLserver 2008 Pin
jojoba201111-May-12 17:28
jojoba201111-May-12 17:28 
AnswerRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen12-May-12 0:45
professionalEddy Vluggen12-May-12 0:45 
QuestionRe: Read LFD(log ) file SQLserver 2008 Pin
jojoba201112-May-12 22:31
jojoba201112-May-12 22:31 
Thanks for reply!
I have create App. and trace everything in SQL but I cannot trace SP and ... that will call from C#.
I mean when i call SP in C# it doesnt trace.
<br />
//را یکبار اجرا نمایید SP این trace ابتدا باید برای فعال کردن<br />
           declare @TraceId int<br />
           -- create the trace<br />
           exec sp_trace_create @TraceId output, 0, N'C:\Temp\OurDemoTrace'<br />
           -- set event and columns to trace<br />
           exec sp_trace_setevent @TraceId, 12, 1, 1<br />
           exec sp_trace_setevent @TraceId, 12, 6, 1<br />
           exec sp_trace_setevent @TraceId, 13, 1, 1<br />
           exec sp_trace_setevent @TraceId, 13, 6, 1<br />
           -- start the trace<br />
           exec sp_trace_setstatus @TraceId, 1<br />
           -- check status for our trace<br />
           select value from fn_trace_getinfo(@TraceId) where property in (2, 5)<br />
           go<br />
              <br />

<pre lang="c#">sb.AppendLine("\nEventClass: " + ts.GetString(ts.GetOrdinal("EventClass")));
                            sb.AppendLine("NTUserName: " + ts.GetString(ts.GetOrdinal("NTUserName")));
                            sb.AppendLine("Command : " + ts.GetString(ts.GetOrdinal("TextData")));


modified 13-May-12 4:56am.

AnswerRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen13-May-12 4:08
professionalEddy Vluggen13-May-12 4:08 
QuestionRe: Read LFD(log ) file SQLserver 2008 Pin
jojoba201113-May-12 19:22
jojoba201113-May-12 19:22 
QuestionRe: Read LFD(log ) file SQLserver 2008 Pin
jojoba201115-May-12 5:11
jojoba201115-May-12 5:11 
AnswerRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen16-May-12 2:06
professionalEddy Vluggen16-May-12 2:06 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pin
JohnPayton22-May-12 19:18
JohnPayton22-May-12 19:18 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pin
Eddy Vluggen23-May-12 0:13
professionalEddy Vluggen23-May-12 0:13 
QuestionSee If Stored Proc Returns Data Pin
Kevin Marois3-May-12 10:51
professionalKevin Marois3-May-12 10:51 
AnswerRe: See If Stored Proc Returns Data Pin
Mycroft Holmes3-May-12 12:40
professionalMycroft Holmes3-May-12 12:40 
AnswerRe: See If Stored Proc Returns Data Pin
Eddy Vluggen4-May-12 0:01
professionalEddy Vluggen4-May-12 0:01 
AnswerRe: See If Stored Proc Returns Data Pin
Corporal Agarn7-May-12 7:21
professionalCorporal Agarn7-May-12 7:21 
AnswerRe: See If Stored Proc Returns Data Pin
vvashishta10-May-12 4:46
vvashishta10-May-12 4:46 
QuestionPlaying music on my end, with APIs of search engines Pin
Neha.prakash882-May-12 21:52
Neha.prakash882-May-12 21:52 
AnswerRe: Playing music on my end, with APIs of search engines Pin
Richard MacCutchan2-May-12 22:24
mveRichard MacCutchan2-May-12 22:24 
AnswerRe: Playing music on my end, with APIs of search engines Pin
Eddy Vluggen4-May-12 0:04
professionalEddy Vluggen4-May-12 0:04 
GeneralRe: Playing music on my end, with APIs of search engines Pin
Neha.prakash884-May-12 0:19
Neha.prakash884-May-12 0:19 
SuggestionRe: Playing music on my end, with APIs of search engines Pin
Eddy Vluggen4-May-12 0:26
professionalEddy Vluggen4-May-12 0:26 
GeneralRe: Playing music on my end, with APIs of search engines Pin
Neha.prakash884-May-12 0:29
Neha.prakash884-May-12 0:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.