Wednesday, 11 April 2012

Resolved ~ How to get back SSMS ‘Find and Replace’ Alert

›
  As you know in SQL Server Management Studio (SSMS), once you have cleared the check box value of ‘Always show this message’, from the ‘Fi...
1 comment:
Thursday, 8 March 2012

Locks and Duration of Transactions in MS SQL Server

›
  It is a common argument which I hear among developers these days, regarding SQL locks. Some say that the ‘locks are held for the duration...
2 comments:
Monday, 16 January 2012

Exclusive access could not be obtained because the database is in use ~ Resolved

›
  Sometimes this is a common error message that we encounter, when we try to restore a SQL database, which is being used by other users. ...
10 comments:
Friday, 25 November 2011

Deploy/Use assemblies which require Unsafe/External Access with CLR and T-SQL

›
  What is an Unsafe Assembly? Assemblies which are built using normal computational functions are considered as safe assemblies. But when ...
5 comments:
Tuesday, 22 November 2011

Using CLR functions with T-SQL

›
Why use CLR? Before using CLR, you should question ‘Why’. When using CLR functions within T-SQL, you have to maintain two different progra...
Tuesday, 9 August 2011

Change the data source of a Crystal Report at Run-time using C#

›
It’s a known fact, that in Crystal Reports, if you try to display details, using data in a SQL Server Database other than the one that you’v...
7 comments:
Monday, 8 August 2011

Invoke a custom method when Crystal Report Viewers’ print button is clicked / Add custom button to Crystal Report Viewer Toolbar

›
If you are developing applications which includes reporting with Crystal Reports, you may have noticed that it’s not possible to invoke a cu...
3 comments:
Friday, 5 August 2011

How to insert data using SQL Views created using multiple tables

›
A view can be defined as a virtual table or a stored query and the data accessible through a view is not stored in the database as a distinc...
6 comments: