Lun

we’ve had problem we’ve been trying solve week , out of ideas.   so i’m posting nhibernate , ms database forum. in nutshell, periodically following message on 1 of our servers, not anywhere else: nhibernate.exceptions.genericadoexception: not insert: [cho.next.global.dataobjects.eventtime][sql: insert chonext.dbo.eventtime (starttime, endtime, startregdate, endregdate, eventid, nexteventtimeid, recurrencegroup) values (?, ?, ?, ?, ?, ?, ?); select scope_identity()] ---> system.data.sqlclient.sqlexception: distributed transaction completed. either enlist session in new transaction or null transaction. it not seem specific 1 (insert, delete, etc.), pass, message distributed transactions.   it inconsistent , hard reproduce.   sometimes work few hours , every operation fail. architecture notes: -this nt service uses msmq.   so each incoming message used spawn new thread, although we’ve changed have single thread running @ time make sure it’s not threading issue. -this ru

i'm running 2 sql servers server1 = (sql2000 8.0.2194) server2 = (sql 2005 9.0.5000) server1 publisher , server2 distributor , subscriber for reason managed create server1 , publisher on server2 can seem sonfigure server2 distributor on server1 see error below error 18483: not connect server xxxx because 'distributor_admin' not defined remote login @ server   what cause? thanks lot best regards, vusi radebe try on problem server:   use master go select @@servername this should return current server name if returns null try: use master go exec sp_dropserver 'oldname' go use master go exec sp_addserver 'newname', 'local' go looking book on sql server 2008 administration? http://www.amazon.com/microsoft-server-2008-management-administration/dp/067233044x looking book on sql server 2008 full-text search? http://www.amazon.com/pro-full-text-search-server-2008/dp/1430215941

hi all, i bit confusing in forum category have post this. i need preparing various  specification documents  need prepare for  maintaining web application. and please provide formates , examples can make documents refernce of documents. thanks devendra had these documents been related software testing, may have considered creating sample documents you. try http://www.scribd.com , should able search example documents. search same document using different search phrases better/ more results. luck. Archived Forums A-B  >  Archived: Software Testing Discussion

hello, have been developing solution using master data services 2016 start workflow on change in specific attribute , transaction log picks change workflow not start. change tracking along "has changed" setting in business rule should starting workflow yet not , workflow gets started when value in member changes not in same change tracking group microsoft, have maybe switched process change tracking group should doing ? so installed latest patch (sqlserver2016-kb3208177-x64) , solves issue change tracking not working. the link patch:  https://support.microsoft.com/en-us/help/3208177/cumulative-update-1-for-sql-server-2016-sp1 regards SQL Server  >  SQL Server Master Data Services

i had question best way deploy (and maintain) custom reports used across multiple team projects.  in msdn guides i've found, little discussed creating reports beyond of own team project.  or author briefly addresses telling reader can make copy of report , drop in team project. this does't work when maintaining report across 20+ team projects. from developer standpoint, ideally prefer make report change , have single deployment destination, other team projects can see latest changes. can accomplish linked reports, define deployment location , create linked reports within each of team projects? require more up-front configuration theoretically easier push out enhancements. what others in scenario? thanks in advance, matt     hello matt, first, in opinion issue not related tfs. reporting service organized in folder mode, linked reports not supported in tfs. in addition, far know can deploy report target destination in sql server business intelligence dev

if upgrade vs2012 rc , use tfs2010 able benefit of new features? example local workspace feature; or is there dependancy on tfs2012?  best regards sina hello sina, although use vs2012 connect tfs2010, can't these new features which are from tfs2012. far know "local workspace", "my work", "merge enhancements" , etc. belong tfs2012. in order use these new features, need use vs2012 connect tfs2012. thanks. vicky song [msft] msdn community support | feedback us Archived Forums V  >  Team Foundation Server - General

why doesn't microsoft create silverlight browser xaml , c#/javascript native.  and develop version works on both windows , phones (including apple , google phones).   if language supported on client il built binaries used language compiled il. this mean, java , other development communities compile il , use browser. day 1, required html + javascript, xaml + il. this mean there browser native support , bypass need silverlight plugin. if browser ie, available , companies use , other vendors may see benifits , move also. the reason microsoft aren't going because decided ditch silverlight. it's deprecated , in end of life cycle support. . if other companies saw silverlight benefit them apple have embraced rather deciding never going run on devices. there therefore of flaw in assumptions here. hope helps. technet articles: wpf: mvvm friendly user notification ; all technet articles

hello. i trying implement next , previous buttons on web page uses ce database, , having trouble getting logic figured out.  data unbound , i'm not returning @ once, paging through item @ time isn't possible.  because of high volume, thinking pass in record id each time need retrieve record , every time user hits next or previous button, i'll requery record need .  sound reasonable? in main page, i'm using viewstate store record id need acquire.  part works--it gives me highest id number (so recent record):         if (!ispostback) {             // start out recent record in selected category.  gethighestconfessionid() return             // id of recent confession.             viewstate ["confessionid"] = mysearch.gethighestconfessionid (int.parse(viewstate["category"].tostring()));         } here's trouble comes in--i need go next record in database when user hits next, don't know how that.  big idea issue command in next button: viewstate

i have problem need pick records <= 52 weeks current week how in mdx. a with member last52weeks as sum ( {[date].[calendar].currentmember.lag(51): [date].[calendar].currentmember} ,[measures].[internet sales amount]) select last52weeks on 0, {[date].[calendar].[month].&[2001]&[12]} on 1 from [adventure works] i have shown month. use week level within hierarchy in date dimension vinu SQL Server  >  SQL Server Analysis Services

  i did many researches on internet trying find out way resolve "directory not empty" issue in past few weeks. even after running promon.exe nothing frustration want share how away , hope can provide me answer. so, problem that, when i'm using default template.xaml run build, randomly 2nd or 3rd sequential build, build goes fails because of error message below. $/teamproject/branches/dev/src/xxx.xxxx.sln ('clean' target(s)) - 1 error(s), 0 warning(s), view log file c:\program files (x86)\msbuild\microsoft\webdeployment\v10.0\microsoft.webdeployment.targets (794): unable remove directory "obj\release\source". directory not empty. or "obj\release\tempbuilddir" so, whenever build failed due  to directory not empty error, under binaries folder @ binaires\release\ _publishedwebsites\wdp (web deployment project)\, sub directories not clean delete binaries work flow recursively. so, put clean task @ wdp .csproject , web site applic

i looking perform backup on busy system.   database around 30gig.  assuming takes 15 minutes up.  a) how sql server maintain db backup consistancy?  b) there big overhead involved? thanks in advance please tell version using. when backup starts, sql server notes oldest open transaction in transaction log, , after backup finishes, 'mini log backup' taken, containing oldest open tran @ start of backup, until whatever logged @ end of backup. when restore backup, sql server can use log contents bring database consistent state, of time of start of backup. i'm not sure asking in b). overhead making backup cost of io. yes, there can impact on rest of system, without lots more details, , without knowing concurrent activities running, can't how impact. hth, kalen delaney www.sqlserverinternals.com SQL Server  > 

hi guys, if query sys.objects select top 22 * from sys . objects order by modify_date desc i retrieve objectid. having how can retrieve db belongs objectid? many thanks sys.objects reflects current database not objects on server objects see in current database. select top 22 db_name(), * sys.objects order modify_date desc tom g. SQL Server  >  SQL Server Database Engine

hi,    havent been able find anywhere on how remove or stop continous integration on build type.   can point me how this?   thanks i guess must have subscribed custom code checkin event kicks off builds.  bissubscribe.exe has /unsubscribe option guess you'll want use turn ci off...  following blog post ( http://blogs.msdn.com/jpricket/archive/2006/09/05/741260.aspx ) has sample app listing subscription ids , instructions running bissubscribe /unsubscribe option. as how change on team project - you'll need find out set ci solution in first place, how works, etc.  said, ci not supported out of box in team build v1.0, must using third-party solution. -aaron Archived Forums V  >  Team Foundation Server - Build and release management

following link create current , previous month , getting error, i tried every cobinations , still not getting desired result http://blogs.conchango.com/christianwade/archive/2006/06/23/mdx-script_3a00_-current_2f00_relative-period.aspx after before following thsi method had 2 time dimensions current year,prev year , ytd and working fine. now according new requirment have create current month , previous month. so followed lik above add new calculations,except new calculations rest working fine i have 1 tine dimension , 1 time shell dimension,since new few new calculatiosn current month , previous month so went ahead , created them using scripts create member currentcube .[time calculations cost].[time calculations].[current month] as null , visible = 1; now used script follow calculatiosn ([time calculations cost].[time calculations].[current month],{ [measures].[pct perfect], [measures].[epay lines perfect], [measures].[total number of invoices pct perfect] } ) = sum

how can set empty key in fact table go unknown member? ex- customerid '' (not null). thanks hello, please take @ following document: defining unknown member , null processing properties: http://technet.microsoft.com/en-us/library/ms170707(v=sql.110).aspx regards, elvis long technet community support SQL Server  >  SQL Server Analysis Services

hi all, i have sl , wcf application. wcf appliation seperate project intermediate of sl application. doubt i'm calling wcf methods sl wcf methods not calling wcf event raised, put break point @ wcf application wcfimageprocessing.svc file control coming here. private wcfapplicationref.wcfimageserviceclient webservice;                 public page()         {             initializecomponent();             compositiontarget.rendering += compositiontarget_rendering;                         initializevalues();             try             {                 blnfimorrim = true;                 initializevalues();                 dblcurrenttotalangle = 0;                 eventofimagemanager();                      }             catch (exception ex)             {                 messagebox.show(ex.message + " innerexception " + ex.innerexception.tostring());             }         }         private void eventofimagemanager()        

is possible break subreport? instance subreport can half page full page in length depending on data pulled database. in form on 1st page prior subreport half page long. if subreport half a page, it's displayed correctly. if subreport full page, it's pushed 2nd page results in lot of space on 1st page. possible force subreport start displaying on 1st page if it's full page long? try below add rectangle control in between master report , subreport , properties below size:5.46875in, 0.03125in dataelementoutput:contentsonly pagebreak:end no matter subreport display in new page. nanda SQL Server  >  SQL Server Reporting Services, Power View

hi gurus, what waittype 0x00b2 means .does means http_endpoint_collcreate .if yes does http_endpoint_collcreate means . regards abhay abhay chaudhary ocp 9i, mcts/mcitp (sql server 2005, 2008, 2005 bi) ms-abhay.blogspot.com/ hi abhay_78, http_endpoint_collcreate wait type encountered tasks. , 0x00b2 hexid http_endpoint_collcreate. waittype 0x00b2 means http_endpoint_collcreate used create endpoints when sql server starts. can used internal only. should pay attention state not specific http. endpoint specifies binding, contract, , address properties service, used expose services. refer : waittype: http://msdn.microsoft.com/en-us/library/ms179984%28v=sql.90%29.aspx . endpoint: http://msdn.microsoft.com/en-us/library/ms731320.aspx . regards, amy peng SQL Server  >  SQL Se

hi, we have few ssrs reports has run daily after data loaded in database. i scheduled reports on timely based , got job id's using sql server agent , using sp_start_jobs stored procedure run. but problem is creating multiple files 1 time , 1 sp_start_jobs procedure. any idea how avoid this? i appreciate help. thanks, sarah if you're going schedule ssrs jobs using agent, don't schedule them in ssrs using subscriptions well... don't forget mark helpful posts, , answers. helps others find relevant posts same question. SQL Server  >  SQL Server Reporting Services, Power View

