Posts

Showing posts from February, 2014

dynamic "hotspots" on scrollviewer

i have simple xaml template: <scrollviewer name="vcilegacyscrollviewer" horizontalscrollbarvisibility="auto" verticalscrollbarvisibility="auto" horizontalalignment="stretch" verticalalignment="stretch" height="480" grid.columnspan="2" margin="0,0,12,0"> <image name="legacygraphicsimage" source="{binding backgroundimage}" stretch="uniform" imagefailed="legacygraphicsimage_imagefailed" height="480" width="640" /> <!-- </canvas> --> </scrollviewer> thing know @ runtime clickable "hotspots" be. so need add "mouseover" points @ runtime , define mouseover events @ runtime.

SSRS report PDF export is zoomed by default

Image
hi,      new ssrs. created report , previewed using preview tab.then,  exported report pdf , saved in pdf format in local drive. when opened pdf,by default opens in 137% zoom. can please tell me how can make small 70% or 100%. there settings? thanks in advance! hi vskindia, when exporting report in pdf format, there no option lets set zoom value. it’s controlled pdf reader using. supposing using acrobat reader, can control edit->preference->page display. more information exporting pdf file, please see: http://msdn.microsoft.com/en-us/library/dd255291.aspx if have questions, please feel free ask. regards, heidi duan heidi duan technet community support SQL Server  >  SQL Server Reporting Services, Power View

manifest.xml

i trying upload silverlight app @ web space provided microsoft. upload process complicated.  please explain done manifest.xml   thanks   i trying upload silverlight app @ web space provided microsoft. upload process complicated.  please explain done manifest.xml   thanks you need describe .js files in manifest.xml  read post thru upload process , manifest.xml style http://ankurkhetrapal.com/blog/?p=3   Silverlight  >  Hosting and Streaming with Silverlight

Unable to create silverlight project

i downloaded , installed silverlight 3 sdk , tools. installation successful. tried create new silverlight project , bang!!! showed me error popup saying "object reference not set instance of object". project creation failed. am using visual studio 2008 sp1 installed , xp operating system service pack 3. how rectify error? i try reinstalling silverlight 3 tools.  sounds did not install right  Silverlight  >  Getting Started with Silverlight

TFS2008: Dual Server Deployment Setup Error during installation of TFS

  i'm testing out tfs2008 on our hyper-v environment   i able successful setup single server deployment initial testing. when run through dual server deployment setup simulate our production setup encountered issue on system health check before running tfs sp1 itself.   here's current environment:   application tier: -windows 2008 ent x86 hyperv -iis 7.0 -sharepoint 3.0 sp1   database tier -windows 2008 ent x64 hyperv -iis 7.0 -sql 2005 ent + sp2 x64 - services installed   i did customizations thing reports point our database tier since db services must installed there.   when reach installation of tfs, saw error:   the system health check has detected problem cause setup fail.   description the sql server analysis services assemblies not installed on application tier.   workaround / remedy the sql server analysis services assemblies not installed on team foundation server applicaiton tier. must install them team foundation

Filter Mobile Report's Scorecard Grid by Time Navigator

Image
if add scorecard grid , time navigator mobile report, there option filter scorecard grid's data keys time navigator scorecard grid data column's values don't change when different time periods selected on time navigator. is there way make work? hi nigelstratton, from screenshot provided above, noticed specified simulatedfiltertable scorecard grid. while in table, there no such date/time column can filtered time navigator. in scenario, please change dataset simulatedtable. please pay attention below screenshot, section highlighted in red. if still have question, please feel free ask. thanks, yuliana gu 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 .

stuttering performance

