Lun

i posted already, reposting here hoping more response in forum .  can leverage existing msbi skills learn big data or have learn scratch. is learning big data helpful career ? thanks, rajendra hello rajendra, there several article / tutorials regarding topic online available, e.g. @ mva = microsoft virtual academy: http://www.microsoftvirtualacademy.com/training-courses/ big-data-analytics olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Analysis Services

we planning migrate tfs 2012 2013. have few questions though: 1. using 'agile' template in our 2012 version. when upgrading tfs 2013 move 'scrum' template. have impact on workitems etc? example have 'userstories' work item, change 'product backlog item' in 2013 scrum template. mean need map workitems new ones? or automatically done upgrade? 2. can still change process template afterwards? so, better straight forward upgrade 2013 'agile' template have, , change 'scrum' process template later?  hi, thanks post. as far know,  there no way change process template 1 other inside team project, you'll have create new team project scrum template migrate to. it's recommended migration after upgrade. can create team project scrum template in tfs 2013 first, , check workaround in case below migration: http://stackoverflow.com/questions/20052478/team-foundation-service-how-to-migrate-from-agile-to-scrum-process-template we

hi   i'm using c++ library reads config.ini file , has methods access usb device. this library wrapped in c# class library com access. a setup , deployment project installs c# com object , library being wrapped correctly, mentioned config.ini file read bin/debug directory (of the c# console client) reason, not location setup&deployment project installs c# , c++ libraries. my question is, place config.ini file access silverlight (as said, installation directory of deployed com object not c++ library looks config.ini) ?   thank you etienne marais dont use current working directory, thts mistake did in case. if silverlight use getexecutingassembly().location.tostring(); not sure method allowed coz of security in sl. current working directory windows explorer selected directory wrong in many cases. Silverlight  > 

i have sql query  needs run depending on 2 criterias no , code.  code works no field. can help  need add version code statement work.  text field private sub cmdrevise_click() dim db dao.database dim strsql string   set db = currentdb() strsql = "delete tbltempmaster" db.execute strsql, dbfailonerror strsql = "insert tbltempmaster select * tblmaster [bom no] = '" & me.bom_no & "'" db.execute strsql, dbfailonerror docmd.openform "frmbomform" end sub i not sure if it's mean, can combine conditions in clause , like strsql = "insert tbltempmaster select * tblmaster [bom no] = '" & me.bom_no & "' and code = '" & yourcodevar & "'" olaf helper blog xing SQL Server  > 

hello have problem :d , have code sub updatestats( byval clientuid as integer , byval timestamp as datetime) clientuid = cint (timestamp.tostring( "yymmdd" ) & clientuid.tostring()) ...................... clientuid number 1112052868 , error  arithmetic operation resulted in overflow if change this sub updatestats( byval clientuid as string , byval timestamp as datetime) clientuid = timestamp.tostring( "yymmdd" ) & clientuid.tostring() it works stucks @ insert query error  the conversion of varchar value '111205183324' overflowed int column yes column int , it's someone's else work , want fix it... there solution ? tried with convert.toint64(clientuid) @ insert query doesn't work...   any solutions ? thanks thanks answering , if try alter table , loose data ? no, you not loose data if alter column data type varchar(20)

all, i hosting videos on silverlight streaming , have custom video application that references proper version of silverlight.js , able set mediaelements source property cdn url after calling slstreaming.translateurls.  works great.  question related wpf application wants display video.  how can easly take url (streaming:/29118/9e2ad65684424404aac5e4b597b1e7af/lake.wmv) , translated cdn url without using javascript?  want cleaner way in c#.  ideas? thanks, --mm hi mm, i trying find reasons want this, , if not wrong want use in asp.net , not silverlight 1.1 (c#) if case can use asp.net futures , use media tag, if trying use within silverlight 1.1 might cause crossdomain call. corret me if got wrong. Silverlight  >  Hosting and Streaming with Silverlight

hi ria services expert. i noticed that when silverlight client calls a get domain service method datetime argument, datetime.milliseconds field lost (resetted zero). datetime.kind resetted unknown whereas utc when client called.   is known issue yes, can confirm finding. date value passed query function parameter lost milliseconds , kind value on server side. date value in data entity holds correct value in both ways.   Silverlight  >  WCF RIA Services with Silverlight

