Author |
Topic |
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-04 : 20:53:41
|
As i browse this great forum sometimes i see people mention undocumented SQL sproc or something else.the latest was xp_execresultset, which executes the resultset of a SQL statement. this particular one is way cool and can really be helpfull, so i was wondering how do you people find this undocumented stuff??is there a super secret database that only the chosen ones can see or something else??because i think many tasks could be eased by knowing that.so if anyone wants to share their knowledge (what am i talking about of course you do )...Go with the flow & have fun! Else fight the flow |
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-04 : 22:35:17
|
We hang around here a lot. Another good way to learn is just mess around with all the commands. See what they do. Do this on your own box of course. It's definitely not recommended for production. MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-09-05 : 03:23:09
|
Some of the procedures can be found in the master database.It's a learning experience to to look through the ms procs,I sometimes just use sp_helptext on the interesting proc to see the code.( won't work for xp though )Profiler is also an asset when you want to see how some software solves a particular problem.xp_execresultset was cool though , and I had never seen that before!rockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-09-05 : 07:22:51
|
The Ken Henderson Guru Guide books are bibles for undocumented SQL Server stuff (as well as all sorts of other goodies). Get them in the Store.Damian |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-05 : 08:09:16
|
Try searching for"sql server" undocumentedin google.Note being undocumented is a meaningful state. Although they may be fun you should be cautious about ever releasing anything that relies on them.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-05 : 12:03:31
|
great!! thanx guys.i guess it's time to play... and yeah i know not to put anything in production based on undocumented stuff...but it sure would be interesting though... Go with the flow & have fun! Else fight the flow! |
|
|
kselvia
Aged Yak Warrior
526 Posts |
Posted - 2004-09-05 : 16:48:15
|
I think I was the one who mentioned xp_execresultset - which I learned from Corey here! Following Corey's his link above led me to recall a puzzle that I added a few comments to that might be of interest. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37378--KenI want to die in my sleep like my grandfather, not screaming in terror like his passengers. |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-09-05 : 19:38:53
|
quote: Originally posted by kselvia I think I was the one who mentioned xp_execresultset - which I learned from Corey here! Following Corey's his link above led me to recall a puzzle that I added a few comments to that might be of interest. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37378--KenI want to die in my sleep like my grandfather, not screaming in terror like his passengers.
Ken - about halfway down this link: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38638, jeff does something pretty cool with updates and variables. I tried to apply that to your previous puzzle. It didn't work like i wanted it to, but I have a revised solution all the same Corey |
|
|
kselvia
Aged Yak Warrior
526 Posts |
Posted - 2004-09-05 : 20:02:50
|
Yeah, I saw Jeff's code the first time it came through. I boggled at it and couldn't wait to find a use for it. I'm sure I will sooner or later :)--KenI want to die in my sleep like my grandfather, not screaming in terror like his passengers. |
|
|
|