hi installed sql express on 2003 sbs - installed fine - usual config of enabling tcpip etc. problem application (vb6 ado 2.8) intermittently fails open connection database. i'm pretty sure network connection not dropping out etc. it fails in startup of app - opens , closes quite few connections - have feeling not releasing connections pool ? we've installed many sql 2000 , sql 2005 clients , works fine.... i tried changing provider in connection string sqloledb sqlncli didn't @ all. the sbs server has 2 gig ram. i had install onto workstation temporary workaround - but  need working satisfactorily server.. any ideas ?  heeellpppp thanks bruce   hi bruce, could give specific error getting when connection fails? have pertinent section of error log occurance of failure. regards, mike wachal sql express team ---- check out tips getting answer faster , how ask question: http://forums.microsoft.com/msdn/showpost.aspx?postid=307712&siteid=1

Export failure from SQL to excel

hi, i trying export table excel following error (and if ignore error cuts content after 255 char): - validating (warning) <dir> <dir> messages </dir> </dir> warning 0x802092a7: data flow task 1: truncation may occur due inserting data data flow column "oneliner" length of 500 database column "oneliner" length of 255. (sql server import , export wizard) anyone has tips of how export data large amount of text in cells excel? would appreciated! sry if posted in wrong forum, did not know question belongs.. br, jennie to pass more 255 characters connection or sourcedata arguments, convert long string array. see if helps. https://support.microsoft.com/en-us/kb/105416?wa=wsignin1.0 another option export flat file. SQL Server  > 

How to store List of objects in ViewModel to display them in DataGrid?

the task pretty simple , i'm sure absolutely general - need display list of objects in datagrid. in more details: i have collection of "consoledata" objects (from trading software). each consoledata has read-only static fields (ticker) read-only dinamic fiels update every second (price) mutable static fields - strategy parameters. numbers static can changed user directly datagrid via command (stop loss) my implementation: public class overviewviewmodel { public observablecollection<consoledata> datalist { get; set; } public overviewviewmodel(iwcfmodel model) { this.datalist = new observablecollection<consoledata>(); model.dataarrived += new action<list<consoledata>>(model_dataarrived); } private void model_dataarrived(list<consoledata> datalist) { // every time receive fresh table - not changes, entire table datalis

sbs2003r2 sp1 w updates off (2007), added sql2008r2 (2010) - all good UNTIL - server updates turned on

now numerous sharepoint errors , amicus attorney database 2010pe malfunctioning (which installed embedded sql 2008r2)  the server updates turned off box isolated , no database involved @ time.  when sql added installers inadvertantly instructed server control updates of 7 attached pcs (no sus , pcs set update automatically on own).   problems arose when server updated , sus 3.0 installed allow server control updates of pcs.   skill level moderate knowledge of server install not of sql, sus or how 3 years of update patches , sus3.0 download may have impacted database application.   hi aofwal, could please elaborate on bit more? please post error messages have received? thanks, stephanie lv please remember mark replies answers if , unmark them if provide no help. SQL Server  >  SQL

do full text searches make sense for multi-word phrases?

suppose search word chaos in table has column of magazine articles.  interested in word "chaotic". so use inflection feature of full text search. but occurs me several words in a search-term used inflection feature, sql server would try inflecting every single word. for instance, "the sociopath next door" might "the sociopathic next door"  or "the sociopathic doors"  or whatever.  real issue? i don't have time research this, expect full-text apply inflexion rules, , suspect want in cases. why not test yourself? SQL Server  >  Getting started with SQL Server

multiplayer game on silverlight

hello! i trying make multiplayer game on silverlight have 1 problem - need run erver-side programm, track users , communicate silverlight through web services.... ive built web service , client-side app on silverlight, im thinking of how make server side app? can run on web server? kind of application should if want running on iis?   thanks help!  p.s: im sorry bad english... your english fine, dont worry it. you're talking socket application though (on server side - sockets server basic windows console application listens on pre-defined port). have @ these sample chat applications using silverlight. push chat messages client (same thing trying do) server. url 1: http://www.michielpost.nl/postdetail_7.aspx url 2:  pete brown -> explains more sockets in general. read! Silverlight  > 

