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

SQL Management Studio external database only

I'm trying to speed up my PC, and I figured out that a full version of SQL Management Studio 2012 is installed including localhost server. I only need to connect to remote hosts, so running a local ...
-3
votes
2answers
111 views

how to create website using asp.net and sql server 2005 as backend? [closed]

How to create website in asp.net and sql server 2005 as backend? And i wants to know it is possible to use stored procedure in this Website? How to upload this website into server?
0
votes
2answers
4k views

Cannot uninstall SQL Server 2005, no matter what I do

Windows 2003 Server R2 64 bit I do Control Panel, remove programs, and get: Setup failed.. the dialog box disappears so fast that I am unable to write down all the messages, but the items get the red ...
0
votes
1answer
175 views

Microsoft.SqlServer.SMO.dll issue in powershell

I dont have a sql server installed in my server. I am designing a powershell script that can execute sql scripts remotely in a db. I have powershellv1.0 in my server and dont have ...
0
votes
0answers
304 views

VS2010 Program won't connect to MYSQL from local SQL Server Computer

my problem here is very weird compared to other that I found on this forum. The VB program is created with VS2010 from computer "A". It work perfectly. Connection to SQL Server and MYSQL DB. But when ...
1
vote
1answer
274 views

Windows 8 & Server 2012: SQL Server Connection Delay

When connecting from a Windows Server 2012 or Windows 8 box to a SQL Server machine, it takes 2 sec to open a SQL connection and .5 sec for any SQL command to execute. Connecting to the same SQL ...
1
vote
0answers
221 views

How to set up Openfire XMPP server?

I have installed Openfire and Microsoft Sql Server Management Studio 2102 on my PC. I have made a database called openfire, conected to it, and have executed the script called openfire_sqlserver.sql ...
0
votes
1answer
78 views

Edit sql code instead of clicking buttons

Does SQL Management Studio 2012 allow editing the SQL DDL (data definition language) code directly? If not, how can I view only the SQL code generated by the application?
1
vote
1answer
2k views

Impossible to Start SQL Server browser

I installed SQLserver Express 2012 on a Win7 machine. The lan is made out of 2 PCs (Win7 and Win XP). I cannot access the SQL server from the Win XP machine. I cannot start SQL server browser. I ...
1
vote
2answers
2k views

MS SQL Server 2012 Express Setup crashes with .NET error

I'm trying to install MS SQL Server 2012 Express on a virtual machine at a client. It's fresh install of Windows Server 2008 R2 Enterprise SP1. I added the "File Services" and "Application Server" ...
2
votes
1answer
1k views

The Login is from an untrusted domain - domain setup with computer level login

I have a SQL Server 2008 R2 database I'm attempting to connect to using ADO.NET using integrated security in the connection string. The database resides on a 64-bit Windows Server 2003 machine. The ...
0
votes
1answer
437 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
133 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
91 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
244 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
510 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
5k 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
33k 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
140 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
100 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
397 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
332 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
728 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
76 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
389 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
546 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
788 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
211 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
755 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
161 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
1k 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
906 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
94 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
397 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
248 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
84 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
37 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
377 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
316 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 ...