Super User
Super User

Questions tagged [sql-server-2012]

51 questions
29
votes
7 answers

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 in 2012 to create a 2008 compatible backup. Am I…
Rich
  • 274
23
votes
4 answers

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 vertically attached to the query editor instead of…
Shevek
  • 16,738
13
votes
2 answers

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 need to change so the zoom controls both?
Matt Slavicek
  • 262
6
votes
2 answers

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 reopening SSMS will solve the problem, but it is quite…
rcs
  • 941
4
votes
3 answers

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 Cannot connect to…
Vikas Bansal
  • 583
3
votes
2 answers

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 updates. Today I wanted to create a new Alias in the…
JustAMartin
  • 1,631
  • 4
  • 20
  • 29
3
votes
2 answers

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 Because sql server's options are set in an .ini file,…
comp.sci.intern
  • 33
2
votes
1 answer

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 tell me a way to find out the expiration date?
shadow master
  • 311
2
votes
1 answer

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 and edit pages. On the Main page, I edited in a…
Corey Ogburn
  • 736
2
votes
1 answer

SQL Server 2012 Setup Failure

I am installing SQL Server 2012 in my computer but this error message always shows up. I tried installing it in a Virtual Machine, and it worked! Other threads says that the issue is permission access, but I've already allowed access and I'm using…
Jmarco29
  • 21
2
votes
0 answers

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 (August 9, 2016), the service no longer starts up…
Peter
  • 509
1
vote
1 answer

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 Arrow in the designer and copy) 4)Connect to server B 5)Open…
mybirthname
  • 387
1
vote
0 answers

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 Professional Plus 2013) I go Data/Connections/Add to…
Richard A
  • 111
1
vote
0 answers

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 Google Chrome. I've gone into MSIE11 and made it…
DoctorKennyG
  • 126
1
vote
0 answers

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…
blueseal
  • 117
1
2 3 4