Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Is SQL Server Express enough ?

Author  Topic 

varunprasadyg
Starting Member

3 Posts

Posted - 2013-09-23 : 09:47:42
Hello All,

I have SQL Server 2008 R2 installed on my office laptop.
But I am very new to SQL Server 2008 as such I want to practice on a sample database on my own.

I am thinking of installing SQL Server Express Edition.

a) Will I be able to create stored procedures in this express edition ?

b) Will I be able to use SQL Server Management Studio in this express edition ?

c) Will I be able to install express edition on a laptop without affecting the existing Windows 2008 R2 ?

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-09-23 : 09:57:17
quote:
Originally posted by varunprasadyg

Hello All,

I have SQL Server 2008 R2 installed on my office laptop.
But I am very new to SQL Server 2008 as such I want to practice on a sample database on my own.

I am thinking of installing SQL Server Express Edition.

a) Will I be able to create stored procedures in this express edition ? YES

b) Will I be able to use SQL Server Management Studio in this express edition ? YES. Servername would be .\SqlExpress. If you don't already have Management Studio, install Express with tools or Express with advanced services, each of which includes Management Studio

c) Will I be able to install express edition on a laptop without affecting the existing Windows 2008 R2 ? YES

Go to Top of Page
   

- Advertisement -