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

1
vote
2answers
2k views

MSDTC on server x is unavailable

I have Windows Server 2003 running in a virtual machine, running some software that is trying to update a database within transactions on my Windows 7 machine (the host for the VM). On my host I have ...
0
votes
1answer
3k views

Downloading MS SQL Server 2008 Standard edition

I want to download MS SQL Server 2008 with business intellegence standard edition. But I don't know how to download it, because the one I got was EXPRESS edition and everytime I run the x86 FULL 2008 ...
0
votes
1answer
88 views

Downloading MS SQL Server 2008 Standars

I want to download MS SQL Server 2008 with business intellegence standard edition. But I don't know how to download it, because the on I got became EXPRESS edition and everytime I run the x86 FULL ...
1
vote
4answers
12k views

SQL Server Management Studio - First Time Setup

I'm on Windows 7 and using free version of SQL Server Management Studio. I try connecting to DB server for the first time. I run the program as administrator. I go to Connect > Database Engine and ...
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?
0
votes
1answer
2k views

Starting a SQL server on fedora

I am a total databases noob, hence please be gentle. I am looking for tutorials how to create a SQL table, how to start a SQL server, and what software to use on fedora. Would anyone share links to ...
0
votes
2answers
789 views

MSSQL Server Management Studio Express 2005 license limit error should not be displayed

I just tried restoring a 250MB database from a backup on my local machine, and got the following message: TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Restore ...
0
votes
2answers
2k views

Error code 0x80070001 on Windows Server 2008

I've been struggling to get Windows Server 2008 running on a virtual machine. I use VMplayer and want to install Windows Server 2008 Database and Enterprise from MSDN AA. The server is running now but ...
1
vote
3answers
2k views

Commas in Comma Delimited Files

I have a SQL export that is comma delimited, but some of the data has commas in it. Is there any way to fix this? I'm guessing I am going to have to re-export the data with a different delimiter.
1
vote
2answers
4k 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 ...
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" ...
0
votes
0answers
771 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 ...
1
vote
0answers
158 views

Errors while installing SQL Server SSIS 2005

I was trying to use SQL Server SSIS 2005 for the first time and mysteriously all the SQL SSIS menu items were missing from my start menu and then from the BIDS project choices even though I did a full ...
0
votes
1answer
243 views

Recover database (SQL Server) from Windows.old folder

I have just installed Windows 7 on a machine which previously ran Windows XP. The old installation had a database which I need a copy of, but of course I did not think far enough ahead to do a backup ...
1
vote
2answers
575 views

Database is full; what should be the strategy?

What if my database is full and I don't have any spare hard disk or memory space. What should my strategy to free up the space?
0
votes
2answers
619 views

Sql server - cant login to Sql Management Studio, username and pwd is correct

After a restart of the DB server last night, I cant seem to log in to SQL Management Studio - but I know that I have the right server name, user name and password. And I know the login details ...
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 ...
0
votes
1answer
120 views

How may I use other server features on Windows Home Server without breaking it?

I am hoping to run some virtual machines, IIS, SQL Server, MOSS, and Team Foundation Server on my HP MediaSmart Server 495, probably not all at the same time. There is a frightening warning message ...
1
vote
1answer
926 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
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
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?
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
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 ...
0
votes
1answer
142 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
3k 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
23k 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
166 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
242 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
554 views

Northwind Database

How can I Install Northwind Database in SQL Managment Studio 2008 R2? Specification: Microsoft Windows XP Service Pack3 2002 version
0
votes
4answers
913 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
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
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
882 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
96 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
0answers
277 views

Access losing db connections

I have a weird problem going on at work. People have been using MS Access to connect to SQL Server db and lately people are getting sporadic problems with connecting to the servers. It's not always ...
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
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 ...
0
votes
2answers
114 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
641 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
1k 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 ...
20
votes
10answers
85k 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.