The sql-server-2008 tag has no wiki summary.
12
votes
5answers
7k 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 ...
11
votes
3answers
399 views
How to install multiple Microsoft applications without conflicts
For all the IT students, self-teachers, and new professionals
Situation: The days of ...
8
votes
1answer
31k 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 ...
5
votes
2answers
734 views
Encrypting my laptop hard drive
I've considered encrypting my laptop hard drive for a while now, but the only thing holding m back is my Microsoft SQL Server 2008 installation. I use my laptop for development and also have some ...
5
votes
2answers
7k 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 ...
4
votes
3answers
442 views
How to use Microsoft SQL Server 2008 as a simple database for testing
As a student, I get Microsoft SQL Server 2008 R2 for free through MSDNAA. I installed it, but I seem to be at a loss for how to use it to test database queries, and how to construct a database with ...
4
votes
3answers
3k views
Change SQLEXPRESS instance name
I installed VS2010 and it automatically installed SQL Server 2008 Express.
Now, the installed instance is called SQLEXPRESS, therefore to connect to it I have to use 'localhost\SQLEXPRESS' or ...
4
votes
4answers
3k views
MS Access vs MS SQL Server
These are two offerings from Microsoft - MS Access and MS SQL Server.
What type of users/uses is Access meant for? Apart from the degree of usage (in terms of number of users), are these two products ...
4
votes
3answers
864 views
Can I install Microsoft SQL Management Studio by itself?
I installed Visual Studio 2010 on my machine and it installed along with it SQL Server Express 2008.
Now I'd like to use the Management Studio, but I can't seem to find it so I assume it doesn't ...
4
votes
4answers
6k 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 ...
4
votes
2answers
3k 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 ...
4
votes
2answers
8k 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 ...
3
votes
2answers
3k views
SQL server 2008 and 2012 on the same instance of Windows
Is it a problem to have both of these installed on the same Windows instance? I.e. will one break the other or impact it negatively in any way?
3
votes
3answers
12k views
How to execute a stored SQL procedure in Microsoft Excel?
How can I execute a stored procedure in Microsoft Excel and get all the data it returns?
3
votes
3answers
7k views
How to remove a broken installation of SQL Server 2008?
After installing the Service Pack 2 of Microsoft SQL Server 2008, the SQL Server failed to start. Trying to repair this, I've done some stupid things, which results now in the situation in which I ...
3
votes
3answers
1k views
Does SQL Server 2008 R2 Express have Intellisense?
I don't have any Intellisense in SQL Server 2008 R2 Express Management Studio - is this supposed to work?
I am connecting to a SQL Server 2008 R2 Express database on the same machine (no other ...
3
votes
2answers
2k views
SQL Server 2008 R2 (x86) and the Access Engine
All,
I have set up the Access Database Engine for SQL Server 2008 R2 (Service Pack 1) on many machines running x64 Windows 7 without any problems running as 'Administrator' (and setting up SQL Server ...
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?
2
votes
4answers
7k views
Move database from SQL Server 2012 to 2008
I have a database on a SQL Sever 2012 instance which I would like to copy to a 2008 server.
The 2008 server cannot restore backups created by a 2012 server (I have tried).
I cannot find any options ...
2
votes
2answers
3k views
Can I install Microsoft Visual Web Developer w/o a SQL Server Express installation?
When I attempt to install Microsoft Visual Web Developer 2010 Express, it forces an installation of SQL Server 2008 Express, which is okay. However, it forces it to have the instance name SQLEXPRESS ...
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 ...
2
votes
2answers
2k views
SQL Server Express Failed to Install
I am attempting to install SQL Server Express (as part of the Visual Studio 2010 Professional installation), but it is failing. I am receiving this error log.
[06/22/11,16:31:39] Microsoft Visual ...
2
votes
1answer
2k views
Free Alternatives for SQL Prompt
Is there any free/open source alternative of SQL Prompt? SSMS 2008 R2 intellisense is good but I need it for code optimization. For example it should notify me when there is an unused variable ...
2
votes
0answers
41 views
SQL Server 2008 and Visual Studio 2008
I have a database project to do. I can't install SQL Server 2008 on my PC (windows 7 64 bit).
When I start it says Microsoft.NET Application Security. It go further though. But it says Older version ...
2
votes
0answers
407 views
Database 28 cannot be autostarted during server shutdown or startup
I installed SQL Server 2008 on a PC with xxx.xxx.x.200. When I connected to the server from another machine(say xxx.xxx.x.81) using SQL Server Management Studio, I get the following error.
TITLE: ...
1
vote
2answers
210 views
1
vote
3answers
2k views
Change font in MS SQL Management Studio Database Diagram
My eyes must be getting old as viewing database diagrams is getting more difficult every year. Is there a way to change font type and/or increase the font size of text in database diagrams? I've ...
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
2answers
2k views
Can't access SQL Server from outside the network
I am trying to log in remotely to SQL Server 2008 R2. After reading several posts I was able to log in remotely from a computer on the same network. But I still cannot remotely log in from outside ...
1
vote
2answers
8k 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
2answers
209 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
6k 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?
1
vote
1answer
5k views
Why don't I have SQL Profiler on SQL Server Management Studio?
I'm running SQL Server Management Studio 2008 (Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 ))
However I cannot find the option to open SQL Profiler.
I was ...
1
vote
2answers
3k views
Windows 2008 R2 Memory is always full
We have a Windows 2008 R2 on a HP Server with 24GB of RAM. The only important software installed is SQL Server 2008 R2 and almost no feature or role is enabled on this Windows.
But the problem is ...
1
vote
1answer
1k views
SQL Server 2008 Management Studio - Edit Rows with Where clause
There is an option to edit rows in a grid - first 200 by default.
In Tools -> Options -> Sql Server Object Explorer, you can set the value for "Edit Top N rows".
I have a table with 200000 ...
1
vote
1answer
2k views
How to change SQL Server 2008 authentication mode?
I have an SQL Server 2008 and I want to check/change its authentication mode. Now I've seen several ways to do so in the web using SQL Server Management but I don't have that..
Is there any way to do ...
1
vote
1answer
337 views
Do we need to install SQL Server 2008 SP2 after installing SQL Server 2008 R2 RTM?
I have installed SQL Server 2008 R2 RTM (Express) with Management Studio. But I am confused, do I need to install SQL Server 2008 (Express) Service Pack 2?
Is there SQL Server 2008 R2 Service Pack 2?
...
1
vote
1answer
2k views
install SQL Profiler for SQL Server Express
I am not sure what I did while installing SQL server express 2008 but sql profiler is not on my machine. is there a way to get that separately? my machine is not running on a server OS.
1
vote
2answers
2k views
Convert MySQL backup (dump script) to MS SQL?
I have a mysqldump output of a fairly large (by measure of doing things manually) database saved in a text file. Does anybody know of a (free) way to use this to build a database in MS SQL? I'm ...
1
vote
2answers
952 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
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
1answer
543 views
Renaming server - sql 2008 server instance affected
Will changing the computer name on which SQL Server 2008 is installed on affect SQL Server in anyway? Or will changing the computer name be transparent to SQL Server?
For example:
I plan to install ...
1
vote
2answers
646 views
Lagging windows and mouse pointer in Windows 7
I'm using Windows 7 and on top of it I have installed Visual Studio 2010 and SQL server.
For some time now I have been experiencing a laggy behavior. Explorer windows minimize and maximize with a ...
1
vote
1answer
67 views
How do I set up a new database with SQL Server 2008?
In my start menu, I have Microsoft SQL Server Express 2008 R2 > Configuration Tools. In this folder, I have SQL Server Configuration Manager, SQL Server Error and Usage Reporting, and SQL Server ...
1
vote
1answer
451 views
What basic linux command-line utility can I use to test a JDBC connection?
I'm troubleshooting an issue with importing data to Apache Solr from a MS SQL Server database via a JDBC connection. Solr is hosted on a CentOS linux machine, and SQL Server is (of course) on a ...
1
vote
4answers
509 views
MS-Access database-upsizing error
I am working on upsizing an MS-Access database from Access 2010 to MS-SQL 2008 (10.0.1600). When I run the Upsizing Wizard, all the tables get moved over except for one...
The table that doesn't get ...
1
vote
1answer
2k views
Unable To Install SQL Server 2008 On Windows 7 & Windows XP
you are my final hope of salvation!
For the last five hours I've been trying to install SQL Server 2008, first on Windows 7 and then Windows XP. Both have had the same issue. Even before 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
1k 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 ...
