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
3answers
223 views

Should I transition from an Excel file to a MS SQL database?

I currently have an Excel spreadsheet acting as a small data base, about 2000 entries. It is fine for our needs but we now need to allow a couple of staff to securely and quickly access subsets of the ...
1
vote
1answer
5k views

How to install SQL Server Express?

While installing Visual Studio 2010, I saw an option to install SQL Express. I checked that option assuming it would install SQL Server Express as well, but apparently it didn't. When I type ssms.exe ...
1
vote
1answer
267 views

connecting to sql server from access for multiple users

I just ran the upsizing wizard on my copy of Access and have successfully connected my Access app to my SQL Server DB but I need to do this for multiple users. Am I going to have to run the upsize ...
1
vote
2answers
2k views

Windows XP PRO SP3. Setup ASP.NET dev. environment

I have Windows XP PRO SP3 And Visual Studio 2010. By default I have IIS 5.1. And there is no option to upgrade it. I want to start developing ASP.NET. Could any one give a good reference how to ...
3
votes
2answers
451 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 ...
1
vote
2answers
117 views

Tools to manage SQL Server and Oracle database from the desktop

I am using SQL Server 2008 and Oracle 11G on my system. Running both database services is making my system very slow. In order to stop the services I have to go to Services and stop them manually. ...
0
votes
2answers
3k views

Why Intellisense doesn't work in SQL Server Management Studio 2008 R2? [closed]

I have SQL Server Management Studio 2008 R2. I have tried these: Tools->Options->Query Execution->SQL Server->General, make sure “By default, open new queries in SQLCMD mode” is unchecked Go to ...
0
votes
4answers
370 views

What is the best way to manually edit and update data within a large table in MS SQL Server?

I have a table in MS SQL server which currently has around 800 records and 20 columns. I want to manually update and add to the information within this table on a frequent basis. Would exporting the ...
1
vote
1answer
39 views

How do I connect to a database without seeing all the other databases on the host?

I'm using Microsoft SQL Server Management Studio 2008 R2, I followed the instructions from my host and I'm successfully able to connect to my database, but I also happen to see all of the databases on ...
2
votes
1answer
400 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 ...
0
votes
1answer
684 views

Troubleshooting inconsistent ODBC connectivity

I'm attempting to integrate UPS WorldShip with a SQL Server 2008 R2 database but the connection is very inconsistent. UPS claims this is a DSN/Windows problem and I have not been able to convince them ...
0
votes
1answer
137 views

Sql Server Express Installation

I am learning ADO.NET programming. I want to install Sql Server Express for doing the some programs. I am using Microsoft Visual Studio 2010 Ultimate on my windows 7 home basics 64 bit. I have ...
2
votes
1answer
3k 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 ...
0
votes
3answers
1k views

Networking in VMware

I am required to imitate a remote database server environment for my project. So I am thinking of installing SQL Server 2008 on a virtual machine (VMware workstation) and then access it from my ...
2
votes
1answer
98 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 ...
1
vote
1answer
835 views

Querying big databases with Excel

Is it possible to use Excel's pivot table as a kind of query builder against a database, without copying the entire database into Excel? I know that with the External Data Sources feature, you can ...
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 ...
1
vote
2answers
23k views

How to install MS sql server client in 64 bit windows 7 operating system?

I want to install sql server client in my windows 7 64 bit version. But I am unable to do that please provide some help. i want to install only Client not sql server. is this possible.
1
vote
2answers
3k views

Can't access SQL Server from outside the network

I am trying to log in remotely to SQL Server 2008 R2. After reading several posts I was able to log in remotely from a computer on the same network. But I still cannot remotely log in from outside ...
1
vote
1answer
940 views

Open port for Microsoft SQL database connection from outside the Windows7 computer

My Firewall seems to be blocking the connection from anywhere to my local MS Sql Server on my Windows7 development machine. On Linux and Mysql I could telnet the database ports and it gives response ...
0
votes
1answer
3k views

Custom forms in Sharepoint with MS SQL Server as Backend. Is it possible?

We're evaluating using SharePoint 2010 as our project management tool. Specifically, the system needs to satisfy the following: Discussion groups Project management (simple issue tracking, no ...
1
vote
2answers
2k views

How can I make a usable copy of an SQL Server database on Windows Server 2003?

I need to make a usable copy of an SQL Server database on Windows Server 2003 for testing purposes. There is a backup tool built into Enterprise Manager but I can't seem to make it work. I've tried ...
2
votes
1answer
5k views

How can i compress when I create SQL backup file in a folder?

I use SQL Server Express and I create backup files for all databases every day using Time Scheduling script. One script Like that; BACKUP DATABASE [Jira] TO DISK = N'C:\Backup\Jira.bak' WITH ...
2
votes
3answers
3k 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 ...
1
vote
1answer
242 views

SQLCMD -L option with a smaller timeout

I am trying to use the sqlcmd -L c command to find out the instance name of the SQL server running on the local machine. It succeeds, but I have to wait for a full minute, for the tool to realize that ...
3
votes
1answer
648 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
27k 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 ...
2
votes
1answer
706 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?
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 ...
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 ...
0
votes
2answers
12k views

How to forward port on a dedicated windows server 2008?

In MSDN to make SQL Server accessible from Internet http://msdn.microsoft.com/en-us/library/ms175483.aspx They say to forward port from sql server remote port to usual sql server port 1443. I have ...
1
vote
1answer
3k views

install SQL Profiler for SQL Server Express

I am not sure what I did while installing SQL server express 2008 but sql profiler is not on my machine. is there a way to get that separately? my machine is not running on a server OS.
2
votes
1answer
249 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 ...
0
votes
1answer
2k views

SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server

SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server. Here's a screenshot of the error:
0
votes
1answer
259 views

How to determine sql server name

I'm trying to install sap business one on my computer. But I can't seem to connect to the database server which is ms sql. ![enter image description here][1] I get the notice: unable to connect to ...
0
votes
1answer
688 views

Database to a Network drive

What would be the syntax to backup MS SQL Database 2005 to a network drive?
0
votes
1answer
777 views

Why can't my bulk loadable CSV file be opened?

This is my error: Cannot bulk load because the file could not be opened. Operating system error code 5 (Access is denied.) I've checked permissions and everything seems fine. The auto bulk ...
1
vote
3answers
3k views

Windows Update KB2463332 Installs, But Still Available to Update?

I am running Windows 7 Home Premium on 64-bit architecture. Windows Update lists one "Important" update even though I've installed it. It is: KB2463332. There is no error when I install the ...
-1
votes
1answer
216 views

Enterprise Manager clone for SQL Server 2005 or later

Is there any project attempting to reproduce the functionality of Enterprise Manager for SQL Server 2005 and newer? I know Aqua Data Studio is sort-of-close. Are there any projects that understand ...
0
votes
2answers
627 views

Best SQL Server Configuration with this hardware

I just received my new SQL Server from Dell. The server will be serve approximately 15 OLTP databases which average 10GB in size. Here are the basic specs: Dell PowerEdge R510 with up to 12 Hot ...
1
vote
1answer
713 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
389 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
277 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
763 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
4k 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 ...