Database States - SQL Server | Microsoft Learn
Nov 22, 2024 · Find out about various database states, such as ONLINE, OFFLINE, or SUSPECT. Learn how to verify the current state of a database.
sys.databases (Transact-SQL) - SQL Server | Microsoft Learn
Use the sys.databases view in the master database of the Azure SQL Database server where the new database is being created. After the database copy starts, you can query the …
Databases - SQL Server | Microsoft Learn
Nov 22, 2024 · Learn about database schemas, tables, filegroups, logins, and roles. See how you can use the SQL Server Management Studio tool to work with databases.
sys.dm_hadr_database_replica_states (Transact-SQL) - SQL Server
Mar 27, 2025 · This dynamic management view exposes state information on both the primary and secondary replicas. On a secondary replica, this view returns a row for every secondary …
Always On DB in recovery pending or suspect state - SQL Server
Apr 8, 2025 · This article describes the errors and limitations of an availability database in Microsoft SQL Server that's in a Recovery Pending or Suspect state and how to restore the …
Create a database - SQL Server | Microsoft Learn
Jul 22, 2024 · This article describes how to create a database in SQL Server by using SQL Server Management Studio or Transact-SQL. To create a database in Azure SQL Database using T …
GRANT Database Permissions (Transact-SQL) - SQL Server
Nov 22, 2024 · A database is a securable contained by the server that is its parent in the permissions hierarchy. The most specific and limited permissions that can be granted on a …
File States - SQL Server | Microsoft Learn
Apr 4, 2023 · In SQL Server, the state of a database file is maintained independently from the state of the database. A file is always in one specific state, such as ONLINE or OFFLINE.
Store ASP.NET SQL Server mode session state - ASP.NET
The following steps describe how to run the InstallSqlState.sql and the UninstallSqlState.sql script files to configure SQL Server mode session state management.
GRANT Server Permissions (Transact-SQL) - learn.microsoft.com
Combine with SELECT ALL USER SECURABLES or VIEW SERVER STATE to allow an auditing process to view all data or all database states on the instance of SQL Server.