Consider the following scenario in Microsoft SQL Server 2005 Reporting Services. You use SQL Server Business Intelligence Development Studio to create a report model project. In the report model project, you create a data source against a SQL Server 2005
Read More...
Created a sample code. == It has the ConnectionLifetime attribute in the connection String set to 10 secs. == Now in the code, i'm having a loop which will open the connection, executes a statement. == Waits for 15 secs and then closes the connection.
Read More...