In database properties there is in General property Name and Owner. I’m trying to get that with SQL Query. Is it possible?

With this query I got name of objects in database, and schema name (is it sys or dbo).

SELECT sys.objects.name, sys.schemas.name AS schema_name

FROM sys.objects

INNER JOIN sys.schemas ON sys.objects.schema_id = sys.schemas.schema_id

But how can I get the name of developer who create that object?

---

Nensy V.

Hi Nensy V_,

The sql script below shows how to get the name and the owner of the current database:
--Get the name of the current database.

select DB_NAME() as dbName;

--Get the owner of the current database.

select SUSER_SNAME(owner_sid) as dbOwner from sys.databases where name=DB_NAME();

Let me know if this does not help.
Aland Li

---

Please mark the replies as answers if they help and unmark if they don't. This can be beneficial to other community members reading the thread.

Hi Nensy V_,

The sql script below shows how to get the name and the owner of the current database:
--Get the name of the current database.

select DB_NAME() as dbName;

--Get the owner of the current database.

select SUSER_SNAME(owner_sid) as dbOwner from sys.databases where name=DB_NAME();

Let me know if this does not help.
Aland Li

---

Please mark the replies as answers if they help and unmark if they don't. This can be beneficial to other community members reading the thread.