Answer Posted / rahul

So many ways:
1.) right click on the server name and then click on
properties. From there you can see all the Server details
including sp.

2.) In Query Analyzer window type select @@version and
execute

3.) in Query Analyzer type xp_msver

How to convert numeric expression data types using the cast() function?

1002

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1024

---

How can I change procedure name in sql server?

972

---

How would you choose between a clustered and a non-clustered index?

914

---

What is auditing in sql server?

879

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

839

---

What is difference between Datepart() and Datename() in SqlServer?

1156

---

How to create a dynamic cursor with the dynamic option?

968

---

Why should you use or avoid select * statements?

965

---

Explain rdbms?

979

---

What is etl - extraction, transformation, and loading?

856

---

Explain about merge replications?

963

---

how to take backup bcp out for a column in table in sql server?

2043

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

984

---

How to create a store procedure with encryption?

949

---