Posts

Showing posts from February, 2013

Silverlight in JSP

hi we have application build using jsp. planning make enhancements it. our idea use silverlight this. question is possible add silverlight component jsp file ? thanks yup.  matter of producing correct html in jsp: http://vinodsardar.wordpress.com/2010/05/18/hosting-silverlight-content-in-jsp-page/ Silverlight  >  Getting Started with Silverlight

DBA horror stories

i trying horror stories poor dba practices have encountered or witnessed on years colleagues or maybe yourselves in younger years starting out dba’s, on poor administration/naïve dba’s can wrong in sql server can have negative consequences on availability , performance of vital databases drive key business applications. examples have come across, or “set , forget it” type admin practices youve witnessed , happen negatively , impact that’s had on db section/business interesting hear. hi, most of them related backups , security. 1. dba never ran backup because he , employer believed raid5 protect against : viruses, asteroid striking earth,  ntfs corruption, tyranosaurus attack, name it! a stupid mistake far more common might imagine. 2. choosing trivial passwords 'sa' , administrator accounts. 3. never tested dr strategy (including clusters, log shipping, replication, dump all tables csv , whatever). once disaster arrived, dba didn't know how restore data,

SQL Server 2012 Upgrade Advisor Timeout

hi all, i running sql server 2012 upgrade advisor, throwing time out error. error description " timeout expired. timeoutperiod elapsedprior completion of operation or the server not responding. " my server configuration processor intel xenon (2 core) ram : 32 gb database size : 9gb please me resolve issue. hello, thanks, running upgrade advisor on same computer. problem solved. ran no exceptions. even have lot of de-supported code in database. if compile de-supported stored procedure manually, throwing error, in advisor not throwing error. may know reason , how can contact microsoft support that. SQL Server  >  SQL Server Setup & Upgrade

Flat File row count in SSIS

Image
hi , i have 2 questions . if please me wonderful 1) using bulk insert task  , bcp load delimited files sql server . during loading process , error occurs . how can debug error 2) loading text  file through flat file source . due auditing requirements , need know row count of how many rows loaded flat file flat file source in ssis  . how can count obtained.   thanks #2 - use row count transform - place after source component. talk me on SQL Server  >  SQL Server Integration Services

The SQL Top Command

hello, say have table listing state\counties in world country in. to top 10 counties country. i can the top 10 counties, cannot go step country, like: for usa:   coutries 1 - 10 for uk:   coutries 1 - 10 for spain   coutries 1 - 10 thanks help, tyrone if you're using sql 2005 , up, it's simple problem using row_number() function partition, e.g.   ; with cte as ( select country, county, row_number () over (partition by country order by county) as rn from listofcountriescounties) select * from cte where rn<=10 order by country, rn for every expert, there equal , opposite expert. - becker's law my blog SQL Server  >  Getting started with SQL Server

How to move MSDE SQL data to SQL Express

i have 3 workstation peer peer network running windows xp pro.  need replace machine hosts sql msde server.  have built new system , software installed except msde.  use proprietary product called time matters law practice uses sql server.  since might want run vista (not right now)  thought try migrate msde sql express.  assume time matters run on sql express.  can please give me on how proceed.  i'm thinking install sql express server on new machine , somehow migrate database on new machine , shut down old unit.  appreciated.     hi, the path considering acceptable... to "move" database between server can have @ http://msdn2.microsoft.com/en-us/library/ms345483.aspx  , http://msdn2.microsoft.com/en-us/library/ms190794.aspx  , http://msdn2.microsoft.com/en-us/library/ms190436.aspx  .. once , running, should modify db owner valid instance login via the  sp_changedbowner  system stored procedure .. database compatibility level should set 90 take advantage of n

Clipping at screen edge killing performance

hi guys, so i've turned of objects writeablebitmaps improve performance (which did), i've still got performance issues when these bitmaps start intersecting edge of canvas (which 'screen'). i have between 7 , 10 small bitmaps (around 165x90 dimension) when on-screen (screen 640x480) 60fps, drops 30fps intersect screen edges. have gpu acceleration turned on cache visualisation on well... is there anyway around this?  :) cheers, paul. how application's performance affected when disable gpu acceleration? i think (though need confirm) silverlight has work maintain/synchronize 2 graphics devices when window straddles multiple monitors.  disabling gpu acceleration cause use single software surface , may alleviate performance problem.  i'll check appropriate people , on thread. the real performance gains gpu acceleration realized if you're moving large, complex-to-redraw, cached surfaces around lot or using plane projection.  if aren't d

distinct count with multiple partitions?

we analyze of our data using distinct measures.  of underlying sources - i.e. daily page views heavy , have millions of rows day.  because of i've created daily partitions process incremental data that's arrived.  however, i'm curious - how distinct count perform when needs rollup on multiple partitions? ie it's dec 25th, , have 25 unique partitions each day of december far.  internally, how distinct measures correctly accumulate unique instances of measure?  there significant performance concerns aware of?  distinct count measure work fine multiple partitions. keeps distinct count values inside partitions, , therefore can correctly aggregate across them. partition per day should ok too. SQL Server  >  SQL Server Analysis Services

Why am not seeing one cube when connected through Excel?

hi when connecting analysis services database excel..data-->from other sources --> analysis services--> entered server name , database name-->here seeing 6 cubes have 7 cubes in database. why not seeing cube in excel? able see through sql server management studio connecting analysis services. please help. thanks in advance. --bi excel shows processed cubes. ssms show cubes regardless of it's processed/unprocessed state. can browse "invisible" cube ssms? http://darren.gosbell.com - please mark correct answers SQL Server  >  SQL Server Analysis Services

textblock foreground problem

hi all.. can body in findaing way vil me change foregroung property dinamacly code behind(c#) have following  text block in mt mytest.xaml < textblock opacity = " 0.0 " rendertransformorigin = " 0.5,0.5 " width = " 140 " height = " 43 " canvas.left = " 2.0 " canvas.top = " 1 " fontsize = " 0 " fontstyle = " normal " foreground = " red " x:name = " overlayed_text1 " > and using folling to get/set values of text block code behind (mttest.xaml.cs)  // setting/getting text public string textelementtext{ get {   return textelement.text; } set {   textelement.text = value; } } // setting/getting font size public double textelementfontsize { get {    return textelement.fontsize; } set {   textelement.fontsize = value; } } // setting/getting  opacity public double textelementopacity { get {   return tex

Partial rendering of database in Management Studio

i've tried creating login name , password in management studio express sql server authentication , desired database selected default. if try connect database outside management studio using login, error message, login failed user <name>. if try open database in management studio express via sql server authentication, database listed in left window in outline (for example, if open tables folder, none of tables listed. what rendering in outline signify? perhaps provides clue why login defective. it signifies logins using not have correct permissions access database. in first example when login sql server username, didn't give permission access database. may have selected default not given correct permissions. in second example, can see outline , not tables means don't have permissions view objects belonging specific schema objects in. sql server 2005 permissions hope helps, -h SQL Server

Using fixed downloaded source code for building project.

hello. i'm trying configure team foundation server project. it's getting finished, i've faced problem. to address situation, have 2 separated solution files share source code. , i've defined many build definitions on tfs build projects different build configurations provide proper locale builds. because source code 700 mbytes, pulling down source code tfs(git) takes long time every locale builds. as know, build agents download source code temporary directory has name hash-coded. builds download same source code each temporary folders redundantly. if can set build agent fixed path share source code among different build definitions, can save lot of time pull source code down. how can it? please let me know. thank you. best regards. jinkyun lee hi lee, thanks post. if don’t want pull share source code tfs server build agent each time when queue build definition, can set clean repository = false in build definition, tfs run incr

Full Analysis Database Sync is blocked

we getting below error. - tf276000: current analysis database sync job has exited without making changes. either analysis database sync job in progress, or analysis database sync job cannot run because optimize databases job running. next analysis database sync job start @ scheduled time we in process upgrade our tfs 2013 2015 update 2.1 . prior want make sure non blocked run of job on tfs 2013.  could please in understanding why job failing. tried rebuild , restart of server . none helped. such job run failure affect tfs upgrade process ? please help. hi dn9, based on error message, means either analysis database sync job in process or optimize databases job running. think job blocked temporary otherwise throws different exception. you process analysis database manually , check result. go http://localhost:8080/tfs/teamfoundation/administration/v3.0/warehousecontrolservice.asmx (tfs machine) click processanalysisdatabase link type full in processingtype t

SQLDiag output is missing first few trace files

when running sqldiag on busy production server find once stopped first few trace files missing. not sure if related, based on sqldiag log file see took 15 minutes time reported "starting profiler trace" until says "sqldiag collection started." here abridged section of log: 2012/11/14 05:01:13.91 sqldiag initialization starting...  2012/11/14 05:03:39.84 server\* starting profiler trace  2012/11/14 05:06:59.24 server\* starting blocking script  2012/11/14 05:11:59.44 server\* msinfo: msinfo32 2012/11/14 05:13:07.31 server\* msinfo: fibrechannelinfo 2012/11/14 05:14:14.61 server\* msinfo: reghardwaredesc 2012/11/14 05:15:19.82 server\* sql 2008 perf stats: sql 2008 perf stats script 2012/11/14 05:16:26.13 server\* sql 2008 perf stats: rdtsctest 2012/11/14 05:17:31.70 server\* sql 2008 perf stats: sql 2008 perf stats snapshot 2012/11/14 05:18:37.02 server\* adding perfmon counters...  ... 2012/11/14 05:18:38.92 sqldiag 259 counters added

Workspace not getting mapped correctly

i have workspace mapped following: <team project>/<directory 1>/<directory 2> when run build, however, following error. "no matching items found in <team project>/<directory 1> in workspace, or not have permission access them." this happens during create label stage. pretty sure have every right in our tfs 2010 server. this happened after got errors workspaces being mapped , subsequently deleted offending workspaces. any appreciated. hi vicky, never mind entire thing... turns out service set run network service instead of dedicated account had running tfs builds... blame erroneous tutorial told me ok leave network service (whatever blog was... >_< ). sorry bothering you... help, though! Archived Forums V  >  Team Foundation Server - Ge

Burndown chart stopped updating in TFS 2013 Update 2

i running new installation of tfs 2013 update 2 , reason our burndown chart no longer updating of our teams. we have configuration 3 different teams , each of them have different backlog associated, configured through iteration admin settings. the burndown working correctly until last friday, stopped working after started new sprint monday. i have checked few things , did not find problems: - sprint dates defined , not overlap - warehouse , analysis processes running fine. able data warehouse , analysis database successfully any ideas? thank you! rafael amorim hi john, thanks response. have done additional research morning , found user error. there updates remaining work field outside of sprint dates , that's why burndown not correctly updated. thanks, rafael Archived Forums V  > 

SQL Server 2008 installation error

hi, trying install sql server 2008 r2 dev edition on window 2008 r2 enterprise(new server). when click on setup.exe, throwing error error parsing c:\windows\microsoft.net\framework64\v2.0.50727\config\machine.config parser returned error 0xc00ce556 click on ok below error title: sql server setup failure. ------------------------------ sql server setup has encountered following error: configuration system failed initialize error code 0x84b10001. ------------------------------ buttons: ok please let me know how resolve this? thank you hi, personally dont have experience solving issue per saw on internet, 2 things can try are "c:\windows\microsoft.net\framework\v2.0.50727\config\machine.config" solve problem, rename original file 'machine.config' 'machine.config.old', , copy file machine , place in same folder. then, re-install again. or it can fixed replacing file  c:\windows\microsoft.net\fr

Modification to process template after it is applied to Project.

Image
i have created custom process template , created project using it, later made modification process. reflect project or not. steps should make reflect changes project. huzaifa gain no changes not reflected projects created. have apply these changes manually existing project also. dependent on type of changes made, either have change work item types (witimport/witexport [2008] or witadmin [2010] -  or use power tools) or upload new reports or .... ewald - please remember mark replies answers if help. blog: www.ewaldhofman.nl Archived Forums V  >  Team Foundation Server - General

trying to add another table

i'm trying add last paragraph query. query runs ignoring last part. thank you, select *   from arr_analytics.dbo.detail d inner join arr_analytics.dbo.detail di on d.sd_key=di.sd_key where d.sd_tran_cde_cat in ('31') and d.sd_ben_wir_acct_ident not ('%twr%') and d.sd_term_name_loc = di.sd_term_name_loc and d.md_tran_amt1 > 4999 and di.sd_tran_cde_cat in ('31') and di.sd_ben_wir_acct_ident not ('%twr%') and di.md_tran_amt1 > 4999 and di.dd_date between dateadd(minute, -10, d.dd_date) , dateadd(second, -5, d.dd_date) , exists (select sd_datekey arr_analytics.dbo.detail di1 where di.sd_key = di1.sd_key and di1.sd_tran_cde_cat in ('21') and di1.md_tran_amt1 > 10000 and di1.dd_date between dateadd(day, -3, di.dd_date) , dateadd(second, -5, di.dd_date))     , exists (select di1.sd_key, di1.sd_datekey from arr_analytics.dbo.detail di1 join arr_analytics.dbo.master m on di1.sd_key = m

email details from SQL Server agent based on query results?

hello,   i want remove records database automatically, important me know (email) if there records or not , how many affected automatic task...   my job scheduled run every day , like:   delete radioactivematerials where (notexplosive = true)   set @rowcount_var = @@rowcount     i detail on deleted records, how can produce email?     if using sql 2005, using books online, refer topic: 'database mail how-to topics'.   if using sql 2000, suggest check out xp_smtp_mail here.  most folks recommend not use mapi mail on sql server. SQL Server  >  SQL Server Tools

Create Excel Files Microsoft.Office.Interop.Excel in SSIS C# Scripting.

Image
hi guys, i have issues specific box when run c# script supposed generate excel file within ssis package using interops. the script running.. /* microsoft sql server integration services script task write scripts using microsoft visual c# 2008. scriptmain entry point class of script. */ //using using system; using system.collections.generic; using system.data; using microsoft.sqlserver.dts.runtime; using system.windows.forms; using excel = microsoft.office.interop.excel; using microsoft.office.core; namespace st_8aa38d8ae4e54a7583cab65abaa02f3b.csproj { [system.addin.addin( "scriptmain" , version = "1.0" , publisher = "" , description = "" )] public partial class scriptmain : microsoft.sqlserver.dts.tasks.scripttask.vstartscriptobjectmodelbase { #region vsta generated code enum scriptresults { success = microsoft.sqlserver.dts.runtime.dtsexecresult.success,

Save Scheduled report output file to database table through custom delivery extension

hi, we using sql server 2005 reporting services. having requirement save scheduled report out put file directly database table in oracle. looked @ custom delivery extension print delivery , found help. i stuck @ point of saving the  notification.report.render("pdf", null);    to database table. not sure how save output of render method i.e  renderedoutputfile[] to database table. any in getting started appreciated. regards, ashwin       ashwin hmm, never done it. perhaps can create linked server oracle , insert data (generated excel) directly oracle database? best regards, uri dimant sql server mvp http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/ SQL Server  >  SQL Server Reporting Services, Power View

VSS based full doesnt truncate logs

i have following queries on backup , recovery.   1.        take full backup   :   monitor firstlsn , lastlsn in msdb.dbo.backupset table 2.        do few transaction , perform transaction log backup   :   monitor firstlsn , lastlsn in msdb.dbo.backupset table 3.        do few transaction , perform transaction log backup   :   monitor firstlsn , lastlsn in msdb.dbo.backupset table   from firstlsn in steps 1 & 2 same. i thinking lastlsn step-1 should equal firstlsn of step-2.   can clarify, if i’m missing or understanding of lsn wrong. using vss sql writer based backup solution.   1.        when take full backup transaction logs not truncated. 2.        is there specific reason disallowing truncation , there way perform truncation via vss sql writer.   a database backup not truncate/empty log. tibor karaszi, sql server mvp | web | blog SQL

How do I modify Union data flow task property?

i've created union data flow task unions string fields couple of queries.  found needed increase length of string field in queries.  increasing length causes error in union task.  can't seem find way change property of fields in union task.  of other data flow tasks have advanced editor can change length or type of fields on input , or output.  can't seem find union task.   is there way short of deleting output column , recreating it? (i order of original output columns)   thanks, bill webster you may better off deleting transformation , adding new 1 back. SQL Server  >  SQL Server Integration Services

Connection Managers and Aliases

at work, use instance of sql server named workserver\sql. at home, run local instance of sql server called homeserver. i use visual studio database projects quite heavily in conjunction ssis projects, there kinds of references workserver\sql in solutions/projects. on home workstation, if create alias called workserver\sql "points" homeserver, can use various tools make sql connections without error. includes visual studio (database projects), ssms, , red-gate tools. expected. ssis appears exception. my packages have connection managers reference workserver\sql , when @ properties of connection manager , click test connection, test succeeds, reference workserver\sql on home workstation. when run package in vs, times-out , following error generated: an ole db record available. source: "microsoft sql native client" hresult: 0x80004005 description: "sql network interfaces: error locating server/instance specified [xffffffff].     why properties window of connectio

Refreshing silverlight page with Telerik RadWindow

hi all,   i using telerik radwindow in application. in have insert values entered user database , display them through database @ same. i inserting values, displayed values not showing unless closing , again opening it.  can plese me refreshing of radwindow can display inserted values @ same time added. i posted in telerik, there no response. posting here.   thanks in advance. hi krishnapodduturi, the issue related third party component, suggest you follow thread posted in telerik. thanks understanding. best regards, Silverlight  >  Getting Started with Silverlight

Annual change to encryption certificates and key - How to

i have been tasked change encryption keys greatest extent possible without decrypting , re-encrypting existing column values.  i realize believe should not required, unless comprise suspected, have nonetheless been tasked it.  we use column-level encryption , we're running sql 2014 standard edition. certificates , key created, , used shown code below, names , other unique string changed. references changing key address tde, , not in use.  i understand change in symmetric key require decryption current key , re-encryption new key, , can regenerate database master key used encrypt certname certificate.  however, looking @ values in sys.certificates, not appear certname certificate affected. guess question is, regeneration of database master key cause re-encryption of certificate in database in way not apparent, , symmetric key encrypted re-encrypted?  if not, steps can take rotate certificates , key in way not require decryption , re-encryption of existing data?

When I hide the item that toggles the visibility of other items, those items are hidden too.

i'm having issue in reporting services. detail rows shown, visibility can toggled group header. group header in totals row above detail lines. works fine, i'd conditionally hide group header , not group if parameter set. my group set group on expression =iif(parameters!showgroup.value, fields!group.value, ""). instead of showing row header column left of data fields want shown above fields appear this: col1 col2 col3 group heading 1 val1 val2 val3 val1 val2 val3 to this, right-click details row group , insert totals row above. can set expression of text box show group value. set visibility of detail row show , set "display can toggle report item" , select group heading text box. the problem when set row visibility of "group heading" row show or hide based on expression not(parameters!showgroup.value). when set parameter false, group row hides, hides detail rows well. though oddly still show first detail row. if export d

Check source data before processing

Image
hi there, i wondering best way this. have daily process copy data source destination, simple truncate , reload. there date field in table (transactiondate). i add check before processing, guess, if max(source transactiondate) > max(destination transaction date), start process, otherwise, nothing. basically make sure there latest data avalaible before doing anything. many thanks don hi don, my opinion employ precedence constraint here. so, follows: 1)add package variable (let's can int or bool); 2) drag , drop execute sql task , craft sql query in data in form of 1 or 0 based on whether max(source transactiondate) > max(destination transaction date); 3) add dft load, connect #2 , change using precedence constraint check value of variable returned (say of query gave 0 not proceed, proceed otherwise). i give blog post read on how mechanics when dealing precedence constraints: http://blogs.msdn.com/b/mattm/archive/2006/10/30/using-expression-based-constra

Day Count Between LastTransaction Date and Current Date

i have 4 measure 1. [max transaction date]  calulated 2. [currentmember] - current date (calculated) 3. daycount - measure dericed dimdate 4. [duecount]  [error part] belllow code works fine these 3 measure. now issue part ************************************** member [date].[date].[duecount] as sum({([date].[date].[max transaction date]): membertostr([date].[date].[currentmember])}) select {([date].[date].[duecount],[measures].[daycount])} on rows on columns, [vendor].[vendor].members on rows from [vendor ledger] error msg : cellordinal 0 value #error calculated member cannot used operand of range operator ( : ). formatted_value #error calculated member cannot used operand of range operator ( : ).   **************************************** but this code works because there no calculated member member   [date].[date].[my range] as 'sum(({[date].[date].&[2005-01-01t00:00:00] : [date].[date].&[2005-01-04t00:00:00]}))' select ([date].[date].[my range],[measures].

Team Projects missing from Connect to Team Project window.

Image
we have tfs2008 server , connect vs2010. on our server there number of team projects. if open team explorer , click "connect team project" relevant server selected , list of projects appears on right hand side. there developers on team cannot see projects. have played access (even made 1 tfs administrator temporarily), still can't see of them. i ran trace on sql server , narrowed down proc: prc_css_get_projects_from_state, text proc encrypted can't see it's doing, if execute proc login , 1 of developers logins results different , match see in vs. if has solution great, or can text tfs stored procs i'm sure can figure out what's missing. hi atomic,     thanks post.     in order resolve issue, want confirm information you: 1         did issue occur in vs 2008? 2         you said if connect tfs 2008 using vs 2010 on client, team projects listed correctly. please logon client using developer’s account, try connect tfs 2008 using vs 2

SSRS output to XLSX format

hi, i using ssrs 2008 sp-1 version. when export report excel , save .xls file. i need save .xslx file format store more no. of rows. kindly let me know save ssrs report .xlsx format. thanks, mahalingam hi mahalingam, this feature available sql server "denali" release. more information, please refer article below: http://technet.microsoft.com/en-us/library/dd239307(v=sql.110).aspx regards, bin long technet subscriber supportin forum if have feedback on our support, please contact tnmff@microsoft.com please remember mark replies answers if , unmark them if provide no help. SQL Server  >  SQL Server Reporting Services, Power View

StrToTuple very slow compared to StrToMember (even when one member passed to strtotuple)

Image
hi all, i've got utility dimension dynamically filters measures. scope([dim benchmark].[benchmark name].members); ([dim benchmark].[benchmark name].members = strtotuple([dim benchmark].[benchmark name].currentmember.properties("benchmark source member"),constrained)); // ([dim benchmark].[benchmark name].members = strtomember([dim benchmark].[benchmark name].currentmember.properties("benchmark source member"),constrained)); end scope; and data drives dim (need change column name now...) it working 'ok' until got requirements needed measures have 2 'benchmarks' applied , changed mdx code use strtotuple instead of strtomember my performance (for single member benchmarks) went 15-18 sec slowest measures 80-90 sec. anything can speed or convert tuple member when has 1 member? the thing can think of adding flag view that'll indicate whether source tuple or member, wondering if there's more elegant mdx sol

unable to create oracle connection using connection manager - TNS error

when try create connection oracle database on tfs, tns error says: tns not resolve connect identifier specified. both microsoft provider oracle , oracle provider microsoft doesn't work. 1) have installed 32 bit version of oracle client on system , downloaded oracle driver oledb. 2) created tns string , tried connecting oracle database , connection successful. able query database. 3) have sql server 2012 database and using ssms, when try import data oracle, works. 4) when use bids 2010, microsoft oledb provider oracle works, oracle provider oledb doesn't works - throws tns adapter error. any appreciated. thanks hi info_suha, i'd know more details scenario. want use oracle databases tfs or projects in tfs? tfs doesn't support use oracle database directly. if latter, can open new thread in relatead forum or sql server forum better response. understanding. best regards, we trying better understand customer views on social support experience, partic

Not able to update Application Certificate kit to 2.2

hi there, i using vs express windows 8. application passed tests when ran application certification kit on app when uploading windows store getting certification failed. when running ack on app getting message there update ack link. have gone link several times , installed updated version still message coming up. have noticed despite of several attempts update ack version 2.1. am missing or there other way update?? any highly appreciated. thanks, sameer hi sameer saran have tried reinstall develop environment? it seems met same question before , reinstall helped him. good luck. james he 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 T-U  >  Tool

Named set is not working in excel

hi all, i have created named set  to top 4 referers products.   but not working expected.i using ecel 2007 reporting ui using pivot tables.   the referers in rows , product in filter. say want top referers (google.com,altavista.com...etc) for vb (or) vc++  or sql 2005 ....etc please suggest me how can i.e arrange in order , vary change of product.   i have 3 tables dim_product, dim_referer, fact table   the content of new named set be:   {([dim referer].[name category]. members ,4,[measures].[value])}     rgds sai named sets created in mdx script static - evaluated once. therefore changing current product won't affect content of named set. SQL Server  >  SQL Server Analysis Services

Printing Sub Reports

hi, i have 2 sub reports in detail line of main report's table.  sub report#1 in column 1 , sub report#2 in column2.  report renders correct when viewed in browser, or in development, however, when printing, first detail line of report displayed.  i've tried many different things far, none fix issue.  also, same thing happens when press "print layout" button in visual studio.  when press "print layout" button, goes show rows, first row.  i've checked make sure there no page break issue. any suggestions appreciated. jt SQL Server  >  SQL Server Reporting Services, Power View

How To Make Logging Configuration-based Only

i need make logging location independent through use of configuration files, cannot seem work. goal: need log packages run-time determined database.  location not know @ development , deployment time.  in fact logging sites available @ development & testing not available @ run-time. what have done: first, added log provider connected through ole db connection manager.  then, enabled logging on package , independently on of executables in package.  ran , works fine, logging shows in right place, etc. secondly, disabled pre/post validation logging , set objects delayvalidation=true because packages spew errors in ide when try move them different environments. thirdly, setup indirect configuration file loads cm's connection string vairable , changed cm add expression variable connection string property.  tested , still works ok. fourthly, set connection string variable invalid server name simulate run-time startup conditions of package (remember indirect configuration file still h

Accessing TFS without Windows Integrated Security? (Internet Access)

from see after installation of beta 3 web site on port 8080 integrated authorization. i thinking of changing basic authorization , after publishing site on ssl isa server. looks that: client - ssl (port443) -> isa - http (port 8080) -> tfs is easy or recommended way of achieving this? does client in vs2005 offer way enter creditentials? there way this, sharepoint , rosetta sites registered elsewhere.  following should push new registration information integration database.  please let know if works. 1. take following template xml, , replace [protocol], [:port], [at server] , [dt server], , replace protocols, ports , server fqdn for deployment registration points , save file myregistration.xml.  note if using default port associated protocol, don't need add [:port] information. <registrationentries> <registrationentry>     <type>reports</type>     <changetype>change</changetype>     <serviceinterfaces>       <serviceinterface>

TFS2013: Please confirm if I have to edit the bug.xml and the categories.xml to get Bug Work Items on the kanban board

Image
hello, vs/tfs 2013 i have studied following links:  http://msdn.microsoft.com/en-us/library/jj920163.aspx , http://blogs.msdn.com/b/visualstudioalm/archive/2013/02/12/add-bugs-to-the-task-board-or-backlog-pages.aspx since these articles on year old wanted confirm still required before , potentially break my system.  assuming this may still required, have question regarding 2nd set of edits, 1st item 5 on webpages for the bug.xml file. i don't quite understand how xml step 5 edit in <form> section.  there 3 major <group> elements.  1 of them contains a <group> element label="status".  supposed copy , paste section web links above, or perform 'additive' edit, in other words ensure every line present still present new lines added in. this current  bug.xml looks in area of <form> element <group label="status"> located: <group label="status"> <column percentwidth