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.
13
votes
9answers
43k 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.
10
votes
4answers
12k 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 ...
9
votes
1answer
12k 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 ...
7
votes
8answers
8k 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 ...
5
votes
4answers
4k 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 ...
5
votes
2answers
944 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 ...
4
votes
11answers
5k 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
411 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
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
2answers
122 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
1answer
1k 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
2answers
129 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
4answers
6k 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 ...
3
votes
2answers
5k 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 ...
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
6k 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
636 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
301 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
1answer
2k 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
2answers
661 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
2k 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
1k 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
489 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
3answers
248 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 ...
3
votes
1answer
437 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.
...
2
votes
1answer
278 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
4answers
6k 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
1answer
562 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?
2
votes
2answers
113 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
1answer
795 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
664 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
1answer
1k 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 ...
2
votes
1answer
89 views
Add data to a database, without physical access to the server machine [closed]
I have two computers in a client / server architecture. The server runs SQL Server. The client has to provide an interface to insert data to this database.
I know that this can be achieved with ...
2
votes
1answer
3k 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" ...
2
votes
2answers
7k 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?
2
votes
1answer
80 views
Advice on webserver / database server setup
I have a home server (HP ProLiant N36L link with 8Gb of RAM), running Windows Server 2012 that I want to use as a home web server.
Is it worth settings up VM's in Hyper-V for virtual DB servers and ...
2
votes
1answer
255 views
How to copy multiple SQL Server Management Studio Express result tables at one time?
I have a query that spits out multiple result tables and I want to be able to select all of the tables at once, hit copy and then paste them all to one Excel file all at the same time. I would also be ...
2
votes
1answer
285 views
I can't install SQL Server on my PC
I have a PC with Windows XP Professional x64.
And I'm trying to install a SQL Server Express x64 version. All goes well until the setup builder try's to set the necessary setup files.
At this point ...
2
votes
3answers
1k views
SQL Server Ports
The Microsoft website states
The firewall must be configured to permit port 1433 incoming (or the port numbers that SQL Server listens to on TCP/IP), and ports 1024 to 65535 outgoing.
Does this ...
2
votes
1answer
447 views
How to convert Microsoft sql 7 database to Microsoft sql 2008 database?
Is it possible to convert an Microsoft SQL 7 database into Microsoft SQL 2008?
2
votes
1answer
78 views
Do data sources travel with a particular mail merge document?
Do data sources that you set up (particularly to SQL Server) travel with a mail merge document?
In other words, if I set up data sources in a mail merge document on my machine and then save and send ...
2
votes
3answers
859 views
Why does MS SQL Server Management Studio almost freeze up my computer while it restores?
Why does MS SQL Server Management Studio almost freeze up my computer while it restores? It makes it so when I click on the clock it takes seconds for the calendar to open. I don't see why this ...
2
votes
0answers
191 views
Import-CSV with powershell using a variable path
I am trying to import a CSV file with powershell in a database, with the path defined in a variable. But it doesn't seem to work.
$path = "C:\Users\Admin\Desktop\TestFolder\file.txt"
Import-CSV ...
2
votes
1answer
223 views
NetWork Intrusion Attack: MSSQL.worm.helkern attempting to attack local port 1434 from IP address 94.188.21.147?
I was on the internet the other just finishing up a project for work and I saw my internet security saying network attack intrusion and I read about some of it but I can't fully understand the full ...
2
votes
1answer
170 views
How can I run this batch file?
This is the batch file:
OSQL -S 127.0.0.1 -U sa -P password
RESTORE DATABASE DATA FROM DISK = C:\backup\data.dat
GO
EXIT
But after I run the OSQL -S 127.0.0.1 -U sa -P password, the command prompt ...
2
votes
1answer
301 views
How can I add a keyboard shortcut for Find-In-Files in SQL Server Management Studio?
I'd like to make it Ctrl-Shift-F to match Visual Studio.
I realize to do that I need to remove that binding from the Query->Save to File item.
But, I can't even add ANY shortcut. When I pull up the ...
1
vote
2answers
842 views
How do I get a standalone SQL Server Management Studio (SSMS)?
I don't want to install the entire SQL Server (2005 or 2008) on my Virtual PC (saving space), yet I need the SSMS to connect to external databases.
What are my options?
1
vote
2answers
201 views
1
vote
1answer
363 views
Record Matching Software to Compare two tables and match on % Based [closed]
So I have some table with Name, Address, and Zip with no record data attached; and I have a table which has all the same, but has more information and I need a way to merge the tables when they don't ...
