Answer Posted / yvbchowdary

yes u can delete the default constraint. First find out the
constraint name for the default and then execute the
following quey

alter table <table-name> drop constraint <constraint-name>

Explain “not null constraint” in sql server?

1039

---

Which is the latest version of sql server and when it is released?

1114

---

How to see the event list of an existing trigger using sys.trigger_events?

1075

---

What factors you will consider calculating the storage requirement for that view?

950

---

What is a group function explain with an example?

993

---

What is transaction server implicit?

1015

---

How to skip remaining statements in a loop block using continue statements?

1000

---

Data table as parameter in sql server?

1050

---

what is spatial nonclustered index

994

---

What stored procedure would you use to view lock information?

978

---

How you provide security to cube? : sql server analysis services, ssas

968

---

How to return the top 5 rows from a select query in ms sql server?

1145

---

Can two tables have the same primary key?

1213

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1194

---

Mention the different types of replication in sql server.

1027

---