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

learn more… | top users | synonyms (2)

0
votes
0answers
12 views

Query to Find Cluster Nodes for an Instance

I need a way, using T-SQL, to find the nodes available to a SQL instance. I have 3 nodes in a cluster running several instances of SQL Server, each instance is 2012 Standard and so can only be ...
1
vote
1answer
31 views

SQL Server 2014 .bak file error - The media family on device 'D:\..' is incorrectly formed

Worst case scenario - the server crashed and the 2014 SQL Server .bak file had to be recovered from the failed disk. The .bak file I have is over 20gb in size but is unusable when trying to restore ...
1
vote
1answer
42 views

Cannot connect to SQL Server from Management Studio (both 2012)

I installed SQL Server 2012 Express. It seems to be running fine. My SQL Server Configuration Manager looks like this: From what I understand it means that my instance is called MSSQLSERVER. ...
0
votes
1answer
17 views

The SQL Server Network Interface library could not deregister the Service Principal Name

After windows patching (windows 2008 R2 , SQL Server 2012 Sp2). I could not start SQL Server Service . I get error 1067 and this from the error log* The SQL Server Network Interface library could not ...
1
vote
1answer
27 views

Is Service Pack 2 completely installed on Passive Node of SQL Server 2012 Instance?

We are applying SQL Server 2012 Service Pack 2 (SP2) to a two-node active/passive cluster, starting with the passive node (as per best practices): How to install a Service Pack at a SQL Server 2012 ...
1
vote
0answers
21 views

Create Nested XML in a Sql Server Indexed (Materialized) View

This page https://msdn.microsoft.com/en-us/library/ms188276.aspx indicates that if you wanted nested XML (ie an XML Tree) then you need to setup your query like this: SELECT Col1, Col2, ...
0
votes
1answer
15 views

Analyse and report disk usage growth historically

Is it possible to use historic information to show disk usage growth? I haven't keep much in the way of database setup and disk usage information. So I can't say how much disk growth has occurred in ...
2
votes
2answers
207 views

Half of a transaction completes, when the other half fails?

I have done some searching on SO, MSDN, and various other sources, and I found plenty of questions about transactions, but none that seem to be exactly what I'm dealing with. Admittedly I'm still ...
-2
votes
0answers
28 views

How can we restore shipped transaction log files in SQL Server 2012 to an online (being used) database without stopping the DB? [on hold]

How can we restore shipped transaction log files in SQL Server 2012 to an online (being used) database without stopping the DB? Is there any way to copy data from an online database to another online ...
0
votes
0answers
15 views

Problem running SSIS package remotely using PoSH

For various reasons I'm trying to run an SSIS package remotely using Powershell. I've enabled remote scripts on my server using the following command. Set-PSSessionConfiguration -Name ...
0
votes
1answer
17 views

How can I limit a user to only be able to run procs in a schema, which access another db?

In a SQL Server 2012 SP2 Standard Edition instance I have a user in database A that needs to be able to run stored procedures in schema foo within that database. They shouldn't be able to do anything ...
1
vote
1answer
27 views

How to generate an error when backing up to an existing file

I'm using SQL Server's BACKUP command and I want the operation to generate an error if I attempt to write to an existing backup file. By default, SQL Server seems to append to an existing file. ...
2
votes
0answers
10 views

Can we use FILESTREAM in case of SQL Server cluster

I saw this point on Technet article about RBS. The local FILESTREAM provider is supported only when it is used on local hard disk drives or an attached Internet Small Computer System Interface ...
0
votes
0answers
31 views

Can't connect to other instance of SQL 2012

I'm working through a Microsoft exam study book. I have set up 2 SQL Servers (both 2012 Standard on Server 2008 R2) and a DC. The book wants me to remotely connect SQL-A to SQL-B. Unfortunately the ...
0
votes
0answers
39 views

SQL Server consuming large amount of RAM [duplicate]

I have Server 2012 with two 2.10 Ghz processors and 64GB of RAM. I have SQL server 2008 installed on this server. but this SQL server is consuming 70-80% of memory. I have limited SQL memory to 24GB ...
3
votes
2answers
54 views

How do I pass multiple statements into sqlcmd?

Wanting to automate some tasks instead of firing up SSMS for everything, I'm trying to write a batch file to run these statements, which work perfectly when I paste them into the sqlcmd prompt. They ...
0
votes
1answer
46 views

SQL Server : Restoring database mirroring once its turned off

