SQL 2005

Error:

Step 1:

                Right-Click on the Project in the Solution Explorer and select Properties.

Step 2:

I have been using Service Broker recently and found it exciting and useful. It seems like a cool feather in SQL Server. I use the SQL Dependency class in my .Net Windows Service to listen for the Service Broker Notification. When there is an Insert to the tables in my database the Service Broker sends me a Notification which alerts my Windows Service Application to Query data from the table and do the processing. It works very well.

How to check if Broker Service is enabled in SQL Server?

To Verify if the Broker Service is enabled on SQL Database, run the following Query:

I am trying to run Queries in MS SQL Server  and it comes up with errors if I specify table names or column names in a different case. The query is case-sensitive….!!!!

If you are using the SQLCMD utility and want to avoid or suppress the column header in the output of SQL Script.

Using SQL Reports is Fun. I have been having fun using it recently. It’s pretty cool. 
Wanted to figure out how to disable the Export Options in the SQL Reports when it is displayed to the user in Report Viewer. To be more specific I wanted to disable exporting in .pdf format. After looking around for it found  out it can be done in the rsreportserver.config file. 

Error: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'xxx'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors Solution: If you happen to get the above Error while using Reporting Services, do the following to get a more detailed Error Description. Note: Option 1 and 2 works for both SQL server 2005 and 2008, but option 3 is only for SQL Server 2008 Option 1: Make changes to the ConfigurationInfo Table