Viewing 15 posts - 646 through 660 (of 956 total)
Did you change your connection string to point to the named instance?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 23, 2008 at 8:14 am
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. ...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 23, 2008 at 8:13 am
Exchange is a SMTP based Mail Server. We use it with database mail at my job.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 23, 2008 at 8:06 am
You can find a complete list in the Books Online:
http://msdn.microsoft.com/en-us/library/ms178653(SQL.90).aspx
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 23, 2008 at 8:04 am
Define availability? You want to know if you can connect to it, if you can query it? Does blocking or excessive locking decrease availability?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 23, 2008 at 8:02 am
Did you install the JDBC drivers for SQL Server? This seems like more of a Websphere application setup problem than a SQL Server problem.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 23, 2008 at 8:01 am
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 23, 2008 at 7:59 am
You can try to use Reflector:
http://www.red-gate.com/products/reflector/
and the SQL2005Browser Addin
http://www.denisbauer.com/NETTools/SQL2005Browser.aspx
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 23, 2008 at 7:56 am
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....
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 22, 2008 at 8:16 pm
RBarryYoung (12/22/2008)
Threshold alarms built on performance metrics that are entirely situational, and even then need to be volume-scaled...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 22, 2008 at 7:20 pm
bitbucket (12/22/2008)
Please read what I consider to be an important post ... last message on page 2...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 22, 2008 at 6:32 pm
Jack Corbett (12/22/2008)
Michael Earl (12/22/2008)
Ok, what happened here?http://www.sqlservercentral.com/Forums/Topic624072-146-1.aspx
Someone trying to see if they could get on this thread?
Does that mean they won the $100? If that was their goal,...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 22, 2008 at 6:29 pm
DavidB (12/22/2008)
This is a pattern puzzle. First one to get the answer will be awarded $100 by sqlservercentral. Right Steve?
That is an interesting thought......
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 22, 2008 at 6:28 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 22, 2008 at 6:24 pm
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.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 22, 2008 at 6:20 pm
Viewing 15 posts - 646 through 660 (of 956 total)