No, when I run my original query it returns 37 rows, when I also run this query to get database sizes it returns no rows: 

SELECT  sys.databases.name, ...

Thanks - I'd played with my original query and seemed to get what I wanted, thought I'd tried this last week and it didn't work: 

SELECT...

jswong05 (10/21/2015)

---

However, the bulk-logged recovery model increases the risk of data loss for these bulk-copy operations, because bulk logging operations prevents recapturing changes on a transaction-by-transaction basis. If a log...

Erland Sommarskog (9/16/2013)

---

That is exactly what you use the syntax graphs in Books Online for.

But...

Where exactly would I...

GilaMonster (9/11/2013)

---

The way I usually recommend is to use impersonation on the trigger.

CREATE TRIGGER ...

WITH EXECUTE AS ....

And execute it as a login that has insert permissions into that audit...

Erland Sommarskog (9/11/2013)

---

The reason that it does not work is that the plain user does not have access to that other database. You could achieve this by enabling the guest...

Thanks - well I found an example of a script here[/url], and with a little editing to suit my needs this is what I have come up with so far:...

thanks for the replies - finally getting back to this task.

Basically what I want to do is find out who connected to a database, what date & time they...

Gianluca Sartori (1/4/2012)

---

Glenstr (1/3/2012)

---

I think Oracles alter database noarchivelog; basically does the same thing as putting an MSSQL database into simple recovery mode, it just has the database reuse the...

Thanks Gail - will do just that (read your earlier post), and yes you are right, at least a transaction log backup taken before putting into simple recovery mode, then...

Thanks for the prompt replies - that clears things up for what options I have anyway. I think Oracles alter database noarchivelog; basically does the same thing as putting...

Thanks all - great bunch of helpful people here - after unchecking all but db_owner it seems to be ok now. Still too used to Oracle, where everything is more...

Did that, and the roles are reflected in the database user properties - but everything is checked in the owned schema's area, and greyed out so I can't change them...