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?