Posts

Showing posts from June, 2011

Could not load file or assembly 'Microsoft.TeamFoundation.WorkItemTracking.Server.EventFilter

hi,   while monitoring team foundation server found out following warning in event viewer, can tell me how fix it?   thanks in advance jf   event type: warning event source: tfs services event category: none event id: 3012 date:  4/22/2007 time:  9:45:22 pm user:  n/a computer: xxxxxxxxx description: tf53010: unexpected condition has occurred in team foundation component. information contained here should made available site administrative staff. technical information (for administrative staff): date (utc): 4/23/2007 1:45:22 am machine: xxxxxxxx application domain: /lm/w3svc/3/root/services-2-128217663219687500 assembly: microsoft.teamfoundation.server, version=8.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a; v2.0.50727 process details:   process name: w3wp   process id: 2180   thread id: 2552   account name: xxxxxxxx\tfsservice detailed message: not load file or assembly 'microsoft.teamfoundation.workitemtracking.server.eventfilter' or 1 of dependenci

SSAS 2005 repository and and databases

hello, i creating installer need know ssas instance on network , once server selected need show available databases on server. similar sql server authentication dialogue box get. has come through scenario or aware of direction on this? ssas repository located on box(i guess should have name of database /metadata somewhere.   any appreciated. thanks, siaj   siaj wrote: hello, i creating installer need know ssas instance on network , once server selected need show available databases on server. similar sql server authentication dialogue box get. has come through scenario or aware of direction on this? i not aware of api let scan ssas server, there may in smo library or be that sql server authentication dialogue remembers ssas servers have connected in past.   once have connection server can use dbschema_catalogs schema rowset list of available databases.   siaj wrote: also ssas repository located on box(i guess sho

Edit selection attributes on a InkCanvas

hi! when select stroke on inkcanvas, it's "internal fill" gets white (at least when have red color). how make selection fill same stroke color? thanks the "glow" settings on selected strokes default going show white.  override behavior modifying drawing attributes of selected strokes after strokes selected may idea leave strokes white highlights in glow may less surprising users.   -gus Windows Desktop Development  >  Windows Desktop Development for Ink, Touch, and Tablet PC

SSDT with Remote Linked Server Connections

hi, one of big issues when using openquery in view or sproc linked server - solution gives unresolved references error cannot suppress. of these databases not sql server i.e. oracle/informix/progress/odbc , cannot imported or referenced via project. makes whole solution painful. i'd love ability ignore validation remote database references. validate main project db , not worry external dependencies may have no control over. where referencing 3rd party database sql server based , can import database want import objects not whole database. drag , drop exercise each dependant object (painful) project tries validate whole database , end loads of warnings can't suppressed - suppress sql warnings seems have no effect. anyone having same issue there work around etc.? regards toby hi, you can add linked server project (we use so for oracle-db): click on project --> add --> new item --> linked server in file add: execute  sp_addlinkedserver   linkeds

SQL 2008 install failed - Could not find the Database Engine startup handle.

i tried install sql 2008  on home computer (vista) , failed.  installed on work pc (window xp) on friday , worked fine. the error message not @ all, , google search not picking useful either.  appreciated. error message: title: microsoft sql server 2008 setup ------------------------------ the following error has occurred: could not find database engine startup handle. for help, click: http://go.microsoft.com/fwlink?linkid=20476&prodname=microsoft+sql+server&evtsrc=setup.rll&evtid=50000&prodver=10.0.1600.22&evttype=0xe53883a0%25400xbe03358b%25401306%254023 ------------------------------ buttons: ok ------------------------------ once hit ok on popup error message dialog, showed errors "database engine services", "sql server replication", "full-text search", , reporting services".  here summary log. overall summary:   final result:                  sql server installation failed. continue, investigate reason failure, correct pro

deplyment error in SSRS

Image
hi,      facing deplyment error in ssrs.the issue is,it not able find shared datasource avalilable in share point.the error message showing shared datasource url like: new sharedata source appended old datasource url.but i can see new data source url in shared datasource folder property of solution.  what may reason. hi nikkred, when deploy report report server runs in sharepoint integrated mode, need type full qualified urls the targetdatasourcefolder , targetreportfolder such http://<server name>/sites/<sub-site>/data sources . meanwhile, current users must have member or owner permission on sharepoint site deploy report. references: url examples published report items on report server in sharepoint mode (ssrs) publish report sharepoint library if issuer persists, please post detailed error message , deployment configurations of project further analysis. regards, mike yin technet community support

"Unpivot" values in a column

hello:   i have data source need "unpivot" here's how it's stored.   there can multiple technicians perform work on order, there's field called "techs" , the multiples values stored in single column delimiter "tech1~tech2~tech3~tech4".   i'd end normalized version like order 234, tech1 order 234, tech2 order 234, tech3 order 234, tech4   how in ssis or tsql?   thanks,   sam   todd,   thanks reply, don't see how applies situation. unpivot task , command seem apply when each of "tech" values held in defined number of columns. in case, multiples values crammed single column delimiter. am missing something?   thanks,   sam sam, try this: dynamic unpivot -jamie http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | me SQL Server  > 

SQL EXRESS 2014

Image
first time user. i ran discovery report after installation of sql express 2014.  there no instance or instance id. not see services running. when launch management studio not know server name entry.  want connect can load database , run through training course.  first time user. i ran discovery report after installation of sql express 2014.  there no instance or instance id. not see services running. when launch management studio not know server name entry.  want connect can load database , run through training course.  hi collector_edi, firstly, please make sure select sqlexpradv package or sqlexprwt package install sql server express 2014 download link . these 2 installation packages contain sql server database engine , sql server management studio (ssms), them, can load database make test. secondly, please make sure sql server 2014 express installed successfully. can post summary , detail logs analysis if fail install it. default, logs can found in

Reading a XML file from IsolatedStorage ?

Image
 hi. i'm reading xml file has been stored in isolatedstorage . exception occurring      root element missing . i'm dead sure there isn't troubles in xml file, don't know result of exception guide me ? thank you. snippet code :    using (isolatedstoragefile isostore = isolatedstoragefile.getuserstoreforapplication()) { . . . string settingfilepath = "codecolorizer\\setting.xml" ; using (isolatedstoragefilestream isostream = new isolatedstoragefilestream(settingfilepath, filemode.create, isostore)) { isostream.position = 0; xmlreader xmlreader; xmlreader = xmlreader.create(isostream); //moves reader root element. xmlreader.movetocontent(); //exception occurring here string value ; while (xmlreader.read()) { switch (xmlreader.nodetype) { case xmlnodetype.element

Code Coverage MSTest.exe error when running on Team Foundation Server 2010

  i trying enable code coverage using team build 2010. have solution on 500 unit tests that builds , runs successfully. when enable code coverage, instrument assemblies (currently instrumenting unit test assemblies because unit tests in separate solution code tested). enable code coverage in testrunconfig file, , configured assemblies instrumented. when run tests, following mstest.exe error. "code coverage turned on in test settings. result, tests cannot run inside mstest.exe process. /noisolation switch not supported these test settings." i removed "/noisolation" flag mstest activities in build process template still same error. confirmed build definition using correct process template. there need other check-in process template has /noisolation flag removed mstest activities? hi caponeman, i'm moving thread "team foundation server - build automation" forum, since issue more related tfs build automation, , better support in "tea

Geometry from Oracle 10g into SQL server 2012

i'm building service(c#) selects number of geometries system stores geometries in oracle 10g, , save copy of sql server database use system. looked first @ sdo_util.to_wktgeometry(). however, geometries stored 3d geometries (even though z-layer 0, not work wkt works if in 2d). option number 2 sdo_util.to_gmlgeometry(), returns gmls in v2, , sql server them in gml v3.1.1(from read)(and have not found simple way convert these). have idea of ​​other options, maybe third-party libraries can used this? understand may find more belong in a. net forum, have been trying such, not been able find anything. ideas appreciated! why storing 3d geometries if z value 0?:) it's been while since used oracle seems me if to_wktgeometry() works 2d geometries (couldn't see limitation documented anywhere?) need "flatten" data 2d first, using make_2d function: http://docs.oracle.com/cd/e11882_01/appdev.112/e11830/sdo_cs_ref.htm#chdbcaee export them wkt. twitte

No domain login & unknown SA password -- how to connect to manage database?

i have sql server 2005 database has been handed on me manage.  unfortuantely, no 1 able connect database in studio as domain login nor anyone know sa password. so, options? i prefer reset sa password if possible and/or enable domain logins. my user local administrator on server.  you should able connect server in single user mode , add permissions back. these guide you. troubleshooting: connecting sql server when system administrators locked out starting sql server in single-user mode | sankar reddy | http://sankarreddy.spaces.live.com/ | SQL Server  >  SQL Server Database Engine

Sum of expressions with if clause

Image
i have column positive , negative values. positive values means number of goods sold, determine profit, multiply quantity selling price. negative values mean number of goods not sold , worth nothing anymore, determine cost, multiply quantity costprice. the prices come in different columns e.g.quantity   |   price   |   name   |   profit     |    cost           5               12            a            5*12             0           -3              5             b             0              -3*5           ...              ...            ...            ...                 ...  so profit , cost calulated expressions, can't in sql query because of if clause but need have total of of profits and costs. any idea how total in report builder?          hi piri10, after testing issue in environment, can refer following expression achieve requirement: =sum(iif(fields!verschil.value>0,fields!verschil.value*fields!verkoops_eenhprijs.value,0),"data

Staying FULLSCREEN on Second Monitor!

simply wanted file complaint when first monitor clicked silverlight exits fullscreen.   i have seen others ask this.   maybe if enough individuals express discontent silverlight feature inadequacy done.   have pleasant fullscreen life , may life not exit fullscreen when bumped. guess debated before more info: http://forums.silverlight.net/forums/p/8020/282496.aspx and if post helpful please 'mark answer' - many thanks sharker khaleed mahmud software developer (mcp,mcts,mcpd[web]) credits member, earns point , marks thread resolved know have been helped   Silverlight  >  Silverlight Installation and Setup

ITestManagementTeamProject.TestCases property throws a NullReferenceException on computers that do not have Visual Studio installed

i having problem itestmanagementteamproject.testcases property throws nullreferenceexception on machines not have visual studio installed. using visual studio 2012 update 4. if install visual studio on machine works fine. design? - teamproject {qatestingteam} microsoft.teamfoundation.testmanagement.client.itestmanagementteamproject {microsoft.teamfoundation.testmanagement.client.testmanagementteamproject} + [microsoft.teamfoundation.testmanagement.client.testmanagementteamproject] {qatestingteam} microsoft.teamfoundation.testmanagement.client.testmanagementteamproject + actionrecordings {microsoft.teamfoundation.testmanagement.client.actionrecordinghelper} microsoft.teamfoundation.testmanagement.client.iactionrecordinghelper {microsoft.teamfoundation.testmanagement.client.actionrecordinghelper} attachmentdownloaduri "http://dortfs2010:8080/tfs/testmanagement/v1.0/attachmentdownload.ashx" string + attachmentuploadmanager {attachmentuploadmanage

javascript eval() doesn't work with Tellme voice browser?

it nice eval() strings returned cti connect javascript objects.  however, i'm getting syntax error: "invalid label".  ideas? this sounds straightforward syntax error. you have 2 possible approaches: try guess what's wrong. if had hazard guess, i'd try instead: eval('(' + yourstring + ')'); to force parser use expression context. you're trying eval looks block of statements. use debug printing output string you're trying parse studio debug log. should able see syntax error. in case, although can trust cti connect, it's practice use safer json parser plain ol' eval; json.org has 1 can use. http://www.json.org/js.html Archived Forums T-U  >  Tellme Studio (retired)

Alerts Explorer - Owner

Image
is there way able see/edit alerts using alerts explorer, not ones owner of?  have developer able see/modify alert.  aware of event subscription tool, ideal if alerts explorer this.  appreciated! thanks! hi tb,   thanks post.   sorry inconvenience, far know, user can view , edit alerts create himself in alerts explorer, can’t edit alerts created other users in alerts explorer.     for scenario, suggest you submit suggestion user voice site at: http://visualstudio.uservoice.com/forums/121579-visual-studio . microsoft engineers evaluate them seriously. uservoice site place feature requests, product team tracking list. john qiao [msft] msdn community support | feedback us Archived Forums T-U  >  Team Foundation Server – Power Tools & Add-ons

Pivot with null values

Image
hi  from entry data in table1 below need pivot these datas ssis table2 below the number of null values variable , number of  pivoted columns = 5 thx help  table1 col1 col2 a 1 b 2 c 3 null null null null table2 a b c d e 1 2 3 null null does not pivotablee.g. 1 , 2 on 1 row , 3 not where d , e were? arthur my blog SQL Server  >  SQL Server Integration Services

Can not open .XAML file created in VS 2008 using MS Blend.

Image
i have visual studio 2008 , silverlight 1.1 alpha installed. have installed ms blend. able create projects in vs when trying open .xaml files in blend shows me error : - "the project file "c:\...... page.xaml" not valid. element <canvas> unrecognized, or not supported in context." version of blend have 1.0.2017.0 service pack 1 , vs 2008's version 9.0.21022.8 rtm. please help. you need blend 2.0 develop silverlight content. latest release (december ctp) available www.microsoft.com/expression . pete Silverlight  >  Programming Silverlight with .NET – General

Separate databases for Staging and Production?

i downloaded "windows azure platform training kit - august 2009 ", contains bunch of labs , presentations on sql azure. i'm still struggling "register ctp", have theoretical question. let's suppose web , worker roles run 100% on windows azure (nothing on-premise). since database schema , data change between versions, experience need 2 separate databases staging/qa , production. once connect sql azure , create database , login/user account need create 2 databases - 1 staging , 1 production?  or moment create 1 database, azure portal creates 2 automatically? if have create 2 separate databases myself, charged staging database? example, if choose $99/10 gb option, charged $198? hi emmanuel, when create a database, (and charged for) 1 database.  if want have two separate databases - 1 staging , 1 production, you need provision two databases.  in case charged 2 databases. stan program manager, sql azure

Difference between TCP 1433 and UDP port 1434

hello is essential to enable the upd also in sqlserver 1434 and which is enabled as far i see i've never needed upd enable port 1434 to communicate sql server browser service on server behind firewall, open udp port 1434 ! content copied books online :  network administrator should configure firewall forward communication sql server ip address , tcp port instance of database engine listening on (either tcp port 1433 default instance, or tcp port configured named instance). also, because microsoft sql server uses udp port 1434 establish communications links applications, have network administrator configure firewall forward requests udp port 1434 on same ip address. more information udp port 1434, see  sql server browser service . example, consider computer running 1 default instance , 2 named instances of sql server database engine. computer configured such network addresses 3 instances listen on have same ip address. default instance

sql server scale out with distributed partitioned views

hi. our company manages online auction , shopping website(something ebay), , have questions regarding scaling out solutions. running sql server 2008 r2 enterprise edition(which servicing asp.net) on our 2 servers near each other. server specifications: server 1: 4   x intel xeon e5-4650 cpu processor 8-core 2.7ghz/20mb/8gt 14 x samsung 16gb ddr3-1600 server 2: 4   x intel xeon e5-2670 cpu processor 8-core 2.6ghz/20mb/8gt (1 per each node) 4   x samsung 16gb ddr3-1600 have 2g database! know not considered large-scale website since expecting gradual growth searching through scaling out solutions. have read far seems  "distributed partitioned views" can work fine among things scalable shared database, p2p replication, ddr,... because not willing make major changes in application,and have frequent updates(users insert new items sell,...). although have concerns relating <b>performance of linked servers</b>. since servers near ea

TF50309 error when accessing TFS Web access

hi, i have w2k8 server tfs2008 installed on it. recently, tried install vs team system web access 2008 power tool sp1. installed "install on exisitng website" option. after installation, site throw error msg, able resolve solutions provided here: http://bloggingabout.net/blogs/mglaser/archive/2008/03/11/configure-your-tfs-wss-3-0-site-to-use-vsts-web-access-2008-tswa.aspx   unfortunately, error got next "the page cannot displayed". hope help. with regards i'd recommend against installing tswa on same site wss avoid conflicts. that being said, tf50309 error means permission issue indicating web access cannot authenticate against tfs using credentials provided. make sure the session state enabled on wss site web access requires it. also, instead of forms authentication, try using integrated windows authentication. hakan eskici - msft Archived Forums T-U

Help writing an instant messenger app using SQL azure

Image
hello in dire need here. have gotten deep trying figure out how write im app using sql azure. had success writing using background worker instead of threads wanted learn how explicitly use threads , tried threaded version. result= big mess. cant seem figure out own code. have 8 months programming experience maybe 1 of more experience software engineers can me out im sure second nature guys. having 2 problems explain in detailed notes in source code. basically, getting unexpected results when comes updating buddy list. have temp buddy list , real buddylist compared against eachother see has signed on , signed off. real buddy list gets set on form load , temp gets set every second on timer/second thread. weird somehow original buddy list being updated while temp 1 should being set. dont know how happening. other problem events dont seem firing. having difficult time trying work.     this buddylist window form code:   using system; using system.collections.generic