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
2answers
160 views

Can I change the default folder location for applications?

Basically I want to know if it is possible to change the path of certain applications that are saving folders in My Documents. For example: Whenever I open SQL Server Management Studio it creates a ...
0
votes
1answer
375 views

Remote application cannot connect to my local SQL Server 2008 R2

I have set up Microsoft SQL Server 2008 R2 (SP1) on a local machine specifically for a certain application to run. The application itself is designed to use an IP address which is hard coded in to ...
1
vote
4answers
760 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 ...
0
votes
2answers
314 views

SQL Server Licence in MSDN

I had bought a VS2010 Professional version licence through our corporate licence. I was recently browsing through the MSDN product download page and found that SQL server download were available for ...
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 ...
0
votes
1answer
625 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
2answers
728 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 ...
1
vote
1answer
1k views

SQL Server 2012 installation - Service 'SQLBrowser' start request failed

I am having trouble installing SQL Server 2012 Express on Windows 7. Whenever I try the installation, I get the error Service 'SQLBrowser' start request failed. If I click Retry, it happens ...
0
votes
1answer
229 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
1answer
883 views

sqlservr.exe's virtual size is big – should I worry?

Is this normal? Does the large virtual size matter on sqlservr.exe for the performance of other apps? It seems to happen any time I use Firefox and iTunes. ( Also running is League of Legends) ...
0
votes
0answers
1k views

Cannot connect to SQL Server from another PC

I am using windows XP SP2 and SQL Server 2000. I can successfully connect to a database from the host computer via 127.0.0.1 and also with the local IP (which is 192.168.1.6). But when when I try to ...
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 ...
0
votes
2answers
3k views

Skip restarting during SQL Server installation

I tried to install MSSQL Express R2 2008 but I noticed that it needs SP3 on Windows XP 32bit. I did install XP SP3 and did not restart the PC. When I try to install SQLServer, it asks for a restart. ...
0
votes
1answer
385 views

SQL SERVER 2000 JDBC DRIVER

I am trying to find the SQL SERVER 2000 JDBC Driver to use in extracting data from SQL SERVER and also carrying out several operation implemented in Java/JSF. Any idea where I could get my hands on ...
0
votes
1answer
1k views

How do I connect to a MySQL database from another computer in VB.NET?

How do I connect to a database of another computer in the same local network using VB.NET? We have already enabled remote connection in the SQL Server configuration and the SQL browser, and we already ...
3
votes
2answers
411 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 ...
0
votes
1answer
576 views

Export .mdf to SQL Server database

I am on a shared hosting plan and cannot install SQL Server Express, is there another way I can use my .mdf database or will I need to export it to a SQL Server database and change all my connection ...
1
vote
3answers
205 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
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 ...
1
vote
1answer
4k 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
248 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 ...
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
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
343 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
388 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 ...
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 ...
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 ...
-1
votes
1answer
209 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
1answer
128 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 ...
4
votes
11answers
6k 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 ...
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 ...
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 ...
4
votes
2answers
147 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 ...
1
vote
1answer
740 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 ...
2
votes
1answer
674 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?
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?
1
vote
2answers
21k 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.
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
3answers
823 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
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
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
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 ...
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 ...
1
vote
3answers
456 views

Is there a way to restrict direct write access to the database in Microsoft Access 2007?

I'd like to set up an Access (2007) project that contains queries on a database (actually in MS SQL Server 2005), but I don't want to allow any direct writing to the database. How can I make it ...
1
vote
1answer
881 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 ...
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 ...
1
vote
1answer
374 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
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 ...