Viewing 15 posts - 15,301 through 15,315 (of 19,564 total)
Tom.Thomson (4/5/2010)
dma-669038 (4/5/2010)
http://www.surveymonkey.com/s/HLR8V5S
I have tried to include the topics we have discussed here. Please post some feedback on verbage etc before we send it out to all (or...
April 5, 2010 at 8:05 pm
halifaxdal (4/5/2010)
I am going to send the result as email attachment in certain period, is it possible to make...
April 5, 2010 at 7:57 pm
Lynn Pettis (4/5/2010)
Jeff Moden (4/5/2010)
ritu.thatola (4/5/2010)
Jason,I don' know the SQL well.
Hmmmm... then why did they select you to resolve this particular problem? You need to read the writing on...
April 5, 2010 at 7:55 pm
Lynn Pettis (4/5/2010)
April 5, 2010 at 7:49 pm
Capitalization of SQL Server should be consistent throughout.
I think I would also reword the questions that say "this certification" to " a middle tier certification."
Some verbiage at the beginning to...
April 5, 2010 at 7:46 pm
dma-669038 (4/5/2010)
April 5, 2010 at 7:26 pm
WayneS (4/5/2010)
CirquedeSQLeil (4/5/2010)
I would also enjoy neural computing. I could get a lot more done just by thinking it.Seems like a foolish risk. 😛
That depends on what it is...
April 5, 2010 at 7:25 pm
ritu.thatola (4/5/2010)
I have to rewrite the query for SQL server 2005
when I try to run this sql in SQL...
April 5, 2010 at 7:18 pm
WayneS (4/5/2010)
CirquedeSQLeil (4/5/2010)
dma-669038 (4/5/2010)
WayneS (4/5/2010)
April 5, 2010 at 6:29 pm
The hostname can also be returned back into this query. That information is returned by fn_trace_gettable.
This would change the query as follows:
SELECT I.NTUserName,I.loginname,I.SessionLoginName,I.databasename,Min(I.StartTime) as first_used
,Max(I.StartTime) as last_used,S.principal_id,S.sid,S.type_desc,S.name,EC.client_net_address,I.HostName
FROM sys.traces T...
April 5, 2010 at 6:27 pm
dma-669038 (4/5/2010)
WayneS (4/5/2010)
dma-669038 (4/5/2010)
WayneS (4/5/2010)
dma-669038 (4/5/2010)
April 5, 2010 at 6:17 pm
ritu.thatola (4/5/2010)
I couldn't get your comment "Just make changes as appropriate to the commented section. "
It would be great If you can rewrite the whole query. I don' know...
April 5, 2010 at 6:12 pm
WayneS (4/5/2010)
dma-669038 (4/5/2010)
April 5, 2010 at 5:59 pm
Viewing 15 posts - 15,301 through 15,315 (of 19,564 total)