Answer Posted / sql2000

Its Possible, run the below code and have a look...

begin transaction
create table test (col1 int, col2 int)

insert into test values (1, 1)
insert into test values (1, 2)
insert into test values (1, 3)
insert into test values (2, 1)
delete from test where col1 = 2

alter table test
alter column col2 int not null

alter table test
add
constraint [pk_col2] primary key nonclustered(col2) on
[primary]
rollback transaction

When to use null data driven subscription?

207

---

Can We Use Data-grids For Our Report In Ssrs?

184

---

Which joins are sql server default?

1013

---

what changed between the previous version of sql server and the current version? : Sql server database administration

1014

---

Define the one-to-one relationship while designing tables.

903

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1051

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

6887

---

What is difference between getdate and sysdatetime in sql server 2008?

1048

---

What are trace files?

959

---

How to create database with physical files specified in ms sql server?

996

---

What should be the fill factor for indexes created on tables? : sql server database administration

1139

---

What do you understand by a view?

998

---

What is the Control Flow in SSIS

1094

---

Do you know what is rank function?

1074

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

946

---