Lun

i have 2 sharepoint lists policy acknowledgment , policy type. in both list, have policy name common field. have create report using 2 dataset on same report page. if have 1 of suggestion or other idea 1) there way combine 2 sharepoint lists single dataset using caml query 2) there way combine 2 dataset single report using common field inner join in sql server?   otherwise if have other idea, please suggest.. thanks. hi estoysol, by design, getlistitems method sharepoint lists web service can return 1 list 1 time. in case, suggest using sub report work around issue:  1. show first list in main report.  2. show second list in sub report using subreport control. for more information, please see: how to: add subreport , parameters (reporting services): http://technet.microsoft.com/en-us/library/ms160348.aspx if have more questions, please feel free ask. thanks, jin chen jin chen - msft

hello, i need change owner of bunch of databases, , not want use sp_changedbowner deprecated next sql releases. there way in alter database statement? any appreciated dave dave sql developer use alter authorization. http://msdn.microsoft.com/en-us/library/ms187359.aspx   alter authorization on database::testdb testuser   best wishes, arbi --- please vote if find posting helpful or mark answered. SQL Server  >  Transact-SQL

  i have started getting unexpected performance issue.  sqlserver.exe chewing 90% of cpu extended times.  how go diagnosing problem?   what quickest fixes?   my server on small side: windows server 2003 sp2 memory 1gb (being upgraded 2gb) 2.2 mhz thank you michael, suggestions: 1. make sure up-to-date service packs (sp2 sql server 2005) 2. reindex tables ( schedule every weekend) this: code snippet use adventureworks; go alter index on production.product rebuild (fillfactor = 90, sort_in_tempdb = on) 3. install sql server 2005 performance dashboard reports  . these reports give great details performance issues based on dmv/dmf data. article: http://www.sqlusa.com/articles/query-optimization/   kalman toth sql server 2012 & bi training new book: beginner database design & sql programming using microsoft sql server 2012

how create   database application using mvvm prism framework. there lot of information out there started with: the prism developers guide the prism source here has sample apps , quick starts and there plenty of msdn code samples too. Silverlight  >  Silverlight 5

i’ve been struggling (for weeks) team foundation server 2008 install in dual server environment. can offer general advice on following setup: data tier server: windows server 2008 64bit hyper v virtual machine sql server 2008, including reporting services app tier windows server 2008 32bit hyper v virtual machine i have done following: app tier server: web server(iis) role added needed features sharepoint 3 downloaded , installed sql 2008 reporting services installed both servers: all ports in install guide opened on both servers. for reporting services doesn’t allow use setup user, i’ve used domain user admin on both machines. sharepoint not on default 17012 port. when try , install doesn’t find reporting services. i’ve tried setup user that’s domain admin , administrator on both machines. i’ve tried using user install things under during test. i’ve tried changing account running “super account”. is there advantage of having 64bit install of sql server data tier on having on

hi, we use team foundation server 2010 in combination visual studio 2013. we have multiple team-project within 1 tfscollection , are using check-in policy "work items" make sure every checkin 1 or more work items associated. have policy activated in team-projects. this works great long selecting files same team-project check-in. when select files multiple tfsprojects policy seems disappear. any ideas why case , how might go in preventing this? thank you, marcel koper hi koper,    thanks reply. according discussions in similar post , it’s known issue in tfs 2010. i tested scenario in tfs 2012 , tfs 2013 servers separately,   found issue not occur in tfs 2012 , tfs 2013 servers. we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey.

since have moved sql server 2008 r2 server have not been getting detailed errors sql server on development asp pages. sql server use return detail error if stored procedure missing parameter or column did not exist. blank page no information directing me source of error. there missing? have through options in management studio have found nothing. tried nothing relating problem. maybe there system stored procedure raises errors globally?   sql server 2008 r2 microsoft sql server management studio             10.50.1617.0 microsoft analysis services client tools                  10.50.1617.0 microsoft data access components (mdac)           3.86.3959 microsoft msxml                                                     2.6 3.0 6.0 microsoft internet explorer                                     8.0.6001.18702 microsoft .net framework                                      2.0.50727.3625 operating system                                                  5.2.3790 coul

hello, i have silverlight business aplication gets data silverlight enabled webservice. when run application in dev environment, works fine. when deploy application , asp.net web development server working, application works fine. but when stop development server, application can't access service. my questions are: when deploy silverlight business application, doesn't service deployed , started. the endpoint address in servicereferences.clientconfig file endpoint address = " http://localhost:9702/mywebservice.scv. do need change this? the enpoint address in web.config blank. < endpoint address = "" . have dod above problem? thanks, h     hi  the endpoint address in servicereferences.clientconfig file endpoint address = " http://localhost:9702/mywebservice.scv. do need change this? of cource. the enpoint address in web.config blank. < endpoint address = "" . have

hi,       running issue unit tests passing locally, getting reported "failed" test cases on our build servers. locally, running win7 vs2013 test agent , build servers running win8 vs2013 test agent. firstly, our tests passing on our local machines, having trouble reproducing problems on build server. secondly, on build servers, tests reporting aren't being executed, based on console output coverage information reported, can see tests running (which mystery us). we have attempted tests locally , our local machines pass, our server machines not pass tests. have attempted rollback previous state on build server passing, has not worked. have attempted clean build/rebooting of build machines, nothing has helped far tests still reported "not executed" (it looks tests in fact executing). anyone running issue or have solution or suggestion on look? -l hi all, update : have pinpointed issue our implementation , turns out our testers picked problem

hello, need synchronize 2 servers tfs2012 (on os windows 2012), using 'tfs integration tool' (march 2011). have set sync replication between 2 servers on same network authentication "windows authentication" on iis8 of tfs server , replication works perfectly. problem starts synchronizing local tfs remote tfs (behind isa server nat) using https connection. when try connect destination tfs server returns "tf30063: not authorized access tfsserver.dominioremoto.it---> system.net.webexception: remote server returned error: (401) unauthorized. help please. hi simone , is there update? if issue fixed, please share resolution here. if not, please provide info mentioned above can further investigation.   best regards, <the content provided "as is" without warranty of kind, whether express or implied> thanks msdn community support please remember "mark answer" responses resolved issue. common way recognize have helpe

hello,   can lock field in work item against further updates once defined, example have rule our bug work items in company severity or priority fields cannot changed through out bug life cycle, bug low severity should remain low on states, reasons, , transitions   regards,   thank much,   i have found solution while searching, using rules whenchanged , frozen   <whenchanged field="microsoft.vsts.common.severity">     <frozen />   </whenchanged>   regards, Archived Forums V  >  Team Foundation Server - Project Management & Work Item

starting navigation framework, have customized registration form not use dataform.  works until point of submit button.  in navigationframework, call made dataform.validateitem ensures of items validated. how make call manually? for example, there checkbox on form.  if user has not checked checkbox or unchecked it, no data validation done before click submit button.  i have done custom validation checkbox should give message must checked before can register.  don't see how force validation occur.  validation occur on items on form.  example, if click submit button without doing @ all, texboxes not yet filled out have red outlline , error message. thanks, greg the answer need write code each control similiar this: bindingexpression beemail = this.txtemailaddress.getbindingblocked expression; then state updated, ie show red outline errors. greg Silverlight

i’m having problems configuring sql 2005 agent job step, new credential , proxy setup stuff.   i followed set per bol , “what’s new in sql agent” (i think) it’s not working.   the job can called correctly , start , execute activex job step fails with:   “error creating security descriptor shared objects (reason: no mapping between account names , security ids done).”   i tried adding user permissions agent account per q283811 (replace process level token, etc.)   but still didn’t work.   it work if set sql agent service run under local admin account (psystem referenced below) instead of local system though seems permissions issue.   since "what's new" technet article says “if upgrade sql server 2005, existing proxy account created , subsystems assigned single proxy account. enables sql server agent jobs continue function did in sql server 2000 after upgrade.”, even built whole new system at sql 2000 , verified that the agent job step functions fine, up

i've finished upgrading tfs 2005 , wss 2.0 to tfs 2010 , wss 3.0.  seems working correctly, except there no reports or documents tab in web version of tfs.  reports , documents node in team explorer show fine; tabs missing in website.  these tabs removed in tfs 2010? they there in 2010 sharepoint portal, not there on web access portal.  having hard time remembering 2005 layout quite bit different , may have thrown in 1 place then.  there division between remote work item/ source management , document/ reporting portals.   can see reason different user groups, seems heavy handed way implement (rather roles or that.) ryan hanisco mcse, mcts:sql 2005, project+ http://techsterity.wordpress.com Archived Forums T-U  >  Team Foundation Server - Setup

hi, i have situation want use qtd accounts , last non-empty other accounts can't use account intelligence in case. i'm trying achieve same thing calculated members. want case when structure on accounts last non-empty used. however, haven't got far. can't last non-empty calculation working properly. here's code it: with member lastnonempty as iif(isempty([measures].[amount]), ([time].prevmember, [measures].[lastnonempty]), [measures].[amount]) problem in total quarter lastnonempty isn't amount last non-empty month sum of months. time dimension years, half-years, quarters, months. i'm not mdx don't know how this. mistake side. try mdx below..that give u right values   scope([time].[quarter].members,measures.[lastnonempty]); this= (tail(nonempty([time].currentmember.children),1).item(0),measures.[lastnonempty]); end scope;   hth mona SQL Server

