Answer / kirubaharan

Unable to create index 'PK'.
Cannot define PRIMARY KEY constraint on Computed column in
table.
Could not create constraint. See previous errors.

Answer / ricky

in sql server 2000 we can create the uniqe and primary key
constraint in computeted coloumn.....but in sql server 2005
we can not create the uniqe and primery constraints in
computed coloumn.

Answer / uma lakshman

Because SQL Server 2000 supports indexes on computed
columns, you can create UNIQUE and PRIMARY KEY constraints
on computed columns

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

Which language is supported by sql server?

0 Answers  

---

last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

---

Is oracle faster than sql server?

0 Answers  

---

---

What is Self Join?

4 Answers  

---

What are the types of indexes?

0 Answers  

---

How to Handle the exceptions in Sqlsrver 2005??

3 Answers   Value Labs, Wipro,

---

Can we write trigger for view?

0 Answers  

---

What is the standby server?

0 Answers  

---

explain different types of constraints? : Sql server database administration

0 Answers  

---

What is the library index called?

0 Answers  

---