Since we recently upgraded to SQL 2008, now I have some small tidbits that I can share! First one is this: Intellisense updating. In SQL 2008, it has built in Intellisense, pretty awesome. Until you add new objects, then everything is red underlined. What to do? Well if you are writing some T-SQL in SQL [...]
View Comments | 702 views
Finally getting around to doing some work on SQL 2008, and after about 3 minutes, I run into this error: “Saving Changes is not permitted.. blah blah blah” See screenshot below. This is different than SQL 2005. Microsoft maybe trying to save us from ourselves? The thing is, I never “enabled the option Prevent saving [...]
View Comments | 1,521 views
Here is a tip about a setting that I think should be on by default, but it isn’t. How many times are you writing T-SQL in SQL Server Management Studio (SSMS) and you need to just copy the results out, paste to Excel and either do more analysis or send off to someone. What happens [...]
View Comments | 3,513 views
