Microsoft Technology

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...

Microsoft SQL Server Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices....

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)....

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...

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...

Risk and Health Assessment Program includes all of the scoping tools necessary to prepare and qualify your environment to receive a Risk and...

When SQL Server Reporting Services ( SSRS ) Report is viewed in Report viewer control in Firefox Browser, it won't display properly. B...

The Following Query Helps you to list out all the table available in a database along with it’s(table’s) count select object_name ( id ) ...

Microsoft SQL Server has been continually improving its Java connectivity support. As such we highly recommend you work with the latest vers...