Yes, I get 3.4 under 2005 SQL Server Mgt Studio too, but I am running beta 2. I didn't know Beta 3 was out there yet?

Well, well, well. A nicely written article that makes tons of sense. Recently I have had to write some complex T-SQL conversion scripts with multiple batches and a lot of...

Oh man, this is automatic: all objects should be owned by dbo. I've been fortunate enough to have all my projects this way.

Although I have to disagree with the statement that T-SQL is a weak language (if it's so weak, then why has it afforded my family and I a great living...

Trick questions like this certainly do not belong here, agreed. On the other hand, I certainly learned something today... never to use this unheard of, hidden, undocumented piece of garbage...

Also, there is no Program_Name column in my output of sp_who, which answers A, B, & D showed.

Nice article for sure. It just makes plain sense to tackle these questions and get good advice from others before making a major decision to switch jobs. The reasons you...

As usual, nice article Steve. I've read other articles and explanations of showcontig and still came away confused, but this puts it into a more clear light. I also have...