Answer Posted / trived.r

this used to changes the permissions on database
this DCL(DATA CONTROL LANGUGE)STATEMENT

*)GRANT---THIS IS ACCESS GARANTED ON PARTICLUR DB OR
USER
*)DENY----THIS IS PARTICLUR USER WAITING FOR ACCESS WHILE
TME WHEN COMMETED THE DATA THEN PERMISSION ON DB

*)REVOKE--- THIS STATEMENT USE THE USER HAVE NO PERMISIONS

What is SubQuery in SQL Server 2008

731

---

Explain sql server service broker?

726

---

What is sqlcmd?

726

---

Can you explain important index characteristics?

702

---

What is a data collection table?

745

---

Can binary strings be converted into numeric or float data types?

774

---

Explain differentiate between a having clause and a where clause?

693

---

Do I need a report server to run reports in my application?

129

---

How do I schedule a sql server profiler trace?

707

---

Describe in brief authentication modes in sql server.

742

---

Create and insert into temp table in sql server?

792

---

What are the steps to process a single select statement?

703

---

What new data source types were added in ssrs 2014?

130

---

Can you use order by when defining a view?

749

---

what is a schema in sql server 2005? : Sql server database administration

711

---