Questions tagged [sql-server-2012]

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

615 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
81 views

The OLE DB provider “MSDASQL” for linked server “(null)” reported an error

I created a linked server to MySQL database server on my SQL Server database server. I tested the connection. It succeeded successfully for MySQL connection. I can see the databases on MySQL instance ...
0
votes
0answers
16 views

Unable to connect to SQL Server 2012 SSIS

I have been searching the web for the answer to my problem and I found this link which describes the problem but does not resolve my problem. Trouble Connecting to SSIS in SQL Server 2017 (14.0.1) I ...
0
votes
1answer
31 views

Change database and execute update query (T- Transact)

Could anyone face with issue like me? I need to update some rows in table, but I don't know exact name of database. I am able to figure out name with: Select name from sys.databases where name ...
0
votes
0answers
88 views

CDC capture Job Step-2 is not running when enabling CDC on table in SQL Server and Change table is empty

My Database has CDC enabled and the table i want to track changes using the below T-SQL, EXEC sys.sp_cdc_enable_db; GO EXEC sys.sp_cdc_enable_table @source_schema = N'dbo', @source_name = N'...
0
votes
1answer
32 views

Query on Linked Server in SQL Active-Passive

We have plan to implement Active-Passive SQL server cluster with shared storage with SQL 2014 version. A-P: There will be two DB servers (DB1 and DB2) and one will be working (DB1) and the other (DB2) ...
0
votes
0answers
16 views

SQL 2016 - TDE Restore Failing Even After Certificate Restore

I'm trying to ship some TDE enabled database backups from one server to another and I'm having a problem. Specifically, I'm getting the following error: RESTORE FILELISTONLY FROM DISK = N'<path>...
0
votes
0answers
14 views

Changing checkpoints settings in sql server 2012

I have a question regarding database recovery time interval settings which by default on SQL2016 is set to 60 secs as indirect checkpoints. Is there a way i can test like measuring certain counters ...
0
votes
0answers
144 views

Unable to connect postgresql server from pgAdmin4, showing error - 'ServerManager' object has no attribute 'user_info'

I am trying to connect a remote postgresql database server(RHEL7.5) through pgAdmin4 from my windows10 pc, but it is showing an error 'ServerManager' object has no attribute 'user_info'. I have ...
0
votes
1answer
23 views

TempDB Configuration using 8 TempDB Data File

On a production server with 512 GB RAM , 2 Sockets 24 Cores (Total Logical Processors 48), i have configured to have 8 TempDB Data Files ( on Primary) with each 4096 MB growth of 1024 MB and Log File ...
0
votes
0answers
9 views

Quantifying synchronous replication latency

Currently, we asynchronously mirror databases across the WAN to a different DC. What statistics can I collect (COMMIT times, maybe?) from Profiler to measure the impact? Any other statistics from ...
0
votes
0answers
96 views

Microsoft Data Migration Assistant Failing

I am using the Microsoft DMA to migrate data from a Microsoft SQL Server 2012 instance into a Microsoft SQL Server 2017 instance. I get all the way to the final step of selecting logins, start the ...
0
votes
0answers
25 views

SQL Server Agent fails to start

I am replacing a SQL Server 2012 cluster with a new one (keeping the same version of SQL, changing OS from 2008R2 to 2012R2). I have 1 node installed so far, but the agent won't start. The error ...
0
votes
1answer
28 views

Cancel Rollback and accept data loss

I have a SQL instance (2012 Standard Edition) which consumes all CPU resources because of a rollback-process. The instance has been restarted, so the database is currently In Recovery. I cannot see ...
0
votes
0answers
40 views

Always On Availability Groups and MSDTC for SQL Server 2012

I have been told that since MSDTC is not supported for SQL Server 2012 Always On Availability Group and should be turned off. what specific settings do I need to change to turn it off? This is what ...
0
votes
2answers
32 views

Does MSSQL Server need more space than the size of the data itself for importing? How much more?

Does MSSQL Server need more space than the size of the data itself for importing? How much more? How to tell? Recently tried copying data into MSSQL server (2012) Microsoft SQL Server Management ...
0
votes
0answers
54 views

How to stuff together earliest date and or text

I'm trying to write a query and output to an excel file which outputs all of a members mortgages into a cell, but grabbing their earliest maturity date first. Table Creation CREATE TABLE mortgages ( ...
0
votes
0answers
33 views

