Answer Posted / swapna

The global variable @@Version stores the build number of
the sqlservr.exe, which is used to determine the service
pack installed.

How to list all stored procedures in the current database using ms sql server?

1118

---

Can one drop a column from a table?

1008

---

What is an identity?

997

---

What is indexing and its types?

1007

---

What is normalization according to you and explain its different levels?

939

---

What is the cpu pressure?

1029

---

How to delete duplicate rows?

984

---

Explain about SQLOS?

994

---

What is the security principal at the server level that represents your session?

1004

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1010

---

How to select true false based on column value in sql server?

1007

---

How to use values from other tables in update statements in ms sql server?

1100

---

How many clustered indexes there can be on table ?

1021

---

Where are sql server user names and passwords stored in sql server?

1070

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

901

---