Answer Posted / raju

yes
usig
exec <procname> <paramiter list>

Where do you find the default Index fill factor and how to change it?

1056

---

Explain sql server service broker?

968

---

How to create a ddl trigger using "create trigger" statements?

1116

---

What is sleeping status in sql server?

1018

---

What are orphan records?

924

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1194

---

What happens to a trigger with multiple affected rows?

933

---

How to list all tables in the database using odbc_tables()?

1037

---

How to create sub reports?

242

---

How to find related tables in sql server?

926

---

What is parameterized reports in ssrs ?

149

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1074

---

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

980

---

What is log cache in sql server?

1027

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2331

---