Posts

Showing posts from July, 2015

desktop development with VS 2008

i have vs 2008 professional , sql server management studio 2005. i have limited ability work 3.5 edition sdf files in vs, , sql server management studio 2005 useless. what tools available work 3.5 sdf files (script support, db design, etc) thanks!  you can use free sql server management studio 2008 express edition, can download here:  http://www.microsoft.com/downloads/details.aspx?familyid=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en  - or use commercial product:  http://primeworks-mobile.com/products/dataportconsole.html erik ejlskov jensen, mcts: wm app, mcitp: sql 2008 dev - http://erikej.blogspot.com please mark answer, if it. SQL Server  >  SQL Server Compact

sql server 2008 express ssrs

hello.  might easy issue have sql server 2008 express on machine.  express2008 used several applications have developed.  after year being requested data provided in reports.  sse2008 has ssrs bi development environment available use.  when go , develop report how save sse2008?  how list machine?  when run report manager, use in url address?  think can sse2008 okay report manager think might culprit. thanks given on this....john please open the reporting services configuration tools and check urls assigned report server , report manager. you can open configuration start-->all programs-->sql server 2008-->configuration tools-->reporting services configuration manager. web service url , report manager url tabs provide details , allow configure these. hope helps. please let know if have further questions.   please click "mark answer" if resolves problem or "vote helpful" if find helpful. bh

How do I insure that SqlBulkCopy resources are cleaned up after use?

if i create new sqlbulkcopy object, vs 2008 , 2010 intellisense not show having .dispose()  method and if type in the compiler won't allow it.  doesn't sqlbulkcopy create unmanaged resources should cleaned calling .dispose() ?  bol/vs indicate object implements .dispose() .  code examples show object being declared in using block, don't believe using can right thing unless believes class has a  .dispose() method. i tried work around: sqlbulkcopy bc = null ; try { sqlbulkcopy bc = new sqlbulkcopy(); // stuff bc } finally { if (bc != null ) ((idisposable)bc).dispose(); } this @ least compiles (and runs).  however, as watch application, copies a lot of sql tables, the process's memory usage keeps growing in task manager. how insure sqlbulkcopy resources cleaned after use? problem solved.  found , fixed incorrect initialization of wpf text field, being used diagnostic messages related bulk copy , keeping infinite undo list (arrgh). 

Database Reindexing and mirroring

hi,   we have scheduled job db reindexing (maitinance plan) oltp database on sunday.   we have used mirroring automatic failover witness server dr reindexing job fails after 30 mins without error.   please let me know why database reindexing gets failed.   regards sufian   add log file job step, execute job.. once failed check log file errors... or add log file the maintenance plan , check out log file after job failure!!! SQL Server  >  Database Mirroring

Sum of Calculation VS AVG of Results

i have simple measure table, called myfacts. in table have values 3 columns call x, y , z.   sample data follow: x y z 55 66 77 44 33 22   my formula is: (x + y) / z   (55+66)/77 = 1.6 (44+33)/22 = 3.5   my current calculation (sum of x) + (sum of y) / (sum of z) = 2 however want is: i want mdx product average of 1.6 , 3.5 equals 2.5     the current calculation follow: with member measures.a as iif([measures].[z]<>0,(         ([measures].[x]) +                                 ([measures].[y])) /                                 ([measures].[z),0) select measures.a on 0 from [mi dashboard dw]   what proper mdx calculate average of results each calculation? ie result of 2.5 not 2.0 hi, calculate row average in dsv named calculation or in data source table/view rowaverage = (x+y) / z then in measure group create measure column sum aggregation.  ma

Analyse my data base in Pervasive

hi,   please let me know if can create data source pervasive sql , create cube on using sql server analysis services.   please guide me how how should connecting pervasive.   if possible can post links explains how should connect pervasive.   thanks shiv SQL Server  >  SQL Server Analysis Services

sql server ssis package

i created package in visual studio. there package executing fine. i want schedule package. may know steps scheduling it? you have 2 options: 1. use sql server agent job - link   i recommend this. 2. use windows scheduler. hope helps !! sudeep    |    my blog SQL Server  >  SQL Server Integration Services

Can this be done with Silverlight

hi, please direct post correct forum if not right place it.  can done silverlight ? - http://www.spinnerfish.com/agv1a/sfmmain.html#   we're considering moving flex silverlight because of our extensive .net experience not sure if silverlight can handle type of ui.  replies appreciated.  thanks.   you can build site using silverlight.  see example of forum written entirely in silverlight 1 nice example of similar want do.  also, developing in silverlight has added advantage of using visual studio development great tool team development.  hope helps! -ken  Silverlight  >  Designing with Silverlight

Any possible issues while migrating Web/WCF Services from .NET 4 to .NET 4.6.1 consumed by Silverlight 4 application?

i trying migrate existing web services/wcf services .net 4.0 to .net 4.6.1. please note changing .net versions only. these web services consumed in my web application built using silverlight 4. there impact on the existing functionality? need make other changes in silverlight apart updating service references? please advice. regards, vinod hi, as know, can consume web services/wcf services created based on .net 4.6.1. hard project have no issue when migrate .net 4.0 .net 4.6.1. when action migrate, please project first. please try it, if issues later, welcome come back. best regards, jambor 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. Silverlight  > 

High Memory Usage.

hello, have sql server 2012 standrad edi64bit server.it using 94% memory.our ram size 36gb.it using 34gb. usage normal?normal sql consume of available memory on machine. if set max server memory value there affect resources available sql.please suggest me solution. thank reply. r educing maximum memory may impact performance right.to avoid in future can please suggest has done.do need make other settings. reducing max server memory might affect environment possible might not. difficult here dont have knowledge system.changing max server memory value changes buffer cache after changing value might see slowness initial  queries cope up. change value when have maintenance period sql server. sql server taking memory normal behavior unless find out out of memory errors or perfmon counters have memmory pressure. please check section 'does system has low memory ' in below link confirm memory pressure http://social.technet.microsoft.com/wiki/contents/article

SSRS 2008 Chart Missing Series Label Properties

i have number of column charts in ssrs 2008. 1 of them have option edit "series label properties". cannot seem figure out how properties last chart. there series data, cannot change labels. there other way property, other right clicking chart , choosing series label properties (as missing). thanks. hi jay, description, might caused data labels hidden in column chart. in order show data labels, please refer steps below: 1. on design surface, right-click 1 of columns in chart, , select “show data labels”.(the data labels show on each series of chart) 2. right-click 1 of data labels , selects “series label properties”. more information position labels in chart, please refer article below: http://msdn.microsoft.com/en-us/library/ms156263(v=sql.100).aspx if have questions, please feel free ask. thanks, bin long SQL Server  > 

Stacked column chart for one field

hello. in power view, how create stacked column chart 1 field based on count? in table, have trade group , count. in chart, see 1 column each component. see % absolute. thanks.  hi alexmartini, based on knowledge, not available format values in chart. how value displayed determined performance in table. can drag fields form list chart. so, if want display percentage value, need calculate in table first , add percentage column chart. if have question, please feel free ask. best regards, yuliana gu SQL Server  >  SQL Server Reporting Services, Power View

Un-Install Patches

i'm working installshield(windows installer service). i'm facing problem while un-installing upadate.  does can explain how 'windows installer' works internally when un-install update control panel. my actual problem update un-installation messing file installed , modified along installer. can me, there system property 'a custom action should not execute while un-installing'. i have tried 'notinstalled'in installexec condition. not helped me in solving problem. i'm fine if can acheive solution adding custom values registry/property manager. thanks in advance sesha sayana reddy v Archived Forums A-B  >  Archived: Software Testing Discussion

How to check of SignalApplicationLoadComplete has been raised

is there way check if (automatic) event signalapplicationloadcomplete has been raised after application innitialized? this can handy if want use "usernotifications.requestnotification" works when signalapplicationloadcomplete has been raised. if use usernotifications before signalapplicationloadcomplete has been raised exception. ps: isloaded , isinnitialized on surfacewindow isn't solution! i'm not sure how check if has been fired, can signal completion using applicationlauncher .signalapplicationloadcomplete you can of course more initialization after signal, e.g. loading data in second thread or that. signalapplicationloadcomplete event merely tells shell application run expected (and won't abort because of missing data or something).   hope helps.   bye, -- bart roozendaal, sevensteps "toine db" schreef in bericht news:a465df0a-ba54-45e5-8dce-58ef3a390a16 ... is there way check if (automatic) event signalap

Interactive Maps in SSRS 2008 R2 or Report Builder 3.0

does know if it's possible use new map feature in conjunction tablix or other report object can click state on map , have filter table/matrix/object in same report?   hi tober79, thanks post. yes, can it. can take use of go report action realize it. please refer steps below: 1. add parameter(name state ) report, bind filter of tablix in report. 2. double click map control, map layers panel appears. 3. in map layers panel, click down icon of relevant polygon layer (which used present state area), select polygon properties. 4. switch action tab, check go report item, specify current report name in report textbox. 5. click add add parameter pass relevant field value parameter state . 6. click ok finish. thanks, bill lu please remember mark replies answers if , unmark them if provide no help. SQL Server  > 

SQL Server Profiler Error while login

Image
it's fresh install of sql server 2008 r2 trial on local development machine , i'm able connect server through sql server management studio. when tried connect server through sql server profiler got following error: title: connect server cannot connect myserver. additional information: the initialization string specified not conform specificiation (pfutil) buttons: ok please me out. kind of appreciated. in advance hi zubarik, we need collect more error logs , post them in forum analysis. there proposes troubleshooting problems, can refer them. 1. please install latest service pack current sql server instance. 2. try connect instance via remote sql server profiler. if issue disappears. sql server profiler may corrupted. need re-install it. there details viewing error logs, can refer them. http://msdn.microsoft.com/en-us/library/ms187109.aspx thanks, sofiya li sofiya li technet community support

Problem with multiple file upload control

hi all,         have silverlight file upload control embeeded in webform. problem when try upload making postback save data on page making postback before file upload control uploads images. need postback after file upload control finishes upload. how can provide time delay? thanks rishi ok no problem use code file uploading , return message box uploded on ok click page postback, please handle dialog result well. sample code: using system; using system.collections.generic; using system.io; using system.linq; using system.net; using system.text; using system.threading; using system.windows; using system.windows.controls; using system.windows.documents; using system.windows.input; using system.windows.media; using system.windows.media.animation; using system.windows.shapes; using system.xml; namespace simplefileupload { public partial class mainpage : usercontrol { /// <summary> /// chunk size in bytes: file uploaded in blocks of th

Failure audit

heya. i've been using tfs 2 years , haven't noticed problems. other day had in event log of server, , entry appears every , then:     failure audit 2007-09-30 18:48:50 mssqlserver (4) 18456 tfsservice teamsystem   more info: event type: failure audit event source: mssqlserver event category: (4) event id: 18456 date:  2007-09-03 time:  18:48:50 user:  comp\tfsservice computer: teamsystem description: login failed user 'comp\tfsservice'. [client: 172.31.201.106] for more information, see , support center @ http://go.microsoft.com/fwlink/events.asp . data: 0000: 18 48 00 00 0e 00 00 00   .h...... 0008: 0b 00 00 00 54 00 45 00   ....t.e. 0010: 41 00 4d 00 53 00 59 00   a.m.s.y. 0018: 53 00 54 00 45 00 4d 00   s.t.e.m. 0020: 00 00 07 00 00 00 6d 00   ......m. 0028: 61 00 73 00 74 00 65 00   a.s.t.e. 0030: 72 00 00 00               r...        any ideas can be?   cheers, /chris refer following blog understand more "login failed" (error 1

CREATE DATABASE permission denied in database 'master'.......help!!

i taking asp.net class , our network configuration thin-client architecture (thin client systems connected massive server storage , virtual profiles).  when try create database in vs 2010 web site, message... create database permission denied in database 'master'. the server trying log in to, using windows authentication, (server name)\sqlexpress.  ideas on how can work around students in the class (i'm professor's ta :) ) allowed create databases in vs? only members of "sysadmin" or "dbcreator" system role, can create databases.  sounds account not authorized.  contact system administrator.   SQL Server  >  SQL Server Database Engine

BUG? Shared Datasource Connection String Gets Wiped Out

any time make change report's main query or of datasource properties (not shared), another shared datasource's connection string gets wiped out. have go datasource's connection string, edit, , "ok" out recommitt there. has else experienced this? pain in butt. john "a bus station bus stops. train station train stops. on desk have workstation..." this redundant thread. please refer to: http://social.technet.microsoft.com/forums/en-us/sqlreportingservices/thread/ac1e93ee-970b-4969-84cf-79d5a9fa96ea "a bus station bus stops. train station train stops. on desk have workstation..." SQL Server  >  SQL Server Reporting Services, Power View

SQL Performance reports

hi, we have windows server 2008 r2 std, sql server 2008 r2 sp2 cu 0. 32gb memory , 2x2ghz 16cores. we can see sqlservr.exe taking memory, , guess ok since have not configured restrictions, , sql take needs. the customer has issues application, "hangs" times, , wondering if related sql server. there performance report or other performance files can give customer can show application provider, because dont think sql server bootleneck. we have not applied cumulative updates since have not had spesific issues. thanks reply. /regards andreas hello andreas, in ssms there "performance reports" available: right mouse click on server node => "reports" => "standard reports" olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  Gettin

Storing Areas, Iterations, Query parameters in Config file

  we have custom reports uses areas, iteration paths, query parameters, report parameters. problem whenever add/modify areas , iteration paths need manually change reports query reflect change. there way store these values in separate config file or whereelse , avoid hardcoding these values in query? thanks, srikanth   hi srikanth, in out of box reports ship, report parameters area , iteration, use queries return areas , iterations in particular team project.  can similar? can describe why need hardcode areas , iteration? thanks, mauli Archived Forums V  >  Team Foundation Server - Reporting & Warehouse

Unable to create subscriber from backup. Error returned is, "Please create a master key in the database or open master key in session before performing this operation."

hello, i had 1 of our system administrators report issue me when using 1 of our documents on rebuilding replication 1 of our products (we create subscriber database backup). here full error returned: "sql server not create subscription subscriber '<subscriber name>'. please create master key in database or open master key in session before performing operation.  microsoft sql server, error 15581." any ideas on caused or how diagnose issue, or fix it?  thanks. obviously database backup encrypted or uses tde. follow instructions here more info on how this. http://stackoverflow.com/questions/209927/sql-server-2005-restoring-an-encrypted-db-on-a-different-server 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

reporting services is running but cannot connect

infrastructure people did maintenance on sql server machine, although not sure if has problem. problem is, have database engine , reporting services turned on, cannot connect reporting services. here symtoms. from client machine, can connect database engine using mgmt studio. using same server name, not able connect reporting services. error says title: connect server ------------------------------ cannot connect nysrv126,2433. ------------------------------ additional information: machine not found (microsoft.sqlserver.management.ui.rsclient) ------------------------------ buttons: ok ------------------------------ "nysrv126,2433" server name , same server name able use connect database engine.   next, on server machine itself, same symtoms above in mgmt studio. is, can connect database engine not reporting services. however, am able open reporting services configuration manager (which means connected reporting

How do you call a method inside that same method???

this code: private sub expandalltreeviewitems(currenttreeviewitem treeviewitem) if not currenttreeviewitem.isexpanded then currenttreeviewitem.isexpanded = true currenttreeviewitem.dispatcher.begininvoke(function() expandalltreeviewitems(currenttreeviewitem)) else integer = 0 currenttreeviewitem.items.count - 1 dim child treeviewitem = directcast(currenttreeviewitem.itemcontainergenerator.containerfromindex(i), treeviewitem) expandalltreeviewitems(child) next end if end sub this troubled line: currenttreeviewitem.dispatcher.begininvoke(function() expandalltreeviewitems(currenttreeviewitem)) when try use throws error saying "expression not produce value" can please tell me doing wrong. thank you hi, you try use recursion. recursion occurs when method calls itself. recursive functions need special stop conditions. otherwise infinitely continue calling themselves. byref keyword, provide way stop recursive function. for more information

Using WCF Data Services (REST based) as a data source

guys, can point me definitive microsoft map reporting services going regarding using wcf data services (ado.net data services, astoria) data source? there's bits of fragmented info out there, creating custom data providers, some sort of extension enable connection azure storage layer (exposed rest data service believe) , connecting latest versions of sharepoint (again, sharepoint exposing data rest service?), there doesn't seem sort of unified vision regards reporting on rest services (i'm particularly interested in wcf data services). have missed portal or somewhere? what's story these 2 technologies? SQL Server  >  SQL Server Reporting Services, Power View

Can I write my own snippets?

Image
hi, i'm liking insert snippet feature in ssdt i'd add own snippets. there way that? tia jamie objectstoragehelper<t> – winrt utility windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | me you can insert them in documents\visual studio 201x\code snippets\sql_ssdt\my code snippets folder for example copy 1 https://dl.dropbox.com/u/20239263/sqlproj/samples/create%20extended%20property.zip they show like: i using http://snippetdesigner.codeplex.com/ design/edit snippet then import using tools\code snippet manager, note descriptive language name :) the stock ssdt snippets in c:\program files (x86)\microsoft visual studio 10.0\common7\ide\extensions\microsoft\sqleditor\snippets\<lcid>\... hope helps, -gertd -gertd @ www.sqlproj.com SQL Server  > 

Database and Log File Size is Growing Very Fast!!!

hi guys, i have database runs on sql server 2012 , noticed size increasing drastically. size of log file on 3x size of data file. please can me on before database crashes. thanks me hi for data file growth , please check transactions running using below -- -- -- -- -- -- --current running transaction -- -- -- -- -- -- -- -- -- -- use master select spid,er.percent_complete, cast(((datediff(s,start_time,getdate()))/3600) varchar) + ' hour(s), ' + cast((datediff(s,start_time,getdate())%3600)/60 varchar) + 'min, ' + cast((datediff(s,start_time,getdate())%60) varchar) + ' sec' running_time, cast((estimated_completion_time/3600000) varchar) + ' hour(s), ' + cast((estimated_completion_time %3600000)/60000 varchar) + 'min, ' + cast((estimated_completion_time %60000)/1000 varchar) + ' sec' est_time_to_go, dateadd(second,estimated_completion_time/1000, getdate()) est_completion_time, er.command,er.blocking_session_id, sp.dbid,last

Problem in creating KPI...

hi, facing problem in creating kpi. kpi details follows, associated measure group: fact target value expression: [measures].[target %] goal expression: case when ( ([dim priority].[hierarchy].currentmember [dim priority].[hierarchy].[priority].&[low]) , ([dim vertical].[hierarchy].currentmember [dim vertical].[vertical hierarchy].[vertical category].&[voice]) , ([dim service].[hierarchy].currentmember [dim service].[service hierarchy].[service category].&[workstation support]) ) 0.75 when ( ([dim priority].[hierarchy].currentmember [dim priority].[hierarchy].[priority].&[low]) , ([dim vertical].[hierarchy].currentmember [dim vertical].[vertical hierarchy].[vertical category].&[non-voice]) , ([dim service].[hierarchy].currentmember [dim service].[service hierarchy].[service category].&[workstation support]) ) 0.75 when ( ([dim priority].[hierarchy].currentmember [dim priority].[hierarchy].[priority].&[medium]) , ([dim

Merge of Loc PRI file failed calling makepri.exe: '0x80073B08'

1>  multilingual app toolkit build started. 1>  merge of loc pri file failed calling makepri.exe: '0x80073b08' 1>  multilingual app toolkit build completed errors. i can't seem able find information on , tried add localization support described here: http://channel9.msdn.com/posts/build-multi-language-apps-using-the-multilingual-app-toolkit any ideas? this error code indicates (localized) resource add attempted, source resource not in pri file. 3 conditions discovered can cause condition resources. a duplicate resource exists in resjson file. javascript example: "cancel" : "cancel" "cancel" : "cancel" <-- duplicate resource a resource id conflicts different resource same base path information. javascript example: "about" : "about title" "about/okbtn" : "ok". <-- resource path same previous resource's id xaml example: mybutton : &quo

Visual Studio 2008 XP vs Vista

hello,   i'm having trouble moving programs visual studio 2008 (post release) on xp vs2008 on vista.   i created windows mobile application on vs2005 (xp machine). recently, upgraded vs2008. app seems have converted well.   i got vista machine. installed vs2008 along with mobile development needs such mobile 5.0 sdk. went open the solution , got message, "xml document must have top level element". same thing happened project file.   i created sample program had same issue. able overcome problem starting new mobile project on new machine , importing of objects. however, program transfer larger production application , i'm dubious re-creating it, importing elements.   the main problem appears xp vs vista.    secondary how such error messages generated. there no indication of xml file being read when error raised, , there lots of xml files sift through.   where post this?   thanks! hi phil.   i don't think you're looking @

Where do I get development tools?

first, read the getting started section of metro style apps website. then, you can down  can load development tools here . dan reagan | microsoft | windows developer preview support Archived Forums T-U  >  Tools for Windows Store apps (archived)

Error in import\export packages when the package sceduled through sql agent

hi all, we have got db cloud server(public ip) in data must pushed on daily basis our internal db server.  when using import\export wizard or ssdt task it working fine, same when creating ssis package in import wizard , scheduling through agent it throwing below error. ''  code: 0xc0016016     source: package      description: failed decrypt protected xml node "dts:password" error 0x8009000b "key not valid use in specified state.". may not authorized access information. error occurs when there cryptographic error. verify correct key available.  end error  error: 2015-05-02 12:29:34.53     code: 0xc0016016     source: package      description: failed decrypt protected xml node "dts:password" error 0x8009000b "key not valid use in specified state.". may not authorized access information. error occurs when there cryptographic error. verify correct key available.  end error  error: 2015-05-02 12:29:34.58     code: 0xc0202009     s

may have some orphaned logins..Deny not working

i have user 'domain\john' can logon sql server today . know belongs few groups has database reader/writer access don't see him belong sysadmin related groups.. i wondering if there created while may still sticking around.. tried deny access login can still logon. using sql 2005.. don't know how track down although looked @ other groups have sysadmin role , not exist there.. did mention few years ago, domain admins.. anyways, cannot seem him denied access sql server... :-( anything can run/do check may going wrong ? hi, you try using xp_logininfo find users permission path, i.e. xp_logininfo 'domain\user' do still have builtin\administrators part of sysadmin fixed server role?  is local administrator on server, or member of domain group that's in servers' local administrator group?  this give him sysadmin rights.  thanks, andrew bainbridge sql server dba please click " propose answer " if post solves problem, or " vo

msdtc cluster problem

i have 2 server cluster,two server os windows 2003 server sp2 i use dtcping tool ,the result ok no problem,log that log test client:yhgbl2 start dtc connection test remote host meijiwei meijiwei resolved 192.168.1.222 ip address traced meijiwei invoking rpc method on meijiwei rpc test successful partner's cid:df08273f-e71e-429a-9f9e-23076ed7bb80 yhgbl2 initiating dtc binding test.... test guid:9670e177-ec88-44ec-9e24-06ce5c3c38a3 trying bind meijiwei received reverse bind call partner:meijiwei binding call meijiwei succeeded client session yhgbl2 initiating dtc poking test.... test guid:83b0efe6-64ac-4702-b463-4dbf6fbc1e86 received bind call partner: meijiwei trying reverse bind meijiwei... yhgbl2 reversing binding succeeded client session yhgbl2 initiated poking test succeeded yhgbl2 1 server name,another server name yhgbg1 my machinename meijiwei but when use dtctester tool .it reutrn error sqlstate=25s12,native error=-2147168242,msg='[microsoft][odbc sql ser

Problems with Tfs service(tfs.visualstudio.com)

Image
my situation this: i have created project(myproject.visualstudio.com) @ tfs.visualstudio.com outlook-accoun( accountname@outlook.com). it works connect tfs service clicking  "open new instance of visual studio" in tfs-portal @ job laptop, not work @ laptop @ home. setup identical same ie(9.0.8112.16421) , vs2012 rc.  the exact error message this: "tf30063: not authorized access " https://myproject.visualstudio.com/defaultcollection". the concept of tfs in azure awesome kind of input solve issue appreciated! martin, after configure connection pictured above , click ok, microsoft account login screen should appear (see below). it? if not, please try clearing ie temp internet files , vs cache follows , let me know happens: fix 1: delete tf service cookie   1.   close browser instances, live messenger instances, skydrive, live mesh, or else signed in microsoft account (formerly "live id"). 2.   open internet explorer , vis

Hierarchical Data on RIA Services

hello all, i have followed article " business apps example silverlight 3 rtm , .net ria services july update: part 21: hierarchical data ", brad abrams, i'm still facing dificulties in perfoming simple task in application. i have generated domain service class entities (using entity framework). change 1 of automatically generated services include navigation property:   public iqueryable<productionorder> getproductionorders() { return this .objectcontext.productionorders.include( "repositorypieces" ); }     in adition, included [include] atribute in repositorypieces property of produtionorder metadata information. tested method in silverlight application , working. have productionorders retrieved repositorypieces included. problem created custom method (in same domain service class) declared as:   [invoke] public productionorder getfirstproductionorder() { return this .objectcontext.p

Package calling other package and passing back the control to calling package

Image
i have loop through n number of package master package, idea how implement this? master package calling child package in each loop , here need loop through n no or rec table , each record needs call child package , return control calling pkg.. need till end of records in table. child package1 -- called perform task , return control master package child package2 -- called perform task , return control master package child package n -- called perform task , return control master package thanks neil something this? http://microsoft-ssis.blogspot.com/2013/01/master-child-packages-part-1-file-based.html please mark post answered if answers question | ssis blog: http://microsoft-ssis.blogspot.com | twitter SQL Server  >  SQL Server Integration Services

Changing SQL service account to AD service account from default broke sharepoint?

we have sql 2012 instance has been running under default account.  i changed ad service account give sql permissions remote share backups.  when did downed sharepoint site. this operation can performed on computer joined server farm users have permissions in sql server read configuration database. so had change virtual account.  anyone have idea why? - before changing account, grant sql server permissions (sysadmin) - use "sql server configuration manager" change service account , never windows service manager; tool isn't aware of required permissions new account. olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Application and Multi-Server Management