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 …

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

Sep 14, 2018 · One way to end up with a database that is in "Recovery Pending" state, is in the context of restoring a backup of an encrypted database (encrypted with TDE) on a new SQL Server instance.

Jul 31, 2018 · A database is composed of files, which store the data. A database can grow as large as the memory available which stores it.

Copied database.mdf and database_log.ldf from the above mentioned folder (SQL 2012), then transferred those 2 files to a new server with different version (SQL Express 2014) of SQL …

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 …

112 I'm looking at creating a basic ORM (purely for fun), and was wondering, is there a way to return the list of tables in a database and also the fields for every table?

Apr 20, 2009 · How do I get a list of all index & index columns in SQL Server 2005+? The closest I could get is: select s.name, t.name, i.name, c.name from sys.tables t inner join sys.schemas s on …

Aug 2, 2013 · There are already a lot of great answers here but it's worth mentioning a simple and quick way to get the SQL Server Database size with SQL Server Management Studio (SSMS) using a …

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