sql server - Get size of all tables in database - Stack Overflow
Oct 25, 2011 · To use this for all tables at once: USE MyDatabase; GO sp_msforeachtable 'EXEC sp_spaceused [?]' GO You can also get disk usage from within the right-click Standard …
sql server - Database stuck in "Restoring" state - Stack Overflow
I had this situation restoring a database to an SQL Server 2005 Standard Edition instance using Symantec Backup Exec 11d. After the restore job completed the database remained in a …
How to fix Recovery Pending State in SQL Server Database?
Sep 14, 2018 · Rename the DB and the Log files (Database Properties -> Files) In the Object Explorer window in SQL Management Studio, refresh the 'Databases Folder', if you see that …
How do I search an SQL Server database for a string?
Dec 8, 2019 · I need to search an SQL Server database for all mentions of a specific string. For example, I would like to search all tables, views, functions, stored procedures, ... for string …
sql - How to find a string inside a entire database? - Stack Overflow
I have one specific string, such as "123abcd" for example but I don't know the name of the table or even the name of the column inside the table on my SQL Server Database. I want to find it …
SQL Server 2008: How to query all databases sizes?
I have MS SQL 2008 R2, 500 databases. What is the most efficient, easiest and 'modern' way to query all databases sizes. The output should have columns: DatabaseName DataFilesSize …
Query to list number of records in each table in a database
Sep 18, 2009 · 51 To get that information in SQL Management Studio, right-click on the database name, then select Reports --> Standard Reports --> Disk Usage by Table. This quickly …
Is there a limit size for a SQL Server database? - Stack Overflow
Nov 26, 2024 · A database is composed of files, which store the data. A database can grow as large as the memory available which stores it.
SQL Server: how do I export entire database? - Stack Overflow
I need to export database from one server and import it into another server. How do I export the entire database to a file, or two files mdf, ldf (either option is fine) How do I import it into a new
sql - Find out current database name (MSSQL) - Stack Overflow
Sep 15, 2022 · 7 With the MSSQL queries below, you can check the current database: SELECT DB_NAME() GO master In addition, if you don't specify a database on sqlcmd, "master" …