Check the SQL Browser service and make sure it is running. This is required to be running when you have a named instance.

If you don't want the SQL Browser...

Your database are set to full recovery and require frequent transaction log backups to clear the log file. If you don't need to be in full recovery model, switch...

You were really close, review the following:

select dateadd(quarter, datediff(quarter, 0, getdate()) - 0, 0)

,dateadd(quarter, datediff(quarter, 0, getdate()) - 1, 0)

...

Verify the connection strings for the web application are using the SQL Server Virtual IP. My guess is that they are connecting directly to the node itself.

a_sood (7/31/2008)

---

Hi Greg,

I have a customer who is currently running WIndows Server 2003 Standard with SQL 200 Std and is haveing memory issue. He is planning to upgrade to Windows...

Glad I could help and you are up and running. The SQL Browser is required when you have named instances to identify the dynamic port that instance is running...

Matthew O'Gorman (7/30/2008)

---

Cheers everyone, I have shrunk the log successfully by running the log backup, then the shrinkfile several times over until the shrink worked without error, as suggested on...

Angelindiego (7/30/2008)

---

BOL is very unclear about being able to do weird stuff with a case in this case (no pun intended) being able to do a select within the case....

Are you trying to create this from the designer, or from a query window. If from the designer - yes, you will get a timeout.

To avoid the timeout -...

GSquared (7/30/2008)

---

I just found something quite interesting on this question.

I hadn't realized that BOL says, "EXCEPT returns any distinct values from the left query that are not also found on...

Is the SQL Browser service running on the server? If not, try starting it and see if you can connect.

Angelindiego (7/30/2008)

---

no dynamic SQL...

what I need is data that I am pulling straight from the table and then based on 2 parameters data about the location. they will pass...

Just a WAG - but have you tried cycling SQL Server Agent? If not, try that and see if it has any affect.

The drop-down does not automatically search the network (or your local system) for all SQL Servers that are available. You can either select the browse for more option -...

First, shrinking the database and/or the transaction log is a bad idea. Performing this nightly is even worse, as it is going to cause file level fragmentation and will...