DATABASEPROPERTYEX function in SQL Server

home » blogs » Did You Know Did You Know » DATABASEPROPERTYEX function in SQL Server

DATABASEPROPERTYEX function in SQL Server

change text size: A A A

Comments (0)
Print
Rating: 0/5 0 Votes

posted 10/1/2011 4:22:37 AM by Did You Know Did You Know - Views: [1132]

Did you know that apart from system catalogs, you can also use System Functions like DATABASEPROPERTYEX to extract metadata about a database.

For example to find out whether AutoShrink is ON or OFF, you can use the function this way:

SELECT DATABASEPROPERTYEX ('AdventureWorks','IsAutoShrink')

The function takes in the name of the database and the property name: another example; to find out the status of the database, you can use the function this way:

SELECT DATABASEPROPERTYEX ('AdventureWorks','Status')

Regards
Did-You-Know from SQLServerGeeks.com

Rate This Blog Entry: register or login

Author

Did You Know Did You Know (Member since: 7/22/2011 4:47:27 PM)

View Did You Know Did You Know 's profile

Comments (no comments yet)

Email Subscriptions

Get the Most Recent Blogs in your inbox

Did You Know Did You Know's latest blog posts

SQL Server 2008 R2 (sp1) & SQL Server 2008 (sp3) Feature Packs

4/23/2012 9:30:33 AM by Did You Know Did You Know - Views: 212 - Comments: 0

Hi SQL Geeks, if you are looking for SQL Server 2012 feature pack; we blogged about it here: http://www.sqlservergeeks.com/blogs/QuickTip/sql-server-bi/523/sql-server-2012-feature-pack But if you are ...
IDC WHITE PAPER - Microsoft SQL Server 2012: Potential Game Changer

2/14/2012 10:34:46 AM by Did You Know Did You Know - Views: 595 - Comments: 0

IDC WHITE PAPER - Microsoft SQL Server 2012: Potential Game Changer Hi Friends, The launch of SQL Server 2012 has revealed a major new release with many feature enhancements as well as a new software ...
SQL Server: Microsoft earns Leader ranking in two Gartner 2012 Magic Quadrants

2/13/2012 1:08:30 PM by Did You Know Did You Know - Views: 950 - Comments: 0

Microsoft earns Leader ranking in two Gartner 2012 Magic Quadrants Hi Friends, Microsoft has earned the Leader ranking in two Gartner 2012 Magic Quadrants, they are: • Business Intelligence Platf...
SQL Server: Execute Package Task - ExecuteOutOfProcess

10/31/2011 9:49:33 AM by Did You Know Did You Know - Views: 1766 - Comments: 0

Many times we use “Execute Package Task” to execute a child package from a parent/wrapper package and we use “Parent Package Variables” as means of configuration for child pack...
SQL Server: The file growth setting is incorrect after you restore a database from SQL Server 2000 in SQL Server 2005

10/31/2011 9:33:41 AM by Did You Know Did You Know - Views: 851 - Comments: 0

