Answer Posted / peter jacob

A login defines access privillege to the SQL Server. A user
defines the accessible objects and rights the login has.

How to create a user to access a database in ms sql server using "create user" statements?

616

---

How to get a list all databases on the sql server?

675

---

What stored by the msdb? : sql server database administration

638

---

Explain about builtinadministrator?

678

---

Do you know the different ddl commands in sql?

670

---

---

Explain indexes disadvantages?

633

---

Explain boyce and codd normal form(bcnf)?

621

---

What are .mdf files?

605

---

What is a group function explain with an example?

620

---

What is nested transaction?

634

---

What happens when converting big values to integers?

664

---

Which table keeps information about stored procedures?

615

---

What does null mean?

676

---

Explain throw statement in sql server 2008?

658

---

How to transfer data from a cursor to variables with a "fetch" statement?

654

---