In SQL Server Management Studio (SSMS), you can see the SQL Server database state. Alternatively, you can use T-SQL commands to verify your database status. You can use the DATABASEPROPERTYEX function ...
5) iterate over the cursor, retrieve the PK value for the record (assuming you don't update those as well, otherwise add another unique identifier to the table) 6) issue an update statement with same ...