c:\windows\system32\wbem\wbemprox.dll "is either not designed run on windows or contains error."   keep getting message when try install sql server 2012. it's thing sales out of tests can fix this. need class started 4 days ago. thank you see http://answers.microsoft.com/en-us/windows/forum/windows_7-system/trouble-with-a-file-called-wbemproxdll/b019ead5-23b9-4b0f-9cd4-705aa85cc8d5 same issue; caused malware/virus. olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Express

i sharepoint administrator using sharepoint 2010 sp1 enteprise edition , running powershell backup nightly full farm backup. backup-spfarm -directory \\serversqlbackup01\sql_full_backups\sharepoint\spbackup\production-farm -backupmethod full -verbose i run backup's in sharepoint's central administration nightly perform full database crawl , incremental crawl every half hour on sharepoint farm. my dba finding these backup's , causing him wonder going on not doing differntial , states happen simple database mode, not full. it happened on simple model databases this export sql management studio 2012 sp1 bi edition databasename          recovery_model         user_name      duration in mins       backup_start_date            backup_finish_date   backuptype     backup_size    size_unit         physical_device_name            backup_set_id search_service_application_server1_crawlstoredb_c9d7342c169a4b75a6254c0b6871f44e     simple            domain\farm-accoun

hi all, have sp send webservice data works fine on windows 2008r2 server , on windows server 2003. moving on windows server 2012 with sql 2008r2 express (32bit) or sql 2012 express (32bit), doesn't work anymore. below sp. -- ============================================= -- author: giancarlo mada service 2008 -- create date: 09/09/2008 -- description: web service interface -- ============================================= create procedure [dbo].[spmd_httprequest] @uri varchar(2000) = '', @methodname varchar(50) = '', -- post, @requestbody varchar(8000) = '', -- xml document envelope @soapaction varchar(255), @username nvarchar(100), -- domain\username or username @password nvarchar(100), @responsetext varchar(8000) output set nocount on if @methodname = '' begin select failpoint = 'method name must set' return end set @responsetext = 'fa

 hi guys, i using scatter series chart in silverlight 3. my purpose creating chart many points , every point has legend. when user hovers on point, label appear and  display informations of point (ex: legend, name, dependentvalue etc.). want manipulate color , form of points too. this sounds scatter chart except part of legend. create each point series , give style.  foreach (....) {                  .....     this.charting.series.add(series); ((scatterseries)charting.series[charting.series.count - 1]).datapointstyle = this.resources["scatterpoint"] style; ... }  i use simple style test:  <style targettype="chartingtoolkit:scatterdatapoint" x:key="scatterpoint">             <setter property="template">                 <setter.value>                     <controltemplate targettype="chartingtoolkit:scatterdatapoint">                         <ellipse stroke="black&qu

how display data in combo box using linq in silverlight 2 beta 2. if have link regarding this, please  forward me. by neethan   hi,  in silverlight combobox control not there.. you can see these links:- http://www.silverlightshow.net/items/using-linq-to-xml-in-silverlight-2.aspx http://msdn.microsoft.com/en-us/library/bb308960.aspx http://blogs.msdn.com/charlie/archive/2007/05/28/silverlight-and-controls.aspx Silverlight  >  Silverlight Installation and Setup

hi, we thinking replicating our databases. 1 issue may come up, these database servers belong different (untrusted) domains. assuming network issues can bypassed, tell replication mechanism allows use local (or other type) accounts? thanks in advance!!! regards, durai hi durai, in addition other post, can set replication across 2 non-trusted domains using windows authentication. when using windows authentication, must configure pass-through authentication. configure local windows account on both publisher , subscriber has same name , password. use account replication agent process account , ensure account has permissions required in replication agent security model . there kb article describing scenario reference. https://support.microsoft.com/en-us/kb/321822 thanks, lydia zhang lydia zhang technet community support SQL Server

hi,    know how set log shipping, question is, kind of backups run on primary besides log shipping backups.  let's full backup weekly , differential backup nightly, how fit in log shipping.  differential ans full backup screw log shipping backups?   thanks no dont think  full ups / differential harm log sequence. only if manually take log thats time lsn out of sync , log shipping crash.   regards, deven ----------------------------------------- please vote if find of post helpful. SQL Server  >  SQL Server Database Engine

