SQL Server- How to Upgrade SQL Server 2005 to 2008

SQL Server Upgrade from 2005 to 2008 While upgrading sql server from one version to another version like sql server 2005 to 2008, recommended to run the sql server upgrade advisor to find out if there is any issue before and after up-gradation of sql server database. We have two type of upgrade in sql server In ...

How to configure database mail in sql server 2005-08 1

Database mail services provides the good option of sending mail to client using SMTP server (Simple Mail transfer Protocol). In earlier versions of sql server this was known as SQL Mailing service which use MAPI(Messaging Application Programming Interface) for sending mails. Service broker need to be running in sql server 2005 for configuring the Database ...

Simple SQL SERVER view with example

What is sql server view ? Views are also known as virtual table in sql server that contain columns and rows. Multiple queries are combined together to define sql server view, it uses the data from one or more tables in sql database. We can insert data through view into table that you have seen ...

SQL Server – How to add column in table

For adding column in table of sql server, We can make use of alter table statement  i.e  alter table [tablename] add [columnname] datatype.  Here datatype could be anything like char, int, varchar, nvarchar that is purely depends upon data that will store in column. Lets take a scenario to understand how to alter table on UAT server. In ...

SQL Server – Move sql database to another drive 1

We can move sql server system database and user database to another drive, in case SAN disk is full then copy the sql server mdf and ldf to another drive that has more drive space. Sql server will not allow to move database files while online.  We have to put database offline and then only it ...