Questions tagged [sql-server-2012]

SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.

619 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
272 views

What is an incremental checkpoint (in the context of indirect checkpoints)?

I was using extended events to trace checkpoint activity of a database with indirect checkpoints enabled. The event stream looks like this: And the details of the selected event are: The description ...
2
votes
0answers
976 views

How to push the data from database?

I want to push the data from database to application instead of application pull the data.I have installed ms sql server and apache tomcat server. I have my application in apache tomcat, here I made ...
2
votes
0answers
984 views

SQL71561 Error on Schema compare after initial import from database

I have created a new sql server project with SSDT 2012, then I went to import an existing database and it created all my scripts. After that I did a schema compare between the project and the database ...
2
votes
0answers
493 views

dropping and adding subscription only picking up new article on some subscribers

I have used the following script to drop aand re-add a table from a subscription so I could move replace the ntext fields with nvarchar(max) columns. the script worked fine, but when I ran the ...
2
votes
0answers
339 views

tempdb objects creator wanted, bufferpool issue caused by tempdb objects

I have a number of tables in tempdb named like #A0030B77 #A01D908C #A06D1FCB #A0F72FB0 #A1614404 #A1EB53E9 #A205D8FE #A255683D How (if) can I get spid of the process which created them? These tables ...
2
votes
0answers
541 views

Best Practice to update columnstore indexed tables

I have a table with aprox. 22 Bn rows, for each month I have made one partition that and each partition has two data files. I created the columnstore index on this table and the performance ...
2
votes
1answer
347 views

Schema for multiple identical queue tables

I am migrating a message processing application that was built on MSMQ to SQL Server 2012 (preferably Standard Edition). Messages are received and distributed via TCP/IP endpoints and the typical ...
2
votes
0answers
3k views

SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled

I have two SQL Server instances in an availability group. They are not mirrored. I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including multiSubnetFailover=...
2
votes
0answers
64 views

How to Remove Articles Based on User

I am using merge replication on SQL 2012. I have a very large database with a large number of tables. The subscribers are using netbooks. I have a filtering scheme that controls which tables end up ...
2
votes
1answer
280 views

GHOST_CLEANUP not freeing up space on SQL Server Availability Group

Had a problem in my SQL Server Cluster for 2 weeks, I had the GHOST_CLEANUP process running 24/7 never stopping even if the users were doing nothing. I was checking the "Free Space" parameter in the ...
2
votes
1answer
5k 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 ...
2
votes
1answer
4k views

SSIS Data Transfer vs. Linked Server

I'm currently designing a SSIS package, which will do following: Clear unwanted records in destination Do ETL using stored procedures and put everything into a table prepared for export in source ...
1
vote
1answer
32 views

How can I configure a connection string in SSRS 2012 using named pipes?

I have SQL Sever 2012 and I want to create a data source that uses named pipes rather than TCP. This is when I have tried: Data Source=np:\\.\pipe\MSSQL$MSSQLSERVER02\sql\query;Initial Catalog=...
1
vote
1answer
70 views

How to replace multiple unicode characters

I have identified a couple of unicode characters in my database by means of the following query: SELECT name FROM table WHERE name NOT LIKE '%'+CAST(name AS VARCHAR(1000))+'%' ...with which I get ...
1
vote
0answers
14 views

SQL Vulnerability Assessment Error in PowerShell

I am running Vulnerability Assessments against my SQL Servers and databases using the PowerShell cmdlets Invoke-SqlVulnerabilityAssessmentScan and Export-SqlVulnerabilityAssessmentScan, however, I am ...
1
vote
1answer
24 views

SQL Server - db_owner user can't see sys schemas

