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
0answers
413 views

BCM - Database Tool 2013 on SQL 2008r2

Im trying to setup a Database with the Business Contact Manager Database Tool -2013 on one of our server. The tool is able to detect the SQL intance but can't create the Database. I've gone through ...
0
votes
1answer
3k views

SQL server Srevive(MSSQLSERVER) not start

i want to SQL server 2008 Enterprise Edition on my Dell N5110 Laptop With windows 7 Ultimate SP1 64- bit edition. when i click "setup" in installation DVD below Error appear: anyway i click ...
1
vote
0answers
124 views

Importing data from database into Excel Web Services with parametres

I need to enable people to import the data they need from an SQL Server database into Excel Web Services in SharePoint. They should be able to choose certain parametres for the query. So, for example, ...
0
votes
1answer
89 views

When will Microsoft stop supporting SQL Server 2005? [closed]

We are purchasing proprietary software that requires it run on a SQL Server 2005. My concern is we will not be able to change/modify/enhance at all. SQL Server 2005 is pretty old and want to know if ...
0
votes
1answer
223 views

How Do I Suppress SQL Server “Informational” Messages?

I've just installed SQL Server 2008 R2 Express for local development, and it's flooding the Application Event Log with a seemingly endless barrage of trivia and drivel ("SQL Server is now ready for ...
3
votes
1answer
490 views

Do Excel / SQL data connections refresh both ways

I've created a connection in Excel that fetches some data from our SQL server. The connection string looks like: Provider=SQLOLEDB.1;Persist Security Info=True;User ID=testuser;Initial ...
0
votes
1answer
2k views

SQL Server 2012 (SQLEXPRWT_x86_ENU) Installer doesn't open/do anything

I just downloaded SQLEXPRWT_x86_ENU (multiple times, to verify it worked as expected), which is supposed to be SQL Server Express 2012 with Tools, from here. It appears to be a file with no ...
0
votes
1answer
4k views

How to connect php 5.4.4 with microsoft sql server 2008 R2 in windows Xp?

How to connect php 5.4.4 with microsoft sql server 2008 R2 in windows Xp? i have installed xampp 1.8.0 with apache2.4 and php 5.4.4 embedded in it. i have installed microsoft sql server 2008 R2. i ...
10
votes
1answer
31k views

How to: Database Model in Visio 2013

I am unable to find the "Database Model" in Visio 2013 and upon linking an existing database to Visio, there is no option to Reverse Engineer. Where do I find this functionality?
0
votes
1answer
137 views

Why does a certain program need .NET Framework and SQL Server?

My question is not intended to provoke a deep discussion, I'm just looking for peace-of-mind. I'd like to download and play this simple game: ...
0
votes
1answer
96 views

SSMS starts without login prompt and stays inactive

recently my SSMS started working really weird, wasting my time. I am working on a laptop connected to additional monitor. SSMS starts without login prompt, and stays inactive as long as I dont shut ...
1
vote
2answers
377 views

Working on a .NET project in VMware Fusion – good way to edit files in OS X?

I'm working in a client's .NET-based web project right now – I have it running well in IIS with SQL Server in my VMware Fusion VM. The .mdf/.ldf files are in the project directory as well. I'm a ...
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
307 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 ...
2
votes
2answers
697 views

Import-CSV with powershell using a variable path

I am trying to import a CSV file with powershell in a database, with the path defined in a variable. But it doesn't seem to work. $path = "C:\Users\Admin\Desktop\TestFolder\file.txt" Import-CSV ...
0
votes
1answer
71 views

SQL Server Management Studio 2005 SQL dump

How can i create a SQL dump (structure and data) with the Management Studio 2005 or the MS SQL server?
2
votes
1answer
3k 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 ...
2
votes
1answer
2k views

how to connect to pervasive sql through odbc?

I am trying to add a linked server to a sql server 2012 database using ssms 2012. the linked server is pervasive sql. here's how i am trying to do it: EXEC sp_addlinkedserver @server = ...
0
votes
1answer
1k 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
vote
0answers
364 views

Change language of error messages in Windows 7 x64

My Windows 7 installation had Russian localization. When I encountered errors, I thought to translate the errors to Google into English. I decided to change the display language to English. In ...
0
votes
2answers
1k views

How to setup Vagrant Windows Server machine with SQL Server on it

Can anyone explain (or give a link) how to setup MS Windows Server VM using Vagrant on Linux (Arch Linux)? I was searching in Google but only think that I found are instructions how to setup Vagrant ...
1
vote
2answers
485 views

SQL Server 2012 bare minimum config for normal usage?

I would like to install SQL Server 2012 with the bare minimum required. I just want a local database and to be able to create/edit/query tables/write queries in the GUI editor. Which of the ...
-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 ...
1
vote
2answers
750 views

How to install Sql 2012 on Windows 8?

I am having trouble installing sql server 2012 on windows 8.
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
198 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
732 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
156 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
987 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: ...
2
votes
1answer
846 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
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 ...
2
votes
2answers
373 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
240 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
81 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
36 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 ...
2
votes
1answer
350 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
296 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
2answers
10k 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
574 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
321 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
813 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 ...
3
votes
1answer
7k 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
701 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
139 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
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
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
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 ...