I'm using SSMS 2014 to fetch data from Progress OpenEdge 10.2B via ODBC, and dealing with OpenEdge's overstuffing of its datatypes is a constant challenge. The only way I've found to see what size my fields need to be is to use the SQL Server Import and Export Wizard. When it detects the field le...
We are looking at setting up SQL AlwaysOn availability groups in the following environment: we have two SQL 2014 Enterprise Servers on two different host Hyper-V 2012 servers. They each have completely different databases on them one is for our research group and one is for our department. ...
Here's the trigger causing the problem: USE [SalesDb] GO /****** Object: Trigger [dbo].[trgAfterUpdate] Script Date: 7/16/2015 6:34:01 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[trgAfterUpdate] ON [SalesDb].[dbo].[Article] FOR UPDATE AS select a.id...
I'm unfortunately well aware from many questions asked previously that SQL Server Compact 4 can no longer be opened as an object in SQL Server 2014 Management Studio. However I can't find any definitive information on whether or not I can add Microsoft.SQLSERVER.CE.OLEDB.4.0 as a provider in SQL...
I am using SQL Server Migration Assistant (SSMA). I have a field that is a (signed) double in MySQL, and I want it to be a decimal(18,4) in SQL Server. I have changed the Type Mapping for Source Types double and double precision to decimal(18,4) in the TargetType column (and clicked apply) in t...
I currently have websites running on SQL Server 2008 R2 - this is the version I also have installed on my own machine. I'm looking at moving my websites to a different provider, however they only run SQL Server 2014. As it's a managed service, I've had very little to do with the installation on ...
We have a nightly SSIS job which downloads data from a Vendor's Oracle system into our SQL Server 2014 system using Oracle's Wallet. On some tables, we've noticed that some VarChar columns have the last character truncated. This appears randomly in some rows, and happens without any errors being...
« first day (210 days earlier) ← previous day next day → last day (1364 days later) »