these is a user in database XXX_service (it's technical account) and it has set "Server role" - public and and user mapping as dbo_owner for one database. Programmer sent logs and there are errors ...
1
vote
0answers
21 views

SSIS won't connect to Oracle issue after ODAC driver un-install & re-install

I installed the ODTwithODAC1120320_32bit drivers and client and could successfully connect SSIS to an Oracle database. I noticed that the installation had defaulted to the E: drive which is where the ...
1
vote
0answers
19 views

SSMS - Can I create a default layout?

Using SSMS 11 to connect to a SQL Server 2012 instance. When I first load up SSMS and log-in, is it possible to have specific nodes in the object explorer expand? I always expand the tables node in ...
1
vote
1answer
26 views

Directory Verification with For Each Loop in SSIS

How can we check if a directory is valid or not inside for each loop . I am having multiple files at some location and i want to load that file but before this i want to check if the directory is ...
1
vote
3answers
102 views

Query to see Index Fragmentation on all databases without using SP or temp tables

I am trying to compile a index fragmentation report on all databases, in a multi-server environment. The query will be executed via an openquery command, so I would like to make it as simple as ...
1
vote
1answer
91 views

How to setup encryption on a column that joins two tables in two different databases

What is the best method to encrypt a column that exists in two tables (BUID) in two different database on a 2012 server, at the end should be able to join on the encrypted columns between two tables ...
1
vote
0answers
96 views

SSMS - Data load Option

I have recently installed the newer version of SSMS on my system. But the option to load the excel file is grey out. I'm not able to load BULK Load I tried to run DTSWizard.exe, even it doesn't give ...
1
vote
0answers
28 views

Enabling FileStream in existing clustered servers in SQL Server 2012

I have heard that enabling FileStream in an already existing clustered environment is tough. I'm working on a consolidation project and currently analyzing the impact it will have if we migrated DBs ...
1
vote
0answers
17 views

AlwaysOn Replicas set to manual but failing automatically

My two synchronous-commit SQL AO replicas are set for manual failover mode but are failing over automatically. When I look through the logs and extended events, it looks just like what would happen if ...
1
vote
0answers
89 views

SQL JDBC upgrade from v6.0 to v7.2 causes java.lang.NullPointerException in *some* stored procedure returned recordsets

I am developing a java application onWindows 10 using Eclipse Oxygen and SQL JDBC v7.2 and java 1.8 update 202. My code runs fine when I use SQL JDBC v6.0 (sqljdbc42.jar Jan 2017 and java 8), but ...
1
vote
0answers
66 views

FOR XML could not serialize the data for node 'col_definition'

looking for some help. I have just started looking at the Blitz stats but getting the following error. This is whilst running sp_BlitzIndex. I am using Version 7.2 (dated 28/01/2019). FOR XML ...
1
vote
1answer
56 views

Efficient method to update character length of columns in large table

I have a table with 80+ million records. There are 2 columns which are currently varchar(MAX), which I would like to update to varchar(255) to save space. It is not an issue if data will be truncated. ...
1
vote
0answers
55 views

sys.login_token doesn't include particular windows groups while they can be listed by sys.database_principals

When I query SELECT principal_id, name, [type] FROM sys.login_token I found some local windows groups were not there. However, when I check by SELECT principal_id, name, [type] FROM sys....
1
vote
0answers
420 views

Openrowset is throwing error for file access as Access Denied

I am getting Access Denied error .. Openrowset is throwing error for file access as Access Denied I tried running these 2 queries as well.. EXEC sp_configure 'show advanced options', 1 RECONFIGURE ...
1
vote
0answers
52 views

Variable Speeds on CHECKDB

Does anyone know why I should experience variable CHECKDB completion times from day to day? I'm seeing times anywhere from 45 to 90min for the task to complete. I am running CHECKDB on 8 SQL Server ...
1
vote
0answers
40 views

Archiving partition and removing the file group used for the same partition

I have created the below partition: CREATE PARTITION FUNCTION pf_table (DATETIME) AS RANGE RIGHT FOR VALUES('2018-01-01') CREATE PARTITION FUNCTION pf_table_Archive (DATETIME) AS RANGE RIGHT FOR ...
1
vote
1answer
34 views

SQL Server 11.0 and AD Groups

I have a user that has his Active Directory logon set to allow logging into a specific SQL Server, and that works fine. This user is also part of an AD Group that has access to a specific database on ...
1
vote
0answers
119 views

Resynchronize transactional replication in SQL Server 2012 without doing a complete reinitialization after disk filled

We have a DB that is doing a transactional replication to one other server. There are three tables it is replicating in the DB. Yesterday the subscriber ran out of disk space. This caused the ...
1
vote
0answers
126 views

Convert output of a query to JSON format

Given the following: https://dbfiddle.uk/?rdbms=sqlserver_2016&fiddle=b72da5e9263d55490fa0809c52577083 I need to have the secondname in the results too, and the output should be in JSON format. ...
1
vote
0answers
105 views

Restoring from a backup having dynamic file names

I want to restore a backup from a set of multiple files. The file names are generated dynamically. I have to restore the UAT with that backup. I need to schedule a job for this restore. This is SQL ...
1
vote
0answers
39 views

Dynamic rows and columns with Pivot and calculated value

I'm trying to build a pivot request but i don't undestand how it's applicable for my database. The value I need has to be calculate (A percentage) for each column and row. I'm using SQL Server 2012. ...
1
vote
0answers
423 views

Another ANONYMOUS LOGIN Error

I have two servers/instances, both MSSQL 2012. I have a linked server set up on SERVER1 "using the login's current security context" (@useself='TRUE') and RPC set to TRUE. SERVER1 is using domain ...
1
vote
0answers
31 views

Multiple queries to linked server (Access db) block Sql server

On a SQL server 2012 I've created a linked server pointing to Access database: It all works fine, unless we have more than one query to this server - queries that are not even related to the same ...
1
vote
0answers
20 views

Is it possible to deny a connection from changing ANSI_PADDING to OFF?

Our application occasionally throws errors if we ever apply filtered indexes because some of the C# application connections change the ANSI_PADDING to OFF for some routines. Is it possible to deny ...
1
vote
0answers
21 views

Microsoft SQL Server 2012 Audit Problems

I have a current audit in MS sql server 2012 that is set up with the following audit properties: queue delay : 1000 milliseconds on audit level failure: continue audit destination: file file path C:\...
1
vote
0answers
77 views

Testing Data Compression

We have a 1TB table that gets queried a lot. I have suggested we use Data Compression to save on space as well as help put more in memory. Because of the concern of CPU overhead, I have been tasked ...
1
vote
0answers
32 views

File Extensions are missing from new SSMS 2012

One of my colleagues SSMS recently got updated to 2012 version from SSMS 2008 R2. After that they are view only a few editors in SSMS for adding different File Extensions Tools ==> Options ==>Text ...
1
vote
0answers
100 views

SQL Server Agent Alert does not pick up some of Events from Application Log written by SQL Server Audit

My end goal is to be emailed when new object (schema, table, procedure etc.) is created / altered / dropped at one of my databases on SQL Server I created a server-level audit, that writes to Windows ...
1
vote
0answers
257 views

Mirroring on-premise SQL Server to AWS EC2 SQL Server

Trying to mirror an on-premise SQL Server instance to EC2 instance, but not much information is available on this topic. The closest one I managed to find is: Implement SQL Server High Availability ...
1
vote
0answers
178 views

Why isn't prod level updated after applying SP - SQL 2012

My environment is SQL Exp 2012 | SELECT @@VERSION = 11.0.2100.6 (RTM) I then installed SP4 + GDR with no errors. Now, SELECT @@VERSION = 11.0.2100.6 (RTM). I would have expected 11.0.7462.6. ...
1
vote
0answers
169 views

SQL Server with peer-to-peer replication migration from on-prem to AWS EC2 instances

I need to move three on-prem servers with peer-to-peer replication to AWS. SQL Server version is 2012. The AWS SQL Server will be on EC2 instances as the SQL Server RDS doesn't support replication yet....
1
vote
0answers
326 views

Create BCP Format File From SSMS

I want to create a BCP format file from within SSMS. Is there anyway to do this? All the sources are asking to use the BCP command line. I would rather utilize in SSMS window. https://docs.microsoft....
1
vote
0answers
40 views

Restricting users to execute queries that bloat up tempdb

we have many a times faced a scenario where bad queries using tempdb just bloats up this system database filling 700 GB of tempdb in like couple of hours. I know there is a scope to tune them up. But ...
1
vote
1answer
56 views

Notification of row entries

I have SQL Server 2012 machine housing a database running an off the shelf application with a users table. This users table contains PII enterable fields. Per requirement none of our databases can ...
1
vote
0answers
237 views

SQL Server Trace Stopped Messages Displaying Random Login Name

When traces are started and stopped we get messages similar to the following in the SQL Server error log: SQL Trace ID 2 was started by login "DOMAIN\loginA". and SQL Trace stopped. Trace ID = ...