Answer Posted / pavit

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

4.) so so so so so so so

If no size is defined while creating the database, what size will the database have?

998

---

How to create percentile function?

156

---

what stored procedure can you use to display the current processes? : Sql server administration

1018

---

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2077

---

is there a column to which a default can't be bound? : Sql server database administration

1021

---

what is sql server? : Sql server database administration

997

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1028

---

What is partition index in sql server?

1127

---

How to get the number of affected rows?

1008

---

Can one drop a column from a table?

1025

---

Explain filtered indexes benefits?

1009

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

1099

---

Which are the important points to note when multilanguage data is stored in a table?

1006

---

How do you manipulate data?

916

---

What do you understand by hotfixes and patches in sql server?

999

---