Tag: SQL Server 2008

“SQL Server 2008 Agent will not accept DatabaseMail (bug in feb ctp?)” or “How to activate DatabaseMail using stored procedures/regedit”

I wanted to set up some error notification for a SQL Server Agent job this morning on our SQL Server 2008 (February CTP 10.0.1300) installation. It's fairly straight forward. First you set up database mail using the configuration wizard. Next you set up your operators. Now comes the interesting part that I had to troubleshoot. … Continue reading “SQL Server 2008 Agent will not accept DatabaseMail (bug in feb ctp?)” or “How to activate DatabaseMail using stored procedures/regedit” →

Visual Studio Database Projects with SQL Server 2008 or ‘Why do I prefer Google Search?’

Ok, I'm going to mix some info with a little bit of remarks on search engines. First up, if you encounter an error when creating a Visual Studio Database Project with SQL Server 2008 telling you only version up to 2005 are supported, just download the Microsoft® Visual Studio Team System 2008 Database Edition GDR … Continue reading Visual Studio Database Projects with SQL Server 2008 or ‘Why do I prefer Google Search?’ →

SQL Server Reporting Services 2008 Tutorial in 5 Minutes or "How to send my boss a report from a view quickly"

Some facts: SQL Server Reporting Services were great in the past. SSRS 2008 are better. MSDN is great. MSDN has lots of details. Sometimes it's too much if you are under pressure. Google usually gets me the information I want faster. Especially when I need to get something done quickly. All in all this post … Continue reading SQL Server Reporting Services 2008 Tutorial in 5 Minutes or "How to send my boss a report from a view quickly" →