Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql-server-2012]

The tag has no usage guidance.

0
votes
0answers
12 views

Error Deploying Microsoft SQL Server Report Designer

We are getting the following error when we are trying to deploy the reports: Microsoft SQL Server Report Designer Could not connect to the report server http://sn12345/ReportServer_sn12345. ...
0
votes
0answers
16 views

Windows Server 2012 R2 Resmon showing incorrect drives (Letter\Number)

I have a bit of a weird one that I hope one of you have come across. In Resmon, my C, D, E, and F drives all show up as follows: H:2\ H:3\ H:4\ H:5\ In Perfom and Disk Manager it shows up correctly. ...
0
votes
0answers
13 views

Will deadlocks occur when deleting rows from a table when being added to by another process? [migrated]

I have to archive data from a table into another table whilst the original table is in use. The archival process is to copy the rows into another table and then delete the rows from the original ...
0
votes
0answers
39 views

Haw can I execute my VB script in every 5 minutes automatically

I write a VB script and I need to run this script as a trigger in every 5 minutes My code is as follows: Sub Write_data_record_into_a_table() '////////////////////////////////////////////////////////...
0
votes
0answers
11 views

Access SQL Server VM hosts and files

is there a way to access my VM hosts from my pc? It's really painful the coding process inside the VM itself, and, is there a way to access its files from my PC too?
0
votes
1answer
40 views

Accessing the database is very slow from a hosted website and fast when accessed from localhost

We've been having a problem which seems to have just sprung out of nowhere. We have a NopCommerce website which our client has hosted off his own server. We have 1 web server which has Windows 2008R2 ...
0
votes
0answers
39 views

SQL Server 2012: Create audit failed (user permission)

I am logged in SQL Server 2012 as db_owner user, I am trying to create an Audit but I receive this error: User does not have permission to perform this action What kind of permission does the ...
0
votes
1answer
490 views

How to change edition of SQL 2012 from express to standard

I have a Windows Server 2012 R2 Standard that is running SQL 2012 Express. How do I go about changing it to be SQL 2012 Standard? I have the media (and ISO image) and it is currently mounted. I ...
1
vote
2answers
2k views

Net stop <service> system error 5 access denied

From SQL server 2012 I try to do this: DECLARE @COMMAND nvarchar(4000) SET @COMMAND = 'net stop <servicename>' exec master.dbo.xp_cmdshell @COMMAND I get system error 5 and Access denied as ...
1
vote
1answer
2k views

Elegent way to set variables in .ini files

I'm currently trying to script the installation of Microsoft Sql Server 2012, and I've run into a problem with letting the user set options for the installation process in my powershell script ...
1
vote
2answers
3k views

SQL Server Management Studio CPU and RAM usage keeps increasing for no reason

I have a weird problem with SQL Server Management Studio, version 11.0.2100.60. When I was writing some query, sometimes the CPU gets hogged, and RAM usage keeps increasing. Usually closing and ...
0
votes
0answers
40 views

Windows / SQL Server upgrade

We are currently using Windows server 2008 R2 OS and SQL SERVER 2008 R2 and asp.net 3.5. Now we are planning to upgrade to Windows server 2012 OS and SQL SERVER 2012. Windows server 2012 is comes with ...
2
votes
0answers
376 views

SQL Server Express no longer starts up automatically

I had SQL Server 2008 Express (SP1) on Windows 7 Pro and it was working fine. After upgrading to Windows 10, SQL Server 2008 Express was still working normally. However, after the last Windows update (...
1
vote
1answer
243 views

How to schedule a recurring SQL Server 2012 DB backup using sqlcmd ?

I'm looking for a way to create a monthly recurring backup of a SQL server database using sqlcmd. I've seen scripts for SQL Express, but they only execute once. I'm looking for a sql script that will ...
0
votes
1answer
452 views

Prevent Help Make Microsoft SQL Server 2012 Better message

When starting Microsoft SQL Server, I get this message: Help Make Microsoft SQL Server 2012 Better How can I prevent this from showing?
6
votes
2answers
6k views

Results view does not change with zoom feature in SQL Server Management Studio

The zoom feature in SQL Server Management Studio is not changing the results window. I have come across many posts that say the zoom controls both the query window and the results window. What do I ...
1
vote
1answer
538 views

How to debug unattended installation of MS SQL Server 2012?

How can I diagnose and debug a configuration file for an unattended installation of MS SQL Server 2012? What I'm doing -- I'm building an installer for a product. The product requires MS SQL Server ...
0
votes
1answer
1k views

Upgraded to windows 10 and now can't connect to sql server 2012

I upgraded to Windows 10 on my laptop. I have opened SQL Server Management Studio, but it can't connect to the server. I have looked at a few other questions, but nothing seems to work. I get the ...
1
vote
1answer
38 views

Copy columns between tables in different servers

Recently I moved to SQL Server 2012 from SQL Server 2005. Current scenario worked without any problem in SQL Server 2005. 1)Connect to server A 2)Open table X 3)Copy 3 columns(Clicking on ...
1
vote
0answers
112 views

How do I connect a SQL Server synonym to an Excel data model?

I have a SQL Server (12.0.411) database with a view that is referenced by a synonym. I want to load the data from the view into Excel's data model using the synonym. In Excel (Microsoft Office ...
4
votes
3answers
34k views

SQL Server not working after upgrading windows 10 from windows 8.1

My Sql server 2012 has stopped working and now its not letting me login. Here is the error: https://drive.google.com/file/d/0ByGXmosQgHUqdGw4alFSb3otVkk/view?usp=sharing TITLE: Connect to Server ...
1
vote
0answers
42 views

SSMS2012 Help going to Chrome rather than MSIE

Running Win7 Ent 64bit From within SSMS 2012 SP2, when I hit F1 (or Help, View Help), I am taken to Google Chrome rather than MSIE11. By every indication I can find, MSIE11 is my default browser, not ...
0
votes
0answers
34 views

SQL Server 2012 change query result position [duplicate]

Traditionally in SQL Server while executing a query the result is displayed below the query dividing the screen horizontally. Is there any settings that can be done to displays the result to the side ...
1
vote
0answers
157 views

Cannot install SQL Server 2012

I'm trying to install SQL Server 2012 and got this message: SQL Server Setup has encountered the following error: The resource 'Microsoft.SQL.Chainer.PackageData.Package.xml' failed to load from 'E:\...
1
vote
1answer
2k views

How to find out MS SQL Server Enterprise Edition Expiration Date?

I have MS SQL Server Enterprise 64bit Install on VMplayer, Version: 11.0.3128.0 Product LVL: SP1 Upon installed, there is no documents indicates how long this license will last. Anyone can ...
0
votes
0answers
448 views

SSMS and SSDT requires administrator

I connect to a client's Server (Server 2012R2) via RDP. I always get the UAC prompt when I start the SQL tools, managemant studio (SSMS) and data tools (SSDT). If I press cancel in the UAC dialog the ...
2
votes
1answer
604 views

Freshly installed wiki still shows red links for pages that have been created?

I just set up MediaWiki for a test run on my laptop. Windows 7, PHP 5.4, SQL Server 2012 SP2, IIS 7, MediaWiki 1.23.6. The installation went smoothly once I got everything in order and I can create ...
1
vote
1answer
479 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 ...
0
votes
1answer
2k views

SQL 2012 in Hyper-V. Why are my queries slow until I drop and create any spatial index?

I have a spatial application that queries several tables (layers) each time the user pans/zooms the map. When I moved the SQL server into Hyper-V, I noticed that there was a several second delay when ...
0
votes
1answer
1k views

Trying to change the color of database and variable names

I am customizing the colors and can't for the life of me find the option to change the color of database/table and variable names ..they are stuck that odd teal color, Ive changed the color of ever ...
3
votes
1answer
2k views

Broken dropdowns in SQL Server Configuration Manager on Windows 8.1

I recently installed a new virtual VMWare machine for development purposes. The machine has Windows 8.1 (64 bit), Visual Studio 2013 and Microsoft SQL Server 2012 Standard Edition, all with latest ...
1
vote
1answer
2k views

SQL Server 2012 installation on Windows 8.1 Single Language

I tried to install SQL Server 2012 with SP1 on Windows 8.1 Single Language, but it terminates straight after starting with this helpful error: I've read that you need SQL Server 2012 SP2 on Windows 8,...
0
votes
1answer
2k views

Assign login to SQL user without login

Environment: SQL Server 2012 Express Edition and Microsoft SQL Server Management Studio. All users are local SQL users, NOT Windows authentication. I attached a database file which came from another ...
1
vote
0answers
515 views

Changing font color in SSMS for different database elements?

I'm trying to change font color of different database elements, for database name to show up one color, table name to show up another and table aliases to be separate color. Is it even possible? ...
0
votes
2answers
6k views

SQL Server 2012 configuration manager not opening in windows 8.1

I run SQLServerManager11.msc in apps to search but nothing happen. Need Help. It is install and showed in control panel.
1
vote
3answers
10k 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
3k views

Execute Backup-SqlDatabase cmdlet remotely

When I run the following script line locally on an SQL Server machine, it executes perfectly: Backup-SqlDatabase -ServerInstance $serverName -Database $sqldbname -BackupFile "$($backupFolder)$($...
0
votes
1answer
956 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, ...
1
vote
1answer
9k views

Windows Server 2012, SQL Server 2012 and .NET Framework 4.0

We want to start developing on the newer versions of Windows Server 2012 and SQL Server 2012. At the moment we are using Visual Studio 2010 with the .NET Framework of 4.0. We are not creating desktop ...
1
vote
1answer
2k 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"...
1
vote
1answer
5k 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
4k 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" ...
1
vote
2answers
9k views

How do I download SQL Server 2012 Express?

I feel like an idiot asking this question, but I can't seem to find the magic combination. (Or maybe Microsoft's website is broken. I'm not sure which.) Anyway, here's what I'm trying. Open SQL ...
1
vote
1answer
47 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
6k views

Unable to install SQL Server 2012

When I am trying to install a new instance of SQL server 2012 on my server, I get the following error message when I try to run the iso (before any gui appears): The operating system on this ...
19
votes
3answers
8k views

Floating or vertical results pane in SQL Server Management Studio

I have a multi monitor configuration and would like to be able to have my query editor on one monitor and the results pane on another. Can this be achieved? Either by having the results pane ...
1
vote
2answers
24k views

SQL Server 2012 fails to install or remove

Got an odd problem here. Installed programs is showing SQL Server 2012 installed, but fails to remove itself when running the uninstaller. To add insult to injury, it also won't let install the ...
0
votes
2answers
6k views

SQL Server 2012 Maintenance Plan can't modify

Click on any created Maintenance Plan: TITLE: Microsoft SQL Server Management Studio Value cannot be null. Parameter name: component (System.Design) BUTTONS:OK Create a new Plan I get this error: ...
28
votes
7answers
107k views

Move database from SQL Server 2012 to 2008

I have a database on a SQL Sever 2012 instance which I would like to copy to a 2008 server. The 2008 server cannot restore backups created by a 2012 server (I have tried). I cannot find any options ...