Documentation of system SPs, UDFs, Tables and columns

Question

Post reply

Documentation of system SPs, UDFs, Tables and columns

maffan76

Ten Centuries

Points: 1256
More actions
January 7, 2004 at 12:31 am

#162938

Hi All,
Does any one know where to find the system SPs, UDFs,tables and columns etc. documentation so that useful admin scripts can be built for users/developers for doing some admin tasks.
Thanks in advance.
Kind Regards,
Affan

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 1

Books Online (BOL)

You can also search this site (sqlservercentral.com) for usefull scripts

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

Hey biker,

your avatar is also kinda cool! Although I prefer a Fireblade

Now, for the pseudo topic relation:

I think Andy Warren mentioned some time ago, he has some SQL Server table maps to share.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

maffan76 Ten Centuries Points: 1256 More actions · Answer 3

I dont think that BOL contains this kind of detail, if you know kindly mention the topic it will ease my search process. also does some one has those maps with him then kindly send me those. Andy can you share those maps.

I need some descriptive details of the system tables and columns.

Kind Regards,

Affan

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 4

- The avatar is my ntv650 easy riding with a bit of curves-fun.

The blade is like a wet dream with all these speedtraps they are implementing in Belgium(Flanders-part)

- Maybe this is what Affan is looking for :

http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

Send me a private message with you email address, so I can send you a html help file which describes the system tables.

The table map is a poster that you can pin to your wall.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Frank Kalis SSC Guru Points: 111183 More actions · Answer 6

Forgot to ask:

Are you on SQL Server 2000?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

slider SSC Enthusiast Points: 114 More actions · Answer 7

How can one obtain a copy of this printed poster? We'd like to get one or two for our Development offices.

kknudson SSCarpal Tunnel Points: 4986 More actions · Answer 8

There is also a downloadable systable.chm version of the system table map.

Don't remember where I got it, I assume off of MS somewhere.

KlK

Steve Jones - SSC Editor SSC Guru Points: 736183 More actions · Answer 9

Used to be able to buy one from MS on the MSDN site, but I can't find it. I'll check and see if I can get a resource.

willhaney Mr or Mrs. 500 Points: 596 More actions · Answer 10

The Systbl.chm can be found at:

http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp

Frank Kalis SSC Guru Points: 111183 More actions · Answer 11

Thanks, and yes, this one I meant.

Couldn't remember where I downloaded it

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

maffan76 Ten Centuries Points: 1256 More actions · Answer 12

Thanks everybody, finally i downloaded the CHM file and it contains the system tables MAP, but one slight comment that it does not contain too much illustration of the fields. but anyways it very helpful.

Kind Regards,

Affan

Frank Kalis SSC Guru Points: 111183 More actions · Answer 13

I got mine as incentive along with my subscription to SQL Server Mag.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Frank Kalis SSC Guru Points: 111183 More actions · Answer 14

Hehe, I know. One of the few things I like about Germany.

Sunday morning in the summer, the Autobahn 31 heading to Emden. Almost 40 kilometres straight with no curve. That's adrenaline pure. My high score was well below 10 minutes ...Ah those were the days when I wasn't married

Btw, don't tell me you haven't twisted your license plate

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]