Lun

below the xaml, intend highlight row, based on column value in column is_deleted. want utilize same value converter, when user clicks delete button in grid. the problem value converter never invoked, hence rowbackgound color never changed.   < sdk : datagrid autogeneratecolumns ="false" itemssource ="{ binding elementname =atp_m_groupdomaindatasource, path =data}" name ="atp_m_groupdatagrid" width ="auto" height ="auto" rowbackground ="{ binding path =is_deleted, converter ={ staticresource rowbackgroundcolorconverter } }" >   public class rowbackgroundcolorconverter implements ivalueconverter public function convert(byval value object, byval targettype system.type, byval parameter object, byval culture system.globalization.cultureinfo) object implements system.windows.data.ivalueconverter.convert if value.tostring.toupper.trim = "t"

hi,   i'm testing out new task hadoop ins ssis sql2016. have installed hdinsight emulator , tried execute little pig script. when execute directly @ grunt prompt pig script works expected, if execute hadoop pig script in ssis fails , have following output (remove comment logs name of task): [remove comment logs] information: schedule hadoop job successfully. job id job_1455103176281_0024 [remove comment logs] information: hadoop job job_1455103176281_0024 status prep [remove comment logs] information: hadoop job job_1455103176281_0024 status prep [remove comment logs] information: hadoop job job_1455103176281_0024 status running [remove comment logs] information: hadoop job job_1455103176281_0024 status succeeded [remove comment logs] information: hadoop job job_1455103176281_0024 tracking url [remove comment logs] information: hadoop job job_1455103176281_0024 exit value 255 [remove comment logs] error: hadoop job job_1455103176281_0024 exit value not 0 task

