Lun

the installer says "setup interrupted before microsoft sql server 2008 r2 reporting services add-in sharepoint 2010 products installed." log file shows following error message: 2011-05-09 16:08:42: adding reportserver feature farm. 2011-05-09 16:08:42: install error: update conflict has occurred, , must re-try action. object sprsdiagnosticsservice updated xxxx\administrator, in powershell (4644) process, on machine xxxx.  view tracing log more information conflict. 2011-05-09 16:08:42: error details: microsoft.sharepoint.administration.spupdatedconcurrencyexception: update conflict has occurred, , must re-try action. object sprsdiagnosticsservice updated xxxx\administrator, in powershell (4644) process, on machine xxxx.  view tracing log more information conflict. i don't know tracing log error message referring to. hi oppodigital, through error information have provided, issue occurs if contents of file system cache on front-end servers newer conte

hi all, i have got 1 big rack server hp dl 580 g7 equipped follows: 4x intel® xeon® processor e7-4830 ( http://ark.intel.com/id/products/53676/intel-xeon-processor-e7-4830-24m-cache-2_13-ghz-6_40-gts-intel-qpi ) 256 gb ddr3 ram 2x fc hba connected ultrafast violin memory array ( http://www.violin-memory.com/products/6000-flash-memory-array/ ) i'm going install sql server 2012 standard edition sp1 consolidate existing old sql server 2005 - 2008 r2 enterprise databases. how can ensure above hardware specification can utilized in full accommodates 90-100+ database single box ? can deploy 4x named instance of sql server database standard ? /* server support specialist */ hello, there few things think before stepping production: 1. hbas rated bandwidth? how compare violin rated bandwidth? 2. how hbas setup? how mpio driver configured hbas? 3. maximum throughput of processors , memory? how compare hba throughput , storage throughput? 4. tested amount of bandwidt

the error says, "the feature trying use on cd-rom or other removable disk not available. insert 'microsoft silverlight' disk , click ok" didn't put on cd. it's looking silverlight.msi file (i guess current version?) , don't think have that. or of sort. in case can me this? (i have version 4.0.50917.0 right now) also, i've seen reports windows installer cleanup utility fixes problem, microsoft retired because damaged office 2007. know if damage office 2010 well? because that's not wanna do... hi, please try uninstall silverlight in "unistall or change program" of control panel. and reinstall silverlight client. Silverlight  >  Silverlight Installation and Setup

visual studio 2008 r2 added. @ point i'm using preview (undeployed reports). while can set parameter when user has supply value report parameter, not @ clear how set defaults (and expect them work) when setting available values populated dataset--with or without multiple values. have seen suggestion use pick-list dataset way populate default values list not work. i understand how create query can accept "all" alternative input parameter return rows product, shouldn't able selectively choose list of valid parameter values adding them values in list of defaults?   __________________________________________________________________ william vaughn mentor, consultant, trainer, mvp http://betav.com http://betav.com/blog/billva http://www.hitchhikerguides.net “hitchhiker’s guide visual studio , sql server (7th edition)” please click mark answer button if post solves problem! hi william, in report parameter default page, can't preview dataset

 how can set usercontrol's template in xaml, xaml this: <usercontrol x:class="silverlightdemo.usercontrols.testcontrol"     xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"     xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"     xmlns:local="silverlightdemo.usercontrols"     xmlns:vsm="clr-namespace:system.windows;assembly=system.windows"     width="400" height="300">     <usercontrol.template>         <controltemplate targettype="local:testcontrol">             <grid x:name="layoutroot" background="white">                 <vsm:visualstatemanager.visualstategroups>                     <vsm:visualstategroup x:name="commonstates">                         <vsm:visualstate x:name="mouseover">                             <storyboard>                                 <

hi ., i used  http://forums.silverlight.net/forums/p/77080/411698.aspx#411698  steps generate deepzoom images., filename.xml & filename(folder(contains 10 sub folder of sliced images)) i want display files  using silverlight.,  i not in silverlight., can u post page.xaml, page.xaml.cs display  stored images in (filename.xml & filename(folder(contains 10 sub folder of sliced images))) plz reply ., may others      displaying deepzoom content uses multiscaleimage control. simplest way use download deep zoom composer , let generate deepzoom project player, if use classic template or behaviours template option available generate vs project source code can learn how use it, or customize project use generated deepzoom content. can check excellent tutorials wilfred pinto deepzoom http://projectsilverlight.blogspot.com/search/label/deep%20zoom Silverlight

i have 2 problems in example below. 1. can't seem twoway binding on datagrid observablecollection (or binding matter). denoted in code comments. 2. can see, move thumb, have manually update rectangle's position, linesegment's point, , corresponding pointlist's point. i've been trying apply databinding automatically tie these values together, can't seem working. example hard-coded, have dynamic example 1000s of points on slow side. hope databinding speed on manual updating of points.  going first problem, when x or y value changed in datagrid, need linked/databound objects update.. need thumb move, pointlist update, , segment move. is possible? can show me how link of these manual updates can rest? thanks. < usercontrol xmlns : my ="clr-namespace:system.windows.controls;assembly=system.windows.controls.data" x : class ="layouttests.hittestandscale" xmlns = http://schemas.microsoft.com/winfx/2006/xaml/presentation x

hi, does knows how correctly open multidimensional model in ssas excel power view report?  i continuously getting error message when open power view report.  "sorry, went wrong while loading model item or data source 'pc01-4300095 sales cube'. verify connection information correct , have permissions access data source." any advise appreciated. thanks, dilwyn i believe need ssas @ least sql 2012 sp1 cu4 on server side , excel 2016 on client side work. excel 2013 power view cannot connect multi-dim cubes. http://darren.gosbell.com - please mark correct answers SQL Server  >  SQL Server Analysis Services

i use domain service encapsulate business logic classes rather linq sql or ef model. know possible i.e. service needs implement domainservice, problem none of business logic classes have public constructors, instead instantiated using factory pattern, e.g. customer customer = customerfactory.factory.createnew()  this means cannot write the following service, public salesservice : domainservice { public void ienumerable<customer> getcustomer() { ... } } does have ideas how can resolved? thoughts write proxy / wrapper classes every class want surface. thanks there's factory class domainservices in framework. don't remember off top of head. think take @ repository sample example ( http://code.msdn.microsoft.com/riaservices ). kyle Silverlight  > 

i have below code in silverlight application , want query statement [insert customer values ("new customer name")] from the wcf class insert method created, show below linq insertonsubmit(). anyway way can achieve that?  i understand can use datacontext.log = console.out to display statement. want statement as string , insert table keep log. action apply update , delete well. any advices? thanks in advance. customer _obj = new db.customer(). db = new linqdatacontext(); _obj.name = "new customer name"; db.customers.insertonsubmit(_obj); db.customers.context.submitchanges(); hi, there no way can sql query form wcf silverlight , can data queried. you can try pass sql statement in wcf. you can try this: http://msdn.microsoft.com/en-us/library/ff422034(v=vs.91).aspx best regards, we trying better understand customer views on social support experience, participation in interview project appreciated if have time.

i have table following data (id, date , time) 11 2015/8/1 12:20:00 1 1 2015/8/1 12:21:00 1 1 2015/8/1 18:05:20 12 2015/8/1 11:20:00 12 2015/8/1 11:21:00 12 2015/8/1 18:10:20 i need table following record only (id, date , time) 11 2015/8/1 12:20:00 1 1 2015/8/1 18:05:20 12 2015/8/1 11:20:00 12 2015/8/1 18:10:20 any suggestion anywhere me  hi navaraj, according thread title, in case, rows time less 2 minutes later previous row should excluded each id , date, right? please see below sample. stefan data. declare @sample table ( id int , [date] date , [time] time ); insert @sample values ( 11, '2015/8/1', '12:20:00' ), ( 11, '2015/8/1', '12:21:00' ), ( 11, '2015/8/1', '18:05:20' ), ( 12, '2015/8/1', '11:20:00' ), ( 12, '2015/8/1', '11:21:00' ), ( 12, '2015/8/

    know variable "max_memory_percent" control size of resource pool. document says " max_memory_percent  specifies total server memory can used requests in resource pool."( http://msdn.microsoft.com/en-us/library/bb895329.aspx ).    my question  that "the total server memory" mean total memory of os ? if yes, resource pool may consume 100 percent of total os memory, may larger buffer pool.  actually, never happens.  when watch memory size of sqlsrver process showed windows task manager,  i find littler bigger sqlserver buffer pool .  but can't figure out is.    there dmv view "dm_exec_query_resource_semaphores", column  total_memory_kb describes memory held resource semaphore in kilobytes. has relation max_memory_percent ?     application reports "there insufficient system memory in resource pool 'respool' run query". there way calculate m aximum query memory?   it execution memory grant memory, @ pla

just confirm need run sql 2005 sp2 on passive node. passive node should rebooted.   it depends on. because sql engine , are cluster-components, but passive node may have other non-cluster-components such reporting services and tools. when apply sp2 on active node, if choose components, 1. sp2 applied on components on the active nodes. 2. sp2 applied on cluster-components on passive node including depending components such snac, sqlxml4, msxml6, etc. 3. sp2 not be applied on other components on passive node. so if want sp2 applied on other components on passive node, need apply sp2 separately.   SQL Server  >  SQL Server Setup & Upgrade

i'm trying connect sql server mobile report publisher to reporting services in sql 2016? i'm having problems configuring work with. can comments me out? first, have local machine have sql installed on. second, configured reporting services , assigned weburl ip address. tested link , can reach this: desktop-77f1pe9/reportserver_sql2016devdb - / microsoft sql server reporting services version 13.0.1601.5 now, i've started ssmrp cannot connect. has connected locally make work? i have wide world imports db want connect make work ssmrp keep missing something. can tell me url should here? maybe better question. add user account authenticate? SQL Server  >  SQL Server Reporting Services, Power View

hi   silverlight application.   stored procedure return values below  statscount                   date                columnheader      rowheader          234                               2011--3-19             businesscords                 domestic   1244                           2011--3-19             profit corps                       domestic   214                             2011--3-19             llc's                                domestic   234                             2011--3-19             business corps               foreign   324                             2011--3-19             profit cors                        foreign   1444                           2011--3-19             llc's                                foreign   have bind above results silverlight datagrid pivot table below                               business corps         profit corps         llc's  domestic                 234                  

i trying calculate total price invoice. i have following columns in tabix: purchaseordernumber, itemno, quantitiy, itemdescription, discount, unitprice, subtotal the subtotal column (textbox8 in tabix) takes consideration unit price, quantity , discount , calculate by: =(((((sum(fields!itemunitprice.value))/100) * (sum(fields!discount.value))) - (sum(fields!itemunitprice.value))) * (-1)) * (sum(fields!quantity.value)) i need calculate total of column. have tried =sum(reportitems!textbox8.value) this brings error: the value expression textrun 'textbox54.paragraphs[0].textruns[0]' uses aggregate function on a report item. aggregate functions can used on report items contained in page headers and footers.   is there anyway of calculating need without value been in footer? if not, '=sum(reportitems!textbox8.value)' work in footer? doesn't seem obvious how add one. if makes diffrence i'm using visual studio 2010, , creating windows form application.

hi, i use visual studio 2010 in combination team foundation server 2010 , power tools. in code files (e.g., .cs) can right click in editor , select "source control"->"annotate" additional column can see, last modified lines. doesn't seem work in mvc-views ( .cshtml). there limitation of file types in extension/function of power tools? or how can enable useful function text-based file types in visual studio? thanks :-) konrad hello konradmd, i sorry not have same issue yours on side. if open .cshtml file in editor, can have annotate node shown under source control node screenshot posted above. and if use vs connect tfs server, same result? think there may settings in vs causes kind of issue. please try reset vs settings see if helps: in vs->tools->import , export settings->reset settings. thanks. vicky song [msft] msdn community support | feedback us

hi team, i doing ssis package development in local machine. have requirement send email output. i developing in local machine. possible configure smtp configuration in local system receive email in gmail? if yes, steps followed. br, shamsuddeen hi shamsudden, gmail not implement/support smtp communications, cannot that. but can  c heck commercial cozyroc  send mail task , part of ssis+ library. support gmail smtp. or can use ssis script task , configure email on there looks this  public static void main(string[] args)             {                 mailmessage mail = new mailmessage();                 //set addresses                 mail.from = new mailaddress("chandran.nr@gmail.com");                 mail.to.add("chandran.nr@gmail.com");                 //set content                 mail.subject = "this email";                 mail.body = "this body content of email.";                 //send message  

i trying max date lookup table , pass dax measure. throws following error: a function 'max' has been used in boolean expression used table filter expression. not allowed. here measure trying create. how can in dax without hard coding in date? =sumx(filter(raw_data, raw_data[filter_date]>=dateadd(max(act_rel_date_lookup[act_rel_date]),-12,month)) hi whalensdad you can use function lastdate.   example, query below gets last date has related 'reseller sales amount' data available. calculate( lastdate( dimdate[fulldatealternatekey] ), filter( factresellersales, factresellersales[salesamount] > 0 ) )   javier guillen http://javierguillen.wordpress.com/ SQL Server  >  Power Pivot

hi, i using windows 2008 server r2 , using sql 2012 evaluation version store database only. i don't  any  development on it. my question there problem in sql in future concerning expiry or something? work fine guys have installed said there won't problem if evaluation version. do need buy product key sql in case?? hello, when evaluation period has expired sql server stopps working; can't use longer. have uninstall or have purchase full license. olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Setup & Upgrade

did db migration approach (on same server) upgrade sql server 2008 r2 sql 2012. tfs had authentication errors db. opened tfs admin console on server. clicked on application tier, team project collection tfs archive first.  on general tab tried edit settings sql server database.  i had stop collection first.  i stopped collection, tested sql server connection because settings looked right. clicked ok. progress bar stating updating project collection properties on server has been running hour or so.    expected?   if not, should now? also, correct steps reconfigure database connection after sql server upgrade? my scenario install of sql 2012 on same server.  i backed dbs before beginning. i uninstalled sql 2008 r2. installed sql 2012.  attached dbs. tfs had issues db access. it repaired adding db access user tfs trying use access databases. Archived Forums V

  can point me ms best practices advise against installing non-sql-related applications on sql db server?  feel common sense have been asked justify direct statement microsoft.  help? i don't think find such statement microsoft. potentially alienate many isv's products might designed operate on 'only' server small organization might possess. in fact, microsoft's own windows small business server allows installing both sql server , exchange on a server domain controller , file server.   however, following 'rule of thumb' of adhere to: if data server 'mission critical' foolish try save few dollars @ potential cost of slower response, , or total disruption of server caused uses other data needs.   sql server designed use processors , memory on server. will, grudgingly, cede cpu cycles , memory demands placed on os other applications.   i have clients using virtural server (to isolate sql server) on multi-processor servers, other critical a

hi all, create function ufn_sample ( @name varchar (20) ) returns table as return ( declare @temp table ( id int identity (1,1), firstname varchar (20) ) declare @return varchar (5) insert into @temp values (@name) select * from @temp ); go any help? how fix error? regards, kumar try alter function ufn_sample ( @numberofcharacters int , @name varchar (20) ) returns table as return with remdups as ( select @name as firstname, cast ( left (@name, 1) as varchar ( max )) as firstnamewithoutdupes, 1 as position union all select firstname, firstnamewithoutdupes + case when substring (firstname, position , 1) = substring (firstname, position + 1, 1) then '' when substring (firstname, position + 1, 1) not like '[a-z]' then '' else substring (firstname, position + 1,

i want save record data while webcam record, don't know how implement it. shall use webservices? besides, raw data of record large, there way encode wmv or other format? should transfer byte[]? hi, please follow blog: http://blogs.msdn.com/b/innov8showcase/archive/2010/01/11/silverlight-4-how-to-capture-audio-and-video-from-a-web-cam.aspx http://zombiebob.blogspot.com/2010/08/large-file-upload-in-silverlight.html Silverlight  >  Hosting and Streaming with Silverlight

i have as  2005 cube (molap) updated incrementally on daily basis.  twice in last few weeks, cube has suddenly become corrupt.  the by-day aggregations previous days show incredibly large positive , negative numbers.  these numbers @ time entered cube accurate. as background, incremental update done via view , view calculating fields.  at point cube processed manually during am, , processing has not reported errors. any insight would appreciated. doug first try install sp1 for sql server 2005 , see if same happening. ( http://www.microsoft.com/downloads/details.aspx?familyid=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en ) if problem persists, please contact customer support , report the problem. edward. -- this posting provided "as is" no warranties, , confers no rights. SQL Server  > 

1. sql server 2014 support buffer pool ssd, if memory, still need buffer pool? 2. can put buffer pool ssd or non ssd, can have multiple buffer pools in sql2014? thanks. multiple buffer pools not supported in sql server 2014.what provide extension of buffer pool nonvolatile storage (usually ssd).  ssd used store clean-pages. if page needs read again, can read ssd. not replace buffer-pool. data/index page accesses done sql server read/modify data go thru buffer pool always. way think of buffer-pool extension l2 cache while buffer pool is  l1 cache. link here describes in great details http://technet.microsoft.com/en-us/library/dn133176(v=sql.120).aspx thanks sunil agarwal, sql server pm Archived Forums SN-SZ  >  SQL Server 2014 Database Engine (Pre-release)

hello, building data warehouse in sql-server 2012. olap analysis shall run in powerpivot (and maybe calculations).my source system ms dynamics nav 2009r2. in model want create 3 cubes sales, inventory, production, related each other. means, once enter plannning values sales amount, want inventory cube show me planed values of sales cube + reserve selected time period (days, month, years). in project before tried solve such problem usage of trigger directly write new dataset inventory cube, once new dataset entered in sales cube. bringing down performance. question: how can make cubes interactive? use 1 table sales, production , inventory values? there function allows me use start , end values inventory can used in scaleable olap analysis? thank help! regards jörg since these seem related, add these 1 cube, separate measure groups. plan 4th measure group. can have sort of calculated members using data.

what best way enumerate through projects within solution file? have program expects csproj file input , need run projects within particular solution. there public api reads solution files? i'd rather not create brittle solution reads solution file directly, when change in next version. jason camp, mcse, mcsd, mcdba, mcpd: web, mcad, mcsa, cissp, scsa hi jason   i think easiest approach create item group holds project files. , process each project file in custom task.   for example, if override aftercompileconfiuration this: < target  name = "aftercompileconfiguration" >   < itemgroup >   < myprojects  include = "$(solutionroot)\solutionname\**\*.csproj"   />   </ itemgroup >   < message  text = "myprojects=%(myprojects.identity)"   />   </ target >       then in build log, should able see paths of .csproj within solutionname. can replace message task here call ap

we have upgraded sql server 2005 2000.  have ms access application connects , links tables new sql server database.  users getting errors when creating records first time on subscriber databases.  have reseeded primary keys on tables no avail.  thing can think of may problem version of ado we're using reference in ms access application.  have reference ado 2.5 , don't know whether should using 2.8.  suggestions?  thank you. you should able use mdac 2.5 basic funtionality (otherwise , new features should use snac driver). sql server located on servers application installed ? sql server 2005 install mdac 2.8 installing 2.5 on version might casue error on server side not if installed on client side. hth, jens k. suessmeyer. --- http://www.sqlserver2005.de --- SQL Server  >  SQL Server Data A

hi there, we (my colleagues , me) using microsofts tfs service (https://tfs.visualstudio.com) our project. the scrumboard helpful missing specific column @ our task board. the states do, in progress , done @ moment (which standard guess). need state called "to test" ... how can add column our task board? best regards oliver hi oliver,  thanks post. as far know custom task board columns in tfs service not support @ time.  for scenario, suggest you submit suggestion user voice site at: http://visualstudio.uservoice.com/forums/121579-visual-studio . microsoft engineers evaluate them seriously. john qiao [msft] msdn community support | feedback us develop , promote apps in windows store please remember mark replies answers if , unmark them if provide no help. Archived Forums V  > 

В модуле пишу: using system.windows.browser; Компилятор выдает ошибку: type or namespace name 'browser' not exist in namespace 'system.windows' (are missing assembly reference?) Почему? У меня также есть ссылка и на system.windows. Может ли это как-то быть причиной? Версии сборок "system.windows" и "system.windows.browser" одинаковые - v2.0.50727 hi swz, if create new silverlight 4 project, error persist? if error happens on silverlight project, please try uninstall , reinstall silverlight sdk below link. http://www.microsoft.com/download/en/details.aspx?id=7335   best regards,   Silverlight  >  Programming Silverlight with .NET – General

hi all, in 1 of production server, faced 1 space issue. here issue the disk d on computer usdc8273sql2b.kih.kmart.com running out of disk space. values exceeded threshold 3% free space , 1331 free mbytes. but checked d drive , has lot of space   please me does relate sql server, see in error.log? best regards, uri dimant sql server mvp http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/ SQL Server  >  Getting started with SQL Server

i  have dataset has datatable having 2 columns i.e table( id string,value string) every single record in datatable represents answer particular question, id column being question identifier , value column  being answer , every question has answer being stored 7 days. now have designed report in form of grid like                      day1 answer, day2 answer, day3 answer............................day7 answer question 1  question 2 .. . . . . .question 40 i tried using lookup function in ssrs reporting service bind every single cell in report using data dataset like = lookup("question_identifier",questionid.value,answervalue.value,"mydataset"); the report working absolutely fine in report designer expected when take asp.net website have generate it, never shows , report couldn't found , make sure have published report kind of errors. i figured problem lookup function because removed lookup function expressions in report , report st

welcome sql server samples , community projects forum. forum place discuss things "samplish" in sql server community , samples space, whether it's "official microsoft sample" or community project in codeplex or code gallery. *not* place discussion specific nuances of t-sql syntax or wage data modeling methodology wars: there lots of other forums purposes. 1 questions samples, community projects , conversations between collaborators build them. some examples of projects open discussion can found here: http://www.codeplex.com/sqlserversamples . doesn't have listed there fair game, it's bet fair game if it's listed there. below few guidelines find answer , people answer questions, answer yours correctly. is question sql server samples , community projects . if it's not please locate correct forum otherwise question may moved, closed/locked or deleted. try searching forum . search forum see if question has been asked before , ans