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

-2
votes
1answer
27 views

How to install MS SQL Management Srudio for SQL Server 2008?

I have downloade SQLManagementStudio_x86_ENU.exe file, but when I run it, it starts global SQL server 2008 installer where I can't find any signs of Management Studio.
0
votes
2answers
651 views

Can't detach database in SQL Server Management Studio after accidentally deleted mdf file

I'm working with a bunch of *.mdf files which I'm attaching on my local computer. After I accidentally deleted the a folder containing some of the *.mdf files, I'm unable to view the databases in SQL ...
0
votes
1answer
62 views

Why do I have to manually add Local Activation permission for domain account even if it's a member of the local Administrators group?

A SQL Server 2012 agent job was failing with: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {...} and APPID ...
0
votes
1answer
45 views

Best practice on how to update & reboot a live server [closed]

We have a business critical server that has not been re-booted in over 2 years. It is running Windows Server 2003, with SQL Server 2005 (SP3), Visual Studio 2005 and 2008R2, and has numerous versions ...
0
votes
2answers
141 views

What are the risks of copying MDF/LDF files without detaching the DB first?

Our support team have been trained to restore databases by stopping the instance service and then copying a backup of the LDF and MDF files into the folder. All without detaching or attaching the DB ...
0
votes
1answer
43 views

How to repair .mdf file?

My sql databases in SQL Server 2014 has the status "suspend" as I saw in SQL Management Studio. I can't restore to serviceable condition sql databases through standard procedures. I need to restore ...
2
votes
1answer
3k views

Default SA password of SQL Server automatically installed by SharePoint Server 2010 setup

I installed SharePoint server 2010 recently on a test server. It was installed in standalone mode. After the installation, I realized that it had installed SQL Server Express 2008 (10.0.2531.0) ...
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
94 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
34 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
1answer
27 views

Log file viewer not displaying database where error occurred

Something keeps being logged to files located here: C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER\MSSQL\Log Files like these keep getting updated: SQLFT0000700007.LOG 15 errors per ...
0
votes
0answers
109 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 ...
1
vote
0answers
393 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. ...
0
votes
0answers
44 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
139 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 ...
1
vote
1answer
1k views

What is the difference between MySQL, SQLite and other SQL servers?

I was digging around in my server and I started to wonder what the difference is between MySQL and SQLite and other SQL servers. If anyone can make this clearer, could you also explain if they have ...
0
votes
2answers
509 views

What characters are allowed in in column (nvarchar 50) of MSSQL Server 2008?

I have a column in MSSQL which is nvarchar(50) in which I enter passwords for users. I know that for example some special characters like $ % are allowed, but where do I see which list characters are ...
0
votes
0answers
129 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. ...
-1
votes
2answers
282 views

SQL Server Database Encryption [closed]

Let's say two programmers are working on a website for a store. They've created a small database for an online store. Users would have to register and provide a username(e-mail address) password,home ...
0
votes
0answers
200 views

Invoke-Sqlcmd not working after PowerShell 4 install

I installed PowerShell 4 yesterday and ever since then, I get the error "The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function". This has been working just fine for months ...
4
votes
1answer
134 views

Copying out color theme background from SQL management studio to Outlook

I have a color theme set in SMS 2012, where the background is dark and some of the syntax is white, when I copy and paste this out into an email (white background) the dark background of management ...
0
votes
1answer
94 views

How to access SQLite database?

