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

Visual Studio: Tables always added offscreen when editing EDMX files

I have a number of ASP.NET projects which utilise .edmx files to access tables on the relevant database for each app. If I add a new table, I have to open the .edmx and click Update Model from ...
0
votes
2answers
4k views

how to synchronize local and remote database?

I have a database in SQL server on local computer, we have the same database on remote p.c , i want to sync it with remote server, is there any script for SQL server or any plugin? Thank you. OS: ...
0
votes
1answer
119 views

What is the thread_stack in Oracle and MSSQL compared to MySQL

I'm using a recursive stocked procedure in MySQL and had to change the thread_stack value in the my.ini from 128K to 512K. I need to deploy the same procedure now to an Oracle and Microsoft SQL ...
0
votes
2answers
241 views

How can Windows performance counter data be saved directly to SQL Server tables?

I would like to log data from a given set of Windows performance counters directly to tables SQL Server. Does Windows provide a way to do this without writing a custom application to do so? If so, ...
0
votes
3answers
5k views

SQL Server Express while attaching a database getting error 5120

I have SQL Server Express installed on my local machine. When I try to attach a database file, it's giving me the following error Unable to open physical file "C:\Adventures2012_data.mdf. ...
0
votes
1answer
54 views

Visual Studio and SQL Server

I've been looking for users that have development tools installed within a company and have identified many that have Visual Studio and believe they need to keep it because they do SQL Queries. In my ...
0
votes
1answer
472 views

List of Services for SQL Server 2012 Express

I recently installed VS2013 Preview onto a clean OS and I'm trying to figure out if SQL Server Express 2012 got installed. Unfortunately, when I look in Control Panel->Administrative Tools->Services, ...
0
votes
2answers
2k views

Remote access sql server 2005 over internet

I find so many similar question/problem and go through but unable to solve my problem. As so I am repeating the question again. I would like to connect my sql server 2005 remotely over internet. I ...
1
vote
1answer
2k views

Query parameters in an external connection to sql server

I want to do exactly this:http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/ but I want to do it in Excel 2010 and also I am querying SQL Server instead of MS ...
1
vote
0answers
41 views

Microsoft Server Deployment Training [closed]

I am creating a learning plan to become more proficient in deploying Windows 2008 Server R2 and Microsoft SQL Server 2008 and 2012. This is a work related goal, so getting a certificate or pass/fail ...
0
votes
3answers
55 views

Removing Microsoft SQL Server

I have quite a lot of Microsoft SQL Server installed on my computed which I'ld like to unistall. They were probably used by the previous computer owner, who used it for his software developing, and ...
1
vote
1answer
604 views

SQL Server Express “hangs”, on startup

I recently installed SQL Server 2012 "Express", and, also, Visual Studio 2012. I was working with it, and all worked ok. At some point, a few hours ago, SQL Server Express, however, started ...
-1
votes
1answer
2k views

.NET Framework 4 Extended?

To avoid XY, I will preface with the following: I am trying to uninstall an unneeded installation of MS SQL Server 2008 R2 on a production server. The server is also running SQL Server 2008 Express, ...
0
votes
2answers
313 views

Can't start SQL Server installation

I want to install SQL Server. I used the iso file en_sql_server_2008_r2_standard_x86_x64_ia64_dvd_521546.iso. I extracted the files using 7zip and started setup.exe – a setup window opens for few a ...
0
votes
0answers
93 views

SQL Server Data Tools Explore Data error

I am reading a step-by-step book to learn more about SQL Server Analysis Services. I am creating a dimension for an AdventureWorks data source. In the Design Diagram pane, I right click on the header ...
1
vote
2answers
70 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
99 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
3k 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
151 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
243 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
182 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
176 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
74 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
1k 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
1k 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
0answers
321 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
2k 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
109 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
78 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
182 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 ...
2
votes
1answer
401 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
1k 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 ...
9
votes
1answer
23k 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
130 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
79 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
306 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
240 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
602 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
64 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?
1
vote
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 ...
2
votes
1answer
1k 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
865 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
293 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
331 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
41 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
643 views

How to install Sql 2012 on Windows 8?

I am having trouble installing sql server 2012 on windows 8.