hello folks, read lobs clobs , blobs not stored in data pages, want know these objects stored. thanks! grate, lucas. if talking data pages guessing talking sql server relational engine , not analysis services mutli-dimensional engine. in relational engine large objects not stored on data pages, 16bit pointer location stored in data page. http://geekswithblogs.net/darrengosbell - please mark correct answers SQL Server  >  SQL Server Database Engine

hello, i'm still relative newbie in using database triggers. the following example produces trigger loop (exceeding recursion limit of 32), because trigger fires trigger b , reverse.  why happen also if database option "recursive triggers enabled" has been set false?   create table triggertest (id int not null primary key, last_update datetime, counter int); go insert triggertest (id) values (1); go create trigger triggertest_a on triggertest after insert, update begin  set nocount on;  update triggertest  set last_update = getdate()  from triggertest t inner join inserted on i.id = t.id end go create trigger triggertest_b on triggertest after insert, update begin  set nocount on;  update triggertest  set counter += 1  from triggertest t inner join inserted on i.id = t.id end go insert triggertest (id) values (2); -- produces recursion error message of course, example without deeper sense, it's test. i'm work

i followed steps below uninstall ssrs , worked.  need reinstall ssrs , followed step 1 & 2 it's asking install media.  since didn't install ssms on server , actual databases hosted on server, how reinstall ssrs?   or there other means reinstall ssrs.  in add/remove programs click 'uninstall/change' button "sql server 2008 r2" in coming dialog, click 'remove' click 'ok' in 'select instance' dialog,  select appropriate instance, , click 'next' in 'select features' dialog, please select 'reporting services' then click 'next' , 'next' till uninstalling process starting thanks in advance help. gabriela lo hi gabriela , you don't need the installation media uninstall component of sql server, need the installation media install one.  hope helps! shahfaisal muhammed http://shahfaisalmuhammed.blogspot.com

hey, when developing games, sooner or later need logics arise, particles, collision detection, sprites, etc... depending on game procedures can put lot of strain on cpu. although silverlight offers large toolset draw transform, scale, etc... nice features involve lot of boxing , unboxing, results in fair amount of performance loss. since game development performance critical section, question here is:  is wise or necessary use features,  or wouldn't better ignore them , implement own methods deal things. thought so, the xaml support useful in more or less static environment, layout not change or changes in range of finite possiblities. since games exceed criterias , theres not use xaml support.   Silverlight  >  Game Development with Silverlight

hi all, we executing query dynamically using exec. in query have used nolock, but  there no effect of nolock. there restriction in using nolock in dynamic sql exec. will there positive result if use sp_executesql please suggest -- reddy balaji c. ##mark answer if solves issue hi, although it's recommanded use sp_executesql, nolock hint should work in dynamic sql in case, if use exec or sp_executesql. see, if schema lock mentioned in below post reason, http://blogs.msdn.com/b/sqlcat/archive/2011/02/20/concurrency-series-why-do-i-get-blocking-when-i-use-read-uncommitted-isolation-level-or-use-nolock-hint.aspx - chintak ( my blog ) SQL Server  >  Transact-SQL

hi let assume want normalize table 2 tables. eg. table person columns phonenumber1...phonenumber5 tables person , phonenumbers foreign key constraint person phonenumber , deletion of phonenumber1..phonenumber5 columns person table.  want preserve data ie phonenumber1..phonenumber5 should end 1 record each non-null data in phonenumber table . how use ssdt achieve ? this 1 simple scenario face in day day life , have been using hand-coded sql manage this. in more complicated scenario, 1 set of tables change set of tables. there easy way in ssdt manage these kind of schema changes , @ same time manage data mappings successfully ? thanks lakshmi hi lakshmi, the point there class of changes 1 may want make schema ssdt incapable of doing nature of how works. @ time of writing there no new features in ssdt cope class of problems other smart defaults , may or may not help. jt objectstoragehelper<t> – winrt utility windows 8 | http://sqlblog.com/blogs/jamie_thoms

