Category Archives: SQL Server

Things to know when Installing SQL Server 2008 R2 side by side with SQL Server 2008

Posted on by
Reply

If you are planning to install SQL Server 2008 R2 as an additional Instance on a machine where SQL Server 2008 exists, then you have to keep in mind some implications. Though nothing fatal might occur in the first place, but there would be some changes depending on what settings / features that are selected while Installing SQL Server 2008 R2. 

When installing the first instance of 2008 R2, you would come across the below warning message. The message indicates that the Shared Components will be upgraded to SQL Server 2008 R2.

What this means to you is, when you are done performing the installation, the shared components of SQL Server 2008 will not be available any more. Some of the shared components include.. SSMS, BIDS, Profiler, Integration Services, SQL Server Browser etc..

To avoid this scenario, the way out is not to choose Shared Components in the Installation step where you select the features list, that way SQL Server 2008 R2 instance will be installed but the shared components will still be of version SQL Server 2008.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post

– Bru Medishetty

Create Linked Server to connect to a SQL Server Part – II

Posted on by
Reply

This blog is Part-II of last week’s blog post Create Linked Server to connect to a SQL Server Part – I. In this blog we shall learn two more ways of creating a Linked Server for a SQL Server destination.

In the first part, we saw how to create a Linked Server using graphical interface from SSMS. In that method, we created linked server by selecting Other data source as Server type. In this method of creating Linked Server, we shall choose SQL Server as Server type and know more details about what is the difference when creating this way.

When creating Linked Server in this way, keep in mind that Linked Server name we are going to enter in the text box should be the same as the target SQL Server. If the target SQL instance is a named instance, you should be entering the full instance name as Servername\Instancename.

Security and Server Options in this method is same as as we saw in the first part of this  blog, so I am avoiding explanation of those steps in this blog. Once you are done, choose OK to create the Linked Server.

Using T-SQL

You can also create a Linked Server using system stored procedure sp_addlinkedserver. Below screen shot shows the script that I used to create a linked server using the system stored procedure sp_addlinkedserver. 

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

–Bru Medishetty

Setting Database Compatibility Level for SQL Server 2012

Posted on by
Reply

In this blog we shall look at 2 ways to set a database to compatibility level for SQL Server 2012. The Compatibility level for SQL Server 2012 is 110.

Using graphical interface in SSMS

The first method we are going to learn is from SQL Server Management Studio. Connect to the target SQL Server, inside SSMS, expand the SQL Server in Object Explorer and expand the databases node. Right click on the Database for which you would like to change / set the compatibility level

Once the database properties box is displayed, in the left side pane, select Options Page and the database options are displayed as shown below. Then in the right side of the properties box, there is a field Compatibility level (3rd from top), from the drop down list corresponding to Compatibility level choose SQL Server 2012 (110) and click OK button.Using T-SQL

Using T-SQL the same task can be achieved by running ALTER database command and Set the Compatibility_level property to 110 as shown in the below script. Remember to change the  database name with your database name.

ALTER DATABASE LearnSQLWithBru SET COMPATIBILITY_LEVEL = 110
GO

Once you have set the compatibility level, you can check if the changes have been applied by running the below script. Alternately you can check this by looking at the database properties (from object explorer).

SELECT NAME, COMPATIBILITY_LEVEL FROM SYS.DATABASES WHERE
NAME = 'LearnSQLWithBru'

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

–Bru Medishetty