Wednesday, 20 January 2016

Error accessing Oracle Database Objects via Linked Server in SQL Server (The OLE DB provider "OracleOLEDB.Oracle" for linked server reported an error. Access denied.)

›
In one of the project we are working these days, there was a requirement to fetch some details, directly from the Oracle Database via VIEWS...
Wednesday, 25 November 2015

Analyzing SQL Server Error Logs / Agent Logs using T-SQL

›
Even though you design our SQL Scripts with the best methods using best practices, or configure the SQL Server to perform correctly and in ...
Sunday, 22 November 2015

Enabling Instant File Initialization in SQL Server

›
Technorati Tags: MicroSoft SQL Server Every time the SQL data file or log file expands, it fills the newly allocated (expanded) space with ...
Thursday, 19 November 2015

Capturing and Analyzing deadlocks in SQL Server

›
Technorati Tags: SQL Server , SQL Deadlocks , Capture SQL Server Deadlocks No matter how perfect your code and how optimized the way you ha...
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: