ERROR: Msg 2786, Level 16, State 1, Procedure sp_estimate_data_compression_savings, Line 20 The data type of substitution parameter 3 does not match the expected type …

  In some projects or scenarios, we need to move some databases between different SQL Server editions. For example, in some organizations, SQL Server Evaluation …

  With a single command: [crayon-673bcd66c2b1f017006441/] If you run this way, you will be opening this Trace Flag to Global, and even if your SQL …

  ERROR: Message Executed as user: DOMAIN\svc_SQLService. The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’. [SQLSTATE 42000] (Error 9002)  BACKUP DATABASE is …

  I was doing some security work to make a SQL Server production environment safer and ready for inspections. I had more than 900 SQL …

  ERROR: The database dbname is not accessible. (Object Explorer) EXPLANATION: Actually, I wouldn’t write an article for this error, but when I saw that …

  The answer to this question depends on the size of the database that you are running this command, the parameters you will use with …

  A colleague today said they received an error like this: Msg 2627, Level 14, State 1, Procedure SP_name, Line 33 Violation of PRIMARY KEY constraint …

  Interesting title, right? We may want to see the processes that are currently running, especially when there are problems. In these cases you can …

  How do you find out if a specific record in a particular table is in the Buffer pool / data cache or in the …