Microsoft SQL Server, commonly referred to as simply "SQL Server," is the relational database engine developed by Microsoft. MS SQL Server 2008 was released on August 6th, 2008, and is major version 10 of the application.

learn more… | top users | synonyms

0
votes
4answers
2k views

Why I can't install SQL SERVER 2008 R2 EXPRESS on my laptop?

When I try to execute SQL SERVER X86 on my laptop...it appear a message...isnt a win32 application! What can I do?I really want to install the management studio.
4
votes
3answers
4k views

Problem with installing SQL Server 2008 SP2 on Windows XP

I'm not much of a super-user but I've been struggling with this issue for hours and I hope maybe someone here will know how to assist me. I've just installed SQL Server 2008 Developer, I've chosen the ...
12
votes
2answers
65k views

Run an SQL Query With a Parameter from Excel 2007

I have a query in an excel table. I followed this to do it. But how can I add a parameter from a cell into my query? I am looking for a way to do this select * from dbo.Customers where CustomerID ...
0
votes
0answers
769 views

SQL Server 2008 forgets my login and password

For some reason SQL Server 2008 (Management Studio) refuses to remember my username and password for a specific server instance even though I've checked "remember password" probably hundreds of times ...
2
votes
1answer
845 views

SQL 2008 installation on SSD

Can SQL 2008 Developer be installed on an SSD ExpressCard? The device is a Transcend 32GB ExpressCard. I'm getting the following error: The path E:\Program Files\Microsoft SQL Server\ is not on a ...
2
votes
2answers
17k views

Where do I run dbcc checkdb?

I was told to run dbcc checkdb on a Microsoft SQL server database. Exactly where am I supposed to run this? In the SQL Server Configuration Manager? If so, where do I actually type this command?
1
vote
1answer
924 views

How to save Windows credentials to a data source in SQL Server Reporting Services 2008 using Visual Studio

I am trying to create a shared data source for SQL Server Reporting Services 2008 that uses a specific Windows user ID and password to connect to the database. Using the Report Manager web interface, ...
0
votes
1answer
85 views

What processor would perform better on database queries?

Does anyone have any logical explaination why the same database SELECT query would run much faster on a Inten XEON W3503 than an AMD Opteron 2425 HE (six core) processor? Even when there are only ...
0
votes
1answer
11k views

SQL Server Express 2008 R2 Installation error at Windows 7

I created an install script that will install SQL Server 2008 R2 on Windows XP SP3, Windows Vista and Windows 7. One of the command that I used in the installation is for silent installation of SQL ...
2
votes
2answers
2k views

Restore T-SQL Editing in VS2010 after SQL Server 2008 R2 install

I was able to edit Database projects in my installation of VS2010 ultimate. However per project requirements I had to uninstall SQL Server 2008 and install SQL Server 2008 R2. Now I have lost the ...
1
vote
1answer
2k views

SQL Management Console can't find SQL Server Express 2008 R2 on MacBook Pro Bootcamp

After some problems with "landingpage.exe" errors and a bunch of reinstalls - I had a successful install of SQL Server 2008 R2 on my Macbook Pro 13" Bootcamp partition. SQL Server is showing as an ...
1
vote
3answers
2k views

Installing SQL Server 2008 on Windows Server 2008 R2

I'm currently trying to assist in the build out of our Company's app on a 64-bit server, as part of "re-upping" our partnership with Microsoft. To get us to the correct point level, we are trying to ...
5
votes
5answers
11k views

try to attach to a database file but can't browse folder which contains the file

I am trying to attach to database file (*.mdf, *.ldf) that I placed in the same folder as all my other SQL Server databases. I begin the attach by attempting to browse to the folder which contains the ...
0
votes
1answer
312 views

How do I configure SQL Server to allow other users to access a database?

Environment: Windows 7 Ultimate SQL Server 2005 Express 2 users on the computer I tried making the 2nd user a user in SQL Server (THINKPAD\2ndUser) and adding him to the database ("2ndUser"). ...
9
votes
2answers
15k views

SQL Server Management Studio Color Schemes?

Is there a way to apply color schemes and themes to SQL Server Management Studio? I really enjoy the ones for Visual Studio 2005/2008/2010 and would love to have something like that. Color Schemes ...
17
votes
5answers
13k views

Is it possible to open a sqlite database from within microsoft sql management studio?

Is there a way to open a .db file (sqlite database file) from within microsoft sql management studio? Right now we have a process that will grab the data from a microsoft sql server database and put ...
0
votes
6answers
1k views

sqlserver 2008 or 2005 express cannot install on Windows 7 home?

When installing 2008 it says it requires .NET 3.5 and 2005 fails : what can I do ?
1
vote
1answer
697 views

Help Installing SQL Server 2008 Express Edition

Ok I am running Windows 7, 64 bit. I cleaned of SQL server 2005 completely off my system leaving only SQL Compact Edition. I went here ...
0
votes
1answer
267 views

SQL-Server 2008 on a windows vista doesn't start

i have installed a SQL2008 Server developer-Edition on my Dell Precision M90 Notebook with windows Vista, but the service dosen't start. SQL Server Configuration Manager shows MSSQLSERVER as stopped ...
2
votes
4answers
1k views

Installing SQL Server Express 2008 on Windows Server 2008

Can I install SQL Server Express 2008 on a Windows Server 2008 or should I stick with the SQL Server Express 2005?
1
vote
2answers
216 views

SQL Server 2008 Express Install Location

MS insisted on installing this via the Web Platform Installer. Now I want to install it again, but I don't want to download it again. Any ideas wheere the install file is located, if anywhere?
1
vote
2answers
2k views

Start an SQL Server instance without SQL Server Management Studio

I took my SQL Server 2008 offline because I was trying to do something... Now I can't log in to it using SQL Server Management Studio anymore. "The server was not found or was not accessible." I'm not ...
1
vote
4answers
4k views

Copy a SQL Server 2008 database verbatim

I need to copy my entire SQL Server 2008 database including the schema and all data verbatim from one computer to another. How do I do that?
1
vote
5answers
8k views

I can't find SQL Server 2008 (or 2005) on my computer but it is installed

Can anyone tell me how I can find SQL Server on my computer? I downloaded MS Visual Web Developer 2010 Express. The MS Web Platform Installer 2.0 tells me that SQL Server is already installed on my ...
2
votes
1answer
2k views

Installing SQL server express 2008 SP1 on Windows 7

I'm installing (well trying to) SQL server express 2008 SP1 on Windows 7 This is not working for me. I started by installing VS2010 B2, it installed SQL 2008 Express. I went into the 'SQL Server ...
1
vote
2answers
8k views

Installing SQL Server Management Studio when VS2010 Beta 2 is already installed

This is driving me nuts -- I installed VS2010 B2 -- It installed SQLEXPRESS -- I went into the 'SQL Server Configuration Manager' and enabled the TCPIP protocol under 'SQL Server Network ...
1
vote
2answers
1k views

Can I install Sql Server 2008 on my windows home server

I would like to do more with my Windows Home server than file sharing and backups. Has anyone tried installing SQL Server 2008 (any version, but I'm using Professional) on a Windows Home Server?
5
votes
4answers
17k views

Rule “Restart computer” failed when installing SQL Server 2008

When trying to install SQL Server 2008 Developer and Enterprise editions on a Windows 7 box I've got this message: Rule "Restart computer" failed. A computer restart is required. You must ...