Answer / Mintoo Singh

Restoring a Visual SourceSafe database from a suspect state can be challenging and may require professional assistance. Here are some general steps that might help:
1. Close all clients connected to the server.
2. On the server, navigate to the 'VssAdmin' folder in the Visual SourceSafe installation directory.
3. Run 'vssadmin repairdb' command followed by the database name.
4. If the repair fails, you may need to rebuild the database using backup files. Consult Microsoft support for further assistance.

What are the advantages of using stored procedures?

1 Answers  

---

What do you mean by sql server 2005 express management tools?

1 Answers  

---

What is data source view or dsv? : sql server analysis services, ssas

1 Answers  

---

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

---

How to view the error log for any specific instance? : sql server database administration

1 Answers  

---

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

---

Do you know what are different types of replication in sql server?

1 Answers  

---

Can we shrink data file in sql server?

0 Answers  

---

Do you know how to send email from database?

1 Answers  

---

how to generate XML out of QUERY?

1 Answers   McAfee,

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

Do you have any idea about the tcl commands?

1 Answers  

---