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

Default text for SQL scripts

In MS SSQL Server Management Studio 2012, is it possible to get new scripts to contain some default text? I want to encourage colleagues to comment their scripts more consistently, so I'd like ...
0
votes
1answer
272 views

SQL server replication, subscription to remote server : issue while choosing the publisher

I am trying to create a subscription to a remote server having SQL 2008 R2 the client PC is connected through VPN to the server and can discover it successfully. I can even connect to the database ...
10
votes
3answers
22k views

Which ports to open for Microsoft SQL Server?

Having searched the internet a few times on the best way to open up SQL Server connectivity through windows firewall i've yet to find a best way of doing it. Does anyone have a guaranteed way of ...
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 ...
2
votes
1answer
2k views

Component Services Error Log - SQL Server Distributed Replay Client

I am getting the following error on a Windows Server 2008 x64 R2 Virtual Machine install: Log Name: System Source: Distributed COM Event ID: 10016 Level: Error Date: 2/20/2013 8:22:14 AM The ...
0
votes
2answers
14k 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 ...
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 ...
0
votes
1answer
988 views

How to un-install sql server 2008 analysis service only?

Initally I installed SQL server 2008 R2 Evaluation version. Then we bought licence key for SQL server 2008 R2 Web and wanted to update my licence, but unfortunately I installed analysis service when I ...
-1
votes
1answer
42 views

SQL Server 2008 Express, just create a few tables and run queries? [closed]

I have installed SQL Server 2008 Express, as I just want to create a few tables and run queries against them. After installing I am a little unstuck. I have an "instance" running, but I am not sure ...
3
votes
1answer
3k 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
2answers
714 views

How to install Sql 2012 on Windows 8?

I am having trouble installing sql server 2012 on windows 8.
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?
1
vote
1answer
955 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
4k views

Unable to install SQL Server 2012

When I am trying to install a new instance of SQL server 2012 on my server, I get the following error message when I try to run the iso (before any gui appears): The operating system on this ...
1
vote
1answer
182 views

SQLManagementStudio - Available databases combo box in menu - can't find it in Tools/Customize

GUI customisation question: In MS SQLServer Management studio there is a combo box with the databases available at the server. I want to copy it to the menu row; but I can't find the control in the ...
1
vote
1answer
1k views

Record Matching Software to Compare two tables and match on % Based [closed]

So I have some table with Name, Address, and Zip with no record data attached; and I have a table which has all the same, but has more information and I need a way to merge the tables when they don't ...
0
votes
1answer
1k views

Installation issue for SQL Server 2005 on my Windows 7 Enterprise 32-bit [duplicate]

Possible Duplicate: Is it possible to install MS sql 2005 on Windows 7? I'm having a problem installing a SQL Server 2005 on my Windows 7 Enterprise 32-bit. The installation never ...
2
votes
1answer
155 views

Advice on webserver / database server setup

I have a home server (HP ProLiant N36L link with 8Gb of RAM), running Windows Server 2012 that I want to use as a home web server. Is it worth settings up VM's in Hyper-V for virtual DB servers and ...
1
vote
0answers
224 views

View numeric columns in hex - SQL Server Management Studio

In SQL Server Management Studio, when I run a query which outputs a numeric column (int or similar types), they are displayed in decimal (example: 193). I want them to display in hex (example: 0xC1). ...
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?
2
votes
1answer
763 views

Restore a database with LDF file only

First of all, i know how stupid it is not to have a any backup. I can't help it, but i have to (try) to solve it. I have a transaction log (LDF) file from a SQL Server 2000 database that contains all ...
1
vote
2answers
376 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 ...
-1
votes
1answer
93 views

Installation with MS SQL Server on Windows 7

I am stuggling to install MS SQL Server on Windows 7. I'm following instruction to re install SP3 and then install MS SQL Server and then install SP3 again. However when I try to install SP3 I get the ...
1
vote
1answer
731 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 ...
2
votes
2answers
341 views

How can I retrieve a MS SQL Express Database from a non-booting computer?

A client has a very important database that has not been backed up in 6 months. The PC has promptly failed. The Windows directory is corrupt, and the computer will not boot. It had a Microsoft SQL ...
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 ...
1
vote
1answer
79 views

Cannot install SQL Server CE 4

I'm trying to install SQL Server CE 4 on a WinXP Pro SP3 machine. I double-click on the file and absolutely nothing happens. There is nothing in the event viewer and the only effect I can see is the ...
0
votes
0answers
35 views

Pause VM when SQL server idle

In OSX Mountain Lion, I run a Windows Server 2003 VM solely to run SQL Sever 2008. It chews up a lot of battery life. Is there some way to automatically pause the VM when the SQL Server is idle and ...
0
votes
4answers
11k views

How to obtain the Windows product id from registry from a remote machine

Would like some assistance on how to obtain the Windows product id from the registry that will work where the WIndows (Windows 2003 Server, 2008 Server) is on a Domain or Workgroup and a remote ...
1
vote
0answers
335 views

Loading Files from My User Directory in SQL Server Management Studio 2012 Under Windows 8

I'm in the process of migrating to Windows 8, part of which was to get SQL Server/SQL Server Management Studio 2012 running. I tried to load some sample data from a .bak file for a 2012 compatible ...
0
votes
1answer
279 views

Explain difference between SQL Server real datatype and Excel representation

The real datatype in SQL Server is precision 7 yet sometimes Excel shows more precision than this, and sometimes completely different decimal parts. Can someone please explain these results: **Number ...
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
vote
1answer
547 views

Data Sources (ODBC) hangs when trying to create a new database connection

When I try to create a new database connection, the Data Sources (ODBC) programs hangs or takes a very long time to find the list of available SQL Servers. This only happens when there are other ...
2
votes
1answer
6k views

Connect to a local MySQL server running on Virtualbox

I am on a Windows 7 machine running a Ubuntu Virtualbox as my local web server and database server (MySQL). I just got a hold of a copy of Komodo which I am running on my Windows machine. I would ...
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
281 views

SQL Server: Audit permission denied

Is there any easy way to see those events in SQL Server 2008 for which permission was denied on a query (along with the text of the query and the specific object that permission was denied to)? I ...
2
votes
1answer
764 views

How to copy multiple SQL Server Management Studio Express result tables at one time?

I have a query that spits out multiple result tables and I want to be able to select all of the tables at once, hit copy and then paste them all to one Excel file all at the same time. I would also be ...
0
votes
1answer
696 views

Possible SQL injection

I have a desktop based software that's built on top of SQL 2005. The SQL server is hosted inside my office, and there is 1 public facing website which displays some of the content from this database. ...
0
votes
1answer
132 views

Fastest light-weight method of executing and displaying results of SQL query [closed]

Many if not most applications can display the results of SQL queries in some human readable format. However, they typically either must be open with an active window (SSMS or excel for example, both ...
1
vote
1answer
285 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 ...
2
votes
1answer
1k 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
0answers
47 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. ...
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
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 ...
0
votes
1answer
3k 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:
1
vote
1answer
2k views

Why Can't SQL Server Management Studio Access The “My Documents” Folder in Windows 7?

I have a database backup located in my Windows 7 Documents folder (C:\Users\Aaron\Documents...), and I'm trying to restore it using SQL Server Management Studio. However, the program is unable to ...
1
vote
1answer
653 views

Linux ODBC database driver for MS SQL Server?

Where can I get an ODBC database driver for MS SQL Server? I need to publish data from a perl script in Linux to an MS SQL Server.
0
votes
1answer
519 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
383 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 ...