Tag with [sql-server] the question related to each database server that implements SQL (Structured Query Language) and not related with the specific Microsoft one. For the latter use the specific tag [ms-sql], or if related with a specific version with the relative tag [sql-server-2012], [sql-...

learn more… | top users | synonyms

29
votes
10answers
146k views

How do I open SQL Server Management Studio?

How do I open SQL Server Management Studio? I installed it but I don't see where I can open it.
2
votes
1answer
2k views

Microsoft PHP SQL Server Drivers not working, cant load module

I am trying to install Drivers for PHP to be able to talk to my SQL Server. I am running PHP 5.5.15 on XAMPP, and SQL Server 2014. I downloaded a driver package from here: http://www.microsoft.com/en-...
0
votes
1answer
359 views

How does SQL Server deal with a missing tempDB?

Azure has announced the new "D" series of VM's where the temporary drive resides on a SSD I was planning to use this as the tempDB, it should speed up SQL somewhat with faster temoDB access. However,...
0
votes
0answers
1k 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
1answer
52 views

Sql Server 2012 Replication Report

We have about 30 users with local installs of SQL Server that have to replicate merge their local data once a month with a central SQL Server 2012 repository. Is there a SQL Server first-party or ...
0
votes
1answer
79 views

Silent, power saving mini-server for home [closed]

I am looking for hardware to make a small, silent, power saving mini-server for use at home. My specifications are: Small Fanless / Small fan Able to run Windows server OS Has 2GB of RAM, ideally ...
0
votes
0answers
41 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
38 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 ...
1
vote
1answer
215 views

Migrate SQL Server 2014 Enterprise to new machine

We had Bizspark, which we are now graduates of. As I understand from the Bizspark page: You can keep, at no charge, all the software you downloaded, including a standard configuration of Windows ...
0
votes
3answers
7k 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
2answers
314 views

Can I change the default folder location for applications?

Basically I want to know if it is possible to change the path of certain applications that are saving folders in My Documents. For example: Whenever I open SQL Server Management Studio it creates a ...
0
votes
1answer
403 views

Comma delimited import issues in SQL Server

I am having a problem with SQL Server. I have a table with 42 columns to which there is frequent monthly imports. These imports are from a flat file using the import and export wizard. My problem is ...
17
votes
1answer
51k 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
2answers
4k 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
13 views

Programmer's guide to Server Resource Usage Report [closed]

I have ASP.NET MVC 5 Application running on a Windows Server 2012 and a Database Server running SQL Server 2012 on Windows Server 2012. I am trying to get a report on the Resource usages of these ...
1
vote
3answers
2k views

Commas in Comma Delimited Files

I have a SQL export that is comma delimited, but some of the data has commas in it. Is there any way to fix this? I'm guessing I am going to have to re-export the data with a different delimiter.
-1
votes
1answer
102 views

SQL server not able to stop on windows 8 … please help … using sqlserver 2000 on windows 8 home

I am currently using a software which is dependent on SQL server 2000. However whenever i try to exit the program and try to stop the SQL server i get a message-- An error 5 (access denied) occurred. ...
0
votes
2answers
3k views

How do I connect to some local DB server in MS SQL Server 2012? [closed]

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
1
vote
2answers
763 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
2answers
4k 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
68 views

Sql server 2012 process reaches 2 GB of memory in one hour if open Management Studio

I have strange situation with Sql Server 2012. If I open Management Studio 2012 (11.0.2100.60) and make some query on a table, the process sqlservr.exe reaches 2 GB of RAM memory in one hour. It ...
0
votes
0answers
614 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
2answers
2k 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 ...
0
votes
0answers
218 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
1answer
108 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?
0
votes
1answer
52 views

How to automatic backup SQL server registered servers?

I have many servers registered. I don't know where this information is saved. After PC rebuild, they are gone. Is there way to schedule task to backup this information?
0
votes
1answer
414 views

Logging on to SQL Server from a Windows 8.1 PC over a VPN

I currently work remotely (new position) and am logged into my Windows 8.1 development machine with my Windows Live account. I can connect to our corporate LAN via VPN but can not access SQL Server ...
1
vote
1answer
1k 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 "hanging"...
0
votes
1answer
2k views

How do I disable automated SQL Server Backups?

SQL Server seems to be doing full backups (.bak) at random intervals then storing them into, C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup Is there an option to ...
0
votes
1answer
179 views

Error in installation of SQL Server 2008 Management Studio

I have installed SQL Server 2008 Express on my machine but I can't find the Management Studio. I downloaded two versions of SQL Server Management Studio, 2008 and R2 This is the result I don't ...
0
votes
1answer
270 views

Installing Sql Server 2012 on Vmware Virtual Server 2008 R2

I have a Virtual Windows Server 2008 R2 set up, I downloaded Sql Server 2012 Evaluation Copy. Now when I try to Install the Sql Server it throws an error, No Error message nothing at all just an error ...
0
votes
1answer
29 views

WEB-INF/web.xml displays mysql credentials?

I found web.xml in /WEB-INF/ on a domain I'm associated with. In said xml file, I see it displays: <database> <jndi-name>jdbc/mysql</jndi-name> <driver> <...
-2
votes
1answer
39 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
1answer
229 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
58 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 ...
4
votes
2answers
3k 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 ...
2
votes
2answers
984 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
0answers
235 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
546 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
votes
2answers
589 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
7k 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 ...
7
votes
3answers
50k views

How to remove a broken installation of SQL Server 2008?

After installing the Service Pack 2 of Microsoft SQL Server 2008, the SQL Server failed to start. Trying to repair this, I've done some stupid things, which results now in the situation in which I ...
6
votes
6answers
6k views

Why am I not able to create a backup plan for TFS?

I am trying to create a backup plan using the TFS Power Tools but I keep running into this error message: I have checked that the account has Full Control on the share, I can edit, create and delete ...
0
votes
1answer
3k views

How to backup Windows 7 Live Photo Gallery?

How do I backup Windows Live Photo Gallery? I've been running on Windows 7 RC and I want to upgrade to the full Windows 7 release. I've been managing my photos with Live Photo Gallery. I want to ...
0
votes
0answers
21 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
1answer
181 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?
0
votes
0answers
603 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
527 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
62 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 ...
1
vote
2answers
9k 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 ...