This tag is for SQL Server 2012, major build version 11.00.xxxx.

learn more… | top users | synonyms (2)

0
votes
1answer
953 views

Support to SQL Server 2000 from Visual Studio 2013(SQL Server 2012)?

I can't access to a database created by SQL Server 2000 from Visual Studio 2013, I asked this before in StackOverflow, but I don't get an useful answer: ...
0
votes
1answer
57 views

What are the compelling resons to update SQL Server name to a real one after its changing?

Took the job of monitoring and tuning a few dozens SQL Server 2012 Enterprise Ed. SP1 (64 bit) on Windows Server 2008 R2 Standard Ed. running inside virtual machines. All of them on running ...
3
votes
2answers
4k views

How to create a server alias in SQL Server 2012

We have a Windows Server 2012 server running with 2 instances of SQL Server 2012 installed on it - Live and System. Both instances are accepting connections on 1433 & Live is the default instance ...
0
votes
1answer
108 views

Use SQL Server Database Mail with Amazon SNS

Is it possible to configure SQL Server 2012 Database Mail (hosted on EC2) with Amazon SNS? I'd love a single place to manage all alert notifications and their subscribers in SNS, but Database Mail ...
0
votes
0answers
1k views

SQl Server 2012 Powershell script to generate database with schema and data

Using Sql Server 2012, could somebody be so kind and show me a simple powershell 3 script that generates my entire database (schema and data)? I tried this one: $Filepath='d:\b\t' # local directory ...
0
votes
2answers
67 views

SQL Server replicated databases swap

I have a SQL Server 2012 database. I would like to be able to make changes to this database or to it's replication, then make the replica, the real one. The point here is to have 0 downtime on ...
1
vote
3answers
134 views

Creating a copy of primary database and attaching the copy database in the same sql instance

I just got into a project in which we have only one SQL Server 2012 copy. We have 12 databases attached to the primary instance of SQL Server 2012. As I don't have SQL Server 2012 or supporting OS, I ...
1
vote
0answers
293 views

SQL Server: Principal DB becomes unavailable after problem with mirror DB, even with Set Partner Safety Off?

We've got a very simple mirroring setup here: just a principal DB and mirror DB, no witness, running in high-performance mode with SET PARTNER SAFETY OFF. This problem has happened to us twice now: ...
1
vote
2answers
2k views

Select all data group by 1 column and functioned by another

I have the following table in SQL Server 2012 : ID int priority int type int other data columns I want to query the table for the following result : grouped by 'type' get the id of top 1 max ...
1
vote
1answer
258 views

Running parallel delete statements

Problem: I have a massive table - occupies a whopping 9.5 TBs. I need to delete around 5 mil rows from it. The best method I have come up with deletes 1 million records in 2 hours! Since I can not run ...
1
vote
3answers
292 views

Trouble with SQL Server authentication in SQL Server 2012

I am working with a SQL Server 2012 database. I am able to log into the server using Windows authentication. Although I have the SQL Server authentication username and password which is provided to me ...
1
vote
0answers
43 views

Turn xact_Abort on for specific applications or user

We have a 3rd party application that requires xact_abort to be turned on, however we have other applications that require it to be turned off. The service that requires it turned on always logs in ...
0
votes
1answer
1k views

Export a SQL Server 2000 database to Server 2012

I have a production environment running Windows Server 2000 and a development environment using SQL Server 2012. I need to make updates to the DB and implement some new features using .ASP. Is there ...
1
vote
1answer
78 views

Locks in SQL Server - Update/Select

I am new to SQL Server and am not sure about how the locking mechanism works here. Please help Issue: Need to delete close to 5 mil records in a table. A website pulls data from that table quite ...
1
vote
2answers
273 views

Automatic Failover in Availability Group

I have 2 nodes in my SQL server fail over cluster. I use SQL Server 2012 Availability Groups for HA purpose. The problem is that when one my server goes down the automatic fail over does not happen! ...
0
votes
0answers
809 views

SQL Server 2012: Login failed for user. Reason: Failed to open the database configured in the login object

Every so often, my SQL Server 2012 throws the following errors: Error (likely related to the one below): Source: spid99 The client was unable to reuse a session with SPID 99, which had been ...
2
votes
2answers
504 views