I have run BinDiff on two binary files, and stored the results in a .BinDiff file. (Which the manufactures assure me is just an SQLite database. How would I open and access this database?
2
votes
4answers
949 views

MySQL - “Root Element is Missing”

Something has happened to the MySQL server installation on my computer. Normally, the MySQL notifier program, which is supposed to start automatically and run in the system tray has stopped starting ...
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
324 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
249 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
571 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
1answer
40 views

MS Access Autonumber dilemma

I am using a sql query that will copy the data from one table to another. The problem though is the counter which I put in the Second table of my Insert into Select Statement. It all started from ...
3
votes
4answers
6k views

Cannot find one or more components. Please reinstall application

I am running Windows 8, 64 bit and have SQL Server 2012 installed. I downloaded the client tools, looked in the directory for SQL Server Management Studio, and see it's there. When I try to run SQL ...
0
votes
2answers
2k views

How do I login to MS SQL server ? authentication

I have no idea on how SQL works. I'm just trying to use a program that is using SQL Server. I have SQL Server 2005 and 2008. In my start menu I only see a list of programs in 2008. In the 2005, I ...
0
votes
1answer
1k views

Connecting to a local SQL Server instance fails with an error

I have installed MS SQL Server 2008 R2 with authentication mode but when now when I click to the connect I gives such kind of error: A network-related or instance-specific error occurred while ...
0
votes
0answers
96 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
1answer
135 views

Unable to run dtsx package

Error is thrown "To run a SSIS package outside of SQL Server Data Tools you must install SSIS log provider for SQL Server of Integration Services or higher." When I am trying to run package from ...
0
votes
1answer
73 views

SQL : swap 2 values in a column without using an intermediate value

Given a table with a single column containing only 2 values, say 'A' and 'B', is there a way to swap them in a single statement Ex: A B A B to B A B A It is a trivial process if we use a bit ...
3
votes
1answer
516 views

Calculation takes forever in large data set on Excel

I connected my excel to ODBC SQL Database(SQL Server) and now my excel pivot table is getting its data from the sql server VIEW. There is a total of about 1 million plus rows from the QUERY. From the ...
1
vote
0answers
53 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 ...
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
3answers
2k views

Error message on SQL Server 2012 install

I am trying to install SQL Server 2012 Standard Edition on my Windows Server 2012. The installation keeps failing, and I have tried everything that I can come up with, but nothing helps. The error ...
0
votes
0answers
161 views

TFS 2012 Backup configuration fails. “TF400998: The current user failed to retrieve the SQL Server service account information”

I'm at a loss with trying to find a solution to this issue. When I am trying to create a backup plan in TFS 2012 I get "TF400998: The current user failed to retrieve the SQL Server service account ...
0
votes
1answer
130 views

Can't open SSMS - stating I don't have permissions

Whenever I try and run SSMS I get the following error. 'Windows cannot access the specified device, path or file. You may not have the approiate permissions to access the item. ' The dialog box ...
0
votes
1answer
59 views

MS SQL Server 2012 drives

I am buying machine for MS SQL Server 2012 Standard and I have questions about drives and performance. How to locate OS, database, logs, backup on WD RE4 500GB and Intel SSD DC S3500 120GB? OS, ...
3
votes
1answer
44 views

SQL Server 7 Transaction Logs Issues

Over the week my database server transaction log was full. With our app people could select from the database but could not update or insert into the database. In the past we have just truncated the ...
0
votes
2answers
1k views

Files left after uninstallation of MS SQL Server

I just uninstalled MS SQL Server 2008 from my machine (using the "Uninstall or change a program" feature in Windows Control Panel). Now I notice that there's still a lot of files left. Around 1 GB ...
1
vote
1answer
215 views

Deployment Fail During Generate Star Schema

I am Using SQL Server Data Tools for Visual Studio 2012 for Generating Start Schema.I am using one Database with four Tables.When i am Click on Start Button. I Got This Error The project could ...
1
vote
0answers
213 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 ...
0
votes
1answer
91 views

SQL Server Unattended Install through SSH

I'm trying to install SQL Server from the command line through Cygwin open-ssh. The install works when I log onto the server as Administrator and execute the script through a Cygwin shell, but the ...
2
votes
2answers
2k views

Can't connect to local Sql Server while connected to a VPN

We have a Sql Server in our office here that I connect to regularly. No problems. We have a client now to whose VPN we need to connect using the Windows VPN software. When I connect to the VPN ...
2
votes
1answer
1k views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
2
votes
2answers
672 views

understanding Microsoft Download Center naming convention

The following are the download names for SQL Server Express Editions. SQLEXPR_x86_ENU.exe SQLEXPR_x64_ENU.exe SQLEXPR32_x86_ENU.exe The machine I have is a 32 bit intel machine. Which one should ...
1
vote
0answers
33 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 ...