Hey Jeff - you realize that the OP posted this yesterday (as Urgent) and has not replied back at all? Wonder how urgent it really was 😉

Sam Aaron Navaraj (12/11/2008)

---

Dear all,

My problem is similar but with differential backups on the LiteSpeed 2005 [Version 4.6.0.00303]

" [SQLSTATE 01000] (Message 1) SQL Server has returned a failure message...

First, let's verify what version of SQL Server you installed. Should be either Developer or Express - and if it is the Express version then you will need to...

At this point, I really could not say how to troubleshoot this problem. It appears (to me) that the DMI database does not reside in that instance of SQL...

I see no references to the DMI database - either starting up or shutting down. That would tell me that the database does not exist in that instance. ...

The section of the log that you have provided appears to be from when the service was shutdown (prior to the failover).

We would need to see the section of the...

Hint:

SELECT 333/334

,333.0/334.0;

I would bet anything that the instance name that you connected to when you setup your DSN was .\SQLEXPRESS and not just SQLEXPRESS.

In your attempt to connect using MS jdbc...

On the reindex task - what is the setting you put for 'Change free space per page percentage to:'?

Wow...

No, you need to convert to a string datatype (char, nchar, varchar, nvarchar). Since...

Jeff Moden (12/10/2008)

---

Garadin (12/10/2008)

---

Egad I hate those commas on the left.:hehe:

(I know I know, it makes it easier to comment out lines and such, but I still hate it)

I do...

Hi Pat - thanks for the feedback. Glad this worked well...

Jerry - that is definitely interesting. Did not know that it was introduced sometime after SP1.

I will give you a couple of hints:

1) You need to JOIN the table in your query

2) You will need to use a CASE expression to return the...