Sybase to MSSQL migration: Lock Datarows while create table

96 Views Asked by At

I am migrating a Sybase DB to a SQL Server DB. I can see that existing Sybase tables have lock datarows or lock allpages specified along with create table statement something like this:

create table new_publishers 
(
    pub_id     char(4)      not null,
    pub_name   varchar(40)  null,
    city       varchar(20)  null,
    state      char(2)      null
)
lock datarows

However, I could not find a way to do the same thing in SQL Server.

Can someone please tell me how to do this in SQL Server?

0

There are 0 best solutions below