How to select the mail profile in a sql agent job

I have several mail profiles configured on sql agent, how can I choose which of these profiles gets used for sending out notifications on a specific sql agent job ?
7
votes
2answers
20k views

SQL server databases stuck in restoring state

I have a Sharepoint server. I guess our network administrator has miss configured his back up tool (I guess he uses Symantec backup exec) and now some of my databases are stuck in restoring state! ...
1
vote
1answer
553 views

Package deployed in SSIS 2012 catalog fails with timeout error

I created an SSIS package in Visual Studio 2008 and deployed it to SQL Server 2012 by using Integration Services Catalogs. When I run the package from BIDS it completes successfully. When I schedule ...
2
votes
1answer
113 views

How to know if logreader agent already exists?

I'm creating a script to recreate a database for test purposes, and the database has some publications. In order to create or not the logreader agent I need to know if the current database already ...
1
vote
0answers
388 views

Error installing Clustering with SQL Server 2012 on Windows Server 2012

We are installing SQL Server 2012 on Windows Server 2012 and trying to accomplish clustering. We've setup all the core functionality on the servers: advanced cluster preparation on all nodes and ...
1
vote
1answer
128 views

Data Compression Enhancement in SQL Server 2012

Is there any specific enhancements in SQL Server 2012 for Data Compression Feature? Last time I checked SQL Server 2008 R2 introduced support for Unicode characters so columns with NCHAR data types ...
1
vote
1answer
64 views

Adding index in table suggestion?

