My fan

hi, have installed sql2008e someweeks ago in english language trying out. want have in german. have uninstall english version first or there way change language only? dietrich dietrich i think have uninstall , reinstall. cannot change language straight away (only collation can changed rebuilding master) http://www.microsoft.com/downloads/details.aspx?familyid=58ce885d-508b-45c8-9fd3-118edd8e6fff&displaylang=de http://www.microsoft.com/downloads/details.aspx?familyid=01af61e6-2f63-4291-bcad-fd500f6027ff&displaylang=de   thanks, leks SQL Server  >  SQL Server Express

hi i have sql azure db in place in table (say a), have trigger (say b) gets called, when update query fired on table a. trigger, call stored procedure c has update query in fires on table a. chain goes like update query fired on table --> trigger b called --> stored procedure c executes --> update query on b fired c on table a--> .... , on, till exit condition of stored procedure c met.   the problem m facing when stored procedure c fires update query on table a, trigger b doesnt called. when direct update query on table made, trigger b fired properly. can please tell me, problem? how can solver it?   thanks , regards akshaya akshaya k sharma hi akshaya, sounds describing recursive trigger behavior. in source database, have 'recursive_trigger' option turned on? , nester trigger settings server? thanks Microsoft Azure ...

a string routine inside clr dll has no dll globals except compiled readonly regex variables, appears be single-threaded.  declaration of routine follows: [system.security.permissions. permissionsetattribute (system.security.permissions. securityaction .inheritancedemand, name = "fulltrust" )] [system.security.permissions. permissionsetattribute (system.security.permissions. securityaction .linkdemand, name = "fulltrust" )] [microsoft.sqlserver.server. sqlfunction (isdeterministic = true , systemdataaccess = systemdataaccesskind .read, dataaccess = dataaccesskind .read)] [ return : sqlfacet (maxsize = - 1 )] public static string fnparsetracequerytextnew([ sqlfacet (maxsize = - 1 )] string strquerytext, bool busequeryparameters, int imaxoutputlength, int ieventclass,                      string strobjectname, string strservername, int idatabaseid, int iobjectid) i pass in string information , return manipulated string.   the dataaccesskind .re...

hello, i planning implement alwayson synching data between main site , dr site in asynchronous fashion. 2 node set up, 1 on main site , on dr site. far voting goes, have read in multiple white papers common remove quorum vote dr node. leaves 1 node (on main site) with vote of 1 , since it's odd number guessing that i don't need set file share witness additional vote.  my question is: a. does topology of alwayson 1 node on main site , 1 node on dr work without file share witness work? b. voting 0 dr node , 1 main site node makes sense? c. periodically (once or twice year), dr test. during time, need failover dr site and test. but, after test done, need perform full database backup/restore main site dr site before setting alwayson or there better way don't need full backup/restore? has similar setup , these test periodically, love hear solution options. sql server version using sql 2012. i appreciate reply. thanks. raj hi kraj1, ...

hello,   i in process of transferring data , contacts onto mysql database. i have had , trying software solution.   so main features migrate large amounts of data , contacts every day. migration done manually.  thanks help. good question: there reason why want manual? solutions exist migrate data , contacts. depends on type of software use. can work proprietary software, expensive compared other solutions open source. software informatica example or talend open studio, open source program. SQL Server  >  SQL Server Integration Services

hello, been trying implement sso using windows logon while now, keep getting stuck: as our internet-facing ssrs2008r2 server using windows authentication, (external) users might ad password expired. have built asp.net website used fba authenticate external users , provides them way change password. use admembershipprovider this. for sso purposes, requirement when user logged in our web application, clicking link should enough redirect user report manager, but how can get ssrs accept cookie our web application? have tried the links custom authentication authentication extensions, seem work the other way around , use custom authentication method user lookup in sql database. want is ssrs accept cookie our web application (or provide authentication cookie can used when clicking link report manager). any ideas? thanks in advance , kind regards, michel  hi michel, thank question.  i trying involve more familiar topic further @ issue. ...

hi, i required create drill down report various hierarchies. different user logged in, has access till specific level of hierarchy. have configured drill down , have put conditional visibility toggle make sure user doesn't has access next hierarchy not allowed view toggle made hidden. the problem have here is, when textbox toggle present (toggle present in column left of group belongs to), made hidden white space. need fill toggle textbox same color of table background. know doesn't sounds big problem, it's causing other issues in terms of user interface having white spaces across report data. i tried placing textbox same background color on toggle textbox(of table), make new textbox visible when ever toggle textbox hidden, that's not turning out fruitful. i appreciate if way handle scenario provided. thanks! mir m ali hi mir, as martina has posted above, cannot change background color of whitespace generated when textbox hidden. take specific scen...