Viewing 15 posts - 2,296 through 2,310 (of 2,701 total)
October 11, 2018 at 4:02 am
You still haven't figured out you are just wasting your time and that of everyone here that has tried to help you.
Had you supplied with all the information...
October 11, 2018 at 3:59 am
intriguing - are all servers on same SP/CU level?
And same for OS
October 10, 2018 at 3:07 pm
bahhh... try and work with irish capitalization...
an tSín (China)
Máire Mhac an tSaoi "Mary McEntee"
where the capital is...
October 10, 2018 at 2:22 pm
Just to be sure sure... if you execute those commands in all of the cluster nodes does any of them give a similar result to that of the dmv?
October 10, 2018 at 1:52 pm
My take on this if I was the DBA.
From your side I would only be interested in knowing the following
--Expected growth of the databases
--Batch job activity...
October 10, 2018 at 12:34 pm
without some type of coding it will be complex and cumbersome - and code is easy, straightforward and plenty of samples on the net. One such example https://stackoverflow.com/questions/6589136/how-to-ping-from-within-an-ssis-package - you...
October 8, 2018 at 5:04 pm
code needs a quotename on the column list build
(select ', ' + quotename(COLUMN_NAME) ---
from ##Resultset
October 7, 2018 at 2:22 pm
you can if you use a custom script.
Not advisable and on my opinion it should not be done, and it is no longer replication.
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addarticle-transact-sql?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/transactional-articles-specify-how-changes-are-propagated?view=sql-server-2017
October 6, 2018 at 5:35 pm
one way.
get a machine with 16 GB or more -- less and it will crawl.
install a free esx hypervisor - https://www.vmware.com/products/vsphere-hypervisor.html
setup 3 VM's
-...
October 6, 2018 at 5:26 pm
Control panel -> administrative tools -> Data sources (ODBC) - Drivers - will most likely also contain an entry for each Oracle driver installed on each home
registry - KHLM\Software\Oracle...
October 6, 2018 at 2:04 pm
1) Don't put SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED in any...
October 5, 2018 at 11:42 am
ScottPletcher - Friday, October 5, 2018 11:01 AMBut does the actual data always match that constraint?
only the OP knows - this...
October 5, 2018 at 11:12 am
October 5, 2018 at 10:11 am
there may be a lot more to it.
first how are you extracting from DB2
- Direct connection from SSIS (OLEDB or similar)
-- in this case...
October 4, 2018 at 5:46 pm
Viewing 15 posts - 2,296 through 2,310 (of 2,701 total)