with   member     [interviewtype].[membername].[onboard] '(  [status].[membername].&[onboard],  [interviewtype].[membername].[all] )'   set test2 '{  [interviewtype].[membername].[onboard]  }'   set level1 '{  [interviewtype].[membername].&[hr screening],                         [interviewtype].[membername].&[skills screening],                         [interviewtype].[membername].&[skills interview],                         [interviewtype].[membername].&[final interview],                        [interviewtype].[membername].&[hr interview],test2  }' im using this(above) query combine 2 different dimensions 1 named set. member [measures].x       case   [interviewtype].[membername]                    when  'onboard' then    ([measures].[onboardss%])     else                ([measures].[pass through rates])      end select  { measures.[x] } on 0 , { level1} on 1 from [pipeline_report] where ([time].[year].&[2008]

hi, all! i have strange trouble. say, have server operation: [ invoke ] ienumerable<somecomplextype> myinvokeoperation( anothercomplextype p1, yetanothercomplextype[] p2 ); when server's operation has been invoked client call: var result = myinvokeoperation( new anothercomplextype { ... }, new[] { new yetanothercomplextype { ... } } ); server's parameters looks strange: p1 assigned ok, p2 has empty array. problem is? tried wrap array class didn't give effect me. hi, all! have strange trouble. say, have server operation: [ invoke ] ienumerable<somecomplextype> myinvokeoperation( anothercomplextype p1, yetanothercomplextype[] p2 ); when server's operation has been invoked client call: var result = myinvokeoperation( new anothercomplextype { ... }, new[] { new yetanothercomplextype { ... } } ); server's parameters looks strange: p1 assigned ok, p2 has empty array. pr

here's tricky thing. want put label, explanation of on work item form. can't find way achieve looking @ entire list of available elements. has every felt similar need , found solution this. here's pro forma of layout snipped work item type defintion i'm envisioning. i have added labe type control i'd alabel. thing doesn't exist of course, the rest of it is pro forma in fact have form 4 columns , text field in each , want embracing label describe 4 columns.  <group label="progress">               <column percentwidth="100">                 <group>                     <column percentwidth="100">                         <control label="the 4 fields below ... blah blah." type="label"/>                     </column>                 </group>                 <group>                       <column percentwidth="24">                         <group label=&q

hi new @ this.  questions when data being inserted or updated how can trap that, check data , modify before inserted or updated? thanks regards if want modify data need use trigger, if need check data can use check constraint http://www.w3schools.com/sql/sql_check.asp http://msdn.microsoft.com/en-us/library/ms189799.aspx SQL Server  >  Getting started with SQL Server

hi, i have bookingsfact having measure field bookedweight , foreign keys plantdimkey , datedimkey, orderitemdimkey in pivot table report data(bookedweight) plants have grouped based on below criteria: 1. if plantdimkey 1  use orderitemdimkey. 2. if plantdimkey 2 use datedimkey. thanks ajit hi , do mean have dynamic relationship in dimension usage tab ? if so, thing cannot done . regards, david . SQL Server  >  SQL Server Analysis Services

i working httpwebrequest , observed strange behavior. http request not reach @ server if not call begingetresponse. in more detail, create http request , call begingetrequeststream; in callback, stream endgetrequeststream , write message stream , close stream. on destination side (destination of http request) observe whether request arrives. observation though close stream, unless call begingetresponse, request not sent destination. true? if is, why not reported in documentation? also, isn't strange design, because name of method begingetresponse, while mean begintosendrequestandgetresponse. code below: private void xyz(object sender, routedeventargs e) { uri uri = new uri(... httpwebrequest request = (httpwebrequest) webrequest.create(uri); request.contenttype = "text/plain"; request.method = "post"; request.begingetrequeststream(onrequeststreamready, request); } void onrequeststreamready(iasyncresult result) { ht

in wpf have been using code similar following size of textblock when wraps text within given size of box. go on position text relative other objects before rendering. mytextblock.maxwidth = boxsize.width*0.9; mytextblock.maxheight = boxsize.height*0.9; mytextblock.measure(boxsize); size textblocksize = mytextblock.desiredsize; in silverlight desiredsize returns zero.  is expected , there can size of a textblock before rendered? thanks nick    yeah, actualwidth/actualheight after setting text properties:     mytextblock.maxwidth = boxsize.width*0.9;     mytextblock.maxheight = boxsize.height*0.9;     mytextblock.font*** = xxxx     mytextblock.text = ...     size textblocksize = new size(mytextblock.actualwidth, mytextblock.actualheight); -mark silverlight program manager microsoft post provided "as-is" Silverlight

hello, i have problem when create clusters created domain account , give him permission create computer objects , real properties there problem when clean cluster pop , error latter tried using domain admin , worked there permission missing cluster ?? or need create computer object , read permission? regards, ayesh. hi ayesh, description, seems error regarding cleaning cluster while creating windows cluster. if “unable cleanup” error, please check solutions in following similar thread , blog. creating new cluster failed "an error occurred while creating cluster , nodes cleaned up" “unable cleanup” error while creating windows 2008 r2 server also, described in article , besides requiring create computer objects , read properties permissions in container used computer accounts in domain, account used create cluster requires administrative permissions on servers become cluster nodes. please ensure account has admin rights on server. in addition,

convert xml xml schema---any way or software?   thanks   hello,   please, have on link ? http://msdn.microsoft.com/en-us/library/xz2797k1.aspx   as i've same problem, found link. be careful gave link towards .net 3.5, @ right top of topic, find links .net 2.0/3.0   please, formulate more precisely question ? and explain purpose of conversion ? and in language ( vb/vc#..) ?   have nice day     SQL Server  >  SQL Server XML

hi, i have ssis package failing on foreach container. i don't know query running or the variable @ whne failes? i know can create message box in script cannot remember syntax , put within package. the variable name called "vlist" thanks we can debug steps in ssis , watch value of variable during runtime. refer below links, http://agilebi.com/jwelch/2009/11/29/ssis-101-viewing-variable-values-at-runtime/ http://www.bidn.com/blogs/shawnharrison/ssis/2408/ssis-tips-watch-your-variables regards, rsingh SQL Server  >  SQL Server Integration Services

hi all, i trying run stored procedure passing parameter using openrowset. note: running below query datasrv2 . datasrv1 & datasrv2 configured linked server between eachother. also openrowset enabled at server level.     select  *     from    openrowset('sqlncli', ' server = datasrv1 ; uid = report ; pwd = passoword ',                        'set nocount on;set fmtonly off;exec datasrv2.db_report.dbo.usp_search_sprocedures ''pefr''')   error: but getting following error: msg 7357, level 16, state 2, line 2 < br > cannot process the object "set nocount    on;set fmtonly off;exec dataserv2.db_report.dbo.usp_search_sprocedures 'pefr'".    the ole db provider "sqlncli" for linked server "(null)" indicates that either    the object has no columns or the current user does not have permissions on that    object.  but when run above stored procd

  hello all,     here need or suggestions following topic...   i using sql server 2000 enterprise edition installed on machine. wanted change edition enterprise standard. there around 4 user databases exists on server. what areas have take care while doing this? normal installation? no log shipping implemented on server.   your suggestions helpful me.   thanks in advance. welcome msdn forums you can perform below steps namely, script logins in sql 2000 enterprise edition using link (use method1) script jobs in sql 2000 enterprise edition using link save dts packages structured storage file detach user databases in enterprise edition , keep in safe location uninstall sql 2000 enterprise edition install sql 2000 standard edition attach user databases detached in step 4 execute scripts taken in step 1 create logins execute scripts taken in step 2 create jobs save dts taken in step 3 sql server 2000 standard edition good luck ! - deepak

hi  sprint burndown report ideal trend showing flat.  we assign 2 tasks current sprint , tfs calculate ideal trend 2 tasks.  we add more tasks in tfs current sprint after few days b ut ideal trend not recalculated. our environment tfs 2015 up3. there anyway can ideal trend normal. warehouse job executing expected verified jobs other team reports expected.  can please suggest here.  thank you!! durga  hi durga, could you please check whether you have set value of remaining work field new added tasks? ideal trend calculate remaining work hours. best regards   msdn community support please remember click "mark answer" responses resolved issue, , click "unmark answer" if not. can beneficial other community members reading thread. if have compliments or complaints msdn support, feel free contact msdnfsf@microsoft.com . Archived Forums V

hi guys, had users ask me other day , i'm not sure start...   we have dimension (product) has 1 many relationship our customer fact table.  in configuration, can see how many customers own each product.   what user requesting able see how many customers have different product combinations.  example, how many customers have product , b?  or a, b , c?   is there way in cube?   thanks!   data mining you're going want use probably. take @ , see if answers question: http://forums.microsoft.com/msdn/showpost.aspx?postid=820872&siteid=1   if you've got data mining question, try data mining forum: http://forums.microsoft.com/msdn/showforum.aspx?forumid=81&siteid=1   if want try doing mdx, following might trick:   select {} on 0, intersect ( exists ( [customer].[customer].[customer]. members ,([date].[calendar].[june 2004],[product].[category].[bikes]) ,"internet sales" ) , exists ( [customer].[customer].[custom

hi,      using ssas cube ssrs rb1.0 generation of adhoc reports use model test. have added calculated fields in particular model on regeneration gets lost.is there way in calculated fields can retained when model generated? , regards, franco lopes. ask question , fool second if don't ask question fool forever. hi franco, did add calculated fields in reporting builder? if so, fields available current report (because limitation cannot modify model). so, try add them in cube? http://msdn.microsoft.com/en-us/library/ms345292.aspx   regards, raymond   SQL Server  >  SQL Server Analysis Services

  hi !   i puzzled following:   on server x, have packages running fine, sql & ssis installed. on server y, have sql server/90 file installed (i don't know does). no sql server, neither ssis (services).   ok, now, want do is able run package on server x server y. in fact, need application on y able start package when data validated.   when pass following command (master name of package) on server x; runs fine: "dtexec /server x /sql  master /rep v" when pass on server, fails, seems login time out problem.   i contacted admin in charge of active directory. account using ad service account, runing admin on both server. have created right level of rights on databases used package. doesn't seem that source of the problem. or @ least, can't think of other possibilities.   after, reading thread way dtexec.exe works. found out several saying detexec running locally. understood when u pass name of package on distant server (/server x /s

  hello all,   is there way retain "reason" previous state in reason field when transition occures?    in specific example, have customized bug work item can transition resolved state closed state. assumption i like to make if tester chooses close bug, close bug same reason developer resolved it.  reason field either default whatever previous state reason was, retain previous reason value, or copy previous reason value reason field.  failing that, set reason field invalid value user forced pick reason list.  possible?  far experience has been 1) cannot copy values reason field @ all, , 2) <defaultreason> tag appears required, overwrites existing value (note, i'm using tfs 2008).    thanks help,   james hello james,     know there no way now. thanks.     Archived Forums V  > 

  i using sql server 2005, sp2. i have created maintenance plan using maintenance plan wizard , in plan, have 2 backup database objects, 1 databases , 1 transaction logs. after have plan, if open again , open backup database (transaction logs) object, has lost list of databases set up. seems bug in sp2 did not happen in sp1. is aware of hotfix this? not see on ms's support site.   terry hi terry,   i agree, it's annoying.  bug has been fixed , should released in next version.   it's discussed more here: http://forums.microsoft.com/msdn/showpost.aspx?postid=3596725&siteid=1   SQL Server  >  SQL Server High Availability and Disaster Recovery

running tfs 2008 sql 2005 sp2.  have 2 maintenance plans backup:   1.  full backup (all databases) unc a path - runs once per month 2.  log backup (all databases) unc b path - runs daily   job 1 runs fine without errors.   job 2 pukes every time , says check history / log more info.  check history / log , doesnt show detail actual underlyling error. soooooooooooo..... decided view sql job #2.   copy sql job , go run manually in sql server mgmt studio.  job tsql runs fine without error!!!    1 have suggestions?     thanks!     it's working i that changed job use unc based backup device (instead of unc path directly).     other problem reportservertempdb set simple recovery mode cant have transaction log backup performed on it.   are recommended maintenance plans for the tfs 2008 db's?   thanks.   Archived Forums V  > 

hi all, i have created report graph. graph type should changed depending on parameter value.(graph1, graph2,graph3 etc). the problem values not in cube. so when try specify details of parameters definte in query, can not selct dimension , hierachy , defualt values etc. can tell me how please? thanks   shamen hi shamen, according description, use parameter supply different graph,please follow steps below, , check if works you. 1. in report data pane, right-click on dataset created sql server analysis services data source type, , clicks query. mdx query designer opens in design mode. 2. on toolbar, click design toggle query mode. 3. on mdx query designer toolbar, click query parameters. query parameters dialog box opens. 4. in parameter column, click <enter parameter>, , type name of parameter. 5. in dimension column, choose value drop-down list, example, select “date”. 6. in hierarchy column, choose value drop-down list, example, select “date.date”

i trying teach myself how import excel files sql server db.  know access quite , time when working access.  trying learn sql server better, , think exercise learn of features of sql server.  so, anyway, i’m following example here: http://sql-bi-dev.blogspot.com/2010/08/dynamic-ssis-package-to-import-excel.html   go through first steps fine.  trying step 2 working: step 2: create new ssis package , rename loaddynamicexcelfiles.dtsx   tried open integration services project business intelligence project (in vs 2008).  keep getting message reads ‘microsoft visual studio unable load document.  design integration services packages in business intelligence development studio, integration service has installed 1 of these editions of sql server 2008: standard eition, developer, or evaluation.  install integration services, run sql server setup , select integration services.‘   now, i’m not sure how create new ssis package.  goggled around solution, still can

hi everyone, recently have noticed 1 of job has scheduled under task scheduler started failing automatically without reason , there no changes on server, when reconfigure same job same steps ran successfully. technically failing understand root cause why earlier job started failing , new job originated old job running well. so can please let me know,if there bug against windows server 2003r2 edition or using can reach out decision. thanks in advance, regards, ashish tripathi it looks oracle related error. below can help http://www.ora11g.de/ora-21561.html http://www.databaseskill.com/2539103/ http://viewssharings.blogspot.in/p/blog-page_2782.html also ms sql related forum. thanks, rama udaya.k (http://rama38udaya.wordpress.com) ---------------------------------------- please remember mark replies answers if , un-mark them if provide no help,vote if gives information. SQL Server

i'm calculating percentages within report, of small, i.e. less 0.5%. i'm displaying whole percentage points small values showing 0%. however, i'd display true 0 values -%, leave small values 0%. there specific format choice this, or have write conditional formula? e.g. want 1.34572456% displayed 1% 0.32456246% displayed 0% and 0.00000000% displayed -%   thanks help ray i work uk time. if post, or another, answers question, please click 'mark answer' button others same problem can find solution more easily. that's did, thanks. from responses, i'm assuming answer original questions is, "no, there isn't format option, have write conditional formula." thanks all ray work uk time. if post, or another, answers question, please click 'mark answer' button others same problem can find solution more easily. SQL Server

after reading, , re-reading articles can find, still unable dts designer open imported dts package in ssms.  clean install of 2008r2(x64) standard.  chose possible ssis and client backwards comp option  @ time of install.  i have applied lastest 2005 feature pack (backwards compat.) and installed (x86) dts runtime. in 1 mdsn article ( ms143755) placed 3 files semsfc, sqlgui, sqlsvc.dlls , rll's;  swapping %program files% %program files(x86)% since 64-bit install. in rdp session on server, in ssms, able import dts packages, unable open 1 fo them. i get: title: object explorer ------------------------------ sql server 2000 dts designer components required edit dts packages. install special web download, "sql server 2000 dts designer components" use feature. (microsoft.sqlserver.dtsobjectexplorerui) ------------------------------ buttons: ok ------------------------------ when try find updates on dts designer components, keep comoing around same a

hi, in sql server 2012 management studio great new standard reports availible. i'm looking since days sources of these new reports not found in web. i have found sources old reports in version 2005 , 2008 ( http://blogs.msdn.com/b/managingsql/archive/2006/08/30/ssms-reports-3.aspx ) need new ones check how hyperlink developed opens filter-dialogue. i need create custom report usage in ssms 2012 , wanted add filter-possibility in same way. example can open new standard report via ssms object browser here: integration services catalogs / ssisdb / standard report / executions after report opened … clicking on "filter" sql server filter setting winform dialogue opened grouped filter-view , possibility update current filter-settings. report reloaded these new parameters. can involve me in how develop it? haven't find way ssdt 2012 , normal rdl. have no sources found on local machine, have installed sql server. thanks help. rené

hi everyone, i've new silverlight, apologies such simple question: i've built simple templated control similar button changes colour , forth when clicked. works a-ok, neither control nor child elements become focussed when clicked. child elements still fire mouseleftbuttondown/up events, focus remain on e.g. standard button on page clicked earlier. focus() , using tab key sucessfully focus control. standard behaviour silverlight require call focus() when clicked? doesn't seem right... any advice warmly recieved! [if relevant, i'm using silverlight 5 beta, can reproduce in silverlight 4] hi, could provide a repro project can test , investigate issue? if want change colour of button, a simple thing in blend: 1. open project in blend. 2. right click button control in objects , timeline panel (or in design window) -> edit template -> edit copy -> pick name  -> click ok button. 3. can change whatever want editing properties in prop

hello..... i don't know how parameterized mdx query..... can give me solution please.....     with set set1 as (            {[date].[newdate].[2008-07-05 00:00:00.000]:[date].[newdate].[2008-07-25 00:00:00.000]}             ,{[date].[arrivedate].[2008-01-01 00:00:00.000] : [date].[arrivedate].[2008-12-27 00:00:00.000]}       ,{[date].[departdate].[2008-01-01 00:00:00.000] : [date].[departdate].[2008-12-30 00:00:00.000]}       ,[status].[businessid].[businessid]       ,[status].[p pickroom]       ,[status].[pickroom]       ,[status].[p statusid]       ,[status].[statusid] ) member [measures].z as   sum (       set1, case         when ([measures].[p statusid] =3                        and [measures].[statusid] = 3                     and [measures].[p pickroom] = 0                     and [measures].[pickroom] = 0 )                                                             then ([measures].[blockroom]

greetings community, this question related express edition. let’s have mydatabase2014 , i’ve been populating data during year 2014. before end of year, want prepare database named mydatabase2015, should empty, of course should have tables, relations, indexes , stored procedures mydatabase2014. idea change connection string , continue using same app same job. so in ssms, right-clicked database, choose script database / create / new query, didn’t wanted. in query window i’ve got create database statement, , below few dozen of alter database set ansi or statements, , set many other things. however, no table creation scripted. also, no stored procedures have been created, , users, , other security objects better not start talk about. i have achieved right-clicking databases node , select new database. what’s point of “script database as”? does work in sql server editions other express? when comes express edition, what’s best practice empty copy of database? thanks help.

hi: i upgraded windows 7 , reinstalled ms sql server 2008 - developer edition.  user on computer , use development box.  i administrator on windows , created user account dataadmin when set sql server responsible of things such sql server agent, analysis services etc. - though not entirely sure why did user on box - needed in order system install. anyway, went restore db , got following error: cannot open backup device 'c:\users\roger\documents\db_backups\hash30_93324\hdco_93324.bak'. operating system error 5(access denied.). i tried going security , giving default user account  rbs1\roger of server roles did not work.  in resolving appreciated. roger   roger, you have go directory listed hash30_93324 , give user 'dataadmin' full control on directory. windows permissions issue in account running sql server not have permissions files in directory. hope helps, sean SQL Se

i've moved new pc, , had bids installed on it.  machine dates set international standard (dd/mm/yyyy). i opened existing report modify includes date range in parameters.  when tried test preview of report in bids, got invalid data error on first date parameter.  after bit of fiddling around, worked out let me input dates in format, yet after input dates converted international format.  when deployed report server, report requires dates input in international format. i've spent half hour checking machine , bids try , find cause of problem, , i'm stumped. any suggestions? what date format database (not report server) using?   SQL Server  >  SQL Server Reporting Services, Power View

i have sql server 2005 instance (the entire stack) installed , using maintenance plans backups, etc.  performed side-by-side installation of sql server 2008 (the entire stack).  appeared well. however, no longer see maintenance plans under maintenance plan folder in ssms (neither ssms 2k5 or ssms 2k8).  can see plans if connect integration services.  maintenance plans execute sucessfully. i not 100% sure behavior not present before 2k8 install, have no reason think otherwise, either.  did not pay close attention it. is intended behavior?  now, edit plans have export them integration services, edit them in bids/vs , re-import them (unless missing something).  not show stopper hassle.  cause customers shake heads , wonder going on. any ideas? tia greg wilkerson this not intended behavior.  valid scenario. should work. can provide me more details on machine configuration , steps reproducing issue ( edition of sql server, os, processor architecture ...) ? thanks, sateesh. mark post hel

i've gotten tfs running on test project , building dedicated build server. the build, static analysis, , deployment work great, i'm having problem unit tests. i'm not using web or load tests, i'm getting failures locating loadtestpackage , aspnethelper assemblies. ideas or suggestions debugging? the build log contains following: using "testtoolstask" task assembly "d:\program files\microsoft visual studio 8\common7\ide\privateassemblies\microsoft.visualstudio.qualitytools.msbuildtasks.dll". task "testtoolstask" loading d:\builds\unitlibrary\full build\sources\netunits.vsmdi... d:\program files\msbuild\microsoft\visualstudio\v8.0\teambuild\microsoft.teambuild.targets(0,0): warning : testtypes\{37e36796-fb51-4610-8d5c-e00ceaa68b9f} not loaded because tip not instantiated following reason(s): not load file or assembly 'microsoft.visualstudio.qualitytools.loadtestpackage, version=8.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a

hi, have build definition runs unit tests in tfs 2015. there way change path of testresults directory? page (https://www.visualstudio.com/docs/build/define/variables) says, it's defined variable named common.testresultsdirectory, , $(agent.builddirectory)\testresults. can changed path such $(agent.builddirectory)\afolder\..\testresults? put variable varibles, , tried set path , build it. but, doesn't work that. advice appreciated! mo hi mo, i tried add variable same name build definition , run build, value won’t replaced. for requirement, suggest use copy files step copy test result other folder. regards starain 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. Archived Forums V