Home Forums SQL Server 2008 T-SQL (SS2K8) Add variable number of rows into a table based on the values in another table (without cursors/while loops) RE: Add variable number of rows into a table based on the values in another table (without cursors/while loops)

  • March 21, 2013 at 3:35 pm

    #1599613

    The article is great. had a question: In Production, is it possible that the login that runs such a query might not have access to Master..syscolumns and so I should use some table from within my own database that i know is always 10k in size or more? Maybe a stupid because it is possible that everyone has read access to such system views. I will test but thought someone may have an answer. BOL says: "In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission."