Answer / Naveen Dev Verma

Sybase provides the sp_procoption system stored procedure to set options for stored procedures. One of these options is 'capture startup' which allows you to capture the SQL used to start a stored procedure. Here's an example:
EXECUTE sp_procoption proc_name, 'capture startup', 'true'

What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

1 Answers  

---

What is server replication?

1 Answers  

---

How do I correct time slice -201?

1 Answers  

---

Explain locking?

1 Answers  

---

What is ceiling()?

1 Answers  

---

Explain about sybase 365?

1 Answers  

---

How do you use workspace in sybase?

1 Answers  

---

What happen when we delete the table using trigger?

1 Answers  

---

What does –i option do in sybase tools?

1 Answers  

---

What is cis and how can I use it?

1 Answers  

---

How do you troubleshoot if your tempdb gets filled

13 Answers   HCL,

---

What is table partitioning in sybase?

1 Answers  

---