hello, i installed sql server 2008 have been installing software in several machines , important me know if sql server 2008 v10.0.1600.22 has sp1 or sp2. thanks in advance. juan yánez you have sql 2008 rtm (i.e. no service packs) you can find sql server build number service packs on website http://www.sqlteam.com/article/sql-server-versions SQL Server  >  Getting started with SQL Server

hey all, cluster install failed following error: there error setting private property 'requirekerberos' value '1' resource 'sql network name (servername)'.  error: value not fall within expected range. to searched online find sp1 resolves matter. went uninstall, , got this: the sql server failover cluster instance name '' not found cluster resource. followed this: there error attempting remove configuration of product prevents other action occuring.  current configuration of product being cancelled result. i've done multiple 2008 cluster installs, first on 2008 r2 (windows) on single node cluster. i'm not entirely sure next steps are, need rid of install , start again. i tried install sp1 see happens, , get: a failure detected previous installation, patch, or repair instance 'myinstance' during configuration features [sql_replication_core_inst,sql_engine_core_inst,mpt_agent_core_cni,]. in order apply patch package (kb968369), must

a while upgraded our tfs server 2005 2008.  result i still have wss2 running on server.  have found documentation on how to upgrade wss2 wss3.  have found documentation on how add moss sharepoint (wss 3) server.  have found documentation on how take tfs server sharepoint 2003 moss 2007.  need can not find documentation on how upgrade from wss2 or wss3 to moss2007 that specific a tfs server. is there documentation describes sort of process? i never found official documentation, here saved me http://secondstanza.com/2008/03/08/team-foundation-server-installation-woes/ Archived Forums V  >  Team Foundation Server - Setup and Administration

hi friends,  i need create 2 datasets 1 r12 , ytd. these both depend on 1 parameter currentperiod. but parameter value in calculated member of measure.  so question how make value default parameter value r12 , ytd after user can change currentperiod value. iam thinking should pass calculated member value 1 variable , pass variable time filter. can u guys plzz give basic idea on how that..   thank you. sandeep.   hi sandeep, of course make use of variable in report, if currentperiod return 1 record, you could give currentperiod datafield as parameter's default value directly, please make sure value date type, utilize cdate function in report convert type date. for more information please see: using report , group variables collections references (report builder 3.0 , ssrs), please see: http://msdn.microsoft.com/en-us/library/dd255208.aspx   creating report parameters , setting report parameter properties http://msdn.microsoft.com/en-us/library/aa33

our application uses sql server 2008 compact edition. we want know after generating 10,000 logs, how many bytes log table takes is there way can figure out how many bytes database table use during application running or use utility ~.sdf? thx! see this: http://support.microsoft.com/kb/827968 http://erikej.blogspot.com erik ejlskov jensen - please mark answer, if it. SQL Server  >  SQL Server Compact

i wrote metro app mobile broadband connection status of system. main code follows: public void initializemanagers () { try { // mbninterfacemanager if ( m_mbninterfacemanager == null ) { m_mbninterfacemanager = ( imbninterfacemanager ) new mbninterfacemanager (); } if ( m_mbninterface == null ) { m_mbninterface = getfirstinterface (); } } catch ( exception e ) { rootpage . notifyuser ( parseexceptioncode ( e ), notifytype . errormessage ); } } private imbninterface getfirstinterface () { foreach ( imbninterface mbninterface in m_mbninterfacemanager . getinterfaces ()) { return mbninterface ; } return null ; } it goes on win8 os, , can connection status successfully. failed on win8.1. exception is: unexpected.exception occured:system.unauthorizedaccessexception:access

hi, i'm experiencing performance hit in silverlight windows compact embedded 7. have multiple pages application, , when i  click on button want app display new page. problem occurs there delay between moment push button , moment page displayed. according tests have made, delay doesn't come lack of performance of cpu fact silverlight not display page when told to. have tried use updatewindow hwnd provided getcontainerhwnd doesn't change things @ all, maybe because applicationd doesn't have wndproc message pump. there way force refresh of active window in silverlight windows compact embedded ? thank you, hi, i suggest use multiple threads, if delay long when change page may means have thread still running . please check code find out if there endless loop. regards, Silverlight  > 

i need upgrade older express 2005 database schema express 2008.  what's best way go doing this? i'm not sure how close express 2005 database express 2008. thank in advance! yes can backup database sql server 2005 instance , restore sql 2008 instance. yes version of database in 2005 & 2008 different. version of database in 2005 611 , when restore in sql 2008 upgraded 655. compatibility of restored database still 90. cheers feroz   mark answer if helps. posting provided "as is" no warranties , confers no rights. SQL Server  >  SQL Server Setup & Upgrade

  when run sql 2008 setup, getting"   title: microsoft sql server 2008 setup ------------------------------ the following error has occurred: unable open windows installer file 'd:\sql2008ent\x86\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi'. windows installer error message: system cannot open device or file specified. . click 'retry' retry failed action, or click 'cancel' cancel action , continue setup. for help, click: http://go.microsoft.com/fwlink?linkid=20476&prodname=microsoft+sql+server&evtsrc=setup.rll&evtid=50000&prodver=10.0.1600.22&evttype=0x5d9a8c61 ------------------------------ buttons: &retry cancel ------------------------------ i downloaded 2 separate iso images msdn , vol lic sites both giving me same error. ran setup local machine same result.   can here... try resolve since morning.   tia   i having same issue. log premier call ms , see if joy there no fixes available o

e.g. in typical .net development team, how should set groups , users? mean how many groups , type of permission give. assuem in small company, there same set of 50 developers working on few projects. have access projects same permission. off head, easiest way is: 1. create set of default tfs project groups ( project administrator, contributor, reader, build services) @ server level, tfs server groups. 2. add proper users above groups, e.g. developers contributor. 3. then, in each project, add these server groups corresponding project groups. this way, access projects, usual case in many small companies. admin need change @ server level keep administrator work @ minimum. if there high security project, add individual users project group. does sound workable? thanks jirong hi yes how doing it. we have our ad: developers group contains developers. groups part of contributers in tfs qa testers part of contributers, have special rights bugs. project managers. no access sourc

hi, i've 2-node cluster of windows 2008 r2 ent having multiple sql instances running. i've upgraded instance sql server 2012 sql server 2008 r2. ever since failover of other instances running sql server 2008r2 taking long time bring sql services online in cluster. , fails after 3 minutes (pending timeout default setting). i've verified sql instance during state change (from offline online), found out sql server available time cluster not able change state , time out. there no information in cluster logs @ point of time. have faced similar issue , pointer check further? can related cluster resource dlls updated while upgrading sql 2012? looking forward cooperation. regards, divesh mathur hello, please review sql server error log from node where fails come online. sql server error log may give you the cause if sql server service not able start. if sql server able start without errors, please check eventviewer , cluster logs for further

hi all, how can current year , month through reporting services expressions?? please me???   thanks =month(now()) =year(now()) i think above expression should work you cheers, jason p.s. : please click 'mark answer' button if post solves problem! :) SQL Server  >  SQL Server Reporting Services, Power View

sub town      if x = 1 , y = 1 then        textwindow.clear()        shop()      elseif x = 1 , (6 <= y > 1) then        townrandom()      endif endsub elseif x = 1 , (6 < y > 1) then im trying make (1,2),(1,3),(1,4),(1,5),(1,6) sub townrandom do want this? sub town if x = 1 , y = 1 textwindow.clear() shop() elseif x = 1 , (2 <= y , y <= 6) townrandom() endif endsub nonki takahashi Learning  >  Small Basic

i'm tyring test null in derived column in ssis - if results null substitute "xxxxxx"  data type dt_str the code (isnull(conv_employeeid)) ? " xxxxxxxxxx" : conv_employeeid doesn't seem work... ideas? have spaces in empid? try isnull(trim(conv_employeeid)) ? " xxxxxxxxxx" : conv_employeeid which error?! visit http://www.pedrocgd.blogspot.com - if question answered, please mark answered. SQL Server  >  SQL Server Integration Services

does have pointers on how build metro sdk windows 8? i'd provide own sdk app developers , want know steps end-to-end building sample api, building installer it. thanks!  check out tim's blog post here . pretty detailed http://timheuer.com/blog/archive/2012/03/07/creating-custom-controls-for-metro-style-apps.aspx dev@mic Archived Forums T-U  >  Tools for Windows Store apps (archived)

hi, i new mvvm. using mvvm light tool kit. i trying create simple silverlight application displays products in gridview. can guide me on how to consume wcf service in mvvm light what changes should make in viewmodel , viewmodellocator collection of data wcf service. how bind data gridview in mainpage.xaml below code have implimented, mainviewmodel.cs using galasoft.mvvmlight; using nyntraonlineshopping.nyntraservicereference; using system.collections.objectmodel; namespace nyntraonlineshopping.viewmodel { public class mainviewmodel : viewmodelbase { readonly nyntraserviceclient _clientcontext = new nyntraserviceclient(); private observablecollection<product> _products = new observablecollection<product>(); public observablecollection<product> products { { return _products; } set { _products = value; } } public mainviewmodel() {