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

Missing arguments in SQL 2012 command line installation

I am new to SQL installation through command line. We are developing an application and using Installation Shield. I need to install SQL server on clients pc, so I am using command line silent ...
1
vote
0answers
439 views

SQL Server 2008 R2 - Process 6 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process

I am running Microsoft SQL Server 2008 R2 (SP2) - 10.50.4302.0 (X64) (Latest CU11, Feb 2014) on Windows Server 2012 R2. I have a simple database and a website that runs on the same machine using IIS. ...
1
vote
0answers
56 views

SQL Server - Database with strange storage space

I have a strange problem with one SQL server database: The database takes 180GBs on disk, with no space available; while the only table it contains should use only sth like 25GBs: EDIT: database ...
1
vote
0answers
229 views

excel sql server error: Invalid object name

I access a stored procedure on a Microsoft SQL Server 2005 database within excel using Select * from [dbo].[fn_ph_by15minbyQueue] ('2013-09-01','2013-09-30','LocationCode') in the data ...
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 ...
1
vote
0answers
170 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 ...
1
vote
0answers
99 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, ...
1
vote
0answers
279 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 ...
1
vote
0answers
192 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
0answers
312 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 ...
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
0answers
158 views

Errors while installing SQL Server SSIS 2005

I was trying to use SQL Server SSIS 2005 for the first time and mysteriously all the SQL SSIS menu items were missing from my start menu and then from the BIDS project choices even though I did a full ...
0
votes
0answers
13 views

Weird SQL Time and Date exception in Windows

OS: Windows - Environment: MySQL I am facing a weird problem (for me at least), I was running some tests on database activities, the full scenario is like this: I have two Java programs manipulating ...
0
votes
0answers
10 views

SQL Server Witness Server Alternative

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 ...
0
votes
0answers
11 views

Why do I have to provide the port to connect to my SQL Express server?

I'm playing around with puppet and vagrant. As part of that I installed SQL Express in a Virtualbox using vagrant. That worked just fine, but for some reason I have to specify the port number in the ...
0
votes
0answers
24 views

Setting up SQL Express on Azure VM

I'm trying to set up SQL express on an Azure VM. I already have SSMS 2012 installed but I cannot access .\SQLEXPRESS. This MSDN discussion says: run powershell script "ConfigureSQLExpress.ps1" ...
0
votes
0answers
23 views

unable to access network share and cannot access sql server on windows 8 over vpn

I was wondering if anyone has any tips on this issue I am having. I am running windows 8 and I basically have setup VPN exactly the same as how I have it setup on windows 7. But for some reason over ...
0
votes
0answers
106 views

OpenFire connect to SQL Server Database: Network error IOException: Connection refused

I am trying to get OpenFire to run with my SQL Server. I am following the instructions at Instructions. I have created a new database, named it OpenFireDB, and have created a new login and user, both ...
0
votes
0answers
25 views

If MSSQL machine is maxed out on resources, can it drop off the network and become un-pingable?

The issue is that our SQL machine will just disappear from the network with request timed out when I attempt to ping it. I have to deal with an "IT Guy" who is telling me that it is because Microsoft ...
0
votes
0answers
60 views

Visual Studio 2013 + Business Intelligence SSDT and missing Reporting Server templates

The other day I have installed Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 (SSDT: Replacement for BIDS) and started using reporting features in VS2013. However, ...
0
votes
0answers
26 views

Change SQL server back to a trial

I need to convert a SQL Server 2008 instance on a VM (which is licensed) back to a trial. What are the steps to do this? REASON for this: Need to give a VM with a custom solution on it to a 3rd ...
0
votes
0answers
16 views

Microsoft SQL: dealing with invalidated databases

I created a Microsoft SQL Server database that has now changed location. (The details are probably unimportant, but for the curious, I originally created it in a folder on an external drive mapped to ...
0
votes
0answers
26 views

SQL Server Error

I am getting the following error: Executing (Error) Messages Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Base Unit of Measure " returned status value ...
0
votes
0answers
25 views

Equivalent to VirtualBox Oracle dev environment available for SQL Server?

Oracle has this wonderful option in VirtualBox where you can download a virtual Linux machine that is setup with SQL tools and a running instance of Oracle. This setup makes it much easier to test or ...
0
votes
0answers
10 views

Business Intelligence for VS2013

I have a small dilemma/issue right here, I've installed this http://www.microsoft.com/en-us/download/confirmation.aspx?id=42313 in order to use Reporting Services with my SQL Server 2014, but when I ...
0
votes
0answers
6 views

Unable to restore testcase database of quality center 9.2

We are using quality center 9.2 for storing test cases. Recently the Quality center server had some issues, so we took back up of entire C drive and formatted the PC and installed OS newly. Now we ...
0
votes
0answers
36 views

SQL Server Data Input

I am new to SQL databases. Due to the huge data that I am dealing with I decided to create a SQL server. My data is mostly in the format of index_1(text) index_2(text) index_3(text) ...
0
votes
0answers
130 views

Unable to uninstall SQL Server 2008 R2 on Windows 7

I'm trying to uninstall SQL Server 2008 R2 on a Windows 7 machine. I keep getting this error message: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\sqlcab.dll ...
0
votes
0answers
67 views

Unable to Create Linked Servers using SSMS on SQL server 2008 R2

I am unable to create or view properties of the Linked Servers from SSMS on SQL server 2008 R2 and the error appears "cannot find table 0. (System.Data)" also the providers are not being displayed ...
0
votes
0answers
95 views

SQL Server 2008 (64-bit)

I have transaction log backup failures randomly. SQL Server Log says: Memory constraints resulted reduced backup/restore buffer sizes. Proceding with 6 buffers of size 64KB.', and the SQL Server ...
0
votes
0answers
92 views

Duplicate SQL Server Database with Access Front End on Remote Machine

I used the SQL Server Migration Assistant to move an Access back end to SQL Server 2008. I tested it on my SQL Express, but actually did the migration via terminal server on my client's machine. The ...
0
votes
0answers
367 views

Windows server 2012 becomes slow

I have a server with following configurations. This is new IBM X3630 M4 server established before one month. Processor : Quad core Xeon E5-2620v2 single processor RAM : 8 GB NIC : 2x 1GbE HDD : ...
0
votes
0answers
38 views

How do I nest sp_msforeachtable in sp_msforeachdb?

Essentially I'm trying to select the top 100 rows for each table in each db on the server I could accomplish that using a cursor and metadata tables I guess, but can this be accomplished using the ...
0
votes
0answers
24 views

SQL Server User-based CPU Limit

30 clients connecting to server through rdp. They are using an Accounting Software. This causes SQL Server uses too much memory. Is there any way to limit the CPU in the user-base, rather than ...
0
votes
0answers
189 views

How to do a cross apply in MS Access?

I have a cross apply query that I wrote in the SQL Server Mangement Studio where I can't seem to figure out how to write the same query in MS Access. I know how to do a GROUP By in MS Access the ...
0
votes
0answers
17 views

SharePoint 2007

MSSQL management studio 10.50.1617.0 Microsoft Data Access Components 6.1.7601.17514 Farm Information Version : 12.0.0.6421 Sharepoint 3.0 Central administration. Exception from HRESULT: ...
0
votes
0answers
125 views

Fix/Reinstall SQL Native Client?

Don't know what happened but on my Windows 7 64bit the connection to SQL2005 using SQL Native client is not working anymore. More in detail, if I try to connect to the SQL server using oledb it works ...
0
votes
0answers
37 views

Monitoring SQL Server Log Shipping with multiple secondaries

I've seen the Transaction Log Shipping Status Report on SSMS, and i'm wondering if there's anything to monitor Log Shipping with multiple secondaries.
0
votes
0answers
119 views

Shift+Tab Loses Alignment in SQL Server Managment Studio 2012

Issue #1: I'm using the following for demonstration purposes: SELECT A.Field1, B.Field2 FROM TableA as A JOIN TableB as B ON B.ID = A.ID WHERE A.FieldA = 'A' AND B.FieldB = 'B' GROUP BY ...
0
votes
0answers
46 views

Free Source Control for .sql files to run alongside SSMS

Does anyone use source control for there .sql files? My job revolves around a suite of approx 75 stored procedures in sql-server. I'm now sharing the development of these files with a colleague. ...
0
votes
0answers
165 views

SQL Server 2005 Express connection

On my computer I had installed Windows XP Service Pack 2. Then I installed Visual Studio 2008 SP1 and then SQL Server 2008 r2 and SQL Server 2005 Express. Up to that I had no problem using SQL Server ...
0
votes
0answers
136 views

BDE Administrator closes unexpectedly when open database

I don't know what happened on my Windows XP Home system for doing this, always worked perfectly but now when i try open a database the DBE Administrator closes unexpectedly without showing any error. ...
0
votes
0answers
20 views

Trying to install SQLExpress tools goes nuts, attempts to install Ati Radeon driver

This applies to all of the downloads with tools, the database itself isn't the problem. Attempting to follow what's going on I find it unpacking itself into a directory on the drive with the most ...
0
votes
0answers
334 views

How to install Mahout on Windows 8.1?

My goal is to build up a recommendation system and after going through many articles, I came across Mahout as a simple, yet effective way to go on. I already have XAMPP installed on my system. How ...
0
votes
0answers
254 views

How can I access my home MS SQL Server DB from a remotely hosted web service?

As can probably be seen (if not already see below) I am fairly networking illiterate. Here is what I would like to do: Setup a SQL Server DB hosted on a computer I have in my home. I want to be able ...
0
votes
0answers
580 views

Windows could not start the SQL Server (mssqlserver) service on local computer error 17058

I'm working with a virtual machine on Windows 8. There is a SQL Server 2008 on the virtual machine. And in the services, when I try to start the SQL Server service I am getting an error like this:
0
votes
0answers
103 views

OTRS and MS SQL Server

I'm installing OTRS Help Desk for our organization. We're installing the application on a CentOS server but would like to connect to a Microsft SQL Server database. However, I was not able to install ...
0
votes
0answers
25 views

SQL Server and Windows 2008 Firewall rules

I have SQL Server Express 2008 installed on a Windows 2008 R2 box. There is a 3rd party application which needs to access SQL Server over the network. For some reason, the app is unable to do this, ...
0
votes
0answers
90 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 ...
0
votes
0answers
237 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 ...