Two thinsg to note:

1) I too had trouble with the DROP Table statement until I used the slanted quotes.  I accidentally discovered that I could also use Brackets to get...

A big thanks to all who have responded.  The situation I describe is unfortunately something I have no control over but still have to work with.  In this scenario the...

..When I refer to SQL, I am referring to the set based SELECT, UPDATE, INSERT, DELETE statements.  When I refer to T-SQL being replaced by CLR, I am referring to...

Straegen, I believe that you recieved the responses you did because your first few posts indicated that you believed that T-SQL was headed for the grave in it's...

David,

You say that dropping the support for the WHERE clause is breaking away from the ANSI standard.  It is the ANSI standard that has pshed the move to using the...

Thanks to both of you for your response.  Let me ask you both this and if anyone else owuld like to chime in then please do so.

If I have a...

I'm inclined to believe that it's not just a fluke that we both have the same problem after installing the Beta.  I'm puttinig my money on their being an issue...

Kenneth, #1 is the technique that I was also recomending.  I was just also pointing out the crwabacks to it; flattening the data.  In the long ruin this is just...

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...