SQL Express Connection string.

hi is there article out there explains why nedd put  "\sqlexpress" in connection string sqlexpress db. ( need show boss why ) .. sqlexpres installed named instance, named instances anme servername\instancename. jens k. suessmeyer. --- http://www.sqlserver2005.de --- SQL Server  >  SQL Server Express

Problem when creating a branch for a web site project

i created branch web site that's part of vb.net solution. let's call website mywebsite , branch called mywebsite-branch. removed original solution , added branch. in solution explorer have start web site mywebsite-branch. when run darn thing jquery errors '$' not defined. if change local folder name of mywebsite mywebsitex (for instance) , mywebsite-branch mywebsite, name appears in solution explorer , thing runs fine no errors. reason needs original name of web site project in solution explorer. if change name of local folders seems mess tfs! arghh! why computers dumb? how fix this? hi richiebabes, thanks post! when removed original website , added branch, have checked solution tfs server? every time make change solution, need check in server. when perform branch, local location same original web site? based on understanding, since solution added tfs, if make branch , add branch solution, need make the branch map same local location original web sit

Date in certain range indicator

Image
hi all, i've got date dimension ymd hierarchy want display on rows, , 3 measures want display on columns (see mdx below). is possible add attribute on rows indicates whether or not [dim date].[date ymd].[year].[month].currentmember intersects set [monthsselection]? with set [monthscurrentyear] as [dim date].[date ymd].[year].&[2016].&[3]. parent . children --comes from  parameter. set [monthsselection] as intersect ([dim date].[date ymd].[year].&[2016].&[3]. lag (2) : [dim date].[date ymd].[year].&[2016].&[3]. lag (-2)) --determine range. select { [measures].[measure1], [measures].[measure2], [measures].[measure3] } on columns , { [monthscurrentyear] } on rows from mycube thanks! haven't understood requirement. looking : with member measures.[monthsselection] count( intersect( [date].[calendar].currentmember,

Error with connecting to Sql Server 2012

hello ,    new sql server , trying access sql server .net web application. environment windows 8 , sql server  2012  the error message : network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: named pipes provider, error: 40 - not open connection sql server) i have tried of blog solutions not open sql server configuration tool in windows 8. sraven kumar kande are giving right server name in connection string? in under same domain? can post connection string values? -prashanth SQL Server  >  Getting started with SQL Server

Excel Data Schema Mismatch With Destination Table In SSIS

hello, i have folder csv files , excel files(excel files multiple sheets). say, every file's schema of format empid,empname,salary. i have destination table in sql server same schema empid,empname,salary. i comfortable in loading these files. problem may files different schema structure empname,departmentname. in case have identify files doesn't have same schema destination table , move these files folder called "schema mismatch files" , create table these dynamically , load these files. thank in advance. regards, sunil a. step 1 : retrieve excel schema (see linke how do  http://www.mssqltips.com/sqlservertip/1674/retrieve-excel-schema-using-sql-integration-services-ssis/ ) step 2.1 condition: if excel in correct schema 2. 1.1 load in static table with  same schema empid,empname,salary. step 2.2: if excel not in desired schema 2.2.1 create new table (execute sql task)  2.2.2 load data in newly created table and done. thanks , regards, pr

slow connectivity while connecting SQL through internet

***problem*** slow connectivity while connecting sql server through internet (tcp port) using vb6 program -           connecting database via vb 6 program : slow speed -           data entry : medium speed -           report generation : slow speed   ***server config*** -           intel core 2 duo, 2 gb ram, windows 2003 standard sp 2 -           sql server 2000 sp4 -           2 ethernet card. 1 connected broadband local network -           database size 2.5 gb -           internet: broadband 1mbps (upto 8 mbps)   ***client config*** -intel p4, 256 mb ram, win xp sp2 - internet: 256 kbps (upto 2 mbps) - there may 2 3 client connect simultaneously via internet , 20 clients connect through local net work   * web sites opening fast, downloading of other files fast, why sql connectivity slow???     if server has broadband 1mbps (or 8mbps) connection internet, issue.  numbers downstream traffic server.  in order data server has upload internet ,

Sql Express

hello   i have network running tcp/ip on 4 networked pc’s windows xp home. in network places can see server(windows xp pro)  and clients, have created a user account in login sections in sql management studio express , yet how access databases client computers   what setting need edit allow users connect server , databases?   what permissions need set o users? what shares should done? please can 1 assist me. please email me on ozzyrocsdbn@yahoo.com   regrads ozer   take @ following blog entry information on how configure express accept remote connections. http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx   cheers, dan SQL Server  >  SQL Server Tools

Parameters are not shown properly

Image
hello,  i'm having issue report's parameters when displayed in internet explorer. the report done reporting services, it's published in sharepoint. when open report using sharepoint url, report's parameters shown vertically, instead of horizontally. , last parameter being cut off, hidden under internet explorer's status bar. if open same report in firefox, parameter displayed since scroll bars appear in parameters area, allowing me scroll down , see parameter's content. is there way fix parameter's length it's displayed in internet explorer. noticed there resize box @ end of parameter, can't find way have control on it. any appreciated. thanks! hi monicanquiroga, by default, parameters shown vertically in parameters pane located on right of report page in sharepoint library. if there many parameters in report, there scroll bar enable scroll down last parameter. in scenario, seems parameter pane not shown property in ie browser

How to identify Silver Light data through Http response??

hi all, i want identify whether data, coming server http response, silver light application or not?? - noticed when http response, header field "server" contains "iis 7.0 iisms 3.0". can use "iisms 3.0" identify silver light data?? thanks in advance.. !!   thanks hi. there's no way of telling whether http response targeted @ silverlight application , ones not. the "server" header not suitable that; name says, expresses server, not client. "iisms" in case stands media services of iis, smooth streaming or similar. when @ official page , you'll see says right in first paragraph not targeted @ silverlight, other http clients well, not indicator there's silverlight client on other end. since silverlight explicitly built work web standards (web services etc.), random response inspect belong other sort of client too.  what particular scenario? maybe there's solution.

FYI: Create missing indices on foreign key columns

i asked how create indices on foreign key columns when don't exist. didn't found script, wrote one: declare @fk table ( constraint_name sysname , parent_name sysname , referenced_name sysname , parent_column_name sysname , referenced_column_name sysname ) ; insert into @fk select fk.name as constraint_name , t1.name as parent_name , t2.name as referenced_name , c1.name as parent_column_name , c2.name as referenced_column_name from sys.foreign_key_columns fkc inner join sys.foreign_keys fk on fk.object_id = fkc.constraint_object_id inner join sys.tables t1 on t1.object_id = fkc.parent_object_id inner join sys.tables t2 on t2.object_id = fkc.referenced_object_id inner join sys.columns c1 on c1.object_id = fkc.parent_object_id

Calculation automatic formatting removes ;

whenever go between script view , calculation view in cube, semicolon seems removed formulas. the string looks (pseudocode) create member currentcube .[measurename] as ' [measures].[measurename] / 100 --, --null ; --)' , format_string = '#,#0' ; what happens semicolon removed end of format string, results in processing error. has else encountered problem?  have similar problems auto-formatting functionality of reporting services queries.  there way disable these features? SQL Server  >  SQL Server Analysis Services

SSRS 2008 R2 3D Pie chart printing incorrectly

hi when printing 3d pie chart bids 2008 r2 or report manager, shadow not proportional pie slice. shadow prints rectangular block starting edge of pie slice - in other words, slice not have curved shadow , not 3 dimensional. however, can export pdf , print correctly there. has experienced problem before? idea causing , if there fix? hi al-meister, thank responding. in last post, tried reproduce issue again. however, worked fine me. if possible, please post dataset structure sample data , report(.rdl file) e-mail address above. way, please try use other printer print report in bids 2008 r2 or report manager. thanks, bin long   SQL Server  >  SQL Server Reporting Services, Power View

vNext build is unable to update workitem integrated in build field for specific branch(es) from team project(s)

hi all, i've powershell script below update workitem integrated in build field; however, pulling entire team project changes. want pull only change(s) branch(es) is/are mapping in the build workspace. here have. dev-build (tfs 2017 vnext build)     workspace mapping 2 different team projects $/teamprojecta/branch1/dev/src , $/teamprojectb/branch3/dev/src param( $username, $password ) $token = ("{0}:{1}" -f $username, $password) $tokenbytes = [system.text.encoding]::utf8.getbytes($token) $authorization = [system.convert]::tobase64string($tokenbytes) $headers = @{authorization=("basic {0}" -f $authorization)} [string] $collectionaddress = "$env:system_teamfoundationcollectionuri" [string] $project = "$env:system_teamproject" [string] $buildid = "$env:build_buildid" [string] $buildnumber = "$env:build_buildnumber" try { $workitemaddress = $collectionaddress + $project + "/_apis/b

Cannot connect to named instance of Analysis Services when SQL Browser is disabled

hi, unable connect named instances of analysis services on server. error message states sql browser service should enabled. but, catch here is, sql browser cannot enabled due security constraints (company policy). there work around same?? please help. thanks. hi, i found out can done defining static port specific instance of analysis services , connecting instance using connection string , specifying port number in connection string. the following blog gives more information regarding same. http://dinesql.blogspot.com/2009/08/connecting-to-analysis-services-with.html regards SQL Server  >  SQL Server Analysis Services

Converting a Silverlight 2 project to a Silverlight 3 Navigation Project

since i've justed spent >6 hours trying figure out, figured i'd give others heads up. if have silverlight 2 project sort of custom navigation, , you're trying implement new navigation functionality, need following in html page: < iframe id ="_sl_historyframe" style =" visibility : hidden ; height : 0px ; width : 0px ; border : 0px"></ iframe > without iframe, navigation functionality appears work, not integrate browser history. Silverlight  >  Programming Silverlight with .NET – General

TFS 2015 has no "Build even if nothing has changed"

i need schedule build run if there have been changes source code (i.e. new changeset). under "triggers" tab select "scheduled" , enter scheduled time there doesn't appear option avoid building if nothing has changed. has been moved or removed tfs 2015 (update 2)? @dwayne, have tried option continuous integration (ci) ? please use mark answer if post solved problem , use vote helpful if post useful. Archived Forums V  >  Team Foundation Server - Build and release management

Unit Test

how automate unit test,codecoverage in tfs , store result in shared location. hrmpg, apologixe previous reply, read message bit fast , mixed code coverage code analysis.   so, not necessary add runcodeanalysis property code coverage :-) , test run configurations has nothing code analys.   regardring vsmdi file: in tfs 2008 have 2 choices, either use test lists , specify which test lists run:   < metadatafile include = " $(buildprojectfolderpath)/helloworld/helloworld.vsmdi " >     < testlist > bvt1;bvt2 </ testlist > </ metadatafile >   , or use test container option, lets run test found in assemblies:   < testcontainer include = " $(outdir)\helloworldtests.dll " /> < testcontainer include = " $(solutionroot)\testproject\webtest1.webtest " /> < testcontainer include = " $(solutionroot)\testproject\loadtest1.loadtest " />   to code coverage, need specify confiogurat

WCF Web Service and Silverlight

i have few questions wcf web services , silverlight.   a) true if silverlight application uses wcf web service must wcf silverlight enabled web service? b) true wcf silverlight enabled web service must hosted in iis? c) if wcf silverlight enabled web service not have hosted in iis can hosted in self-hosting application? d) aspnetcompabilitymode have enabled wcf silverlight enabled web services work?   i have read on cannot seem concrete answers these questions.   thanks ian a) no.  can use wcf service supports of supported protocols listed on page http://msdn.microsoft.com/en-us/library/dd470110(vs.95).aspx  the silverlight enabled wcf service template makes easy create compatible service.   b) if silverlight app calls service different domain then app looks crossdomain.xml or clientaccesspolicy.xml file give silverlight app permission to use service.  difficult work windows service for example. http://www.dotnetcurry.com/showarticle.aspx?id=208&a

