Query to find SQL Server database names created by users

Home
Topics
Microsoft SQL Server Database Development
SQL Server Database Modeling and Design
Query to find SQL Server database names created by users

Query to find SQL Server database names created by users

Can you give me a query to get all the database names (created by users) of one SQL Server?

Requires Free Membership to View

Login

When you register, you’ll also receive targeted emails from my team of award-winning editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by today's SQL Server database pros.

Hannah Smalltree, Editorial Director

By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

You can query the sys.databases view or the sysdatabases compatibility view.

Dig Deeper

People who read this also read...
Related tags
- created
- database
- find
- get
- name
- query
- server
- sql
- user

Related glossary terms

Terms for Whatis.com - the technology online dictionary

Show me more

This was first published in December 2007

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Data discovery vendors cast spell in Gartner Magic Quadrant for BI
  
  Business users turn to data discovery vendors like Tibco, Tableau and QlikTech for easy-to-use and easy-to-deploy analytics tools, much to the chagrin of IT, according to Gartner.
- TDWI conference takes fresh look at BI dashboards, scorecards
  
  From the TDWI World Conference Series, business intelligence expert Cindi Howson talks about BI dashboards and scorecards -- from basic definitions to newer innovations.
- 'Big data' analytics projects easier said than done -- but doable
  
  Putting an effective "big data" analytics plan in place can be a challenging proposition. Consultant Lyndsay Wise offers her advice on what to consider and how to get started.
Data Center
- Dell packs more DIMMs, disk drives into new PowerEdge 12G
  
  New Dell PowerEdge 12G servers give customers more memory and disk capacity for virtualization along with management software updates.
- IT pros rethink data center infrastructure to support 'big data'
  
  "Big data" analytics isn’t just for Web 2.0 anymore. Here’s how IT pros at some well-known companies manage big data infrastructure.
- Converting CPU hours to MIPS: Mainframe capacity planning process
  
  In this expert tip, learn how to convert CPU hours to MIPS to aid in mainframe capacity planning.
Data Management
- Loggly CEO: Log data management takes on 'the original big data'
  
  Former Splunk Inc. executive Kord Campbell talks about his new company, Loggly Inc., a cloud-based search engine for machine-generated data.
- Gartner Magic Quadrant names Teradata the top data warehouse vendor
  
  Teradata is the overall leader among data warehouse software vendors, followed by Oracle, IBM and three others, says a Gartner Magic Quadrant report.
- Appliances increasingly finding homes in data warehouse architectures
  
  A growing number of companies are adopting data warehouse appliances, mostly to supplement existing systems. But some have gone all in on appliances.
DataManagement UK
- From the Editors: Black gold, mobile BI, stemming youth unemployment
  
  Predictive analytics is helping global oil industries and local youth charities alike, but Gartner has its own prediction of the role of mobile BI in 2012.
- Predictive analytics used to cut costs in oil sector
  
  Predictive analytics is being used in the oil and gas industry to better manage asset maintenance on capital equipment. And a more enterprisewide adoption of the technology is predicted.
- Medway Youth Trust wins Gartner BI excellence award for text analytics
  
  Medway Youth Trust has won a Gartner Business Intelligence Excellence award for its use of text analytics to identify young people at risk of becoming NEET -- not in employment, education or training.
Oracle
- Partitioning and Oracle licenses
  
  One reader asks expert Scott Rosenberg from Miro Consulting about partitioning Oracle software licenses.
- Oracle Exalytics helps in-memory become a commodity
  
  Oracle Exalytics, the company’s in-memory BI server appliance, became generally available on Monday. One expert expects in-memory’s speedy processing to eventually become a commodity.
- Oracle outlines Taleo roadmap, calls acquisition ‘additive’
  
  Despite some product overlap, Oracle maintains its acquisition of Taleo is complementary and will not have an impact on its Fusion roadmap. One analyst is not convinced.
Content Management
- Health care firm drives progress with SharePoint 2010 implementation
  
  A comprehensive enterprise SharePoint 2010 implementation is expected to help one health care consultancy more effectively advise clients and deliver new drugs and medical tools to the market.
- Mobile Web content management strategy poses multiple-choice dilemma
  
  Successful mobile Web content management begins with a solid understanding of the factors involved in building a website easily displayed on different devices, according to designer Graeme Blackwood.
- SpringCM addresses mobile content management, cloud security issues
  
  SpringCM’s Roger Bottum discusses mobile content management, cloud security issues and user engagement as it applies to mobile business.
Windows Server
- Quiz: How well do you know Windows Server 8?
  
  Windows Server 8, the pre-release operating system from Microsoft, has a bunch of new features. But how well do you know them?
- How MAP Toolkit 6.5 can put you on the right migration path
  
  The latest edition of the Microsoft Assessment and Planning Toolkit offers expanded features to ease local and cloud-based migrations.
- Using Microsoft PerfView to profile process performance data
  
  Microsoft made its internal performance monitoring tool available to the public. Here's how it offers an advanced peek at application processes.

All Rights Reserved, Copyright 2005 - 2012, TechTarget