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...

tipkul (4/27/2008)

---

I'm learning to create partition from sql 2005 but i got and error Msg7736, level 16 and it say "Partition function can only be created in Enterprise edition of...

ChrisMoix (4/24/2008)

---

I still have Selurbium stuck in my head from a High School pop quiz question of what element does Sb stand for. I know it isn't right, but it...