Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2012]

Microsoft SQL Server 2012 (often abbreviated as SQL Server 2012 or MSSQL 2012) is a version of Microsoft's SQL database server software. It includes new features and upgraded functionality from its predecessor, SQL Server 2008 R2, went RTM on March 6th, 2012 and to general release on April 1st, 2012.

SQL Server 2012 logo

Microsoft SQL Server 2012 (often abbreviated as SQL Server 2012 or MSSQL 2012) is the latest version of Microsoft's SQL database server software. It includes new features and upgraded functionality from its predecessor, SQL Server 2008 R2, went RTM on March 6th, 2012 and to general release on April 1st, 2012.

SQL Server 2012 is available in several "mainstream" editions, as well as some "special" editions not widely available for wide, such as a Development edition, an Azure edition and a Massively Parallel Processing Edition.

The mainstream editions are:

  • Enterprise Edition
  • Business Intelligence Edition
  • Standard Edition
  • Express Edition
  • Web Edition
  • Compact Edition

The complete feature set of SQL Server 2012 is massive, and probably too big to list, but Microsoft has a large page devoted to the topic, and includes feature comparison across the various mainstream editions. SQL Server 2012 adds new features focused on increasing the availability and scalability of the SQL Server product line, most notably a "AlwaysOn High Availability" feature, a dedicated Disaster Recovery feature, "scale-out reads" functionality and database mirroring capabilities.

268 questions
2
votes
1 answer

5.7.1 SMTP error when running stored proc using DB Mail in SQL Server 2012

I am getting an error in SQL Server 2012 Database Mail when executing a stored proc to send an email from a specified address to a specified address using Office 365 as the SMTP server. The mail could not be sent to the recipients because of the…
medina
  • 135
  • 1
  • 3
  • 11
2
votes
2 answers

Add an Excel file as a linked server in SQL 2012

I'm trying to add a linked server to an Excel 2010 file from SQL Server 2012. Every reference I've found online for doing this is using older versions of SQL Server, and the driver that they tell you to use 'Microsoft.Jet.OLEDB.4.0', is not present…
MgSam
  • 141
  • 1
  • 5
2
votes
0 answers

Failover_Partner connection in file DSN not working

I have an application which uses file DSNs to connect to a central database server. This database server is mirrored onto a secondary server, and in the event of a failover, it is my understanding that adding a line in the file DSN…
JJBurgess
  • 41
  • 3
2
votes
1 answer

Shrinking Database using the AUTO_SHRINK ON , helpful or is it consuming to many resources?

I have multiple databases which are constantly growing. So from time to time, I truncate the log table and shrink the biggest databases. For the biggest one (>40gb) it takes quiete some time. So I read about the option to have auto_shrink on ,…
RayofCommand
  • 1,451
  • 8
  • 26
  • 36
2
votes
1 answer

If a SQL Server Replication Distributor and Subscriber are on the same server, should a PUSH or PULL subsciption be used?

Thanks in advance for any help. I'm setting up a new Microsoft SQL Server replication and I have the Distributor and Subscriber running on the same server. The Publisher is on a remote server (as it is a production database and MS recommends that…
userx
  • 133
  • 1
  • 4
2
votes
1 answer

Upgrade Expired SQL Server 2008R2 Evaluation to SQL Server 2012

We have been working on developing several SharePoint sites as a POC using the evaluation versions of SharePoint 2013 and SQL Server 2008R2 Enterprise Evaluation. POC worked, went into limited production, well the SQL Server Evaluation expiration…
Matt Bear
  • 874
  • 3
  • 12
  • 28
2
votes
1 answer

Windows Installer runs constantly in the background on Windows Server 2012?

While trying to install a program, it complained that something else was being installed and that Windows Installer was already running (msiexec.exe). Sure enough, there were two instances of the process with one of them using 25% CPU (quad core,…
Triynko
  • 3,418
  • 6
  • 31
  • 30
2
votes
1 answer

SQL Server: Cannot log into SQL Server Management Studio on Server

I installed SQL Server 2012 on a Windows Server 2012. I am going back a few days later and unable to log into SQL Server Management Studio (SMS) using Windows Authentication, even if I launch SMS using the "Run as Admin". I keep receiving error…
Sarah Weinberger
  • 421
  • 2
  • 11
  • 23
2
votes
0 answers

SQL Server 2012 database availability design?

Can anyone please suggest me what is the best practice for me to follow when consolidating multiple stand alone DB from SQL Server 2005 - 2008 boxes into just 2x SQL Server 2012 Enterprise nodes in two different sites (1 x physical server in PROD…
Senior Systems Engineer
  • 1,275
  • 2
  • 33
  • 62
2
votes
1 answer

Where Does sqlpackage.exe Store Database Backups?

I have a deployment script which uses sqlpackage.exe to deploy incremental changes to a database. (The project is maintained in the database edition of Visual Studio 2012 Express.) One of the flags I'm passing to this tool…
David
  • 133
  • 1
  • 7
2
votes
1 answer

SQL Command Line Setup Failing

When running SQLEXPRADV_x64_ENU.exe directly SQL Installation Center shows up and I can install SQLEXPRESS just fine. I want to perform automatic command line install so I have done the SQLEXPRADV_x64_ENU.exe /X to extract the files to my USB drive.…
Petar Vučetin
  • 163
  • 7
2
votes
3 answers

How to run PHP + IIS8 as Windows User, or should I?

I am creating a PHP website on IIS8 that needs to connect to an SQL Server that is in the same Windows Domain as the IIS8. I am given a Windows Domain user account and asked to connect using its credentials. I am using sqlserv_connect() for PHP and…
Jake
  • 1,172
  • 6
  • 28
  • 48
2
votes
2 answers

MS SQL Server 2012 - Unable to access Instance on localhost

5 days ago I was access able to access SQL Server on my localhost machine via SSMS perfectly, no errors logging in with credentials. Now I get this error: ================================================================================== A…
loonison101
  • 31
  • 1
  • 1
  • 4
2
votes
1 answer

Missing menu items for Azure SQL tables within SQL Server Management Studio?

I have a table (say Table1) that is replicated via SQL Data Sync Agent across a local SQL Server 2012 as well as an Azure SQL Server (part of Microsoft Azure). Everything about Table1 (schema, table values etc ) is identical to the best of my…
DeepSpace101
  • 698
  • 5
  • 12
  • 25
2
votes
1 answer

SQL Server (2012 Enterprise) Browser service failing

SQL Server (2012 Enterprise) Browser service failing I have a problem as described below: I have an instance of SQL Server 2012 Enterprise (thanks to MSDN) for local development on my PC. I try to start SQL server Browser Service from SQL Server…
Watki02
  • 587
  • 2
  • 12
  • 22
1 2 3
…
17 18