I was running security updates on the sql server mirror setup and I encountered split brain scenario as mentioned here Should I pause Mirroring and stop SQL Server services before running windows ...
-1
votes
1answer
26 views

Trying to add permission to a Role is failing

I am trying to add a role into Create and Restore permissions and After researching online, it sounds like it should be as easy as using the GRANT statement. So far so good. However, my simple grant ...
0
votes
0answers
14 views

Replication / HA Planning for Disaster Planning

I am designing a system with MS SQL Server 2012-2014 / MS Server 2012-2014 and would like to know some methods that others have used. I currently have a clustered 2003 Environment 2 boxes at one ...
3
votes
0answers
39 views

MS SQL Server IO read increase appear randomly

The number of read (IOPS) in my MS SQL Server database increased randomly even during the night (low activities) from 0.3 MB/SEC (normal) to 25-30 MB/SEC. After like 30 minutes, it's capped to 6 ...
0
votes
1answer
30 views

What is the risk of doing a rebuild to my indexes in sql server 2012?

What is the risk of doing a rebuild to my indexes in SQL Server 2012? I have to do a REBUILD, but I don't know what are the risks . The server is running and a lot of information is going in and out. ...
3
votes
1answer
23 views

Microsoft SQL Server 2012 Mirrors Go Into Disconnected

I have some Microsoft SQL server 2012 mirrors, without a witness in asynchronous mode, that are sporadically going into disconnected. I am running SQL Server 2012 11.0.5058. Looking at the logs on ...
27
votes
2answers
40 views

SQL Server unpredictable select results (dbms error?)

Below is simple example, which returns strange results, that are unpredictable and we cannot explain it in our team. Are we doing something wrong or is it SQL Server error? After some investigation ...
0
votes
2answers
43 views

How many records should be deleted when batch delete is used?

I am going to migrate a large amount of data from one table to other table. The target data source table has foreign key constrains, so I am not able to use DELETE with OUTPUT clause, but need to have ...
0
votes
1answer
36 views

Indexes in a big table. (About 400 mil of rows)

I have a little deal. I have this table in a SQL Server 2012 Standard edition database. The table contains about 400 mil of rows. CREATE TABLE [dbo].[prodeje] ( [id] [int] IDENTITY(1,1) NOT ...
0
votes
0answers
25 views

SQL Server service crashes when i run a linked server query

I'm using SQL Server 2012 on a Windows 7 Professional, 32 bit system. With the SQL Server service running, I run a linked server query and the service crashes. The OS is already updated and I change ...
0
votes
2answers
52 views

Error when restoring SQL Server 2008 R2 backup on 2012

I am trying to restore a .bak file (backup taken on SQL Server 2008 R2, compatibility level 100). I am restoring the backup on SQL Server 2012 edition. I get the below error. Unfortunately the ...
0
votes
1answer
18 views

Setting Key Constraints using a Diagram

I been using SSMS for diagramming my databases and I got used to create the key constraints with this tool. Now I started thinking, while going through related chapter of a book, "...maybe this is not ...
0
votes
1answer
43 views

Restoring SQL Server 2012 DB - OPEN SYMMETRIC KEY SKey DECRYPTION BY CERTIFICATE NAME Not working

Database Admins, can you please help me out and let me know why my script is not allowing me to DECRYPTBYKEY once I restore my DB from a PRODUCTION BACKUP.... -- SET Staging to Single User Mode to be ...
1
vote
1answer
20 views

Error when restoring SQL Server 2008 R2 backup on 2012

I am trying to restore a .bak file (backup taken on SQL Server 2008 R2, compatibility level 100). I am restoring the backup on SQL Server 2012 edition. I get the below error. Unfortunately the ...
0
votes
1answer
61 views

SQL Server: query for getting TOP X groups of records which have highest subsequent values

I'm querying each SQL Server DB CPU usage (based on query from here -- Get CPU utilization by database (Query 29) (CPU Usage by Database)) every 60 seconds and storing this information in dedicated ...
0
votes
1answer
24 views

How to optimize STDistance execution?

I am creating temporary table during stored procedure execution with the following structure: [ID] BIGINT [Point] GEOGRAPHY the ID is not unique - there are about 200 records for each ID. ...
0
votes
1answer
45 views

DB Permission: User can drop only their created db's?

I want to set permission against a user, which can create database and drop on their created databases neither any database. Any idea/suggestion ?
1
vote
1answer
57 views

SQL Server Mirroring can't connect to mirror database

I am at my wits end with this. I am trying to set up mirroring between a development server and my local machine. The error that keeps coming up is: Msg 1418, Level 16, State 1, Line 1 The ...
-1
votes
1answer
44 views

Restoring a backup of a database from SQL Server 2014 into SQL Server 2012 [duplicate]

Is it possible to load a backup of SQL server 2014db into SQL server 2012? Trying to import/restore is throwing backward compatibility issues. Thanks
0
votes
0answers
23 views

Hide Inconsequential Result Sets From Stored Proc

How does one mask resultsets in multi-layered stored proc calls? Due to stored proc reuse, I have an issue where a top level stored procedure calls multiple stored procedures (directly) and in-tern ...
0
votes
1answer
22 views

SSIS Package not retaining parameters in SQL Server agent job

I have an SSIS package stored in the Integration Services catalogs on a SQL server instance. This package is used as a step in a SQL Server agent job. The package has 4 required parameters. Using ...
1
vote
2answers
30 views

How to identify and remove the SQL table row which contains UTF 8 BOM characters

I recently identified that some of the rows in our table contains UTF 8 BOM (Byte Order Marking) characters ().. Is there a way to identify those rows and removing the BOM characters from those ...
0
votes
1answer
26 views

Could not find prepared statement with handle -1 SQL Server Profiler

So I have this issue where I'm running Sql Server Profiler and I'm getting hundreds(at least) of Could not find prepared statement with handle -1.(error 8179) per second. I can't seem to really ...
0
votes
0answers
23 views

Could not find prepared statement with handle -1 SQL Server Profiler

So I have this issue where I'm running Sql Server Profiler and I'm getting hundreds(at least) of Could not find prepared statement with handle -1.(error 8179) per second. I can't seem to really ...
0
votes
2answers
33 views

How do I extract a repeating string pattern from multiple rows?

I have the following data: | ID | BadCol | +------+-----------------------------------------------+ | 1 | All of R489804 R489805 R489806 R489807 ...
0
votes
0answers
3 views

SSMA not moving partition info from MySQL to MSSQL

I am trying to convert my existing database from MySQL5.x to MSSQL 2014. While all the table schemas gets ported from MySQL into MSSQL, table partition info are not being carried over. ...
0
votes
0answers
51 views

SQL Server 2012 Express installation failed

I'm trying to install SQL Server 2012 Express on a computer with Windows Server 2012 Foundation, I must recall that this is an Active Directory domain controller but I cannot install the server on ...
0
votes
2answers
25 views

Does a mirroring configuration requires the database do stop receiving requests?

I want to configure a SQL Server 2012 Mirroring. I know that I have to create a full backup of the Principal server and restore it at the Mirror server. After that, I will backup the transaction log ...
0
votes
1answer
23 views

How to safely resume a SQL Server Mirroring scheme that had a expired certificate?

We have a production database with a SQL Server 2012 Mirroring scheme with three machines: Principal, Mirror, Witness. The mirroring was configured with a certificate that had only one year of expiry ...
1
vote
0answers
21 views

Can I Parse and/or include “And” in my SQL Statement for a full text index?

So I have a query that looks at a full text index like this: SELECT * FROM Table1 q INNER JOIN CONTAINSTABLE(Table1,TableField, @Keywords) search ON q.Key = search.[KEY] Now @Keywords ...
0
votes
0answers
29 views

Scale-Out Query Server: SQL Server 2012/2014 Enterprise vs BI Edition

Was reviewing the Features Supported by the Editions of SQL Server (2012, 2014) and noticed what appears to be a mistake, but I'm just not certain and looking for confirmation. For 2012/2014, there ...
0
votes
1answer
38 views

Transaction over linked server causing time out

When I execute this query on [RemoteServer] linked server, it works just fine: INSERT INTO [RemoteServer].[DbName].[SchemaName].[TableName] VALUES (1, 'bar'); but when puting it inside a ...
0
votes
1answer
22 views

backup a specific set of tables to be moved to a remote system [duplicate]

I need to generate either backups or data dumps for about 30 tables. I want to generate a file of some sort that contains the data for these tables and transfer them to a different system. Each ...
7
votes
1answer
148 views

How does SQL Server's optimizer estimate the number of rows in a joined table?

I am running this query in the AdventureWorks2012 database: SELECT s.SalesOrderID, d.CarrierTrackingNumber, d.ProductID, d.OrderQty FROM Sales.SalesOrderHeader s JOIN ...