Answer Posted / rajkumar v

select convert( varchar(20), getdate(), 103)

Do you know how to send email from database?

1045

---

What is BCP? When does it used in sql server 2012?

1102

---

what are the different types of replication you can set up in sql server? : Sql server database administration

1058

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

931

---

Tell about MOM Tool(Microsoft Operator Manager)?

1957

---

How exceptions can be handled in sql server programming?

1068

---

What is cte (common table expression)?

1080

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1210

---

Which autogrowth database setting is good?

1091

---

What are the different types of sql server replication? : sql server replication

1360

---

How many levels of sp nesting is possible?

1099

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2078

---

How can we use ConnectorJ JDBC Driver with MS SQL?

1050

---

What is catalog views?

1115

---

What gets stored inside msdb database?

1305

---