hi i running windows 2003, sql management studio 2008 express.  accpac application requires sql.  use acronis disk imaging software backup therefore image taken of machine , no native backup being performed on sql databases.  in past had sql 2005 on machinge purpose of running previous backup software , sophos, services have been disabled within services environment. i confused , need guidance not aufait sql. my event viewer logging following errors:- 3014, 18210 , 24583.  when investigate sql management studio window (sql logs) same erros being recorded. errors backupiorequest::reportioerror: write failure on backup device '{6ce7cc4c-a29a-47d0-9fe0-aa698b635819}129'. operating system error 995(the i/o operation has been aborted because of either thread exit or application request.).  07/19/2013 00:03:25,backup,unknown, error: 18210 <c/> severity: 16<c/> state: 1. error: 3041<c/> severity: 16<c/> state: 1. error :24853 how can resol

hi guys, need bits of advice.   i data several tables in database , export database b.  in instance both databases are sql  use ddq task vb script provide logic insert record if dosnt exist , update record if does.  know if there more effcient task can perform function, dosnt require vb script     the 2nd piece of advice i'd know concerning getting data oracle database , importing sql database through use of csv files.  process slow (up 8 hours).  there way of using kind of dts package speed things up? or not possible.   many thanks sql2005 integration services great scenario. can add lookup task , handle control of flow in 1 package. if you're using sql2k, perhaps dump data holding table , run simple insert statement put in new values?   if you're taking data oracle, create dts/ssis package query oracle direct , pump data sql server. i'd have thought efficient way.   hth!

