Category Archive: SQL Server

Oct 23

Resolved: Cannot alter user ‘dbo’

Resolved: Cannot alter user ‘dbo’ I was working on setting up a new Microsoft SQL Server 2016 instance and importing databases from the old server when I ran into this issue. During the import (Attach) process, I assigned the user the application uses to connect as dbo (The application requires dbo rights btw… just saying …

Continue reading »

Aug 20

SQL Server 2012: How to copy a database from one server to another using the Copy Database Wizard

SQL Server 2012: How to copy a database from one server to another using the Copy Database Wizard I was provisioning my SQL box when I found I didnĀ“t need an already provisioned Windows Server box I had used for Exchange 2013. Lazy enough I installed SQL Server 2012 on my already installed Windows box. …

Continue reading »

Oct 24

How to delete/drop all the tables from a SQL Server database

I’ve recently been working on a data migration and I constantly been needing to delete all the tables in the db and start over. After doing some research I came across this hidden stored procedure in SQL Server that allows you to delete each table in the database you are connected to. Use this extremely …

Continue reading »

Jun 15

MsSearch.exe

Short description: Microsoft Search Component for SQL and Exchange Servers Long description: A process that is used by SQL server and Exchange server for the creation on indexes to hasten search. On my server it looks like it consumes a lot of memory and I’ve read high CPU use is also likely specially if there …

Continue reading »