Answer Posted / vikas

select top 100 max(field name) from Table Name

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

932

---

Explain what is “asynchronous” communication in sql server service broker?

908

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1918

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1198

---

What is the difference between the 2 operating modes of database mirroring?

1100

---

What are the types of normalization?

1025

---

Is it important for a database administrator to understand the operating system and file access?

972

---

How to get the query of a table in sql server?

892

---

How to move database physical files in ms sql server?

1021

---

what is create database syntax? : Sql server database administration

1099

---

What is the parse query button used for?

1025

---

What do you mean by data manipulation language?

1007

---

What does it mean if @@cursor_row returns a negative number?

982

---

What are views in ms sql server?

1071

---

Difference between report and query parameter.

1088

---