Dear Partners,
Need:SQL Server (80% developer & 20% DBA) especially transaction logs,DBCC & CDC
(NY) Local or near by!!!
Job Responsibilities
Developers and not DBA/Admin type.
Someone who have developed applications with SQL Server especially transaction log readers, change data capture applications. SQL 2000 and 2005.
DBCC and CDC.
Location :NYC
Rate:Open
Interview today for right candidates!!!!
Note:
Develop code (or advise our developer on APIs) that reads the current Transaction logs and has a displays the LSN (log sequence number), the Object name and the transaction Id, once you select the record it gives you the Record Data ( column and values) that were part of the record, the SQL used to generate (insert/update) the record and the SQL to delete the record. The capabilities all should exist from interpretation of the transaction Logs.
Need to show LSN and the actual DML/DDL (SQL thats was used for insert and the undo SQL) associated with the TransactionId, since MS SQL Server does not support
query by rowid.Thanks,SonaliZealTech Inc.Phone:510.870.5025 * Cell: 510.449.5280 * Fax : 510.372.0571
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Microsoft DOTNET ASP, C++, SQL SERVER" group.
-------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------
For stunning photoshop tutorials, visit:
www.psd-help.blogspot.com
-------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
