sql server - Why must QUOTED_IDENTIFIER be on for the whole db if you have an indexed view? -

-

yesterday added indexes on view in mssql 2008 db. after seems store procedures need run quoted_identifier set on, don't use view in question.

why so? can configure on db or have update stored procedures set quoted_identifier on? think rather weird required stored procedures not using view.

do these stored procedures relate base table(s) view based upon? quote creating indexed views:

after clustered index created, connection tries modify base data view must have same option settings required create index. sql server generates error , rolls insert, update, or delete statement affect result set of view if connection executing statement not have correct option settings. more information, see set options affect results.

and it's kind of obvious, when think - you're potentially going updating contents of view whenever touch these base tables, , inherit same responsibilities when created index.

you can set defaults @ multiple levels:

  • any application can explicitly override default settings executing set statement after has connected server. set statement overrides previous settings , can used turn options on , off dynamically application runs. option settings applicable current connection session.

  • ole db , odbc applications can specify option settings in effect @ connection time specifying option settings in connection strings. option settings applicable current connection session.

  • set options specified sql server odbc data source using odbc application in control panel or odbc sqlconfigdatasource function.

  • default settings database. can specify these values using alter database or object explorer in sql server management studio.

  • default settings server. can specify these values using either sp_configure or object explorer in sql server management studio set server configuration option named user options.


Comments

Post a Comment

Popular posts from this blog

ASP.NET/SQL find the element ID and update database -

-
basically i've got update query runs when click submit button. i have asp:repeater in page layer inside this <asp:repeater id="dgbookings" runat="server" onitemdatabound="itemdb"> <itemtemplate> <div class="bookingscontent"> <div class="bookingdetails" id="<%# databinder.eval(container.dataitem, "booking_ref") %>"> <p class="infotext"><%# databinder.eval(container.dataitem, "adults") %> <asp:linkbutton onclick="editdetails" text="edit..." runat="server"></asp:linkbutton></p> <p class="infotext"><asp:linkbutton onclick="submitdetails" text="submit..." runat="server"></asp:linkbutton></p> </div> </div> </itemtemplate> <asp:repeater> and outputs ...
Read more

jquery - appear modal windows bottom -

-
i have modal windows in application, work fine <div id="modal" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="mymodallabel" aria-hidden="true"> but when modal appears, appear top of windows, , want appear bottom the application joomla 3.0! , using template of meet gavern any idea? i found solution i modified de css in bootstrap .modal.fade { top:-25%; -webkit-transition:opacity .3s linear, bottom .3s ease-out; -moz-transition:opacity .3s linear, bottom .3s ease-out; -ms-transition:opacity .3s linear, bottom .3s ease-out; -o-transition:opacity .3s linear, bottom .3s ease-out; transition:opacity .3s linear, bottom .3s ease-out; }
Read more

c++ - Compiling static TagLib 1.6.3 libraries for Windows -

-
i having super hard time compiling , using taglib 1.6.3 in qt project. i've tried can think of. taglib claims supported through cmake i'm not having luck. furthermore, i'm confused kinds of files need qt libs! i've built *.a files, *.lib, , *.dll. understand far... believe since i'm working in windows *.lib want. no matter do, end "undefined references" taglib functions try use when try compile qt project. have tried mingw32, msys, visual studio 2008, , cross-compiling windows on linux. turning nothing. what makes less sense me if compile same taglib source qt on mac (g++ think?) works fine! somewhere in windows compilation procedures have going wrong. have been smacking face on desk 30 (on , off) hours trying figure out. since qt uses mingw must compile taglib same compiler? if compile *.lib's visual studio not compatible? are *.a libraries usable in windows? (assuming mingw) i'm still trying handle on c++ stuff, after reading coun...
Read more