Viewing 15 posts - 16 through 30 (of 120 total)
FYI..
here is my view.only on one column from one table.
USE [Database1]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW [dbo].[View_Table1]
AS
SELECT distinct(idnumber)
FROM Table1
GO
August 21, 2020 at 9:29 pm
Basically anytime when a new record is inserted into the specific table\column , it grab the record and bring it over in some way for use in another system.
we have...
August 21, 2020 at 9:23 pm
Thank you for valuable suggestions.
August 21, 2020 at 1:57 am
yes , it is required in real time.
when a source table has any insertions that should be transfer and update at target table.
August 20, 2020 at 5:59 pm
will sqlserver service\database work if i try to install SP2 and if it fails for some reason.?
Thank you.
May 22, 2020 at 12:55 pm
I am confused whether SP2 has installed or not.
Do i need to install SP2 for MSSQLSERVER selection and followed by CU12 installation?
May 21, 2020 at 7:00 pm
when i run the SP2 , it shows that MSQLSERVER section is "incompletely installed" and shared features section shows "installed".
PFA the screenshots.
shall i run the sp2 for MSQLSERVER selection?
May 20, 2020 at 8:44 pm
yes it is sql2016 sp2.
select @@version
Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server...
May 18, 2020 at 11:23 am
Just realized that ,actually we did't install the SP2 separately.
Installed sqlserver2016 enterprise and sp2 together with same installer file.
Can we still run the SP2 patch and select shared features ?
May 15, 2020 at 2:29 pm
Thank you. I will re-path with SP2 only for shared features, then apply the CU.
May 15, 2020 at 11:47 am
we don't have Always On Availability Groups configured .
PFA the summary log.
May 14, 2020 at 4:27 pm
Hi,
Installed the same CU12 in other servers(sqlserver2016 sp2 standard) without any issue.
But its failing on the server sqlserver2016 sp2 Enterprise edition.
Not understanding the exact cause. Any suggestions here .
Please find...
May 14, 2020 at 2:18 pm
Viewing 15 posts - 16 through 30 (of 120 total)