Answer Posted / subbu

suppose if we write a trigger on the table on insert or
delete or update

on insertion of record into that table,
inserted table will create automatically by database,

on deletion of record from that table,
deleted table will create automatically by database,

This two tables inserted and deleted are called magic
tables.

How can you manage sql azure security?

105

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

999

---

Explain transaction server explicit transaction?

968

---

Is it ok to shrink transaction log?

1048

---

What number sorts of privileges are accessible in sql?

1085

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1165

---

how to do partition in sqlserver

2539

---

A trigger can reference objects outside the current database? State true or false.

1056

---

Does transparent data encryption provide encryption when transmitting data across the network?

1095

---

What is Sqlpaging in SqlServer 2005 ?

1111

---

What is check constraint in sql server?

1042

---

Define master database?

1137

---

How to change the password of a login name in ms sql server?

1056

---

What is cross join in sql server joins?

1195

---

What is the maximum size of sql server database?

1050

---