If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

---

How do I delete a sql server database?

0 Answers  

---

Write a SQL query to delete a table?

0 Answers   Amdocs,

---

What is an index. What are the types?

0 Answers  

---

What is the need for indexing?

0 Answers  

---

---

Explain why variables called the most powerful component of ssis?

0 Answers  

---

Explain syntax for viewing, dropping and disabling triggers?

0 Answers  

---

How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes

1 Answers   INDUS,

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  

---

Do you know what is sql injection?

0 Answers  

---

What is log cache in sql server?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---