Microsoft Technology

Problem: Today I tried to install SQL Server 2005 Developer edition in my system. During the installation, it throws the given error: --...

For SQL Server 2005: 1 Clustered Index + 249 Nonclustered Index = 250 Index http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx ...

This Article, helps to start a windows services thru SQL Script. To control the windows services, we can use SQL Server’s Extended Stored P...

The SQL Server 2005 evaluation software is no longer available. Learn more about the enhancements and new features in SQL Server 2008. Re...

Microsoft has released a new Java Database Connectivity (JDBC) driver. The SQL Server JDBC Driver 3.0 download is available to all SQL Serve...

Microsoft SQL Server Native Client is DLL, it provides an access to the SQL Database. This DLL contains both the SQL OLE DB provider and SQL...

Problem: When I create a data source of my SQL Server, it throws the following error --------------------------- Microsoft SQL Server Log...

Here are the steps to uninstall SQL Server 2005 components manually. In Add or Remove Programs, uninstall all SQL Server 2005 components ...

When you create a Data Source in SQL Server Integration services (SSIS), there are default Data provider will be listings in the connection...

In our Project, we’ve created Trigger for generate the transactional log. This log will be updated, whenever new data has been “inserted” or...

What are the basic functions of master, msdb, tempdb databases? Microsoft SQL Server has four system databases:  Master - The master ...

What is Database Replication? It is a kind of Data Transformation Services and it is responsible for the process of copying/moving the dat...

What is a pass-through query? Microsoft SQL Server sends pass-through queries as un-interpreted query strings to an OLE DB data source. Th...

What is Cursor? Cursor is a SQL Objects and it is having Row by Row Scrolling behavior while processing on the result-set (Set of records)....

In My Previous post ( View in SQL Server ), I’ve mentioned that a table can be deleted even though it is associated with normal view. Also w...

What is View in SQL? View is a virtual table. it won’t occupies any memory space for the data. it is referencing to the other table like...

Recently I’ve posted about the topic Handling Error in SQL , in this link, I’ve explained, what is the simplest way to handle the error?  T...

How will you handle Errors in Sql Stored Procedure? SQL Provides a system variable named as @@ERROR , If any error occured in query execu...

A stored procedure is a set of Structured Query Language (SQL) statements that you assign a name to and store in a database in compiled for...

Indexes in DB are very similar to indexes in the books. It helps to search the data very quickly without scanning whole data in a table. Ind...