Answer Posted / yogesh

Start Menu\Programs\Microsoft SQL Server 2005\Performance
Tools\SQL Server Profiler\newtrace

Can primary key be null?

674

---

How to write character string constants or literals in ms sql server?

747

---

How to how to convert numeric expression data types using the convert() function??

717

---

How to create sub reports?

210

---

Define outer join in sql server joins?

668

---

---

what authentication modes does sql server support? : Sql server database administration

705

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

833

---

what is database replication? : Sql server database administration

706

---

What are the differences between stored procedure and the dynamic sql?

759

---

How to send email from database?

752

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

828

---

What do you understand by mirroring and mention the advantages of the mirroring?

787

---

What do you mean by 'normalization'?

779

---

How are the exceptions handled in sql server programming?

753

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

696

---