sp_who vs sp_who2

What is the difference between sp_who vs sp_who2 in SQL Server Instance?

When deciding whether to use sp_who or sp_who2, check the table below for a detailed comparison list. The main difference between the two commands is this: sp_who is documented and officially supported. sp_who2 is undocumented and therefore unsupported but commonly used. As you can see on the comparison table below, they both basically return the same...Continue reading

How to attach database without transaction log

How to attach database without transaction log files in SQL Server Instance

If you are trying to attach a database and you only have the database file (.mdf) and not the transaction log file (.ldf) the steps are fairly similar to what they were in my previous blog – How to attach database using different methods in SQL Server Instance. Just like when attaching a database with transaction log...Continue reading

attaching and detaching a mysql or SQL server database

How to attach database using different methods in SQL Server Instance

Today I needed to transfer one of our development databases to another development environment. I had two choices: I could make a full backup/restore and drop the database since we did not want the same database stay on both servers or I could use the detach/attach database method. In order to eliminate some steps I decided to...Continue reading

Scroll to top