how to connect sybase to sql server 2005?.

1 Answers   ABC,

---

How to call stored procedure using http soap?

0 Answers  

---

When would you prefer to have a minimum number of indexes?

0 Answers  

---

please differentiate between delete and truncate?

0 Answers  

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

---

Can you explain the role of each service?

1 Answers  

---

How you can find out if an index is useful to the optimizer?

0 Answers  

---

What is an identity column in insert statements?

0 Answers  

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

0 Answers  

---

what stored procedure can you use to display the current processes? : Sql server administration

0 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,

---

Mention the uses of stored procedures.

0 Answers  

---