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 the difference between mysql and sql server?

1025

---

Do you know sql server 2008 backup compression?

968

---

What is sql profiler. What are the default templates with it? : sql server database administration

1045

---

What are the advantages of passing name-value pairs as parameters?

1168

---

How to optimize stored procedure optimization?

894

---

How to restore performance issues and how to check?

2004

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1958

---

Explain about local stored procedure?

972

---

What are the differences between char and varchar in ms sql server?

1066

---

How to test subquery results with the exists operator?

1107

---

1 01 101 01010

2054

---

What is database black box testing?

1034

---

What is xml datatype?

1074

---

How to connect of datebase with sql express.?

1104

---

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

1006

---