Geeks With Blogs
My Digital Life in Data Flow Data Warehouse, MDX, Cube, SSIS, BizTalk, SQL, XML, SSAS, SSRS, .NET November 2010 Entries
Change Data Capture to get a paricular set of change within a time span
The "fn_cdc_map_time_to_lsn" is especially useful DECLARE @begin_time datetime, @end_time datetime, @from_lsn binary(10), @to_lsn binary(10) SET @begin_time = '11/10/2010 10:00 AM' SET @end_time = '11/10/2010 8:00 PM' SET @from_lsn = sys.fn_cdc_map_time_to_lsn(... greater than or equal', @begin_time); SET @to_lsn = sys.fn_cdc_map_time_to_lsn(... less than or equal', @end_time); SELECT _OU.unit_natural_id AS Order_Id , CONVERT(DATETIME, LEFT(CONVERT(VARCHAR(80), _OR.return_body.query(' ......

Posted On Wednesday, November 10, 2010 5:38 PM

Execute SQL Job synchronously for BizTalk via a Stored Procedure call
The async one was very easy to do. However, in the process automation task I was given, there was a need to execute SQL Job and waiting for the execution result. I couldn't find anything on the web to do what I wanted, so I make the following stored procedure. In addition, this stored procedure is quasi-synchronous. I start the job and then check the status. You can change the timing of the status check, but for the example below, it is "synchronous within 30 seconds." I wish there is a better way ......

Posted On Monday, November 1, 2010 3:18 PM

Hitting a strange Vista Ultimate install issue
[Update 2010-11-03] This is really strange as I can restore the Vista Home Premium onto that machine and it works. Also, I just installed Windows 7 Ultimate and it works fine, too. The curiosity will probably prompt me to try installing it again, but downloading the images from TechNet is taking me 3 days so far. ;) Thanks, AreyouSerious, I'll try your suggestion, too. [Original Post] I'm hitting a really strange Vista Ultimate install issue. After the installation, the Windows Update cannot find ......

Posted On Monday, November 1, 2010 1:58 PM

Copyright © Kevin Shyr | Powered by: | Join free