SQL Server query to import database names

by
Roman Rehak

Discover a query that will import all database names into your SQL Server.

I want to import all database names into my SQL Server using a query. How can I do this?

Use the following SQL Server query:

SQL Server 2000: SELECT * FROM master.dbo. sysdatabases
SQL Server 2005: SELECT * FROM master.sys.databases

Step 2 of 2:

This was first published in February 2008

Dig Deeper on SQL Server Stored Procedures

All
News
Get Started
Manage
Problem Solve

PRO+

Content

Find more PRO+ content and other member only offers, here.

E-Handbook

Shining a light on SQL Server storage tactics

Related Q&A; from Roman Rehak

Tips for tuning SQL Server 2005 to improve reporting performance

There are a few things you can do to tune SQL Server for improved reporting performance. Here are some generic and Reporting Services-specific ...continue reading

Storing and searching for image files in SQL Server

Learn about working with image files in SQL Server, including advice on using queries to locate them, in this expert answer.continue reading

Can I encrypt and restore a database backup in SQL Server 2005?

Discover the best solutions for encrypting, decrypting and restoring a database in SQL Server 2005.continue reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Sellpoints sold on using Spark SQL for big data ETL jobs

To help companies target ads to website users, Sellpoints Inc. relies on the Spark processing engine -- including its Spark SQL ...

Smart grid technology cuts out guesswork at Arizona utility

Public utilities are increasingly turning to smart grids and advanced analytics techniques to help manage their operations. ...

Open source not best bet for all business analytics projects

Many enterprises today are building their business analytics programs around open source tools, but one software company took a ...

SearchDataCenter

Software-defined applications and infrastructure explained

The inner mechanics of today's software-defined applications and infrastructure reveal an interconnected web of isolated ...

New hyper-convergence entrants seek a spot in enterprise IT

Hyper-convergence can simplify IT operations by bringing together compute, storage and networking hardware with virtualization ...

SQL innovator journeys into the database future

Jim Starkey, who developed some of the earliest incarnations of the relational database, reveals a vision of the database future ...

SearchDataManagement

Big data platforms pose structural issues for new users

Big data systems require the same kind of data partitioning and setup steps as conventional ones do. But first, users have to ...

Social media startup uses NoSQL Redis Cloud to 'scale to infinity'

Because of growing data demands, and the need to nimbly scale up and down, a startup social networking platform chose a Redis ...

Q&A;: Dinsmore sees open source Apache Spark moving to new stage

Analytics vet Thomas Dinsmore says Apache Spark is entering a new phase of adoption, one in which hype gives way to clearer ...

SearchAWS

SQS queue workarounds for AWS Lambda functions

AWS Lambda integrates with many services under the AWS umbrella -- but not with Simple Queue Service. There are several bypasses ...

AWS Snowball slings hunks of data back to your data center

AWS Snowball is now a two-way street, as customers can move large data sets in and out of the cloud with the plug-in appliance.

Manage services with Amazon DynamoDB database tool

Amazon DynamoDB manages database administration tasks, freeing up time for developers to write code for independent distributed ...

SearchOracle

Big Data Discovery may put Oracle back in BI Magic Quadrant

Oracle didn't make it onto Gartner's 2016 BI Magic Quadrant, but analyst Josh Parenteau says new products like Big Data Discovery...

Oracle cloud customers link vendor support, cloud adoption

Rebecca Wettemann, vice president of Nucleus Research, answers questions on cloud adoption, third-party support and how that ...

The link between third-party vendor support and the cloud

In this question and answer session, Nucleus Research Vice President Rebecca Wettemann explains the current trends in third-party...

SearchContentManagement

Context-aware technology draws customers closer, but not too close

Companies must tread a fine line with context-aware content: They must demonstrate that they know their customers, and be able to...

Five tips for a foolproof content security policy

Content security policies that are too restrictive are destined to fail. These surefire tips will help you secure documents ...

How cloud ECM can help reshape the digital workplace

Enterprises are using cloud ECM features to augment existing business practices -- but it's also important to re-evaluate the big...

SearchWindowsServer

Enlist Windows SFC and DISM tools to fix server OS problems

Administrators can diagnose and treat a buggy server operating system by using the Windows DISM and SFC utilities for image ...

Microsoft Nano Server: Small footprint adds savings, security

Organizations that reduce their server footprint can reduce costs and improve performance by running only the most necessary ...

How Host Guardian secures Windows Server 2016 Hyper-V VMs

In an effort to get more workloads into the Azure cloud, Microsoft has developed a new system to protect data in Hyper-V VMs from...

Dig Deeper on SQL Server Stored Procedures

E-Handbook

Related Q&A; from Roman Rehak

Have a question for an expert?

0 comments

E-Mail

Username / Password

Password

Forgot Password?

Your password has been sent to: