The MS SQL Server is a database management relational database created by Microsoft in partnership with Sybase in 1988 and inserted as a complementary product to Windows NT. Tag questions specific to a version with [sql-server-2012], [sql-server-2008], etc.

learn more… | top users | synonyms

20
votes
10answers
84k views

How do I open SQL Server Management Studio?

How do I open SQL Server Management Studio? I installed it but I don't see where I can open it.
12
votes
6answers
40k 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 ...
10
votes
4answers
21k views

Which ports to open for Microsoft SQL Server?

Having searched the internet a few times on the best way to open up SQL Server connectivity through windows firewall i've yet to find a best way of doing it. Does anyone have a guaranteed way of ...
10
votes
1answer
22k views

How to remove Crash Dump Files under Windows 7

My Windows 7 hard drive suddenly filled up today. After doing some research, I downloaded and ran WinDirStat. This identified that 29% of my hard drive was occupied by Crash Dump Files (*.mdmp). I ...
9
votes
1answer
23k views

How to: Database Model in Visio 2013

I am unable to find the "Database Model" in Visio 2013 and upon linking an existing database to Visio, there is no option to Reverse Engineer. Where do I find this functionality?
8
votes
9answers
18k views

Why does it take so long for SQL Management Studio to connect?

Considering that Microsoft SQL Server is not, technically, a slow database management system, I keep wondering why it often/usually takes such a long time for SQL Management Studio to connect. This ...
6
votes
2answers
2k views

preserving \n from SQL Server Management Studio

I have a column called EventLog varchar(max) and can be pretty big because essentially it stores the event log of an entire batch process. The problem is that when I go into the query window and do ...
5
votes
2answers
7k views

Disable SQL Server at windows startup (VS 2010)

After I installed Windows 7, booting lasted for about 40 seconds. Then I installed VS2010 and booting is 20 seconds longer. In task manager I see SQL Server process running. Is there a way to disable ...
5
votes
4answers
6k 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 ...
5
votes
6answers
5k views

Why am I not able to create a backup plan for TFS?

I am trying to create a backup plan using the TFS Power Tools but I keep running into this error message: I have checked that the account has Full Control on the share, I can edit, create and delete ...
4
votes
11answers
6k views

Less daunting front end for SQL Server

We currently have a few users who have been using Access very succesfully to throw around large amounts of data. We've now got to the point where the data is just too large to be held in Access, as ...
4
votes
3answers
1k 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
2answers
148 views

How do I connect to a SQL Server DB to run some queries?

I have a SQL Server DB but have no idea how to connect to it to run some queries. I naively assumed that I'd be able to open up a DB in a similar fashion to Microsoft Access, but can't seem to do ...
4
votes
4answers
7k views

Cannot find one or more components. Please reinstall application

I am running Windows 8, 64 bit and have SQL Server 2012 installed. I downloaded the client tools, looked in the directory for SQL Server Management Studio, and see it's there. When I try to run SQL ...
4
votes
1answer
2k views

Windows 7 Credential manager and accessing SQL Server from outside of the domain

My SQL Server is set to use Windows authentication. If I am connected to the domain directly from my Windows 7 Ultimate x64 machine, SQL Management Studio (SSMS) will let me authenticate with Windows ...
4
votes
4answers
9k views

Cannot connect with Sql Server Studio: error 18456, state 8 — but password is correct!

Using Sql Studio Express (on a Windows 7-64 machine) to connect to three different Sql Server 2005 servers using Sql Server Authentication, I'm getting Error: 1846, State: 8. According to ...
4
votes
2answers
145 views

Is it necessary to install SQL05 Express w/VS2008 if I have SQL Server 2005

Is it necessary to install SQL Server 2005 Express with Visual Studio 2005/2008 if I already have SQL Server 2005 installed? I'm wondering if SQL Server Express adds any integration that SQL Server ...
4
votes
3answers
934 views

Is it possible to enable Intellisense for SQL Server Management Studio Express 2012 (SSMS)?

I have installed SSMS to connect with my Old SQL Server 2005. Just want to test new features for new version of SSMS Express 2012. I use Right click on the Text Editor to enable Intellisense but I ...
4
votes
1answer
157 views

Copying out color theme background from SQL management studio to Outlook

I have a color theme set in SMS 2012, where the background is dark and some of the syntax is white, when I copy and paste this out into an email (white background) the dark background of management ...
3
votes
2answers
8k 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
1answer
15k 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 ...
3
votes
3answers
29k 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
1answer
2k views

I can't “unmaximize” my window

I've got a windows app (I don't think it matters which one, but in case you're wondering, it's SQL Server Profiler) that I can't put back into "windowed" mode. I can maximize or minimize it, either ...
3
votes
1answer
5k views

Default SA password of SQL Server automatically installed by SharePoint Server 2010 setup

I installed SharePoint server 2010 recently on a test server. It was installed in standalone mode. After the installation, I realized that it had installed SQL Server Express 2008 (10.0.2531.0) ...
3
votes
2answers
2k views

SQL Server Management Studio print in color

I am using SQL Server Management Studio 2012. I am trying to print a stored procedure in the color-coded syntax that it loves showing me, but cannot find an option to enable this. Any ideas? I know ...
3
votes
1answer
5k views

How can I get sql server profiler installed

I have Sql Server 2008 R2 installed. But in Management Studio, under Tools menu, I don't see Profiler. What feature do I need to install in order to get profiler?
3
votes
3answers
998 views

Is my system compromised? I got message about ntoskrnl.exe

I am not sure this question belongs her or not but let me try. When I get to office this morning One of my colligues had a problem with his laptop and told me he had trouble restarting it and when he ...
3
votes
2answers
11k views

