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
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
154 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 ...
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 ...
1
vote
1answer
651 views

Is it possible to replicate SQL Server Express 2008 => SQL Server Express 2012?

Is it be possible to configure the one way replication between SQL Server Express Edition 2008 => SQL Server Express Edition 2012?
2
votes
1answer
147 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 ...
0
votes
2answers
804 views

How do I install SQL Server Reporting Services for my version of SQL Server?

I believe the version of SQL Server 2012 that I have installed is a developer version. It is version 11.0.3000. I would like to install Reporting Services and Report Builder. I tried this link: ...
1
vote
1answer
649 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
votes
1answer
92 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 ...
2
votes
2answers
280 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
0answers
195 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). ...
1
vote
1answer
75 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 ...
3
votes
2answers
2k views

SQL Server Management Studio print in color

I am using SQL Server Management Studio 2012. I am trying to print a stored procedure in the color-coded syntax that it loves showing me, but cannot find an option to enable this. Any ideas? I know ...
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 ...
1
vote
0answers
320 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
263 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 ...
0
votes
2answers
7k views

SQL Server 2012 fails to install or remove

Got an odd problem here. Installed programs is showing SQL Server 2012 installed, but fails to remove itself when running the uninstaller. To add insult to injury, it also won't let install the ...
1
vote
1answer
500 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 ...
0
votes
1answer
239 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
674 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 ...
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 ...
2
votes
1answer
1k views

Visual Studio 2012 SQL editor missing tool bar

I have a number of SQL script files in a database project. When I open some of them, the editor includes a toolbar, with options to connect to database, execute the script, etc. However, when I open ...
0
votes
1answer
642 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
127 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
954 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 ...
-1
votes
2answers
3k views

SQL Server 2012 Maintenance Plan can't modify

Click on any created Maintenance Plan: TITLE: Microsoft SQL Server Management Studio Value cannot be null. Parameter name: component (System.Design) BUTTONS:OK Create a new Plan I get this error: ...
1
vote
1answer
243 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 ...
12
votes
6answers
41k 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
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
2answers
356 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
941 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
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. ...
1
vote
1answer
126 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
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
1answer
68 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
204 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
492 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
365 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
2k 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
488 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 ...
3
votes
1answer
15k 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
8k 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
501 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 ...