• Ooooooo....

    I think if I found one of my developers using SMO to access database objects directly, that person would be found hanging from a cross in the morning.

    This situation is exactly what having an API full of stored procedures is for. The devs should never be querying base tables directly, or updating database / server level settings.

    Any dev wishing to try using a programmatic interface to access SQL Server would also likely run into permission problems, as the credentials they have may not have permissions on various objects.

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.