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
1answer
727 views

Timeouts when connecting to SQL Server since installing SP1 for Windows 7

I just installed SP1 for windows 7 and I have severe performance degradation when connecting to SQL Server 2005 since then. Establishing connection takes more than 30 seconds while it's instantaneous ...
0
votes
2answers
2k views

How to turn off IIS forever?

I have just installed Sql Server and it needed IIS. Now when I go to http://localhost/ I get -2147467259 (0x80004005) I bet its IIS. How to turn it off and remove it from autostart?
0
votes
2answers
2k views

Having problems with connecting to/seeing the local SQL server with Microsoft SQL Server Management Studio

I'm having some difficulties when I'm trying to connect to my local SQL Server. I'm pretty sure the server is running (many of the other topics on this subject suggests that the services might not be ...
0
votes
1answer
3k views

Accessing SQL Server in Windows XP Mode Virtual Pc

I have a laptop running 64bit Windows 7 Ultimate. I created a Virtual PC using Microsoft XP Mode. I've installed SQL Server 2000 on the Virtual Machine. I have SQL Server 2008 R2 installed on the ...
1
vote
1answer
399 views

Display corrupted with repeated scrollbar in SSMS Microsoft SQL Server Management Studio

Microsoft SQL Server Management Studio (SSMS) corrupts the display results and query window in both versions 2005 and 2008 as shown in the screenshot. It seems like the window drawing / re-drawing ...
1
vote
3answers
296 views

Could not find file 'SqlAccess.dll'

When running CREATE ASSEMBLY MyAssembly FROM 'S:\SourceCode\TryUDF\bin\Debug\TryUDF.dll' an error is returned: Could not find file 'SqlAccess.dll' in directory 'C:\Program Files\Microsoft SQL ...
0
votes
3answers
4k views

Recommended utility to import .csv files into Microsoft SQL Server 2008 R2?

I'd like a better method to import .csv files into Microsoft SQL Server 2008 R2. The default import wizard maps everything, by default, to a varchar(50), even when its quite obvious that its a columm ...
0
votes
3answers
794 views

Drupal 7 on Windows - File Module Problems

Installed Drupal 7 using the Web Platform installer on Windows 2008 For some reason, the file module, when you upload a file, uses the first few letters of the filename as the unique key to store in ...
0
votes
3answers
5k views

Dates not recognized as dates in pivot table pulling directly from SQL Server

My pivot pulls from an external data source with a date column. Excel doesn't see this column as a date and the 'Format Cells' option panel doesn't change how the dates are displayed. The cell data is ...
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
91 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
6k 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
810 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
779 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
159 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
245 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
582 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
636 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
122 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
934 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
243 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
925 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
3k 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
884 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
2k 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
2k 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
284 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 ...