Describe how to use linked server?

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,

---

Why olap is used?

0 Answers  

---

How to replace given values with null using nullif()?

0 Answers  

---

How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,

---

Without Using Cursors , How to Select the Selected row??

3 Answers   CarrizalSoft Technologies, Wipro,

---

Differentiate between truncate vs delete in mssql?

0 Answers  

---

how many types of store procedre in sqlserver 2000?

2 Answers   ATI,

---

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

---

what is advantages in sql 2005 over sql 2000?

4 Answers  

---

Explain about thread and memory management process of SQL?

0 Answers  

---

How except clause is differs from not in clause?

0 Answers  

---