SSIS Package Stalls in SQL Server Agent

hi, i have package works fine in debug hangs 40% of time in sql server agent , have checked system resources seems fine, not writing disk, memory still available. this package consists of multiple joins, lookups, , other memory intensive processes. while pretty expensive process, work , confident have resources handle it. background info-- winserver 2003 sp1, 16core 1.22tb raid config 100gig ram server, running sql server 2008 (not r2), ssis , ssas in operates in single server environment, there no blocks on spid when queried, no system events, no error. thanks in advance ideas.   jon jamie, table lock , blocking first guess, after checking scheduled events query sys objects , etc i'm sure there's not type of conflict. i rediscovered package establishes multiple connections unix server. have dealt multiple connections , expensive queries ssis unix mysql in past. while commandtimeout set on ssis, have had unix server dropping seemingly dormant connections bec

#Error on expression

hi, here's problem simple solve, somehow can't figure out what's going on. my expression : =len(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre") -instrrev(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre"), ":")) my field's value : 18 janvier 2016      heure : 13:00 there's total of 34 caracters. i've tried split expression narrow down number of possible mistakes might have made. len(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre")))    returns 34 instrrev(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre"), ":")    returns 32 so, 34 - 32 should return 2, #error message. anyone has clue on one?? thank you. pat ok problem solved, seems can't subtract inside comas of len expression, did subtraction outside of comas, second parameter of "right" function. final result : =left(first(fields!daterendezv

