MSSQL Query

MSSQL and TSQL Programming and TSQL Examples

Supply a Valid Database Name in SQL Server. To See Available Databases, Use Sys.Databases Error

by · Published · Updated

Supply a Valid Database Name in SQL Server To See Available Databases Use SysDatabases Error
Supply a Valid Database Name in SQL Server. To See Available Databases, Use Sys.Databases Error

Hello everyone. In this article, Supply a valid database name in SQL Server. I will give information about To see available databases, use sys.databases.

In SQL Server, you may encounter such an error in some cases.

You can solve this error by using the code below.

USE master;
ALTER DATABASE Old_Database_Name SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE Old_Database_Name MODIFY NAME = [New_Database_Name];
ALTER DATABASE Old_Database_Name SET MULTI_USER;

Good luck to everyone in business and life.

5 Views

Tags:

Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

You may also like...

Don`t copy text!