Reputation
541
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
3 7 22
Impact
~57k people reached

  • 0 posts edited
  • 0 helpful flags
  • 33 votes cast
Dec
12
comment SQL Server Profiler behavior?
If you don't select the event, that event isn't captured or sent that helped. So if i do not select to monitor sp's , sql server will not throw events for sp's right? ( i dont care about who is catching those event , i just care if sql throw events of sp's)
Dec
12
comment SQL Server Profiler behavior?
After an event occurs, if the event class has been included in a trace definition... trace definition can contain (or not) event to listen. but does the event source EMITS IT at first place ?
Dec
12
comment SQL Server Profiler behavior?
@ThomasStringer I didnt understand from it if it emits all event from event source !
Dec
12
asked SQL Server Profiler behavior?
Dec
12
accepted Get the windows account which runs the query?
Dec
12
awarded  Editor
Dec
12
revised Get the windows account which runs the query?
added 47 characters in body
Dec
12
comment Get the windows account which runs the query?
@RemusRusanu it is from a paper not a board. :-) but thanks
Dec
12
comment Get the windows account which runs the query?
I need to tell the IT manager : "please grant access to ____" . Is three any select account which shows me the value of "______" ?
Dec
10
comment Get the windows account which runs the query?
will the 'whoami' result and the service account will always be the same ?
Dec
10
comment Get the windows account which runs the query?
Thank you ( as always).
Dec
10
asked Get the windows account which runs the query?
Dec
7
awarded  Popular Question
Dec
4
comment Separate stored procedures for inserts and updates?
Sorry ! of yours ! (InsertOrUpdateYourTable )
Dec
4
comment Separate stored procedures for inserts and updates?
isnt the first query of mine is quicker ?
Dec
4
comment Separate stored procedures for inserts and updates?
Thank you very much Martin.
Dec
4
accepted Separate stored procedures for inserts and updates?
Dec
4
comment Separate stored procedures for inserts and updates?
Can you please elaborate how upsert will look like ?
Dec
4
comment Separate stored procedures for inserts and updates?
@MartinSmith it could be IDENTITY - but then , it will be used for : scope_ident ( for insert) , or by id (for update).
Dec
4
comment Separate stored procedures for inserts and updates?
@ypercube Thanks for helping :-)