Developing Apps for Microsoft Surface SDK 2.0 for Third-party Device

hello, we need write applications nui multiple simultaneous users. have following options: 1. opengl 2. microsoft surface sdk 3. microsoft windows 8.1 rt of above 3 options believe opengl can write programs, confused other two. with microsoft surface sdk 2.0 unable confirm can used third-party multitouch enabled devices windows 7/8 ready. , application run on windows 7 platform, or run on windows 8.x platform too? how able deploy microsoft surface sdk 2.0 application on third-party device? microsoft windows 8.1 rt support multitouch gestures can't find concrete on limitations of number of simultaneous touches. so on getting more info on writing microsoft sdk 2.0 application third-party devices. regards, dhrumil Other Forums  >  Surface Application Design and Developm

TFS 2013 - How to create a label with a Gated Build

we switched several of our builds on triggered gated check-in realize a build label not generated with build.   no problem say,  we can figure out.... not! even though label source build parameter set true vs. false , field active (not greyed out), the gated build not seem create label.  since "black boxed" can't seem override conditional logic prevents label generated. next... i looked at adding labelworkspace build.  seems option.  after build should have arguments needed execute labelworkspace.   again.... tfs 2013 "black box" here stuck trying figure out how generate label gated build.   i need command override conditional "do not create label" logic or a example showing me how best populate the workspace , scope parameters of build label.  can create own arguments and populate them but, creates more maintenance me.   hi spammy1970, for generating label gated build, might need customize build process template used in buidl definiti

