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

0
votes
1answer
10k 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
5answers
6k 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?
0
votes
1answer
39 views

issue on MS SQL managament studio 2005..?

am having MS SQL 2005 developer edition. And when am trying to install it(MS SQL 2005) on my windows XP SP2 system- am not getting MS SQL management studio..?/ what will be the issue..??
5
votes
4answers
5k 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 ...
0
votes
1answer
141 views

SQL Server 2005 - backup during database changes

Is backing up live database that is being actively used safe and consistent ? I mean will the system take a snapshot of all tables when backup starts or does it save each table content as it was when ...
1
vote
2answers
2k 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?
10
votes
1answer
20k 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 ...
0
votes
3answers
164 views

User Accounts in Win 7

I am having a difficulty in Win 7 because of different accounts (Me the user account, and the admin account). Many times I have to close the program (Visual Studio, SQL Server) and restart again as ...
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 ...
0
votes
1answer
1k views

Install Microsoft SQL express database on Windows XP Home SP3?

I am trying to install Microsoft SQL express on a Windows XP SP3 Home Edition machine. But it does not satisfy the requirements. Is there a way to remove SP3 from my machine and revert to SP2? ...
2
votes
1answer
226 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 ...
1
vote
2answers
549 views

Northwind Database

How can I Install Northwind Database in SQL Managment Studio 2008 R2? Specification: Microsoft Windows XP Service Pack3 2002 version
1
vote
4answers
762 views

What are the best tools for modeling a pre-existing SQL database structure?

I have a MS SQL database that has been running strong for 10+ years. I'd like to diagram the database structure, without spending hours laying it all out in Visio or something similar... I've ...
4
votes
2answers
142 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
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 ...
2
votes
1answer
861 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 ...
0
votes
1answer
26 views

Does anyone know of a program that can search database objects (i.e. StoredProcedures) for keywords?

Is there a tool that would look through a group of stored procedures for source code keywords? A client has a lot of business logic coded into their database and I need to find where it is using ...
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 ?
0
votes
1answer
1k views

Getting account lock status in MS SQL Server

I want to unlock an account in MS SQL Server. Before unlocking I have to check whether the account is locked or not - I only want to unlock if the account is locked. Are there any SQL queries or ...
2
votes
1answer
95 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 ...
1
vote
2answers
3k views

Problem creating ODBC connection to SQL Server 2008 with Vista

Well, I'm trying to get a database schema thing working, first I tried just doing it in Linux where I'm more comfortable, but ODBC seems to be a hack there and I couldn't get it to work. So I figured ...
3
votes
2answers
3k 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 ...
0
votes
2answers
110 views

SQL Server on Linux

For a particular project that is coming up, I am trying to expand my knowledge of Linux, so I am going to set up a Linux system at home. Rather than dual booting, I am thinking about putting SQL ...
2
votes
3answers
1k 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 ...
1
vote
3answers
2k views

How to connect to a SQL server through a public IIS server

I have two computers on my LAN. One with IIS and a public IP, the other with SQL Server and a LAN IP. How I can access to the SQL server through the IIS server from a computer connected to the ...
0
votes
1answer
580 views

is using Hosts for resolving a sql-server more performant?

we have a legacy application which uses a access.mdb with hundreds of ODBC-connected tables on a sql-server. the access.mdb contains nothing else than these odbc-connections. Now we consider to use a ...
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
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
3answers
914 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 ...
15
votes
10answers
73k 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.
0
votes
1answer
299 views

How to find sql server instance?

I have sql server 2000 and 2005 installed on my machine. Now instances were installed as Machine04 [2000] and other Machine04\SomeInstance [2005] (this some instance i don't remember now) So is ...
0
votes
1answer
212 views

SQL Server 2000 Client won't connect

One day instead of connecting to the database my SQL Server Management gave me the following error: "Data Source name not found & no default driver found" Note it had been working for several ...
1
vote
2answers
2k views

Connecting form Mac OS X 10.6 to MS SQLServer

I develop iPhone Apps so my set up is a Mac running Snow Leopard (10.6). However the databases that the App connects to all run SQL Server (2005 or 2008). I would like a native (free?) solution to ...
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 ...
0
votes
1answer
65 views

Password format not liked by installer

I'm installing Chargeback and I get to the database-related information page (step 5 on page 17 of the users guide). Using a Windows account (it is an administrator of the server and I am logged on ...
2
votes
3answers
824 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 ...
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?
3
votes
2answers
10k 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?
0
votes
2answers
1k views

Registry entry for Microsoft SQL Server

How can I check from the registry which Microsoft SQL Server(2000,2005 or 2008) is installed in my computer?
0
votes
4answers
8k views

How to obtain the Windows product id from registry from a remote machine

Would like some assistance on how to obtain the Windows product id from the registry that will work where the WIndows (Windows 2003 Server, 2008 Server) is on a Domain or Workgroup and a remote ...
1
vote
1answer
3k views

Problem with logging into SQL Server Management Studio

I can log into SQL Server Management Studio with a SQL Server Authentication login and password, but when trying to log in with Windows Authentication I get this error: "Cannot generate SSPI context. ...
0
votes
1answer
313 views

Opening offline version of Microsoft Books Online in browser

I often use the MSDN website for language reference. In order to make navigation faster, I downloaded the offline version of SQL Server 2005 Books Online from here: ...
0
votes
3answers
241 views

How can I know about the local SQL Server on my system ( windows 7 )

How do I know whether I have a local SQL Server on my system? If there is what are the login details to the local SQL Server ? I have a windows 7.
1
vote
1answer
638 views

Linux ODBC database driver for MS SQL Server?

Where can I get an ODBC database driver for MS SQL Server? I need to publish data from a perl script in Linux to an MS SQL Server.
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
195 views

How do I find out what my SQL Server database audit records contain?

I need to find out if my SQL Server 2005 database audit records contain the required information that I need. Where or how can I find this out?
1
vote
1answer
629 views

What do these Microsoft Updates do, and why can't they configure correctly?

MB: Biostar M7NCG 400 CPU: AMD Athlon XP 2200+ 1.8GHz RAM: 2.5GB (I don't know the speed, but does it really matter?) Display: NVidia GeForce 4 TI 4200, with hardware support for ...
2
votes
1answer
413 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 ...
0
votes
1answer
1k views

Why Can't SQL Server Management Studio Access The “My Documents” Folder in Windows 7?

I have a database backup located in my Windows 7 Documents folder (C:\Users\Aaron\Documents...), and I'm trying to restore it using SQL Server Management Studio. However, the program is unable to ...