SQL2008

08/02/2012 00:11 aidan82#1
Can anyone point me in the right place for SQL Server Management Studio Express and SQL 2008 plz

Im using Windows 7 i've download 4 diff 1's and none seem to be working.
08/02/2012 00:13 iDarky#2
32bit or 64 ?
08/02/2012 00:17 aidan82#3
32bit the problem i have is that im using SQL 2008, but cant seem to fine server manager 2008
08/02/2012 00:20 PortalDark#4
[Only registered and activated users can see links. Click Here To Register...]
thats the official link for it
08/02/2012 00:26 aidan82#5
Cheers that helps alot now :)
08/02/2012 01:09 CrazyGirL_ZSZC#6
Quote:
Originally Posted by aidan82 View Post
Cheers that helps alot now :)
remember , if u downloaded SQL SERVER 2008 ( R2 ) the Studio management must be R2 too , there is 2008 and 2008 R2
08/02/2012 01:44 aidan82#7
I have SQ 2008 and management 2008, but having loads of problems installing them lol

Im getting this error now

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'AIDANSMITH-PC'. (Microsoft.SqlServer.SmoExtended)

For help, click: [Only registered and activated users can see links. Click Here To Register...]

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)

For help, click: [Only registered and activated users can see links. Click Here To Register...]

I dont understand this as im using SQL SERVER 2008 ( R2 ) version 10.50.1600.

Can anybody advise me on what im doing wrong?
08/02/2012 13:59 kevin_owner#8
Well you probably installed too many sql server and forgot to uninstall a sql 2008 version.

sql 2008 = Version 10.00.1600
sql 2008 R2 = Version 10.50.1600

You say you have 2008 R2 installed so you probably have selected the wrong sql instance.