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
359 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 ...
6
votes
1answer
17k 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
1answer
206 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
1answer
37 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 ...
1
vote
0answers
600 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
320 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
3k 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
1k 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
170 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
375 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 ...
1
vote
1answer
430 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
231 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
135 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?
4
votes
4answers
2k 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
441 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
363 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
1answer
47 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 ...
7
votes
5answers
12k 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
4k 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
2k 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
1answer
246 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
91 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
854 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
68 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
3answers
4k 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 ...
1
vote
1answer
248 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
67 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
46 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
2k 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
339 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
357 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
126 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
3k 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
4k 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
2k 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
39 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
6k 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
135 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
400 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
7k 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
69 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
574 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
4k 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 ...
0
votes
3answers
62 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
829 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
407 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
119 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 ...