Solutions

How to Copy Database Schemas without Data in SQL Server

Learn how to backup and restore database objects for a SQL Server databases, using DAC Package. When operating on a SQL Server database, there can be situations where you wish to copy a database in a given server to another server, with schema information only, and not the data. This can be done in multiple ways, a few of the basic ones include: Separate the script from the source database, and run it for a fresh, empty database, this can also be the target to copy the objects in source...

Read more »

How to Auto Send an Outlook Email Notification when a Specific Excel Worksheet Is Updated

Every time when you update a specific Excel worksheet, if you always need to send an email notification to specific recipients, you can utilize the method introduced in this article. Some users ask for a solution to let MS Excel automatically send an Outlook email notification to specific persons every time when they update a specific worksheet, in that they often forget to send such an email. Now, in the followings, we’ll guide how to achieve this function with VBA code. Auto Send an...

Read more »

How to Always Open Outlook Meetings with “Scheduling Assistant” Page

There are two pages available in Outlook appointment and meeting window. One is “Appointment” page, and the other one is “Scheduling Assistant" page. If you want to always open meetings with “Scheduling Assistant" page, you can refer to this article. When you access an appointment or meeting, the item window will open with the “Appointment” page. Maybe you have noticed that there is another page available. It’s “Scheduling Assistant” page. To be honest, the latter page is...

Read more »