Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.
SQL Server Interview Questions and Answers – Introduction
Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.
SQL SERVER – 64 bit Architecture and White Paper
In supportability, manageability, scalability, performance, interoperability, and business intelligence, SQL Server 2005 provides far richer 64-bit support than its predecessor. This paper describes these enhancements. Read the original paper here. Following abstract is taken from the same paper. Another interesting article on 64-bit Computing with SQL Server 2005 is here.…
Read MoreSQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.
Some errors never got old. I have seen many new DBA or Developers struggling with this errors. Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection. Fix/Solution/Workaround: Change the Authentication Mode of the SQL server from “Windows Authentication Mode (Windows Authentication)”…
Read MoreSQL SERVER – Script to Find SQL Server on Network
I manage lots of SQL Servers. Many times I forget how many server I have and what are their names. New servers are added frequently and old servers are replaced with powerful servers. I run following script to check if server is properly set up and announcing itself. This script…
Read MoreSQL SERVER – 2005 – Disable Triggers – Drop Triggers
There are two ways to prevent trigger from firing. 1) Drop Trigger Example: DROP TRIGGER TriggerName GO 2) Disable Trigger DML trigger can be disabled two ways. Using ALETER TABLE statement or use DISABLE TRIGGER. I prefer DISABLE TRIGGER statement. Syntax: DISABLE TRIGGER { [ schema . ] trigger_name […
Read MoreSQL SERVER – Fix : Error: 3902, Severity: 16; State: 1 : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
SQL Server Integration Services Error : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (Microsoft OLE DB Provider for SQL Server) Fix/Workaround/Solution: Option 1: To work around this problem, do not call the stored procedure by using ODBC Call syntax. You can call the stored procedure in may ways…
Read More