Alter-Rename SQL Server Database Using Management Studio or Query Hi friends, in this post we will learn how to Alter-Rename SQL Server Database Using Management Studio or Query. Sometime we have a requirement of changing database name, we can do it by two ways. Using SQL Server management studio and Query. We will demonstrate you both
How To Create Database in SQL Server Hi friends in this post, we will learn how to create database in SQL server. We can create database by two ways, in this post we will discuss about both ways in details. Create Database With SQL Server Management Studio: 1. Login into SQL Server Management Studio. 2.
Microsoft SQL Server System Databases In this post we will learn about Microsoft SQL Server System Databases. SQL Server includes the following system databases, every system database has its own importance and responsibilities. System Databases: master Database: Records all the system-level information for an instance of SQL Server. msdb Database: Is used by SQL Server Agent for scheduling alerts
Microsoft SQL Server Introduction In this tutorial, we will learn about Microsoft SQL Server Introduction, SQL Server is a Relational Database Management System developed by Microsoft. SQL Server primary function is storing and retrieving data through applications. Microsoft SQL Server comes in different editions: Enterprise, Buisness Intelligence, Standard, Web, Developer, Express Microsoft SQL Server Components
SQL Server 2012 Interview Question Answers Q: Difference Between DTS and SSIS. DTS SSIS DTS stands for Data Transformation Services 1.SSIS stands for Sql Server Integration Services DTS is a set of objects using an ETS tool to extract, transform, and load information to or from a database SSIS is an ETL tool provided by