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
319 views

Log of SQL queries to ODBC driver?

I have an application on my Windows XP SP3 machine that's querying and returning data from a database through the SQL Server Native Client. Is there a log file being kept that would show me the SQL ...
16
votes
6answers
53k views

Move database from SQL Server 2012 to 2008

I have a database on a SQL Sever 2012 instance which I would like to copy to a 2008 server. The 2008 server cannot restore backups created by a 2012 server (I have tried). I cannot find any options ...
2
votes
1answer
2k views

I can't install SQL Server on my PC

I have a PC with Windows XP Professional x64. And I'm trying to install a SQL Server Express x64 version. All goes well until the setup builder try's to set the necessary setup files. At this point ...
0
votes
1answer
4k views

Powershell SQL query--connection string

I am trying to query several different SQL servers and run a command on each of them. I am unable to get the connection string right. Code, below. I receive the following error:Login failed. The ...
1
vote
2answers
390 views

What is the easiest way to connect to a remote SQL server?

So for the last few days I've been wrangling with usernames/passwords and trying to use different tools to connect, all to no avail. I know there are many ways to connect, VPN, or command line, or ...
4
votes
3answers
1k views

Is it possible to enable Intellisense for SQL Server Management Studio Express 2012 (SSMS)?

I have installed SSMS to connect with my Old SQL Server 2005. Just want to test new features for new version of SSMS Express 2012. I use Right click on the Text Editor to enable Intellisense but I ...
1
vote
0answers
48 views

Visual Studio 2010 DON'T CLEAR Query if doesn't succed or syntax error

In VS2010 when you perform a query against database if the query itself has any syntax error the VS by default clears all text from screen. This makes you to type again the text and resolve syntax. ...
1
vote
1answer
132 views

How to create a condition clause using a current computer time

I have an SQL View which contains a column with dates of the '2012-06-21 19:44:50.543' format. I need to entre the condition to show only lines with dates starting from the beginning of the previous ...
1
vote
1answer
3k views

How do I automate the exporting of a result set from an SQL Server database?

I have a View in an SQL Server 2008 database which I need to be exported into a CSV file automatically at the beginning of each month. As I understand, two procedures are needed: The SQL script to ...
3
votes
1answer
4k views

Importing specific date format to Excel from Microsoft SQL Server

I've already asked the question at: StackOverFlow and got sent to this place here. I'm importing dates from a German SQL Server table into a German Excel file via the built-in Excel connection tool. ...
1
vote
1answer
69 views

How to find my network and database access [closed]

Our company gets audited pretty regularly and I was wondering if there's an easy way to find out which accounts have access to what on our network? We're an all windows development shop, so all our ...
0
votes
2answers
230 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
545 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 ...
0
votes
2answers
394 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
3k views

SQL Server 2012 Connecting to MS Access 2003

SQL Server 2012 - Access 32-bit 2003 - I can import the database, I don't understand why I can't link to it. SQL 2012 may have changed the connection string or something. I just installed SQL Server ...
0
votes
0answers
78 views

Sharing MS Excel Sheet over network? [duplicate]

Possible Duplicate: Sharing Excel sheet over network? Is it possible to have a Server PC running a MS Excel Sheet to which several Thin Clients will be connected via TCP/IP having Barcode ...
0
votes
4answers
553 views

Sharing Excel sheet over network?

Is it possible to have a server PC running a Microsoft Excel sheet to which several Thin Clients, with Barcode Scanners, will be connected via TCP/IP? The scanners should dump their data in the Excel ...
1
vote
1answer
2k 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
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 ...
5
votes
1answer
19k views

Why don't I have SQL Profiler on SQL Server Management Studio?

I'm running SQL Server Management Studio 2008 (Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )) However I cannot find the option to open SQL Profiler. I was ...
1
vote
1answer
1k 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) ...
3
votes
2answers
9k views

SQL server 2008 and 2012 on the same instance of Windows

Is it a problem to have both of these installed on the same Windows instance? I.e. will one break the other or impact it negatively in any way?
0
votes
1answer
558 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
2answers
4k 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
2k 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 ...
0
votes
1answer
668 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
266 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
6k 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
291 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 ...
5
votes
2answers
545 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
121 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
4k 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
408 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
424 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
769 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
152 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 ...
3
votes
1answer
4k 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
99 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
930 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 ...
5
votes
3answers
2k 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
26k 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
981 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 ...