Did you change your connection string to point to the named instance?

You can query the sys.databases view to get the status of the database:

select name, state_desc

from sys.databases

Now exactly how you go about this depends on what you are after. ...

Exchange is a SMTP based Mail Server. We use it with database mail at my job.

You can find a complete list in the Books Online:

http://msdn.microsoft.com/en-us/library/ms178653(SQL.90).aspx

Define availability? You want to know if you can connect to it, if you can query it? Does blocking or excessive locking decrease availability?

Did you install the JDBC drivers for SQL Server? This seems like more of a Websphere application setup problem than a SQL Server problem.

You can, but SQL 2008 is then running in a named instance. I prefer to keep it in the default instance unless it is intentionally going to be a...

You can try to use Reflector:

http://www.red-gate.com/products/reflector/

and the SQL2005Browser Addin

http://www.denisbauer.com/NETTools/SQL2005Browser.aspx

Look at the Setup Bootstrap folder and provide the output of the Summary.txt file. That should have the necessary details to try and help guide you towards a solution....

RBarryYoung (12/22/2008)

---

Oh, I know what it is Jonathan, but it's still flaky.

Threshold alarms built on performance metrics that are entirely situational, and even then need to be volume-scaled...

bitbucket (12/22/2008)

---

Best way I know of to broadcast this to frequenter users of this forum.

Please read what I consider to be an important post ... last message on page 2...

Does that mean they won the $100? If that was their goal,...

That is an interesting thought......

You shouldn't have had to install the named instance. You should have been able to migrate the default instance from Eval to Dev using the installer. This would...

At this point in the game, I would recommend that you install SQL Express SP3 and update to the latest service pack rather than just applying the GDI+ update.

http://www.microsoft.com/downloads/details.aspx?familyid=3181842A-4090-4431-ACDD-9A1C832E65A6&displaylang=en