Stuff With XML Path

DECLARE @v NVARCHAR(MAX)='' select @v =STUFF((SELECT CASE WHEN MeterID=0 THEN '' ELSE CONVERT(VARCHAR(50),MeterID) + ',' END AS [text()] FROM (SELECT DISTINCT mr.MeterID FROM #...
0
votes
1answer
41 views

Duplicate record inserted - why trigger is not preventing it?

I have two tables: DebitIUVs and RPTs. I have record inside DebitIUVs which is with state 118001. My business logic must insert new line inside RPTs table. Inside RPTs table there is additional ...
0
votes
0answers
322 views

Oracle Linked Server Issue

I am having a Linked Server from SQL Server 2012 to Oracle 11G. TNSPing and Test Connection to the Linked Server is working fine. But when using the Linked Server to run a stored procedure or when ...
0
votes
0answers
102 views

I/O Requests taking longer than 15 seconds, Flush Cache During Replication SQL-Server

Hello I'm primarily a developer but I am trying to troubleshoot our database that basically just locked up last week. I have been diving into this pretty heavily but I'm also a bit out of my league in ...
0
votes
1answer
93 views

How to see restore history of a deleted database?

For example, I had a database and I want to see which physical backup file was used to restore into it. The problem is that the database was deleted. How can I see the record?
0
votes
0answers
42 views

Transactional Replication with 2 subscribers

I have an existing subscriber and want to setup another subscriber but on different machine.So 2 subscribers, 1 publisher I want to initiate it from a backup rather than snapshot but when i try set ...
0
votes
0answers
30 views

Is it a problem to define a non-UTF8 collation in an NVARCHAR field?

I am working on an application I need to make cross-database. One of the things I stumbled on is that SQL Server by default has a case-insensitive collation defined, which makes queries on NVARCHAR/...
0
votes
0answers
58 views

xp_sysmail_activate

There are multiple instance that whenever I am seeing xp_sysmail_activate running in SQL Server, DB performance is degrading. Whenever I kill the process, the database can't recover and restarting ...
0
votes
0answers
142 views

Error Formatting Query, probably Invalid Parameter

I created a SQL mail job on Thursday and it runs hourly. It ran fine until Sunday at 3 for which it has been failing with the following error. Executed as user: NT AUTHORITY\SYSTEM. Error ...
0
votes
0answers
210 views

RESTORE VERIFYONLY FROM DISK is failing

We are having WSFC(Windows Server Failover Cluster) configuration for one of database server and from last few days, backup of one of the database is failing. Sometime backup itself fails whereas on ...
0
votes
1answer
81 views

How to find average of transactions every 15 min in Sql server for last 7 days?

This question might not be new in forums , but struggling to get the expected out put. Please any body share the similar requirements if we face with solutions. I would like to find average of total ...
0
votes
1answer
30 views

Movement of data from one data file to another within PRIMARY Filegroup

Scneario: We had only 1 data file(.mdf) which is now around 900 GB. We are planning to split it across multiple drives to improve IO performance. As of now we have created 8 different data files in 8 ...
0
votes
0answers
16 views

Can we change asymmetric key attached to a SQL server login

I have created a login using the below command: Create Login test From Asymmetric Key asymkey1; Is there any way to alter the login and attach a different Asymmetric Key asymkey2?
0
votes
0answers
171 views

SQL Server 2012 Fails to Install with 0x80004005 - The system cannot find the file specified

I'm trying to install SQL Server 2012 Express SP4 with Advance Tools on Win Server 2012 R2 Essentials. It keeps failing in the SqlEngineConfigAction_install_startup_Cpu64 action. It fails with error ...
0
votes
1answer
109 views

Error 23 on transaction log backup, full backup works fine

I have a database with the database files on the E: drive, and logs files on the D: drive. I'm getting the following error when trying to run a transaction log backup: Read on "D:\LOG\AOA_Log.ldf" ...
0
votes
1answer
55 views

Does Data Migration Advisor migrate system databases?

I would like to know if Data Migration Assistant copies system databases (master, model, msdb) into the new server.
0
votes
0answers
16 views

Report Service stopped unexpectedly

The SSRS service stopped unexpectedly and the workaround was to recycle the app pool and then restart the service, but no clue of what happened. When looking at the error log below:   <Path>C:\...
0
votes
0answers
126 views

Not able to migrate DTS package from SQL Server 2008 to 2012. Getting errored out

Requirement: We need to migrate SSIS/DTS package from SQL Server 2008 to another machine having SQL Server 2012 on it. Steps performed so far: 1. First I exported the package from Source server to ...
0
votes
0answers
32 views

How to recalculate and adjust the entire row of time in and time out in sql server?

In SN = 1, I have an original schedule of 09:15:59 with my first time in is 09:50:57 so that I am late about 34 mins. In SN=2, 13:27:05 is my time out. In SN=4, I time in again of 15:40:13 that gives ...
0
votes
1answer
331 views

Mssql query problem. Column '' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause

There is a problem I have experienced in mssql. ( but I don't have this problem in mysql. ) They know two different engines. but I could not find a solution. Do you think I can fix this error? My ...
0
votes
1answer
64 views

Restore previous version of database in sql server

I need your help on restoring previous version of database on SQL Server. In last week I restored database 'A' in DEV server with it's production copy and didn't realize that this database 'A' in ...
0
votes
0answers
40 views

Migrating SQL Server 2012 Web Edition to Azure

I am trying to migrate to Azure I have gone through this article Migrate SQL Server to a single database or pooled database in Azure SQL Database online using DMS, However since I am having SQL Server ...
0
votes
1answer
36 views

What will happen if master goes down in peer to peer replication?

In case of Peer to peer replication, if Master goes down, will the other two nodes continue synchronizing or not?
0
votes
1answer
40 views

Aggregating data in .net SQL

I'm converting a database originally written in MS Access VBA to .net and many of the SQL statements that worked in Access don't work in .net. My data set is standard stock market daily information ...
0
votes
0answers
24 views

There is no column named id5093 in the table body_record. It is ignored for this operation

One of our Database - has been Error Spamming Event Logs for over 8 months stating the below Error: There is no column named id5093 in the table body_record. It is ignored for this operation. The ...
0
votes
1answer
49 views

MSX Job deployment: Not creating job on certain servers

I am deploying a new index maintenance jobs through MSX to about 100 servers, I am in the process of manually checking that each job has been created and I have already discovered that for some ...
0
votes
0answers
64 views

Performance difference between on-prem SQL Server and SQL Server running on Azure(IaaS)

We are comparing the performance of an on-prem SQL Server and SQL Server running on Azure VM. The Azure VM is created by Azure Site Recovery(ASR). For the testing purpose, we have executed following ...
0
votes
0answers
83 views

Writer vs writer deadlock and solution

Earlier we used to have reader vs writer and writer vs reader deadlock, which is resolved by setting isolation level at application configuration level from "Repeatable Read" to "Read Committed" which ...
0
votes
0answers
487 views

Create SQL Server Agent job for stored procedure with input parameter

Could you suggest please how to create SQL Server Agent job for a stored procedure that have 1 input parameter? The procedure is correctly created and i executed it using this code : EXECUTE dbo....
0
votes
1answer
555 views

SQL - Update certain database records with a loop

I have a certain IDs in a table that I would like to change a column value from false to true. How can I do a loop that goes through the specific IDs given and changes a column value from false to ...
0
votes
0answers
110 views

Regarding NIGHT SHIFT Employees

I have small issue on night shift of our employees. Shift timings are from 22:00 to 6:00. If the shift starts today at 11 PM it will end the next morning at 6:00 AM (7 Hours ). Here I want to know ...
0
votes
0answers
220 views

Loading 'Image Service Package' crashes Management Studio

I'm getting the following error on my SQL Server when I log into the system: I ran a repair on SSMS successfully, but it did not resolve the issue. The following error message is recorded in Event ...
0
votes
2answers
78 views

SQL Server 2017 Express edition Bulk load

I am working on the SQL Server 2017. I need to import 20 text file into one table. Every text file has the same data type and column name. I have checked the data and they have in the same order also. ...
0
votes
0answers
28 views

Connect to SQL server from client

Currently, I am using the SQL Server 2012 Express version and it is installed on Windows Server 2012 R2. Now I just want to connect to this database from a Windows 7 client. The Windows 7 computer ...

1
7 8
9
10 11
13