SQL Code Snippets : Database Properties

List all the databases and their owners

select name as DatabaseName, suser_sname(owner_sid) as DBOwner
from sys.databases

Change database owner

sp_changedbowner ‘sa’

Get the compatibility level of a database

select compatibility_level
from sys.databases
where name = ‘DB_Name’

Get the database name

select db_name()

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s