This is great information everyone! Thanks!!

To go beyond a few things here I will elaborate as to what I do do to keep busy.

1. Run Traces...hehe...gotten into a...

dma-669038 (4/15/2010)

---

Great article but in large environments you dont get to run/profile all stored procs at one shot(many times the application will not even call some procs depending on how...

If you want to get an idea of how sql syntax is laid out I highly recommend WinSQL by Synametrics[/u]. The trial version (14 days) allows you to use...

Whoa, Scott!!

I like your solution much better! It gives a nice little multi-line reply to the object your looking at.

Thanks!!

I highly respect the newbie but I also want you to know the risks of using tools that let you access system components you don't understand. I have used...

Lynn Pettis (12/1/2009)

---

Gift, he is trying to look at the code behind the system views which is not possible by right clicking on the view in the Object Explorer in...

I have to disagree with you on "clueless developers". The program, even the lite version, has been instrumental on helping not only me but many others not only learn...

Okay....got about 90% of what I was looking for. And here is how I got it.

Actually there are 2 different ways to do this.

1.

USE AdventureWorks

GO

Select...

Not to be rude but you didn't read my post on top of the screenshot....I said, "Here's a screenshot from WinSQL (the 3rd party program I hinted around)"

That is NOT...

Okay...I usually consider myself wrong but will investigate to make sure I'm not just misreading things.

Here's a screenshot from WinSQL (the 3rd party program I hinted around). I highlighted...

Okay...newb mistake on my part. :blush: It has something to do with rights/permissions I don't have.

I was able to drill down to the View section on my test machine(with SS2k5...

I'm sorry. I was rather vague in my question. :ermm:

The DDL (data definition language) of a "View". Hope that makes more sense.

Yeah, heh...funny you mention the quality code control focus. One of my other primary jobs is to review submitted code by field programmers to make sure it meets our...