I have a table called Products with ID(PK, Clustered), Name, Price, Brand, ...., RetailerID, SKU, ModelNumber. My query have SELECT .... FROM Products WHERE RetailerID = @RetailerID AND ( ...
1
vote
4answers
718 views

SQL Server 2012 - where is the table in dbo? [closed]

I am trying to insert something into the dbo.Documents table. After the query is run, I can't find the Documents under the TSQL2012 database. I created TSQL2012 for exercise purpose. I couldn't ...
2
votes
3answers
86 views

MS SQL Server instance name

Quick question guys! Will there be any issues if I use the default instance (MSSQLSERVER) for both test and production environments? They are on separate physical servers. I'm using MS SQL Server ...
-2
votes
2answers
180 views

SQL Server 2012 - Stopword Error [closed]

I am doing an exercise in Microsoft 70-461 certification book (written by Itzik Ben-Gan) In chapter 6-Query Full text data. I run the following query to create a stopword list. The system showed me ...
1
vote
1answer
512 views

Stop and Start the Instance In a Job

i have sql server job. in the last step of job i want to stop/start sql server. I create .bat file with NET STOP "MsSqlServer" i try ssis package that use execute process task with cmd.exe and ...
3
votes
1answer
168 views

Transactional Replication: can create 52 publication, but creating 53rd leads to problems

My apologies in advance for a long post, but I was really trying to make sure I do my due diligence before turning to the community for help, so here it goes. I am working on a proof of concept with ...
0
votes
1answer
1k views

Sql Server Fix Users

I Create a user in my database with following command : CREATE USER Test WITHOUT LOGIN I created a login with the Test Name. I want to link Test user with Test Login. When I use following command ...
1
vote
0answers
180 views

KPI Metrics Table Design [closed]

We are currently working on project to get KPI metrics from out account partners,We want to design a table and It will have 3 Major Business units 4 Business Verticals (Service Desk, Knowledge ...
1
vote
0answers
1k views

Issues with Log Shipping

First time at posting a question on here, so please bear with me and I'll try and detail all the information. Currently, I'm log shipping from SQL 2012 Standard Edition (11.0.3000) (lets call it ...
0
votes
2answers
91 views

Copying a restoring database in SQL Server 2012

I've got two SQL Servers, one of these servers (Server A) is backing up transaction logs on some database and uploading them to the other (Server B). Unfortunately I have no access to Server A, I ...
0
votes
2answers
35 views

Transactional Replication Update process

I need to create report using ssrs. for that i create the main table contains the values from nine other tables which is the Source tables. Now the new source tables which are used for main table are ...
1
vote
1answer
78 views

Query tuning - performance

Could you please help me tune this query. It takes over half an hour to run! I want to identify repeat bookings (can only be identified using an annoying varchar field - email) UPDATE #Repeats --a ...
3
votes
1answer
54 views

reset sql server to default?

Sorry in advance for the noob question. I am trying to learn to mirror a test database and in the course of doing this, was typing in some commands into a query box. While trying to create a ...
3
votes
1answer
87 views

Does MERGE updates when not needed?

In SQL Server 2012, Does a merge statement like this : WHEN MATCHED THEN update SET A.len = B.len updates a row even if A.len equals to B.len ? Or does the SQL SERVER knows to ignore this ...
2
votes
0answers
69 views

SQL Server 2012 Replication

Please help me out with a problem I am facing. I have a table T. I altered the table to alter the column C from varchar (10) to varchar (100). Now, there is a view V that is schema bound and selects ...
5
votes
1answer
13k views

How to uninstall SQL Server Management Studio 2012? [closed]

How to uninstall SQL Server Management Studio 2012? ControlPanel's "Uninstall or change programs" (in Windows 7 Prof) gives a row of entries: while internet search results always tell: "click ...
4
votes
1answer
192 views

Why clustered index scan?

I just started to learn to optimize my queries and to analyze their query plans. I thought this query would generate nonclustered index seek + key lookup. SELECT ct.* FROM Person.ContactType AS ct ...
5
votes
2answers
1k views

Mirroring in SQL Server 2012

I have been trying to learn to do this. I've got newly installed Win 2008 R2 machines, in a workgroup, in the same subnet, and of course SQL Server 2012. I allowed login with SQL Server ...
1
vote
1answer
2k views

How can I view special characters in SQL Server 2012 Management Studio grid view?

In a SQL Server 2012 database, I have a log table where I log SQL queries executed by a VB.NET application. The field is defined as nvarchar(MAX) In Microsoft SQL Server Management Studio, when I ...
1
vote
1answer
332 views

SQL Server 2012 Publisher SQL Server 2008 Subscriber version issue

So I have a setup where one virtual machine is a SQL Server 2012 publisher and I need to setup merge replication on a SQL Server 2008 subscriber on a different vm. When setting up the subscription ...
1
vote
1answer
125 views

sql server database size shown different in properties pane

while monitoring when checking database space used,my favorites are use indexinternals sp_spaceused select (sum(size)*8)/1024 as size From sys.master_files where name like 'indexinternals%' ...
1
vote
0answers
262 views

CDC with SSIS: process all changes in order of occurrence

I have a SSIS package that I'm using to sync (in an on going basis) all changes from one table to another. Note that I need to sync ALL changes and not just NET changes. My problem is that I cannot ...
2
votes
1answer
421 views

Sync & Async Synchronisation on SQL Server 2012

Is it possible to set up async synchronisation (high-performance) on MS SQL Server 2012 globally, but somehow force synchronous replication for one table between nodes? Nodes are in different ...
2
votes
3answers
362 views

SQL Server not properly using memory?

Ihave a database with two tables in it. One table has approximately 20 million rows and another has approximately 70 million rows. When I run sp_spaceused on these two tables I find that the total ...
6
votes
1answer
801 views

How accurate is the sys.partition.rows column?

The system view sys.partitions has a column "rows" that is the total number of rows in a given partition. For a table that is not partitioned (or only has one partition depending on how you look at ...
0
votes
1answer
172 views

SQL Server 2012 for data warehouse [closed]

I have to develop a data warehouse using SQL Server 2012. I'm confused about the release I could use... Standard or Enterprise? The database server will have 16 or 32 GB of RAM and a Quad-Core CPU. ...
5
votes
1answer
3k views

How to changes or update local server connection in Maintenance plan job

Two days back our client changed one of our Dev Server name After Server Renamed, All my maintenance jobs and other jobs are failing because server name mismatch. We are using sql server 2012 ...
8
votes
1answer
599 views

How to move a database from SQL Server 2012 to SQL Server 2005

What are my options if I need to move a database from SQL Server 2012(32bit) to SQL Server 2005(64bit)? I know I cannot: restore a backup of the database on SQL Server 2005 detach & attach I ...