SQL Server Whitelisting For Mcafee Solidcore
Does anyone know of any list of Microsoft SQL Server ( version 2014 and 2016 ) executables and its associated files and DLLs that needs to be whitelisted from Mcafee Solidcore for it to work properly. This is for a Microsoft SQL server that will be…
sql server2019 cannot log in using Computer name in diffrent machine
There are two machines in LAN,Both have installed sqlserver service. All The sqlserver instance name is default. Now, They can login in each other using IP,But can not login in using Computer name. why?
Database with master key
A Citrix database created with some Citrix Wem tool have a symmetric key where it was once created. Trying to move database no another server and is prevented to add to Availability group because of the master key. Been searching for this and as database…
How to log Connection string in SSIS
Hi, I have a package which runs from a SQL Server and connects to dozens of other instances on the network before running various scripts. I am getting a lot of SSIS Error Code DTS_E_CANNOTAQUIRECONNECTIONFROMCONNECTIONMANAGER Is there any way to…
How to import password protected Excel file into sqlserver using ssis
Hi All, I want to import password protected excel file into SQL Server using SSIS. Please help me
SQL Server - How to keep DB access up while creating a bacpac file
First, we are a startup with a relatively big (14 GB) database and a small budget. We need a current, weekly would be ok, copy of the database for local use. The bacpac method works well, except that during the export process DB access slows to a crawl,…
SSIS dtexec Error - The 'OraOLEDB.Oracle.1' provider is not registered on the local machine.
Hi I am have one SSIS package that connects to Oracle and pulls the data. I am trying to execute this package using DTExec utility. "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\DTExec" /ISSERVER…
Can I deploy to SQL Server 2014 SSIS Catalog from Visual Studio 2017?
We are testing Integration Services Catalogs with SQL Server 2014. We are trying to find a way to deploy from Visual Studio. When we try from Visual Studio 2017 Pro (with data tools) we receive the following error. ![18800-image.png][1] I'm trying…
UniqueIdentifier - Performance Issues Though doing a Index Seek
Dear Experts, I have two Tables with 800 Million Records in each where the Two Tables which I have Uniqueidentifier Column in the both as Primary Keys and one is references to other table. While the Select is done with other tables including these…
.Net SqlClient Data Provider Queries "Stuck
We started to notice that a bunch of client-side exe apps that run simple SQL queries (Insert, delete) are stuck. When we copy the query and run it manually it completes in seconds, but it seems like all these jobs are stuck. Any ideas why and/or what…
Visual Studio C# 2012, MS Sql Server Express 17
OK Folks, I've been developing code in Visual Studio C# V12, using MS Sql Server Express V2017 for a year. -No Problems. Code compiled, and I could test and deploy code. -I added a database in MS Sql Server Express V2017 -total unrelated to my…
BCP date format
I am attempting to import data using bcp. The data contains dates formated as Jan 03 2019 12:00:00:00.000000AM. BCP rejects this data, saying this is an invalid date format. I believe BCP expects a date formatted as 2019-01-03 12:00:00:00.000000. …
How to Process Cubes on Different Server?
Hi guys, I am trying to process SSAS cubes on server"B" by kicking SSIS on server"A" with the EffectiveUserName option. The job executing user is an AD user whitch has admin authority on both server "A" and…
Heterogeneous Logreader encountered an error in call to LoadReplCmds when processing state 'SYNCINIT_FETCH'
We are having a Oracle as Publisher and distributor and subscriber is SQL SERVER. My Log reader Agent is getting failed showing below error : Error messages: Query timeout expired (Source: MSSQLServer, Error number: 0) Get help: http://help/0 …
MDX code to get today's date
Hello, I created a query for Excel in Power Pivot using the visual designer. I currently have to change the dates every month. I need to modify it so it automatically returns the data for January from the current year until the current month. …
Global variables using in other forms
I am making a software i want a global variable so that i can use across one form to other so basically i want to call roll no. that is written in an event datagridview row header event: Roll_No =…
Database trigger and there is login fail on the sql errorlog
I have the following trigger database trigger and then there is a error in the errorlog why is that ?
Index Optimization job stuck - Sql 2008R2
Hello, We have Sql 2008R2 and we are running Index Maintenance job (Index optimization) part of Ola's maintenance Solution but during job was running and Sql server Shutdown/Restarted and job still showing as in 'Progress'. This is a Sql Agent job we…
SQL Server 2019 Highly Available Cluster - Setup
I have a Hyper-v Cluster and would like a recipe for adding a highly available SQL role
SQL Server 2014 table compression
Hello, planning on running a SQL Agent Job to compress some Prod Tables which looks like will take a couple of hours to finish. Is it correct to say that during this Tables (only) compression job just the target tables will be unavailable/locked and…