Actually there is a piece of code that will show Stored Procedure dependencies and its available at this website.  The name of the SP is funProcWithoutComments and you can...

I’m curious as to how those who have posted comments stating that the current implementation of the Employee-Job relationship is a bad would change the database or do differently...

You can use SQL's built-in DateTime functions to extract various date values such as Year() which will return the 4 digit year of a date.  In your case your date...

I apolagize for not having the complete code for this but I don't have much time this morning while my internet is still up and I'm trying to handle as...

No method of securing digital material will remain secure.  At some point all security technologies will be hacked period!  It is only a matter of when not if.  Because of...

Jamie, I'm not doubting what you are describing has happened to you but I find it odd that when I try to duplicate this I am unable to produce the...

I also come from a mixed background with experience in both programming (primarily in VB) and SQL (Specifically SQL Server 7 & 2000) and I see the CLR integration as...

My company produces accounting software for a specific industry.  Often our clients have multiple database's because the government or some other legal entity has one or more regulations requiring this...

Nothing in this world is free.  SQLServerCentral's method of dealing with advertising in the way it has is the best compromise I have ever seen.  If there are those who...

Brian,

   I can't find the words to thank you enough for the links to the motivational articles at dexterity.com .  The techniques provided in these articles will greatly help me...

Julian,

   Curiosity question. 

   It is my opinion, based on reading from numerous sources, that it is very important that the database be properly structured for optimal performance and that...

Journeyman,