This is documented in Microsoft KB article 958004. When you restore a database from 2000 version of SQL Server to ver 2005 (specific builds being SQL Server 2005 build 2191 or later builds of SQL Serv...
SQL Server 2008 R2 & SQL Server 2008 side by side

10/21/2011 11:44:17 AM by Did You Know Did You Know - Views: 1221 - Comments: 0

Many of you know that SQL Server 2008 R2 can be installed side-by-side with SQL Server 2008. SQL Server 2008 R2 is a minor release. Since both the versions share the same major version, R2 installatio...
SQL Server Denali CTP3 Demo VHD

10/20/2011 7:03:08 AM by Did You Know Did You Know - Views: 1327 - Comments: 0

Want to try out Denali (SQL Server 2012) without installing it? A HyperV image of SQL Server Denali CTP3 in action, including fully configured services and integration with SharePoint 2010 and Office ...
SQL Server service can listen on multiple ports

10/7/2011 5:00:45 AM by Did You Know Did You Know - Views: 1280 - Comments: 0

The default instance, by default, listens on port 1433. SQL Server can listen on multiple ports on the same IP address. For this you can list the ports separated by commas. For example: 1433,1533,1633...
DATABASEPROPERTYEX function in SQL Server

10/1/2011 4:22:37 AM by Did You Know Did You Know - Views: 1133 - Comments: 0

Did you know that apart from system catalogs, you can also use System Functions like DATABASEPROPERTYEX to extract metadata about a database. For example to find out whether AutoShrink is ON or OFF, y...
INFORMATION SCHEMA VIEWS in SQL Server

9/30/2011 5:39:45 PM by Did You Know Did You Know - Views: 875 - Comments: 1

Did you know that INFORMATION SCHEMA VIEWS are one of many ways in which you can view SQL Server metadata. INFORMATION SCHEMA VIEWS are included in SQL Server to comply with ISO & ANSI standards. ...
Data Mining was first shipped with SQL Server 2000

8/8/2011 9:50:44 AM by Did You Know Did You Know - Views: 1216 - Comments: 0

Did you know that Data Mining platform on SQL Server was first released with SQL Server 2000. There were only 2 algorithms at that time. Since the release of SQL Server 2005, there are 9 built-in algo...

Latest community blog posts

SQL Server Analysis Services - Setting the Default Measure for the cube

5/17/2012 9:38:28 AM by Amit Bansal - Views: 372 - Comments: 0

Hi Friends, This is indeed so basic and simple and I got surprised when I observed during one of my assignments that the customer has not set a default measure for the cube; they just did not know abo...

SQLServerGeeks.com bi-weekly webcast – 16 May 2012 at 11:30 a.m. IST

5/14/2012 5:27:36 AM by Admin Admin - Views: 86 - Comments: 0

Dear SQL Geek, Hope you are doing well. Continuing the success, here is the next bi - weekly webcast, absolutely free for the SQL Server community. It is your opportunity to hear a specialist and this...

SQL Server 2012 - Determining the size of a Columnstore index

5/11/2012 9:41:45 AM by Amit Bansal - Views: 943 - Comments: 0

Hi Friends, By this time, many of you already know about columnstore indexes, a column store architecture that groups and stores data for each column on separate pages and then joins all the columns t...

SQL Server - My experience as a SPEAKER - SQLBits 10 March 2012

5/11/2012 9:37:12 AM by Amit Bansal - Views: 496 - Comments: 0

Hi Friends, Speaking at SQL Server conferences is something that I cherish a lot, even more when it is outside my home country, India. It is indeed a privilege to interact with global audience and sha...

SQL Server : Clustered Index Physically Orders a Table Revisited

5/8/2012 9:46:47 AM by Ahmad Osama - Views: 4051 - Comments: 6

Hi Friends, Continuing on from my last blog post “SQL Server: Clustered Index Physically Orders a table”, this post demystifies the myth “Clustered index physically a table”. T...

Installing SQL Server 32 bit on 64 bit Operating System

5/7/2012 9:14:49 AM by Amit Bansal - Views: 975 - Comments: 3

Hi Friends, Today I got a question on “can you install SQL Server 32 bit on 64 bit OS?” Answer: Yes, you can ! During setup, click on the Options link and select the architecture (64 bit o...

Analysis Services IgnoreUnrelatedDimensions property in Dimensions Usage Tab

5/2/2012 5:20:04 AM by Amit Bansal - Views: 606 - Comments: 0

Hi Friends, Look at this scenario: When I try to slice Reseller Sales measure group by Geography dimension, I get the following output: Rightly so, because the Geography dimension is not related to th...

SQL Server Day in Gurgaon in May 05’ 2012

4/30/2012 5:05:54 AM by Admin Admin - Views: 280 - Comments: 0

Dear SQL Geek, SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And after successful events in Bangalore, Kolkata & Mumbai, we a...

Completed-Advanced SQL Server Database Administration & Performance Tuning - October 2011

4/28/2012 9:37:27 AM by Amit Bansal - Views: 352 - Comments: 0

Hi Friends, Today, while I write this blog, I am preparing to travel to Hyderabad for another assignment with Microsoft India Development Center. My last training blog post was here: http://www.sqlser...

Restoring a SQL Server Database: A Practical Example – An effective approach used to set up LogShipping.

4/26/2012 10:40:00 AM by Satnam Singh - Views: 1308 - Comments: 2

Scenario : A couple of days back, I was asked to setup a Disaster Recovery Strategy for one of the database located on my Production Server which was using SQL Server 2005 and Service Pack 3. This was...

SQLServerGeeks.com bi-weekly webcast – 27th April 2012 at 3 p.m. IST

4/26/2012 5:00:54 AM by Admin Admin - Views: 214 - Comments: 1

Hi SQL Geek, Continuing the success, here is the next bi - weekly webcast, absolutely free for the SQL Server community. It is your opportunity to hear a specialist and this time it is Amit Bansal pre...

Super Hit SQL Server Sessions in Bangalore, Mumbai and Kolkata

4/24/2012 7:29:03 AM by Sarabpreet Anand - Views: 338 - Comments: 1

Hi Friends, Attending SQL Server sessions in India was never been so easy and accessible at- least not for free, but now anyone can attend these sessions for free and easily while being in their own c...

SQL Server 2008 R2 (sp1) & SQL Server 2008 (sp3) Feature Packs

4/23/2012 9:30:33 AM by Did You Know Did You Know - Views: 212 - Comments: 0

Hi SQL Geeks, if you are looking for SQL Server 2012 feature pack; we blogged about it here: http://www.sqlservergeeks.com/blogs/QuickTip/sql-server-bi/523/sql-server-2012-feature-pack But if you are ...

SQL Server 2012 Feature Pack

4/23/2012 9:24:41 AM by Quick Tip - Views: 241 - Comments: 0

Hi SQL Geeks, The Microsoft® SQL Server® 2012 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2012. You can download the ...

SQL Server QUOTENAME function

4/23/2012 9:09:51 AM by Amit Bansal - Views: 1158 - Comments: 4

Hi Friends, Here is an interesting function: QUOTENAME() which returns a Unicode string with the delimiters added to make the input string a valid SQL Server delimited identifier. (from Books Online) ...

SQL Server – Are Inline Table-Valued Functions better than a View?

4/20/2012 6:41:09 PM by Piyush Bajaj - Views: 321 - Comments: 1

Hello Folks, You would be very much aware of the View in SQL Server. But do you really know about Inline Table-Valued Functions? Well you don’t have to worry further more on this, because I will...

SQL Server Index Internals Part 3 – Index union operations

4/18/2012 5:15:08 AM by Amit Bansal - Views: 994 - Comments: 4

Hi Friends, I am writing this blog on my way back from Great Indian Developer Summit where I presented 2 sessions and received great feedback on my session. I had started the Index Internals series so...

SQL Server Analysis Services - another known bugissue in 2008 R2 64 bit – function library showing blank

4/16/2012 8:13:41 AM by Amit Bansal - Views: 748 - Comments: 0

Hi Friends, Last week while working on an assignment in Analysis Services, I came across a strange behavior that trace output was not showing. One of the readers of my blog, Tejal, pointed out that it...

SQL Server 2012 - Speaking at Great Indian Developer Summit (GIDS) - April 2012

4/16/2012 7:58:39 AM by Amit Bansal - Views: 1056 - Comments: 0

Hi Friends, This is turning out to be a fantastic year of conferences and speaking engagements. And God & my well-wishers continue to bless & wish… I haven’t been luckier before. ...

SQL Server 2008 R2 Express Database size limit

4/12/2012 8:20:10 AM by Ravi Kumar - Views: 926 - Comments: 0

Hi All, It is a great news to all those who use SQL Server Express editions. Microsoft has increased the database size limit of SQL Server 2008 R2 Express edition from 4GB to 10GB. Previous versions o...

SQL Server Analysis Services - Trace output not showing while processing the cube

4/11/2012 9:49:14 AM by Amit Bansal - Views: 3969 - Comments: 2

Hi Friends, I got a query from one of our blog readers that while he was processing the cube, the trace output was not showing up in the ‘Process Progress’ window. Something like this: If ...

SQL Server – What is Scalar Function?

4/11/2012 7:04:48 AM by Piyush Bajaj - Views: 3239 - Comments: 2

Hello Friends, It’s been a while that I have posted any blog. So here it is- Well with the arrival of SQL Server 2000, Microsoft has introduced the concept of User Defined Function (UDF). So the...

SQL Server 2012 Released to Manufacturing

4/9/2012 11:41:31 AM by SQLnews SQLnews - Views: 325 - Comments: 0

Exciting news! SQL Server 2012 has released to manufacturing. Customers and partners can download an evaluation of the product today and can expect general availability to begin on April 1. Microsoft ...

Winners Announcement – Webcast Quiz - 15March 2012 Thurs-Index Tuning by Amit Bansal

4/7/2012 5:45:58 AM by Admin Admin - Views: 233 - Comments: 0

Hi Geeks, We thank all the attendees who participated in the webcast quiz - 15March 2012 Thurs–Amit Bansal by Amit Bansal. The quiz was hosted here: http://www.sqlservergeeks.com/forums/sqlserve...

SQL Server 2012 SEQUENCE Feature RTM restrictions and update

4/7/2012 4:40:14 AM by Amit Bansal - Views: 4085 - Comments: 0

Hi Friends, I had written a series of blog posts on the SEQUENCE feature in DENALI (now SQL Server 2012). You can browse them here: http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/346/sql...