How do I give myself admin rights to a sql server instance, having forgotten the sa password?

I have lost all passwords for a SQL Server instance, how do I give myself admin access again?
3
votes
2answers
479 views

SQL Server Management Studio ignores default DB

When I use SQL Server Management Studio to log in to databases, it ignores my default DB and always puts me in master. I checked that my Windows user has a login with the correct DB set, and I tried ...
3
votes
2answers
1k views

How can I start using MS-SQL Server ( express )

I have just installed Microsoft SQL Express from here: http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx I need it because an example of some code I have uses it. How do I start using ...
3
votes
3answers
3k views

Creating a named pipe on Windows

I want to write a large dataset from a SQL Server 2005 database using BCP (bulk copy program). Ideally I'd like to do the following: bcp MyDatabase..MyTable OUT STDOUT -c -t, |gzip -c ...
3
votes
1answer
2k views

SQL Server Connectivity Test

Many times people around me fail to connect to SQL Server from other Non-Microsoft Applications. Assuming that there is no SQL Server Client installed, what are the different ways we can ...
3
votes
1answer
44 views

SQL Server 7 Transaction Logs Issues

Over the week my database server transaction log was full. With our app people could select from the database but could not update or insert into the database. In the past we have just truncated the ...
3
votes
1answer
664 views

Purging Expired SQL Server Backups

I have set up a SQL Server Agent job to execute a backup every night at 3am. The job appends the backup to an existing backup file, and sets the expiry of the backup to expire in 7 days time. It's ...
3
votes
1answer
6k views

Network Service Account password

In order to debug a SQL Server 2008 stored procedure, I would like to change the account that the SQL Server (MSSQLSrver) service is running under, namely, changing the account from "Network Service" ...
3
votes
1answer
3k views

Importing specific date format to Excel from Microsoft SQL Server

I've already asked the question at: StackOverFlow and got sent to this place here. I'm importing dates from a German SQL Server table into a German Excel file via the built-in Excel connection tool. ...
3
votes
2answers
4k views

Archive Outlook mail items into SQL Server

I am looking (and so far not finding any) for a solution to archive e-mail items from my Outlook into SQL Server. My PST is beginning to get really really big, and I'd love to extract my older e-mail ...
3
votes
1answer
601 views

Calculation takes forever in large data set on Excel

I connected my excel to ODBC SQL Database(SQL Server) and now my excel pivot table is getting its data from the sql server VIEW. There is a total of about 1 million plus rows from the QUERY. From the ...
2
votes
1answer
411 views

Is it a virus on my PC?

Somehow sqlservr.exe launches cmd.exe (with very strange command line params) and ftp.exe processes on my PC, please see screenshots. I have already installed antivirus. What it could be, how to treat ...
2
votes
3answers
4k views

Why won't Windows 7 install my downloaded .NET 3.5 SP1?

When I try and install SQL Server 2008 Developer Edition, it stops and says I need .NET 3.5 SP1. Windows 7 has .NET 3.5 installed (I selected it in features) but I guess it's not SP1? (I'm running ...
2
votes
2answers
942 views

understanding Microsoft Download Center naming convention

The following are the download names for SQL Server Express Editions. SQLEXPR_x86_ENU.exe SQLEXPR_x64_ENU.exe SQLEXPR32_x86_ENU.exe The machine I have is a 32 bit intel machine. Which one should ...
2
votes
1answer
1k views

Visual Studio 2012 SQL editor missing tool bar

I have a number of SQL script files in a database project. When I open some of them, the editor includes a toolbar, with options to connect to database, execute the script, etc. However, when I open ...
2
votes
5answers
7k views

Can I install SQL server on my laptop?

I want to install SQL server on my laptop. Current spec of my laptop: Windows XP SP3 Intel atom 1GB RAM 160 GB HDD What do I need to install first, and what kind of SQL server?
2
votes
2answers
279 views

How can I retrieve a MS SQL Express Database from a non-booting computer?

A client has a very important database that has not been backed up in 6 months. The PC has promptly failed. The Windows directory is corrupt, and the computer will not boot. It had a Microsoft SQL ...
2
votes
2answers
1k views

SQL management studio hangs when opening after being closed down on dual screen

I have a dual screen set-up. I'm running windows 8.1. I have had this issue with Management studio 2008 R2, 2012 and 2014. If I drag the management studio screen across to my 2nd display, and then ...
2
votes
1answer
881 views

Sql Server Managmenet Studio Alternative - Are there any?

I am looking for lightweight MS SQL Server Managmenet Studio (2005) alternative (open source/freeware is a bonus). Something more like HeidiSQL for MySQL. LINQPad is not an option (although it's ...
2
votes
3answers
869 views

WIndows XP file path in Windows Vista?

I am looking for a SQL Server file I am supposed to delete, only the instructions I found for this are for Windows XP and my OS is Windows Vista. And as ridiculous as this is, I cannot find this file ...
2
votes
4answers
1k views

MySQL - “Root Element is Missing”

Something has happened to the MySQL server installation on my computer. Normally, the MySQL notifier program, which is supposed to start automatically and run in the system tray has stopped starting ...
2
votes
2answers
2k views

Can't connect to local Sql Server while connected to a VPN

We have a Sql Server in our office here that I connect to regularly. No problems. We have a client now to whose VPN we need to connect using the Windows VPN software. When I connect to the VPN ...
2
votes
1answer
4k views

How Do I Investigate a CPU Usage Spike Without Being Present?

I have a server that's mysteriously using up a lot of CPU late at night, when it shouldn't be under heavy load. This causes some database calls to time out, and I've set up some alerts in PerfMon to ...