hi, i have table userinfo column name   name kalees mano ashok   i pass query input 'kalees','mano','babu'   i need output babu   i need select data input value except userinfo table.         try tis; declare @vtable table ( name varchar (20)) declare @vqueryinput varchar ( max ) insert into @vtable select 'kalees' union all select 'mano' union all select 'ashok' set @vqueryinput = 'kalees,mano,babu' select [value] from dbo.fnsplit(@vqueryinput, ',' ) except select name from @vtable if passing comma separated values, correct way 'kalees,mano,xyz'. check @vqueryinput variable in above script. if dont have dbo.fnsplit, here code; comma separated value splitter function helpful in development. create function [dbo].[fnsplit] (@pstring nvarchar ( max ),@psplitchar char (1)) returns @tbltemp table (tid int ,value varch

hello everybody, i new mdx , struggling come query works.  have a  ssrs report  filters week. need write query run last week default. the query have cooked is: with member measures.lastweek as [time dimension].[report week].currentmember.lag(1) select measures.lastweek on 0, [time dimension].[report week] on 1 [sales] this returns null value. i have searched , searched internet answer have found nothing. appreciate help.   thanks. hi jonny   you need associate numeric measure value query selecting (you can skip member declaration here, not creating new measure, referencing different week member), like select measures.amount on 0, [time dimension].[report week].[year].[2010].lastchild.lag(1) on 1 from [sales] in example assuming [time dimension] user hierarchy , last member loaded dimension current week  (may not case in cube) javier guillen SQL Server

select st.*, cl.clientname, stst.studystatusname #studies studies st inner join studiesclients stcl  on stcl.studysqlid = st.studysqlid , stcl.studyincid = st.studyincid , st.isdeleted = 0x0 , stcl.isdeleted = 0x0 , stcl.sponsorranking = 1 inner join clients cl on cl.clientsqlid = stcl.clientsqlid , cl.clientincid = stcl.clientincid , cl.isdeleted = 0x0 left join studiesstatuses stst on stst.studystatussqlid = st.studystatussqlid , stst.studystatusincid = st.studystatusincid , stst.isdeleted = 0x0   charindex(cast(left(datepart(yyyy, getdate()), 2)  + substring(st.studycode, 2, 2) nvarchar(30)), @year) > 0 and (charindex(cl.clientcode, @sponsorcode) > 0 or @sponsorcode null) and  charindex(stst.studystatuscode, @studiesstatuses) > 0  select distinct ac.activitycode ,ac.activitystartdate #temp1 activities ac inner join #studies st on ac.studyincid=st.studyincid and ac.studysqlid=ac.studysqlid and ac.isdeleted=0x0 inner join activitiesad

hi, i want create menu left of report creating stays same , links same reports.  can please tell me options available this?  our dba wants using custom code.  thinking might possible using either text box or list box (report items) embedded code. thanks i hear , forget. see , remember. , understand. hi, 1. right click on text box 2. go action . 3. go report. 4. pass same report name (same .rdl) 5. pass required parameter. it should work hope !!! sanjeewan SQL Server  >  SQL Server Reporting Services, Power View

hi,  we have 2 databases merge replicated 2 subscribers. merge agent scheduled run @ 5pm everyday. have scenario. the agent start run on 15th march. merge agent running average of 18hours.replication agent shows agent ran out errors , completed on 16th march 8:30am. there updated replicated table on 16th march 2:30am. updates have not gone through subscriber. merge agent running , agent started on 16th march 5pm. will updates happened table @ 2:30 on march16th propagated subscriber on run.? how can reduce latency @ subscriber? how should determine best way schedule merge agent? please advice me on this thanks have subscriptions taken 2 days synchronize? having subscriptions set never expire can negatively impact replication performance since metadata never cleaned up.  recommended set retention period value can reliably predict subscribers synchronize within period. brandon williams ( blog | linkedin )

good morning, i have ssrs report sharepoint list datasource.  report parameterized create date start , end; list items created on or after 5/15 (3 on 5/15, 3 after).  1 of fields choice field choice , choice b options.  i have developed table totaling list items each of choices - choice a/choice b listed in first column in distinct rows , corresponding list item totals listed in second column. when use 5/16 or after start date, table displays correctly.  when use 5/15 or before start date, totals correct, first column lists choice a; row 1 says choice choice a's totals , row 2 lists choice choice b's totals.  any ideas on causing this? hi scook217, could please elaborating issue showing design structure of report? how filters designed? there group in table? if possible, please post screenshot of issue. helpful reproduce issue , out. regards, mike yin SQL Server

have process doing number of things - getting data from/into multiple sql server databases on multiple servers - updating data in databases using business rules , xml schema processing - generating xml data go different parts of various systems while of in ssis, considering workflow 4 tool locate type of logic.  have other processes in ssis move data into/out of sql.  however, wanting separate of distinct "buckets" isnt running on sql server.  if spin sql server run ssis on, have additional licensing costs, 1 thing. at end of day, coming down choice based on our skill sets serve best.  consideration alone, going workflow.  our sql version 2005, , feel more comfortable c# , visual studio bids. anyone else had make kind of decision? are going use windows workflow? yes, ssis not have rich support xml. bids , c# 2 different things, ssis's paradigm not coding long - provides solution faster. imo, choice seems reasonable. arthur my blog

greetings everybody please can me. looked on forum elsewhere solution, namely " split string using delimiter" thread , " how calculate least anmongst list of quarters" thread. no applied success. first thread looked promising unfortunately did not split field separate columns. i have field called address, contains 1 to 4 lines separated | delimiter. wish split field 4 columns. what have attempted incredibly messy , works (hence top 2 clause) breaks down when there 1 | delimiter. know there slicker , more simple way achieve aim. thank in advance provide. kind regards paul select top 2 a.address, substring (a.address,1, charindex ( '|' ,a.address,1)-1) as address1, ( len ( substring (a.address,1, charindex ( '|' ,a.address,1)))+1) as start2, ( charindex ( '|' ,a.address,1+ len ( substring (a.address,1, charindex ( '|' ,a.address,1))))-1) as end2, ( charindex ( '|' ,a.address,1+ len ( subst

  i want compare 2 sets , based on result come :   like  :   case @parameter when @parameter set(of members or tuples) then set , on end   anybody have idea   thanks in advance   nishant first thing comes mind is: when intersect (@parameter, otherset).count = otherset.count maybe better way else? hth george spofford SQL Server  >  SQL Server Analysis Services

q1) how clip region in canvas1 images moving off screen dont continue displayed? q2) can simplify of code have defining height,width . need width , hieht of every canvas1. mc:ignorable= "d" d:designwidth= "1050" d:designheight= "500" > <grid x:name= "layoutroot" background= "white" width= "1050" height= "500" > <grid.columndefinitions> <columndefinition width= "150" /> <columndefinition width= "500" /> <columndefinition width= "200" /> <columndefinition width= "200" /> </grid.columndefinitions> <grid.rowdefinitions> <rowdefinition height= "500" ></rowdefinition> </grid.rowdefinitions> <canvas x:name= "canvas4" grid.row= "0" grid.column= &q

hello i have some report shows bugs links version items mht files, , if there test result linked mht file , can see in   report . i have 4 bugs have link same manualtest1.mht , 2 of them belong 1 team project , 2 others belong second team project. now i've deleted team project one, refreshed warehouse, still work items in report.   can explain why these work items still there?   thank you.   hi katy, if you've processed warehouse , imported team project's data the warehouse, after delete project, project's info still in warehouse.  difference team project marked "deleted" in "team project" dimension.  in report filter out items belong team project name begins "deleted project -". could tell me expect happen? thanks, mauli Archived Forums V  > 

our company switching tfs our common source control, , wondering if has been able implement within webmethods 7.1 environment.  thanks, brad hi brad, i holding off responding in case "real" people dropped give of reports.  sorry no-one has got you.  remember worked customer in late 2008 / 2009 when we still teamprise using webmethods i've not tried myself, nor include specific ide in our test matrix.  standard eclipse repository provider should have luck. my best suggestion download trial , have go sample project in environment , let know if have problems. http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=af1f5168-c0f7-47c6-be7a-2a83a6c02e57 sorry i can't of more help. martin.   http://www.woodwardweb.com Archived Forums V  >  Team Found

in silverlight 1.1 displayed images filling rectangle image source. approach noticed images take time show (load). since silverlight 2.0 however, i've been using image control. is there difference between these 2 approaches?  advantages , disadvantages?   i have guess.... best guess rectangle imagebrush less efficient, uses more memory image object. why use rectangle , brush instead of image control? image control available in 1.1 if i'm not mistaken... Silverlight  >  Programming Silverlight with .NET – General

  i describe problem , hope me find way solve ! my task how find "similiar" words in our database ! now, have use software find similiar name. example : the name : "donaldson filtration slovensko s.r." , name : "penta slovensko donaldsin spol. sro" "similiar". in case : word "donaldson" , "donaldsin" can called similiar because diffrence not more 1 character in same positon in string. i used stored procedure sovle problem because larg number of records in each table (for on 1 million records each table). the way had used first create temperary table contain _____________________ create table #seperatestring1 (  string1 nvarchar(100) ) create table #seperatestring2 (  string2 nvarchar(100) ) ____________ so that, analyze string 2 tables detecting blank character between 2 words ! then, compare values between 2 tables, _________________________ declare st1_cursor cursor   select string1 #seperatestring1

while subscribing 1 of ssrs (sql sever 2005) report, getting following error.  "an error has occurred because control id 'ctl5785$ctl51' not located or different control assigned same id after postback. if id not assigned, explicitly set id property of controls raise postback events avoid error"  please me solve issue? hi bhuvana, generally, error "an error has occurred because control id 'ctl5785$ctl51' not located or different control assigned same id after postback. if id not assigned, explicitly set id property of controls raise postback events avoid error" occurs in asp.net web site when "enableviewstate" of control set true. however, in sql server reporting services, there no option enable view state manually. if added property page of report server or report manager manually, please remove it. or, please check if have added "<pages enableviewstate="true"/>" in web.config of report server or report mana

microsoft has created new forums platform ( msdn | technet | expression | microsoft ) increased performance, stability, , improved user experience. during week of 12/8     this forum moving new platform. make sure smooth transition, want using forum have chance try out new forums in advance, , give feedback. we’ve created sandbox forum , can create threads , try out functionality, , suggestions forum can give feedback. please take time go new forums today , let know think.   on day forum moves new platform, post made letting know process has been started, , forum locked new posts. once process complete, final post forum made letting know forum has moved.   1.        all posts in forum preserved 2.        any points you’ve received replies move (on per forum basis) 3.        any bookmarks forum or threads within forum redirect new location 4.        your “my threads” preserved on new platform   the thing you’ll need after migration set windows live alerts threads

hi team, the visual studio tools - ultimate 2013, tfs 2013 , release management 2013 available in same server. created sample .net application , when tried perform release using tfs build template - releasedefaulttemplate.11.1.xaml got below error message: note - in release management, tfs name added in lowercase letters in http mode. <dir><dir><dir><dir><dir><dir> run release management build process current configuration 　 <dir> microsoft.teamfoundation.release.build starting process... processing using following parameters: teamfoundationserverurl:                http://tfsname:8081/tfs/collection teamprojectname:                        demo teamprojectwithcollection:              collection/demo builddefinitionname:                    appone buildnumber:                            appone_20150331.2 targetstage:　 creating release , waiting deployment result... error: tfs collection (http://tfsname:8081/tf

a question sql browser, have cluster 2 nodes. on node1 installed 2 instances, 1 production, 1 qa. same node2. browser keeps stops, causing front end sharepoint not available. have restart sql browser service fix that. not sure if problem of network because before running fine long time have done research sp3 fix that. looking @ instances on node1. both instances - tcp/ip port leave blank, guess both using default port. correct configuration? have set 1 of instance's tcp port different number, or don't have to? sqlfriend go error.log  per instance , see port listening to... best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/ ms sql optimization: ms sql development , optimization ms sql blog: large scale of database , data cleansing remote dba services: improves ms sql database performance SQL Server

in sl there neat method called navigatetobookmark in system.windows.browser.htmlwindow class, , off same class you can read current bookmark. note, bookmark is named anchor in url (post # part of uri), though i think meant hold name value pairs (why, don't know?). anyway, since can navigate , read bookmark, i wondering how can capture change in bookmark property. tried hooking into any possible dom events but to no avail, and there no event handler defined in htmlwindow or related classes. ideas how can capture changes in current bookmark? this bookmark feature has many many great possible uses, like hooking directly into a page in loosely coupled way (i think called deep linking), if can capture changes is! i don't know how you'd hook changes going cause repost , there security reasons can't monitor or change address bar. i've created example uses facility support linking silverlight application hint @ right state of control (or support button). ho

  having rectangle , filled brush defined in template. when changing view state "checked", replace other brush. corroect way? tried: --------------------in resource, has checkedcolor, defaultbrush, checkedbrush_2 defined : <color x:key=" checkedcolor ">#ffff0000</color> <radialgradientbrush x:key=" defaultbrush " gradientorigin="0.205,0.892">         <radialgradientbrush.relativetransform>             <transformgroup>                 <scaletransform centerx="0.5" centery="0.5" scalex="0.929" scaley="0.929"/>                 <skewtransform anglex="0" angley="0" centerx="0.5" centery="0.5"/>                 <rotatetransform angle="180.34" centerx="0.5" centery="0.5"/>                 <translatetransform x="0.111" y="-0.129"/>             <