Home Forums Article Discussions Article Discussions by Author Discuss content posted by RBarryYoung Find all objects in Server Owned by a Login RE: Find all objects in Server Owned by a Login

  • December 3, 2009 at 11:39 pm

    #1087498

    JC-3113 (12/3/2009)

    Hi RBarry Young

    sorry to bug you again, but i came across another issue when running this on another server

    seems there's a 256 limit somewhere

    Msg 106, Level 15, State 1, Server NSAB-SS83-SQL-N, Line 1218

    Too many table names in the query. The maximum allowable is 256.

    Msg 102, Level 15, State 1, Server NSAB-SS83-SQL-N, Line 1234

    Incorrect syntax near ')'.

    Msg 102, Level 15, State 1, Server NSAB-SS83-SQL-N, Line 1256

    Incorrect syntax near ')'.

    Thanks

    Jiim

    Hmm, the 256-db/table limit is a tougher nut to crack and I am afraid that I will not be able to address it right away...

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]