Check our collection of quick technical tips.
Here’s a quick T-SQL tip on getting the paths for all database files in a SQL Server instance. The T-SQL Tip You can get the list of paths for all database files (both data and log files) using the undocumented SQL Server stored procedure sp_MSforeachdb. You can use the below T-SQL statement: exec sp_MSforeachdb @command1=”USE … Read more…
In this article, we will be discussing about the following error message in SQL Server and how to easily resolve it: Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed… About this Error Message If you ever encounter issues when trying to create, add, or edit steps for a … Read more…
In this article, we will be discussing about how to rename logins in SQL Server. A Scenario Where You Might Need to Rename a Login in SQL Server When a Database Administrator creates Windows Logins in SQL Server, the format of these logins is: [Domain or Server Name]\[Windows Username] [Domain] can also be the … Read more…
In this article, we will be discussing about the proper way for closing a C# application (including hidden forms). C# Applications with Multiple Forms There are many times when we develop C# applications, where we make use of several forms. To this end, there are times that we are using the Hide() method for … Read more…