Rows per batch property - social.msdn.microsoft.com
Oct 6, 2016 · Can someone please explain to me exactly how the "Rows per batch" property is applied in an OLEDB Destination? I understand "Maximum insert commit size" but I find myself putting …
compare time in ssis - social.msdn.microsoft.com
Nov 10, 2015 · There are different ways to do it. If you are comparing in T-SQL you need to use CAST or Convert functions to match and compare the format. Below is the link to help you to convert into …
Convert Numbers/Currency to Words - social.msdn.microsoft.com
Mar 28, 2019 · I am using SQL 2005. Are there any functions or logic that will return string of words for a currency For e.g. if the Value is $ 4,444.44, then in words it would be Dollar Four Thousand Four …
Merge replication - Not working - social.msdn.microsoft.com
Jun 4, 2008 · PS: (Applied SP2 Patch, but the problem still persists) and the process works fine if i use pusg subscriptionFor reference here is the t-sql subscription code, and the vb.net that initiates …
Why rollback transaction can't roll back all update/insert sometimes
Aug 3, 2012 · Most DBAs would cringe at code like this because we’ve learned to make transactions as granular as possible. Inexperienced T-SQL programmers, however, might not be familiar with …
Implicit conversion of varchar value to varchar cannot be performed ...
Jan 28, 2016 · I think, this is not an issue of the variable. Have you take the sql-statement in a new query-window and try to process? I believe the Collation of your database (s) and the tempdb are …
TDE stuck in 2 (encryption in progress) - social.msdn.microsoft.com
Sep 18, 2016 · You need to "cycle the transaction log" so that you don't have any non-encrypted log records in the log anymore. In simple recovery, execute the CHECKPOINT command from within the …