Which stored procedure will you be running to add a linked server?

1 Answers  

---

Which virtual table does a trigger use?

3 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

how we can use a database with php.

2 Answers   HCL, IT Solution,

---

---

Do you know what is rank function?

0 Answers  

---

How to create user defined functions with parameters?

0 Answers  

---

what are the different ways to return the rowcount of a table?

0 Answers   Microsoft,

---

How to get the definition of a trigger back?

0 Answers  

---

explain different types of constraints? : Sql server database administration

0 Answers  

---

Tell me about pre-defined functions of sql?

0 Answers   EXL,

---

How and why use sql server?

0 Answers  

---