Forum Replies Created

Viewing 15 posts - 1 through 15 (of 716 total)

  • Reply To: A Reuseable Window

    Sorry, but the answer is wrong! I ran the code in SQL 2022 got below error:

    Msg 102, Level 15, State 1, Line 15

    Incorrect syntax near 'WINDOW'.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    October 2, 2023 at 6:50 am

    #4299466

  • Reply To: The Migration Tool to Use III

    I think the correct answer should be DMA, from BOL:

    The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    September 13, 2023 at 7:25 am

    #4285480

  • Reply To: Disabling the CEIP

    https://www.brentozar.com/archive/2020/10/what-is-the-sql-server-ceip-service/#:~:text=Can%20you%20disable,or%20Enterprise%20Edition

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    September 11, 2023 at 8:32 am

    #4284042

  • Reply To: Having a problem with error 22050. Need help.

    Change the database context to msdb, the query will work fine, tested myself.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    May 31, 2023 at 6:24 am

    #4201227

  • Reply To: Need a trigger to stop a restore with replace

    db_backupoperator

    Members of the db_backupoperator fixed database role can back up the database.

    I guess that would be enough privilege to perform the backup but CANNOT DO RESTORES!

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    November 26, 2019 at 9:54 am

    #3700955

  • Reply To: Need a trigger to stop a restore with replace

    @john-2 Mitchell, Thanks for the reply! The accidental restore was done by a 3rd party powerful tool not SSMS, even worse the REPLACE & drop current connections options were chosen...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    November 26, 2019 at 9:33 am

    #3700953

  • Reply To: Need a trigger to stop a restore with replace

    I have the same problem (almost), but it`s not about permission, I need to stop everyone from doing a restore operation in production server (business requirement after an accidental restore),...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    November 26, 2019 at 8:28 am

    #3700926

  • Reply To: Need a trigger to stop a restore with replace

    Hi,

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    November 26, 2019 at 8:24 am

    #3700925

  • RE: XP_CMDSHELL fails execution

    Hi,
    Please note that when xp_cmdshell is called by a user that is not a member of the sysadmin fixed server role, it connects to Windows by using the account name and password...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    September 27, 2017 at 2:31 am

    #1961107

  • RE: SQL Mirroring + Multiple End Points on SQL Instance

    @perry Whittle

    I need to configure 2 different Mirroring instances for a single database?! in other words can I Mirror database 1 to instance B and then Mirror the...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    March 21, 2017 at 2:38 am

    #1934120

  • RE: SQL Mirroring + Multiple End Points on SQL Instance

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    March 19, 2017 at 7:04 am

    #1933886

  • RE: SQL Mirroring + Multiple End Points on SQL Instance

    Ok, I know it`s a 7 years old post, but I am stuck with some issue related to that post:

    "Can I configure 2 different instances for a single database?!...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    March 19, 2017 at 7:04 am

    #1933885

  • RE: Resource Governor Limits?

    Meaning limiting the CPU to 25% with MAX_CPU_PERCENT has no effect & was ignored somehow!

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    May 15, 2016 at 12:15 am

    #1879118

  • RE: Converting to XML

    Nice question, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    March 30, 2016 at 2:39 am

    #1868498

  • RE: Term Extraction Languages

    Ed Wagner (3/16/2016)

    Not being an SSIS guy at all, I learned something new. Thanks.

    + 1 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant
    https://www.linkedin.com/in/hany-helmy-1845ab11b/

    March 20, 2016 at 12:13 am

    #1866306

Viewing 15 posts - 1 through 15 (of 716 total)