Home » Blog » » Page 10

Henry Davidson

~ Modified: June 23rd, 2022 ~ ~ 10 Minutes Reading

Forum Replies Created

Viewing 20 posts - 181 through 200 (of 223 total)
  • Author
    Posts
  • Henry Davidson
    Moderator
    31 pts

    Do you have the browser service enabled?

    in reply to: How to remove identity in a column through query #2100 Score: 0
    Henry Davidson
    Moderator
    31 pts
    • Create a new column
    • alter table users add newusernum int;

    • Copy values over
    • update users set newusernum=usernum;

    • Drop the old column
    • alter table users drop column usernum;

    • Rename new column to the old column name
    • EXEC sp_RENAME 'users.newusernum' , 'usernum', 'COLUMN';

    in reply to: How to Recover Deleted Records from SQL Table? #2099 Score: 0
    Henry Davidson
    Moderator
    31 pts

    Thanks all for your help
    I have recovered my deleted records successfully by using SysTools SQL Recovery.

    Henry Davidson
    Moderator
    31 pts

    hi
    You can also do this using Exchange Admin Center. Just follow below steps:
    1) GO to Recipients and then Mailboxes in Exchange Admin Center.
    2) Select a mailbox for which you want to apply Email Forwarding and then click on Edit.
    3) Then click on Mailbox features on mailbox properties page.
    4) Now go to Mail Flow and select View Details to change settings of forwarding emails. You can also set maximum no of recipients here.
    5) Now check the Enable Forwarding Checkbox and then click on Browse.
    6) In Select Recipient, select a user whom you want to forward emails.
    7) If you want to keep a copy of forwarding mails in your mailbox too then check the checkbox Deliver message to both forwarding address and mailbox.

    Henry Davidson
    Moderator
    31 pts

    Hi Kerry,

    To check whether your Outlook and Windows have a Click-to-Run Installation or MSI installation: ●Go to the File tab in Outlook and click on Office Account.
    ●If there is Office Updates in the Product Information area, it means you’ve a Click-to-Run installation of Office 2016.
    ●If there is no any Office Updates in the Product Information, it means you’ve a MSI Installation of Office 2016.

    To know where to see the Office Updates. Find the following steps:

    Open your Outlook >> click on File >> click on Office Account >> click on Update Options >> there you’ll see Office Updates.

    Thanks & Regards,
    Henry

    in reply to: How to configure Yahoo mail into Outlook #2057 Score: 0
    Henry Davidson
    Moderator
    31 pts

    To Michael,

    Thanks for the reply and for posting such a nice article! I was doing the mistakes while filling in the details (especially the port number and encryption type) under the server information, I think the SSL port for POP3 has changed from 110 to 995.

    Hope the above article will help others having the same problem as me.

    Thank again!
    Henry

    Henry Davidson
    Moderator
    31 pts

    Hi Kerry,

    The reason behind this issue could be due to the above reason or it due to incorrect value data in the registry related to the Excel previewer. To resolve this issue, modify the registry key by following the below steps:

    ● Click Start>> type Run under the search box and hit the Enter key >> In the Run command box, type regedit and hit the Enter key or click OK

    ●Locate and select the registry key by following the below mentioned path as per the system requirement.

    For Click-to-run installation of Outlook and Windows, locate to this path:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Windows\CurrentVersion\PreviewHandlers

    For MSI installation of Outlook (32-bit) on Windows (32-bit) or Outlook (64-bit) on Windows (64-bit), locate to this path
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\PreviewHandlers

    For MSI installation of Outlook (32-bit) on Windows (64-bit), locate to this path:
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\PreviewHandlers

    ●After you’ve located to PreviewHandler, navigate to the variable of PreviewHandlers that is equal to “{00020827-0000-0000-C000-000000000046}”, and do the following:

    If it’s “Type” is not set asREG_SZ” then right click the variable “{00020827-0000-0000-C000-000000000046}” and click delete.

    If it’s “Type” is set asREG_SZ” then right click the variable “{00020827-0000-0000-C000-000000000046}” and click Modify.

    In the Value data, type Microsoft Excel previewer and click OK.
    Exit the Registry Editor.

    After following the above steps, start your Outlook and try to open attachment.

    Thanks & Regards
    Henry

    in reply to: How to configure Yahoo mail into Outlook #2052 Score: 0
    Henry Davidson
    Moderator
    31 pts

    Hi,

    I followed the same steps as I did during the Gmail configuration but this time I’m getting the error due to which I’m unable to connect to the server. I’m trying to connect my Yahoo account with POP3 configuration.

    Many thanks in advance.

    Regards,
    Henry

    in reply to: How to Reduce Size of Exchange 2013 Mailboxes #2051 Score: 0
    Henry Davidson
    Moderator
    31 pts

    You can go for Exchange Database(EDB) File size reduction by Defragmentation.
    Use ESEUTIL /d filepath.edb Command for this.

    Henry Davidson
    Moderator
    31 pts

    Hi Kerry,

    You can follow this link for migration from 2007 to 2016.

    Henry Davidson
    Moderator
    31 pts

    Hi Kerry,

    You can create noreply mailbox using powershell or Exchange Management Console.

    get-mailbox noreply@mydomain.com

    Run above command in PowerShell to create noreply emailaddress and mailbox to exchange server 2013.

    To create it using EMC, follow below steps:
    1) Create a user with no-reply and create password for that and check the checkbox “User cannot change password” and “Password never expired”.
    2) Allow number of users by creating a Group to access this mailbox and send email using this mailbox.
    3) Disable incoming messages to this to this mailbox.

    in reply to: Microsoft Exchange Server Migration from 2007 to 2016 #1999 Score: 0
    Henry Davidson
    Moderator
    31 pts

    You can follow step wise technique for migration of database from exchange 2007 to 2016.
    Using step wise migration you have to first migrate from Exchange Server 2007 to 2010 and then exchange 2010 to 2016 migration is possible.

    in reply to: Outlook does not close properly #1994 Score: 0
    Henry Davidson
    Moderator
    31 pts

    Hi Barry,

    Follow the steps as suggested by Michael and if the problem still persist then try to disable Add-Ins from Outlook. For your kind info, you must aware of those Add-Ins that may unnecessarily appear in Outlook, because sometimes these kind of Add-Ins related issues may also prevent Outlook from closing.

    Below are the steps to know how to disable Add-Ins:

    Start Outlook >> click on File.
    Click on Options >> click on Add-Ins.
    Look at the option COM Add-ins >> and click Go…
    De-select all the checked boxes to disable Add-Ins and click OK.

    Regards,
    Henry

    in reply to: Microsoft Exchange Server Migration from 2007 to 2016 #1982 Score: 0
    Henry Davidson
    Moderator
    31 pts

    Hi Kerry,

    There are two ways of migration from Exchange 2007 to 2016.

    First you can go by Step wise migration. In this method there will be no downtime.

    Second, You can Export Exchange Database (EDB) to PST and then install new Exchange and then Import PST file to Newly installed Exchange Server. But in this method there will be downtime of Exchange Server till the time you won’t Import PST file.

    in reply to: Hyperlinks are not working in Outlook #1975 Score: 0
    Henry Davidson
    Moderator
    31 pts

    Hello Kerry,

    Thanks for posting such a nice article. I tried “edit registry box” which is explained in the mentioned article and with luck it really helped me to get out from the issue that I was facing since last few months. Thanks again!

    Warn Regards,
    Henry

    in reply to: Showing error “0X8004010F” in Outlook #1964 Score: 0
    Henry Davidson
    Moderator
    31 pts

    Hi Eddie,

    An error “0x8004010F: The operation failed. An object could not be found.” occurs in Outlook basically while sending/receiving emails. The main reason behind this error is corrupted Outlook profile. To fix this error you need to create a new profile in Outlook.

    Follow the below steps to create one for your account:

    Start Control Panel >> Click Mail >> click Show Profiles
    Click Add>> give a name to Profile Name and click OKto create
    Check the circle to select Always use this profile >> click OK and exit Control Panel.

    For more info click here: http://www.msoutlookware.com/basic-tips/introduction-of-outlook-profile.html

    Thanks & Regards
    Henry

    Henry Davidson
    Moderator
    31 pts

    Hi Lincoln,

    You should repair Outlook Data File(.pst) to get rid of hanging problem. There might be a chance of PST file corruption which is leading to hanging issue.
    You should go below link to know about repairing Outlook PST file.
    Repair Outlook Data file (.pst)

    in reply to: Showing error “0X8004010F” in Outlook #1942 Score: 0
    Henry Davidson
    Moderator
    31 pts

    Hi Kerry,

    An error “Task reported error (0X8004010F): the operation failed. An object cannot be found” appear basically when you try to sync Offline Address List (OAL) in Outlook/Exchange server and cache mode is enabled.
    There could be many possible cause behind this error but the solution is also available to fix this error. You need to Download the Offline Address Book (OAB in short), which enables you to sync address book without any error.

    How to download:
    Connect your Exchange server with Outlook >> click File >> right click Account Settings >> click Download Address Book. (Offline Address Book is the copy of Global Address List)

    Thanks & Regards
    Henry

    Henry Davidson
    Moderator
    31 pts

    Hi Kerry,
    Thanks for posting in SYSC

    If you want to delete your previous emails then you can go for it but take backup first. To backup emails from outlook you can use its export feature, which will save all emails in PST file.

    After successful backup, proceed for deleting emails.
    Run Outlook and go to the View tab.
    Now click on Reading Pane and click on Off. You can view below image for reference.
    Outlook View Menu
    Make sure that all emails are organized as received according to date.
    Now Select the first mail at a particular date from which all previous mails you want to delete.
    After selecting the first emails for selected date Press Ctrl + Shift + End key to select all previous emails. After selection of all previous emails from selected date, right click of mouse button above selected mails and select Delete to delete all emails.
    If all deleted mails goes to Deleted items folder then you can delete all emails from there by using same procedure.

    I hope your problem will be resolved if you follow above described way. If you again find any hanging issue after deletion of mails then feel free to post about that.

    Regards
    Henry

    in reply to: Outlook Data File #1914 Score: 0
    Henry Davidson
    Moderator
    31 pts

    Hi Dear

    Well don’t get panic because Outlook provides service of Inbox Repair Tool for corrupted Data files. Have you tried it?

    If not, then search for SCANPST.exe in your local drive. Then execute the .exe file and hope so it will repair your corrupt data file.

    Note: – Here is the location of scanpst:- C:\Program Files\Microsoft Office\Office15

    Regards
    Henry Davidson

Viewing 20 posts - 181 through 200 (of 223 total)