I wouldn't think you would need your msdb database to be in full recovery model. What are you doing that necessitates full recovery model for that database?

Taking out the parentesis arround the select statement fixed it.

Are you sure there aren't any stray characters in your query window? Might try copying the code to a fresh window to rule that out.

Are you sure it's not just the inner join that is tripping you up?

I would expect that query to not show any users that don't have a login to the...

Good question of the day...I totally fell for it!

I suppose you could modify the stored procedure that is used for the report to just ignore the server parameter passed into it, and return everything.

Might make for a big...

We currently use Idera here, and I have about the same opinion that you do. It's really nice when it works, but when it doesn't work you don't know...

Has anyone used Lumigent's Auditing software? Any comments on it?

Sounds like you have installed the database services, but not the client tools.

John Bates (5/27/2008)

---

In the 3 companies I've worked for, none had the Enterprise Edition.

It would be interesting to see a survey of the percentages of DBAs who have only Standard...

I'm sorry! I sent you SQL 2005 code.

Somebody verify this, but I think you can use the query below to accomplish that. It gives the the filegroup that the clustered index is on, which is where...

I thought it was a good question, even if I did get it wrong 🙂

OK. I tried the install again and it installed everything but SSIS. When I try to go back and install SSIS, I get:

"Failure setting securityrights on user...

dragos_sv (4/30/2008)

---

shouldn't it be a 'none of the above' option? 😛

if i did not miss something in the qod.... i think that in sql2005 the default listening port is 1434

should...