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

can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,

---

Explain about Normalization?

0 Answers   Infosys,

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

0 Answers  

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

---

What type of locking occurs during the snapshot generation? : sql server replication

0 Answers  

---

How to convert character strings into numeric values?

0 Answers  

---

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

---

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  

---

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

---

Can binary strings be used in arithmetical operations?

0 Answers  

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---