in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,

---

What is the difference between coalesce() & isnull()?

0 Answers  

---

How to provide login information for a new odbc dsn?

0 Answers  

---

How to make a column nullable?

0 Answers  

---

How do triggers work?

0 Answers  

---

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

Does view occupy space?

0 Answers  

---

What is the difference between dataadapter and datareader?

0 Answers  

---

What is the maximum row of a size?

0 Answers  

---

What are subquery and its properties?

0 Answers  

---

How you can find out if an index is useful to the optimizer?

0 Answers  

---

How to set the current database in ms sql server?

0 Answers  

---