Tag: sql-server-2012

How to send email alert when 2 SELECT COUNT statements from 2 different servers is not equal?

I currently have two servers that must always be synchronized with one another. To monitor this, I have a query that I am using to check whether they are equal or not. This is the query: SELECT COUNT (distinct filename) from DB.dbo.Table (nolock) WHERE SentWhen > ‘2017-07-17 00:00:00’ I am having problems with regards to […]

Unable to load stored procedure result set into temporary table in SQL Server

I am trying to load stored procedure result set into a temp table, but data is not loading into the temp table. The stored procedure results are not stored into the temp table. It is showing “0 rows affected”. Example #1: EXEC dbo.emp (10 row(s) affected) Example #@: insert into #tempemp EXEC dbo.emp (0 row(s) […]

Converting SQL server table data from a column structure to a different column structure

i have just taken over development at my place a work and have basically been thrown in the deep end with the SQL server, i’m not very knowledgeable with query’s and the format so please go easy on me. i’m using Microsoft SQL server 2012 and basically what i’m trying to achieve is to take […]

Reset INCREMENT VALUE For Identity Column using T-SQL Script

I Need Change Increment Value for Identity Column For Example I have create table Test Table with Identity Column Create Table test ( Id Int Identity(1,1) ,Name Varchar(200) ) Now it is easy to Reseed the start value of Identity Column using DBCC CheckIdent(‘TEST’,Reseed,100) But I want to change the Increment value 1 to 10 […]

How To Stop A SSIS Package Step In SQL Server Agent Job

I have a SQL Server Agent job that runs on daily basis and the first step in the job is to execute a SSIS package. For the past a few days the step 1 is being running endlessly. Is there anyway that I can shut down the running step?

Data from Oracle to SQL Server

I have SQL Server 2012 and I need get into it data from Oracle. I go true manual: https://www.sqlshack.com/link-sql-server–oracle-database/ and I stack with files: sqlnet.ora and tnsnames.ora I read and saw youtube manuals how to make values into sqlnet.ora and tnsnames.ora but it does not work. Files sqlnet.ora and tnsnames.ora I try created new but […]

Split comma separated values in sql based on condition

This question already has an answer here: T-SQL split string 21 answers

Failed to find or load the registered .Net Framework Data Provider. (System.Data)

I open my SSMS and right click on DB and then Tasks -> IMport Data to import data from a source but as soon as I click I get this error: Failed to find or load the registered .Net Framework Data Provider. (System.Data) This is the full error: =================================== This wizard will close because it […]

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. while creating a new stored procedure in sql server 2012

I am getting Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. while doing drop and create for a stored procedure in SQL Server 2012. This error only comes for this stored procedure only while I can drop and create other stored procs just as usual. The thing is that it has now dropped the stored procedure […]

The required MSI package D:\Microsoft SQL Server 2012 Enterprise\x64\setup\.' doesn't exist error

I have the setup file on the D: drive, and I am installing the SQL 2012 enterprise on the C: drive. Every time I try to install it, it gives the following error TITLE: Message Details The required MSI package D:\Microsoft SQL Server 2012 Enterprise\x64\setup.’ doesn’t exist Screenshot I tried to copy/paste the sql_engine_core_inst from […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.