Answer / Ajeet Kumar Singh

To get a list of all schemas and tables in a SQL Server database, you can run the following query:n```nSELECT SCHEMA_NAME(schema_id) AS SchemaName, name as TableName FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE';```

Explain trigger and trigger types?

1 Answers  

---

Define ACID properties in a Database?

1 Answers   iNautix,

---

How to avoid cursors?

3 Answers   CarrizalSoft Technologies, HP,

---

How do you manipulate data?

1 Answers  

---

Explain error handling in ssis?

1 Answers  

---

What are various aggregate functions that are available?

1 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---

How to tune a stored procedure?

6 Answers  

---

How can a user-defined datatype be created?

1 Answers  

---

Explain left outer join and right outer join?

1 Answers  

---

Differentiate between ms sql server reporting services vs crystal reports?

1 Answers  

---

Explain log shipping?

1 Answers  

---