Hi,

SqlPackage.exe is used for apply dacpck and dacpac is applied successfully and have done new data modifications.
I want rollback all changes (new tabels , new procedures etc.)...

Hi

any other method for rollback dacpac applied.

Hi,

Anybody have any idea about dcapac rollback

Regards
Binu

Hi,

Below is output
SoftwareVersionMajor    SoftwareVersionMinor    SoftwareVersionBuild
13                                    0          ...

Hi,

index have created  other tables without issue,
have to check about network latency

Regards
binu

Hi Jason,

Index is created from another machine.
Not killed the statement.
Cancelled query from ssms.
checked index creation in ideal time, but not completed execution.
Issue in client...

Hi Jaison,

Below query is blank output 
select * from sys.indexes where name ='IDX_POSITION_ID_FROM_DATE_TO_DATE'

Regards
Binu

Hi John,
below is full output.
output is taken when executing the query  

session_id host_name program_name client_interface_name login_name session_status database_name request_status command wait_type wait_sec last_wait_type wait_resource blocking_session_id blocking_host blocking_program blocking_login transaction_id open_transaction_count cpu_sec total_elapsed_sec start_time reads writes logical_reads isol_level object_name sql_handle plan_handle text
51 MSCSMCY-SHIPMAT Microsoft SQL Server Management Studio - Query .Net SqlClient Data Provider Administrator running SHIPMATE_1 runnable CREATE INDEX NULL 0.000000 SOS_SCHEDULER_YIELD  0 NULL NULL NULL 163522173 1 587.649000 591.452000 2017-08-23 17:09:15.850 0 0 1567 Serializable NULL 0x01000C00F582920120D0D3DC0600000000000000000000000000000000000000000000000000000000000000 0x06000C00F5829201600BF8AE0600000001000000000000000000000000000000000000000000000000000000   CREATE NONCLUSTERED INDEX...

Hi,

as per below query there no wait type and blocking

/* running requests */
SELECT s.session_id, s.host_name, s.program_name, s.client_interface_name, s.login_name, s.status AS session_status,
  db_name(er.database_id) AS database_name,...

Hi Phil,

Another index have created for same table.
How can check blocking
Regards
Binu

Hi John,

how can identify wait type for the SPID

Binu

Thanks for info

Hi All,

Any solution for below issue

 Detailed message Unable to reconnect
to database: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xf3ffe274; actual: 0xf3fff274)....

Below message when run DBCC CHECKDB WITH NO_INFOMSGS
Msg 211, Level 23, State 255, Line 3
Corruption in database ID 43, object ID 60 possibly due to schema or catalog inconsistency....