• 89netanel - Tuesday, May 8, 2018 6:52 AM

    Oops 😜

    I wasn't joking there. Having such a simple password for an sa account is probably one the worst things you can do in SQL Server. You should be using a highly secure password for any account with sysadmin privileges, and you should only be connecting as that login when you need to do sysadmin things. The sa account should NEVER be used for something like returning data in an OPENROWSET query, especially as the DDL will be stored in plain text in the View's DDL. YOu need to change the password, and the login that the OPENROWSET query uses, now (not later, this should be a huge priority for you).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk