Database Related

This saved my butt of having to search through almost 2000 tables for a value. DECLARE @SearchStr nvarchar(100) SET @SearchStr = ‘String to search here’ — Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved. — Purpose: To search all columns of all tables for a given search string — Written by: Narayana Vyas Kondreddi…

Source: MSSQL$MICROSOFT##WID Event ID: 28005 An exception occurred while enqueueing a message in the target queue. Error: 15517, State: 1. Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission. Download SQL Management Studio, run as admin, connect to…