Archive for the ‘ SQL Server ’ Category

Get List of Tables Present in SQL Server Database

Today I have to get a list of all tables present in database. I used following query to get the list of all tables present in SQL Server Database.


Expert SQL Server 2008 Development

Backup And Restore Database SQL Script for SQL Server

Its a very common task to backup and restore SQL Server databases. SQL Server Management studio offers a GUI for performing backup and restore but following queries would be very useful for backup and restore if you are not having access to SQL Server Management Studio

Backup Script

BACKUP DATABASE  database_name  TO DISK = ‘C:\example.bak’ WITH FORMAT;

Restore Script


Microsoft SQL Server 2005 developer’s guide

Recently i started working on SQL Server 2005  development and developing applications using SQL Server 2005. Microsoft SQL Server 2005 Developer guide help me a lot and might be useful for others also. most importantly this book can use without any cost (web version). If you want a local then you should purchase a copy of this book.

Download SQL Server 2008 Service Pack 1

Microsoft SQL Server 2008

Microsoft has released the first service pack of SQL Server 2008. Service pack 1 is available in following languages Chinese, English, French, German, Italian, Japanese, Korean, Portuguese, Russian and Spanish. SQL Server Service Pack 1 fixed all the issues that are affecting the stability and impacting SQL Server 2008. For a list of the bugs that are fixed in SQL Server 2008 Service Pack 1, see KB article 968369. The following KB articles highlight some of the known issues that are important to read before you upgrade SQL Server 2008.

What’s New in Service Pack 1

The following features are new in Service Pack 1.

  • Slipstreaming is an installation method that integrates the base installation files for a program with its service packs and enables them to be installed in a single step. You can slipstream a SQL Server 2008 update and the original installation media so that original media and the update are installed at the same time. The update setup documentation available from the Download Center has the most recent description of the slipstream process. The update setup documentation is also available at MSDN.
  • You can uninstall SQL Server 2008 cumulative updates or service packs from Programs and Features in Control Panel. For more information, see “Overview of SQL Server Servicing Installation” in the update help file.
  • SQL Server 2008 Service Pack 1 provides a ClickOnce version of Report Builder 2.0. Report Builder is available for use in Reporting Services (SSRS) installed in native or SharePoint integrated mode. If SSRS is installed in SharePoint integrated mode, you need to install the add-in, Microsoft SQL Server 2008 Report Builder 2.0 ClickOnce for SharePoint, to make Report Builder 2.0 ClickOnce available from a SharePoint site. For more information, see the Report Builder 2.0 ClickOnce for SharePoint Readme.

Download SQL Server Service Pack1

Microsoft SQL Server JDBC Driver 2.0

Microsoft has released a new Java Database Connectivity (JDBC) driver. The SQL Server JDBC Driver 2.0 download is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000, SQL Server 2005, and SQL Server 2008 from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5.
This release of the JDBC Driver is JDBC 4.0 compliant and runs on the Java Development Kit (JDK) version 5.0 or later. It has been tested against all major application servers including BEA WebLogic, IBM WebSphere, and JBoss.

System Requirements

  • Supported Operating Systems: HP-UX; Linux; Solaris; Unix; Windows Server 2003 Service Pack 2; Windows Server 2008; Windows Vista Service Pack 1; Windows XP Service Pack 3
  • Java Development Kit: 5.0 or later
  • SQL Server 2008 or SQL Server 2005 or SQL Server 2000

Microsoft SQL Server JDBC Driver 2.0