| Author |
Topic |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
 Posted - 2006-08-18 : 04:30:07
|
| I recently (some weeks ago) posted a query to parse the log files of SQL server with the help of an undocumented function that started with "::". I remember I got at least one follow-up posting.I need to find that query.Peter LarssonHelsingborg, Sweden |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-08-18 : 05:17:28
|
luckily i saved your query  select * FROM ::fn_dblog (DEFAULT, DEFAULT) l join sysobjects so on so.name = l.[transaction name] i think this is it...Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-18 : 05:30:31
|
| Yes! Great work Mladed. Thanks.Peter LarssonHelsingborg, Sweden |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-18 : 11:54:06
|
| I search sqlteam with google. Just put "site:sqlteam.com" in the search ad that will limit all googling to just this site.-ec |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-18 : 12:40:10
|
| Strange that Google is better off searching SQLTeam, that SQLTeam itself...Peter LarssonHelsingborg, Sweden |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-08-18 : 13:17:29
|
| it's not "better" or "worse" it's "different" Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-18 : 13:24:12
|
| Google works better than http://support.microsoft.com as well. If you aren't finding what you want on the sites that you are doing the searches on, always check it with Google. There's a reason why they are number 1.Tara Kizer |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-15 : 05:50:19
|
| Now there is another post of mine I can't find.This was about creating parameters for VB and calling a stored procedure in SQL.Also there was the stored procedure for UPSERT.Anyone can find it? I can't. Have used inhouse search and google to no vail.Peter LarssonHelsingborg, Sweden |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-11-15 : 06:02:12
|
| I can't find my keys sometimes.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-15 : 06:22:23
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70783?? Doesn't satisfy the UpSert requirement, but then estate agents don't listen too closely to their customers requirements for a good reason!EDIT: In case relevant Google:site:sqlteam.com peso Parameters CreateObject inurl:"topic.asp"Kristen |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-15 : 06:36:42
|
| Thanks!I have tried with "site:sqlteam.com createparameter peso" before but it doesn't work anymore.Hmmm... I have forgotten I shortened the sql code down...Peter LarssonHelsingborg, Sweden |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-11-16 : 05:49:48
|
quote:
I can't find my keys sometimes.
LMAO - Merkin you're wicked! More seriously you obviously haven't Googled for them - http://www.google.co.uk/search?sourceid=navclient&ie=UTF-8&rls=GGLG,GGLG:2006-14,GGLG:en&q=my+keysNot sure the first hit is right as its blocked here but the second one (the video) may solve the problemWhen I tried to make this a link as it didn't like the "keys", maybe that's why you can't find them  (had to let it work out for itself)steve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
|
I can't find a post of mine