Answer Posted / padmapriya

1.sql server 2005 include interprise manger and query
analyser together in same window we can open many window
tabs in same place but in 2000 it is in different.
2. sql server 2005 support more new datatype like xml
3. we can make more database 2(paw(20))-1 in 2005 in compare
to 2000 where not possible so much database
4. in storeprocedure we can write try catch statemenet in
2005 not in 2000

How to execute stored procedure in select statement sql server?

1106

---

Is mysql better than sql server?

1102

---

Can I use sql azure as a backup with log shipping or database mirroring?

156

---

How to connect sql server management studio express to sql server 2005 express?

1090

---

what is normalization? Explain different levels of normalization? : Sql server database administration

1404

---

What is the purpose of update statistics and scope_identity() function?

1152

---

What is filtered index?

1142

---

What is identity?

1080

---

What are the ways available in sql server to execute sql statements?

1202

---

Explain system scalar functions?

1042

---

What are the differences between ms sql server & oracle?

1107

---

What are the essential components of sql server service broker?

1065

---

What is difference between inner join and full join?

1106

---

How to perform backup for certificates in sql server? : sql server security

1141

---

explain the storage models of olap? : Sql server database administration

1008

---