MONEY column showing .0000 for value 0... Used to be 0.00, kinda

execute in sql server management tools: select cast(0 money) dollars; 0.00 result. receive php/mssl_* functions. sql server driver php .0000 annoying. can it? using v1.1 of driver w/sqlserver2008. affects display of returned in hundreds of stored procedures. use code see in php: $conn = sqlsrv_connect(...); $result = sqlsrv_query($conn, 'select cast(0 money) dollars;'); while($ar = sqlsrv_fetch_array($result, sqlsrv_fetch_assoc)) { print_r($ar); } not do. driver defines money data type decimal 4 digits @ right of decimal point. in line t-sql representation described at: http://msdn.microsoft.com/en-us/library/ms179882.aspx   thanks, serban serban iliescu - msft SQL Server  >  Microsoft Drivers for PHP for SQL Server

Best practice advise for structuring Team Projects in VSTS

hi, at risk of asking question has been asked many times before - i'm after current thinking following when using visual studio team services. have seen answers question elsewhere on web answers several years old , think product , opinions have possibly changed since then. in nutshell: in a small team of 20 working on variety of different project types (mobile, web, data, integration) recommended have multiple team projects in collection or 1 flat 1 area paths create necessary separation of work? we planning migrate on-prem tfs 2015 vsts. team project collection first created in tfs 2010 6 years ago , broken down 16 team projects our intranet, public web site, mobile app, systems integration solutions, etc. etc. years have found creates more problems solved there lot of code sharing between solutions (for example apis developed in systems integration needed in intranet). also, team set in tfs, under 1 team project deliver new integration , features in our intranet, ye

