Answer Posted / prasad

Login is for Entire SQL server Instance,
User is for particular database.

1 login=many users.

Is sql server is free?

1017

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1190

---

What is the maximum size of column in sql server?

944

---

What do you understand by triggers?

977

---

What is the purpose of linked server configuration in sql server?

1095

---

What are ddl (data definition language) statements for tables in ms sql server?

1152

---

what is a deadlock? : Sql server database administration

1150

---

Explain collation?

1102

---

How to end a stored procedure properly in ms sql server?

1147

---

How to write a query with a right outer join in ms sql server?

963

---

What are the advantages dts has over bcp?

1050

---

What does it mean to normalize data?

999

---

Suggest a method of joining two tables.

1233

---

How to divide query output into multiple groups with the group by clause in ms sql server?

1090

---

How to check status of stored procedure in sql server?

1042

---