Monday, 26 October 2015

Elevate permission on a SQL login having read only access to Execute Stored Procedures and to View Database Schemas

›
Due to an unavoidable situation, it was decided that all the write access to a particular server (SQL Server) was required to be removed imm...
Saturday, 17 October 2015

Elevate permission on a SQL login having read access to run the SQL Profiler

›
Sometime it’s necessary to allow SQL logins only to have read access to the respective SQL Servers. But it becomes a necessity to allow the ...
Wednesday, 3 June 2015

Error occurs when CTE Alias is ‘RESULT’ - Incorrect syntax near 'RESULT'

›
Few days back one of my colleague ran into a very strange issue when he was asked to do an alteration to an existing procedure. The procedur...
Wednesday, 20 May 2015

Conflict in log4net on GAC when a Crystal Report is viewed through .Net Code

›
We faced an issue sometime ago, which put us into a very tight situation. The issue was when a Crystal Report file is loaded through .Net co...
1 comment:
Monday, 5 November 2012

Create a Cursor using Dynamic SQL Query

›
Even though we are advised not to use or to minimize the usage of cursors in SQL, there are times which, it’s the only available option, dep...
4 comments:
Wednesday, 19 September 2012

Introduction to SSDT (SQL Server Data Tools)

›
What is SSDT ? SQL Server Data Tools (SSDT) is a toolset which provides an integrated environment for database developers to carry out all ...