Creating a System.Management assembly in order for my own Assembly to work?

hi i bit paranoid did sql server 2005 clr experiment. i created class lib in c# called inlinelib has class queue represents object  id field. in separate namespace called inlineclrsql, i created class called test which hold function accessed db,  referenced , created instances of queue class, , retrieve it's id in function called printmessage . namespace inlineclrsql{ public static class test { public static void printmessage(){ inlinelib. queue q = new inlinelib. queue (); int = q.queueid ; microsoft.sqlserver.server. sqlcontext .pipe.send(i.tostring()); } } } to access db, attempted create assembley referencing inlineclrsql.dll . didn't work complained inlinelib assembly not existing in db. attempted create assembley for  inlinelib barfed saying  system.management assembly not created. so did ( and need know if ruined sql server or not): 1- alter database mydb set trustworthy on; . 2- create assembly systemmanagement

ROLAP, DSV and disparate data sources

hi all, we have come across peculiar issue using rolap has devastating effects on our performance. we sharding data across multiple sql instances (all same schema).  for example, have 3 servers , 3 partitions in our main fact measure group pointing 3 separate data sources. in our data source view, specify first server data source can correctly add tables etc.  in xmla data source, has "<datasourceid>server1</datasourceid>" when running mdx query hit these rolap partitions, actual sql query generated different.  without being specific, this: @param1 = '1' select sum([agg_1].[amount]) [agg_1], openrowset( ... ) [product] [agg_1].[productid] = [product].[productid] , [product].[categoryid] = @param1 select sum([agg_1].[amount]) [agg_1], openrowset( ... ) [product] [agg_1].[productid] = [product].[productid] group [product].[categoryid] the latter query being run on 2 other servers (the ones not referenced in data source view).  if

JDBC Statement.executeBatch mysteriously and intermittently fails on good SQL statements

hi everyone, i'm in middle of adding support our product sql 2005.  has been pretty simple except 1 thing jdbc statement.executebatch mysteriously failing.  changed my error handling such whenever part of batch fails (execute_failed) query gets re-run.  well, everytime re-run failed statment in new new statement object using statement.execute works! another characteristic of failure no matter if batch running 1  or 10 updates in batch, fail execute_failed , when re-run individually each succeed.  there no exception thrown.   has run this? netmon, we have fixed 2 batch related bugs, first 1 looks similar issue problem describing. possible test scenario our newly released june community tech preview? http://www.microsoft.com/downloads/details.aspx?familyid=f914793a-6fb4-475f-9537-b8fcb776befd&displaylang=en   for of issues resolved on drop take @ release.txt change list ships package, highlighting batching issues here: 428197 batch execution of prepared statements