Have a look on this:
https://blog.sqlauthority.com/2007/03/28/sql-server-fix-error-8101-an-explicit-value-for-the-identity-column-in-table-can-only-be-specified-when-a-column-list-is-used-and-identity_insert-is-on/

DBCC CHECKDB command is the main command to detect the inconsistency in the database. It is an amalgamation of other DBCC CHECKDB command, CHECK CATALOG, CHECKALLOC and DBCC CHECKTABLE. Running...

This may help you out:
https://www.mssqltips.com/sqlservertip/5567/sql-server-service-broker-error-receiving-data--10054-an-existing-connection-was-forcibly-closed-by-the-remote-host/

You can track tempdb usage by three DMVs command:

• sys.dm_db_task_space_usage
• sys.dm_db_session_space_usage
• sys.dm_db_file_space_usage

October 11, 2018 at 7:14 am

#2009091

Here is how can you reduce database log file. Shrink the database log file according to the recovery model:
https://www.mssqltips.com/sqlservertutorial/3311/how-to-shrink-the-transaction-log/

Here is the query to find all the queries in SQL Server
SELECT dest.TEXT AS [Query],
deqs.execution_count [Count],
deqs.last_execution_time AS [Time]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS...

You can migrate your SQL Server database from one Server to another by various methods. Copy Database Wizard, Generate script, by Backup & Restore,
http://www.technologycrowds.com/2018/10/import-sql-server-database-to-another-server.html

Here is the step by step procedure to migrate SQL Server 2014 to 2014. Go through it:
https://www.virtualizationhowto.com/2017/03/how-to-upgrade-sql-server-2014-to-sql-server-2016/

SQL Error 8101 occurs when user has attempted to insert a row containing a specific identity value into a table that contains an identity column. See this, this will help...