SQL SERVER – The Limitations of the Views – Eleven and more…

I had earlier written, interesting article series on the limitations of the views. I had a great time writing this series. I got many many requests to write more on the subject, but honestly, I think I gave my best to the subject.

I am now interested to read what all of you have to offer on this subject. I encourage all of you to go through complete series and write your own on the subject. If you write an article and send it to me, I will publish it on this blog with due credit to you. If you write on your own blog, I will update this blog post pointing to your blog post.

Solarwinds

SQL SERVER - The Limitations of the Views - Eleven and more... limitedview

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
Previous Post
SQLAuthority News – SQL Server Seminar at Colombo Full – Hyderabad Few Seats Available
Next Post
SQL SERVER – Error : Fix : Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file failed with the operating system error 2(The system cannot find the file specified.)

Related Posts

7 Comments. Leave new

  • Hey pinal here one more limitation of the Indexed View

    I got the error while createing IV from synonyms.

    Error : -Msg 2788, Level 16, State 1, Procedure U_ALLOBJECT, Line 4
    Synonyms are invalid in a schemabound object or a constraint expression.

    Reply
  • read all articles..informative. thanks!

    Reply
  • GReat pinal sir…………………….

    Reply
  • Most of this limitations are connected with indexed views.

    Reply
  • Dinesh Vishe
    June 22, 2012 3:40 pm

    can we use set like

    SET ARITHABORT OFF
    SET ANSI_WARNINGS OFF
    in views ??

    Reply
  • Kunal Ranjan Bhattacharyya
    December 8, 2015 7:10 pm

    Which of the following statements regarding SQL Server 2012 objects is TRUE?

    A. A user-defined data type can accept an input variable and return a table of results but cannot be used within a view.
    B. A scalar function can accept an input variable and return a table of results but cannot be used within a view.
    C. A table-valued function can accept an input variable and return a table of results but cannot be used within a view.
    D. A table-valued type can accept an input variable and return a table of results but cannot be used within a view.

    sir pls help to find the correct answer.

    Reply
  • BTW: you can’t use a CTE in an indexed view (well you can create a view with it but not index it)

    Reply

Leave a Reply

Menu