Oct 25, 2011 · 801 If you are using SQL Server Management Studio (SSMS), instead of running a query (which in my case returned duplicate rows) you can run a standard report. Right click on the …

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 there is another …

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 "Restoring" …

Apr 2, 2023 · An instance of SQL Managed Instance is similar to an instance of the Microsoft SQL Server database engine offering shared resources for databases and additional instance-scoped …

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 with a ...

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 LogFilesSize

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 …

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.

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" database is …

Jul 13, 2017 · Is there any way or tool in SQL Server 2016 to find a column in the entire database based on the name? Example: find ProductNumber and it shows you all the table(s) that have it