hi i have below code update browser title.   htmlpage.window.eval( string .format( "document.title='{0}'" , title));  but if value of title contains apostrape (') throwing error. have tryed @ , \ escape sequences. still getting error. suggesstions. thanks anandraj.a. use escape character \" htmlpage.window.eval( string .format( "document.title=\"{0}\"" , title));   Silverlight  >  Programming Silverlight with .NET – General

we have 2 branches, main , dev branch.  merged main dev.  we've done few times, , have had problems files not having correct content.  i.e. image.cs should contain small class called image, contains assemblyinfo.cs file.  little frustrating, tried careful , catch before went wrong. however, our last merge left dozens of corrupt files, including numerous interface files (usually less 2kb) new sizes in mb range. we're running tfs 2008 on windows 2008 server visual studio 2008 team system team suite clients. has seen behavior before?  we're lucky happened on our dev branch, not our main branch, nonetheless, have lost lot of work. thanks wow.  mess.  looks being caused out kaspersky anti virus software.  large numbers of files being brought down server, virus check hosing delivery of files.  if brought them down 1 @ time, fine.  wasn't seeing problem because had somehow missed deployment of kaspersky on machine.  else had issue. also, our site had begun cause bsod's o

in searches found how can create dynamic script (using execute sql task) inside each loop supplied list containing name , other details table. however, when try fill table data flow, i'm not seeing object allow me map unknown columns. however, in case search led me down wrong path, more general description. have 2 existing databases, i'll call them base , dynamo. base used app that's being being integrated app uses dynamo. base being redesigned. for several tables need create new table in dynamo, name doesn't match name base, , columns not same. transforming data, know how in data flow. the problem in column mapping. can attach tables using variables, i'm not finding way similar thing columns. identifying correct ssis objects can lead me solution appreciated. thanks, dave it sounds you're trying design data flow connect columns don't know @ present - , know @ runtime.  ssis unable using bids designer - period. however, may not exact problem, , if is, there

hi, it possible automatically notify if release rejected because of failed step( e.g. sql server not available therefore deployment of dacpac fail) ? thank you, daniel daniel hi daniel emails sent when component can't run because of server unavailability - go release managers. it's pretty coarse grained setup , colleague of mine has posted more details here . cheers - graham blog: http://pleasereleaseme.net    linkedin: Archived Forums V  >  Team Foundation Server - Build and release management

hello, did manage create transparent background surfacelistbox ? no background or borderbrush, neither overrides in templates (also generated ones) seem work. in blend transparent, @ runtime light whiteish halo there... thank you stefano .: stefano baraldi, ph.d. sb@tabulatouch.eu tabulatouch.eu onthetabletop.eu hello, did manage create transparent background surfacelistbox ? no background or borderbrush, neither overrides in templates (also generated ones) seem work. in blend transparent, @ runtime light whiteish halo there... thank you stefano .: stefano baraldi, ph.d. sb@tabulatouch.eu tabulatouch.eu onthetabletop.eu found it. it hard find problem lies surfacelistboxscrollviewerstyle. i edited copy of template of surfacelistbox. relies lot of other templates. extracted template , changed has no background @ all. or change template (i left away stuff, because otherwise message long, can retrieve left out stuf doing copy of template yourself):

hi all, i have primary datafile , secondary file of same database on d:\ drive @ mount point 1. today primary file got full , throwing full error. d:\ mount point 1 is full files reside. i detached database , moved secondary file mount point 2 on same d:\ drive. when tried attach database once again, it strated throwing error primary file missing. somebody please explain...!!! thanks, hunt_sql hi hunt_sql, please explain exact steps taken while dettaching , attaching files. share complete error description & error no. in case files (data-log) available can try re-attaching them. as per scenario primary file full -  if there file growth restriction on primary file - after secondary file movement (if @ required) need release restriction or increase upper limit file can used. sarabpreet singh anand blog , personal website this posting provided , "as is" no warranties, , confers no rights. please remember click "mark answer&

i getting error while doing data driven subscribtion of ssrs using c#. the required field field missing input structure. ---> microsoft.reportingservices.diagnostics.utilities.missingelementexception: required field field missing input structure. the stack trace is  server stack trace:     at system.servicemodel.channels.servicechannel.handlereply(proxyoperationruntime operation, proxyrpc& rpc)    at system.servicemodel.channels.servicechannel.call(string action, boolean oneway, proxyoperationruntime operation, object[] ins, object[] outs, timespan timeout)    at system.servicemodel.channels.servicechannel.call(string action, boolean oneway, proxyoperationruntime operation, object[] ins, object[] outs)    at system.servicemodel.channels.servicechannelproxy.invokeservice(imethodcallmessage methodcall, proxyoperationruntime operation)    at system.servicemodel.channels.servicechannelproxy.invoke(imessage message) exception rethrown @ [0]:     at system.ru

what i'm looking samples in using sql server 2008 in console application want able insert, select , update. 1 have samples in vc# 2008. toppers bbs http://toppersbbs.dtdns.net hi, the "console" mode has nothing different .. can use sqlclient.sqlcommand object in richclient interfaces.. http://www.csharp-station.com/tutorials/adodotnet/lesson03.aspx regards http://www.asql.biz - dbamgr2k - dbamgr , further sql tools SQL Server  >  SQL Server Express

greetings,  name bryan krieger , program manager working on upgrade feature within team foundation server.   in process of testing upgrade feature on tfs 2010, , in the next release able upgrade directly either tfs 2005 or tfs 2008.   right are collecting real world customer databases test against.    specifically, looking customers of tfs willing share (via upload secure ftp site) sql backup copy of databases here @ microsoft.  use these databases to test tfs upgrade feature.   if interested in participating , can share tfs database, please email me directly at bryan.krieger@microsoft.com .   thanks, bryan bryan krieger - principal program manager - tfs hello, bryan! i interested in offer - did send e-mail ready provide our tfs 2005 databases testing appropriate installation package of tfs 2010 server in order able test upgrade our premises. thank response. Archived Forums V

i have database backup made on sql server 2005 machine.  backup made using ssms logged in 'sa' on local machine console.   i trying restore database machine sql server 2005 on it.  if restore database using ssms logged in 'sa' on new local machine console , try see 'securables' local user in database, not see anything.  however, if restore database connecting same sql server 2005 machine using ssms machine , logging in 'sa', when restore database, can see securables user.   to further complicate things, if create new user on target machine using local connection, cannot set securables user, if use ssms connection machine, can.   has experienced this, , there can alleviate behavior.  need ship backup of database customer, script creation of user , permissions.  have of scripting completed, doesn't persist settings because of noted above.   thanks --ct   edit: more information   here's bit more tried.  logged in local mach

hi, i trying access ssrs report using url below, ="javascript:void(window.open('http://10.10.11.15/reportserver/pages/reportviewer.aspx?%2ftransaction_all_reports%2fcustomer_+payment_receipt_report&rs:command=render+name &reportparameter1=" & fields!custtransid.value & " &rs:command=render','_blank' ,'resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=1040,height=1040'))"                   when try access above url, asked network credentials, giving pages of ssrs report rendered in browser window. now want display these contents in popup window inside webapp. when try open asks credentials, what need possible give credentials inside  above code block? username , password, i need directly open w/o asks credenetials can me please ,it save life... hi samba, from description, want pass credentials via url use can access report manager directly, right? in reporting services, can use lot of param

hi, in 1 of our environment, tfs web acces web site ask credential in loop remote access works great local. all tests made same credentials, it's not user rights problem. tests locally on server, accessing web acces localhost. result : success locally  on server, accessing web acces servername. result : success remotely, accessing web acces servername. result : ask credentials what looked i have compared applicationhost file of environment in problem applicationhost file of other environment works correctly, , found little no differences. fixing differences, not solve problem i have looked @ authorization, authentication rules, .net authorization rule , ip address domains restriction , found nothing different between both environment. just clear, problem not fact credentials prompted. it's fact when input correct authorized credentials, still don't goes through. please, don't suggest add url in trusted or intranet sites. hi richard, as can visi

how keep slicers , column sizes in pivot changing? hi alexmartini,  slicer size, please right click slicer->size , properties, format slicer window, can format slicer want. please see highlighted in red line. column size, right click pivot table->select pivot table options. in pivot table options dialogue box, click “layout , format tab”, , uncheck “the box autofit column widths on update”. please see highlighted in yellow shown in screenshot below. after that, column width doesn’t change each time pivot refreshed, need define how wide column urls should be. go pivot , select column long urls. right-click, , enter value column width.  if have issue, please feel free ask. best regards, angelia 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 contac

can direct me documentation referring how windows populates domain list via winlogon prompt (log on section). netbios broadcast scan, domain trusts, etc.? also how vary across different os versions?   this forum related sql server setup , upgrade related discussions. feel question needs moved appropriate forum pradeep adiga blog: http://www.sqldbadiaries.com SQL Server  >  SQL Server Setup & Upgrade

trying shred xml relational table rows , can 1 set of node values .. having difficulty creating pair of columns. relevant part of xml looks ... <ns:coverage>      <ns:coveragecd>cvalue1</ns:coveragecd>      <ns:form>           <ns:formnumber>fvalue1</ns:formnumber>      </ns:form> </ns:coverage> i can navigate through xml , pull set of rows values of coveragecd. i'm trying add column each output row formnumber value associated coveragecd value. however; formnumber not present. found example using 'outer apply' can account that, it's not working me. here's xquery: with xmlnamespaces('http://www.mycompanyname.com/acord1.11.0/policy_1.0/xml' "ns") select cov.i.value('.', 'varchar(30)')   [coverage],          form.i.value('.', 'varchar(30)')  [formnumber] from  dbo.mytablename        cross apply xmlcolumn.nodes('.//ns:coverage/ns:coveragecd&#

i have stacked bar chart values "invoiced" , "budget" , 2 categories year , month - problem bar chart shows values invoiced , budget in top of each other , not overlapping each other . ex: now:  invoiced =  200   budget = 300   - bar chart shows column of 500 month (not correct) what want is show 1 column each month 200 colour green , 200 300 colour blue example.... how achieve ? hi hcmj, by default, bar value not overlapping each other in stacked bar chart, , cannot increase or decrease gap between series in reporting services. based on research, find workaround can achieve requirement, please refer steps below: create dataset query below (sample data): create table #temp(name nvarchar(50),time nvarchar(50),value int) insert #temp values     ('invoiced','year',100),('invoiced','month',200),('budget','month',300),('budget','year',600) select * from  #temp insert time field cate

hi all, i have problem showing 1 of detail rows after group subtotas ... i have dataset looks this: here need group on left field(city names) in report .for each group each row appearing 'r' value calculated based on seperate conditions.is there way can show 1 of these detail row under group containing 'r' can shown after group subtotal? the output report should this: i want show pointed row after group sub total... please ask me further clarifications...   hi nag1234, thanks post. according description, specify report table showing 1 detailed row after group subtotal in each group. if use table control show data, can take use of group header show subtotal value. can specify expression detailed row control visibility of detailed row. show subtotal value on group header. 1.right-click row handle of group row, select edit group. 2.check include group header item, click ok. 3. right-click relevant textbox, select ex