Archive | MS SQL SERVER 2008 RSS feed for this section
Generate script from Microsoft SQL Server Management Studio
From Microsoft SQL Server Management Studio right click on database, a pop up menu will appear. From popup menu select tasks > Generate Scripts. A new dialog box called Generate and Pub...
Another reason for getting the error “A network-related or instance-specific error occurred while establishing a connection to SQL Server…” in MS SQL Server 2008
Normally the reason behind getting the error – “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible....
Recursive queries in MS SQL Server 2008
Case 1: In human resource management system each employee is supervised by another employee. To do this I create a table where I assigned one employee with other by following ways. Employee ID Name Su...
Easy way to track the store procedure error in MS SQL SERVER 2008
You can easily trace all the errors of store procedure in MS SQL SERVER. To do this, first create a table called Error. CREATE TABLE [dbo].[Error]( [iAutoID] [int] IDENTITY(1,1) NOT NULL, [dErrorDate]...