Lun

in 2000 made update processing off dimension , full processing of last partition in every cube. made in transaction. duering processing old version of data available mdx querying. if i do same in 2000, database seem locked. what make wrong? hiere xmla batch send as2005. < batch transaction = " true " processaffectedobjects = " true " xmlns = " http://schemas.microsoft.com/analysisservices/2003/engine " > < parallel > < process xmlns:xsd = " http://www.w3.org/2001/xmlschema " xmlns:xsi = " http://www.w3.org/2001/xmlschema-instance " xmlns:ddl2 = " http://schemas.microsoft.com/analysisservices/2003/engine/2 " xmlns:ddl2_2 = " http://schemas.microsoft.com/analysisservices/2003/engine/2/2 " > < object > < databaseid > mw </ databaseid > < dimensionid > abteilung </ dimensionid > </ object > < type > processupdate </ type > ...

i installed sql server 2008 standard edition (10.0.1600.22) got "evaluation period has expired..." error message. changed registry key specified in http://support.microsoft.com/kb/971268  using option 2 still error message. prior this, had sql server 2008 r2 nov ctp version, , may have deleted folder automatically created as part of installation (the 1 numbers) , somehow cannot uninstall evaluation version successfully. tried remove each of sql server 2008 programs in add/remove programs somehow, there 2 cannot remove, microsoft sql server 2008 r2 november ctp , microsoft sql server 2008 r2 setup november ctp (english). now, cannot sql server 2008 installed on server. please help!! thanks. thanks. a~ hi, thanks post. it seemt still have ssms nov ctp version installed on server, kb article applies rtm version of ssms may not work here. work around issue, need make sure sql server 2008 nov ctp uninstalled before try installation. that, recommend followin...

hello,   have implemented forms authentication report builder. datasources report models have sqlserver authentication. want changed windows authentication due security issues. did that. able access model, unable connect database model. windows authenticated user application pool identity, have access database, in fact has serveradmin access.please advice going wrong. hi canadags, as per understanding, when using form authentication, windows integrated security disabled. @ time, data source use domain account access database invalid. there similar issue, can refer it. http://social.msdn.microsoft.com/forums/sqlserver/en-us/99df3c51-9cbc-4303-8c71-3a0b392a0c0f/using-a-domain-account-for-a-shared-report-datasource-with-a-custom-security-extension-in-ssrs-2008?forum=sqlreportingservices regards, alisa tang if have feedback on our support, please click here . alisa tang technet community support ...

hi guys,  forgive me if question has been answered i'm trying find out best way tackle 3 exams required mcsa in sql server. read blog post on pluralsight website which, in discussing mcsa in windows server, advised best approach study 3 exams rather 1 @ time there's amount of overlap. my question apply sql server 2012 too? or bets study for, , take, 3 exams separately , 1 @ time? i'm completing trainsignal (now pluralsight) sql server 2012 administration essentials 28-video course , begin going through equivalent book when read blog post. my background in desktop/server support (10years following degree) , before now, have had no real exposure sql server. asked year ago current manager "keep eye" on sql instances have , began replicating our fail-over cluster in virtual environment testing purposes , gain understanding of set-up. i've since developed keen interest in sql server , plan certified...    many in advance. marcus. exams are: ...

hello all, i created simple silverlight 2.0 project  . in default.aspx page added three  images tv channel logos zeetv.jpg   ,setmax.jpg ,sony .jpg .now want show  show silverlight  popup on mouse on event of these logos .the silverlight  popup contains videos respective logo on which  mouse on . if have code or links me please share also. how achive this.  i waiting reply.   thanks dinesh chaudhari   so want silverlight control show in regular web page popup ? in case put silverlight control tag in hidden div. when mouse on html images on page show div. on silverlight object control tag, can use initparam specify page want silverlight start page <object data="data:application/x-silverlight," type="application/x-silverlight-2-b1" width="100%" height="100%"> <param name="source" value="clientbin/wordtest.silverlight.xap"/> <param...

i using sql server on windows azure vm (d12_v2, 4 cores, 28gb) run group of relative small databases (~80, not more 8-10 active @ time). recently moved sql server 2016 running on windows server 2016. since have noticed times cpu percentage getting high (>90%) minutes. has happened 4 times in last 2 weeks. during high load period users cannot connect databases. cannot connect same machine ssms , named pipes. so, can explain me happening? can change parameter maybe in server protect situation happen? has else noticed in sql server 2016? ps: using default configured sql server 2016 vm machines, standard edition. tempdb (4 files) running on local ssd. some parameters have changed: max degree of parallelism = 2, blocked process threshold = 30, optimize ad hoc workloads = 1 thanks, dimitris you need resolve causing high cpu.  need enable alerting when high cpu , follow steps here diagnose it. https://blogs.msdn.microsoft.com/psssql/2013/06/...

hi, i new in bi, kind of reports presented ms sql server bi solution? what kind of client tools available?    thank you hi, for reporting service client tools, can used report creation are 1) report builder 3.0 2) sql server devlopment studio for types of reports can refer link http://msdn.microsoft.com/en-us/library/bb630404.aspx kindly revert more questions. - chintak ( my blog ) SQL Server  >  SQL Server Reporting Services, Power View

i need fill data destination table source table. columns identical in both. need see if same primary key exists in destinatination table in source table. if there primary key in source table , destination need update other coulmns based on change in source table if not need insert data. how accomplish this? sounds me should have separate package (or data flow, or pipe within data flow - depending on best practice follow) fills in normalized tables first.  i suggest taking @ using sql server 2005 integration services populate kimball method data warehouse (level 200) webcast: http://msevents.microsoft.com/cui/webcasteventdetails.aspx?culture=en-us&eventid=1032297073&countrycode=us also, might @ " checking see if record exists , if update else insert " thread: http://forums.microsoft.com/msdn/showpost.aspx?postid=1211340&siteid=1 SQL Server ...

hi, met question when use 'xp_cmdshell' invoke executable file. '.exe' file used insert record table in database. when exec xp_cmdshell '**.exe', process can forked, no record has been inserted table. have tested '**.exe' in command line, can work correctly. knows why? thanks! just checking, have you've tried commandline on own machine, or on databaseserver? because when use xp_cmdshell execution takes place on databaseserver you're connected on.  m. streutker, info support | blog SQL Server  >  SQL Server Integration Services

hi, is there way force users of tfs latest version sourcecontrol before cheching in changes? get latest version on checkout doesn't work becaus if working on file couple of hours file can changed , checked in else.  thx pieter if file has changed since last time got latest, prompted resolve conflicts.  tfs won't let overwrite newer version of file without going through conflict resolution first. so if got latest morning at 9:00 and worked on changes, checked out @ 9:30 , checked in @ 10:00.  when check in @ 10:30 going prompted resolve conflicts between 10:00 check-in , yours.  in cases auto-merge feature works, unless same lines of code changed in case you'll have open merge window. so tfs forcing latest, in sense.  if latest before checking in, changes wouldn't lost...you prompted resolve conflicts if changed file checked-in else since last time checked out. esteban garcia - my blog ...

i understand between inclusive. suprisingly, im not getting same results when select values using between in folowing statements: statement 1: trunc(to_date(     '01011970' , 'mm/dd/yyyy' ) + ( trandate + 2 * 3600000 ) / 86400000 ) between : atrandate and : btrandate statement 2: and     to_date( '01011970' , 'mm/dd/yyyy' )+( trandate + 2 *3600000 )/( 86400000 ) between to_date( '03-01-2010' , 'mm-dd-yyyy' ) and to_date( '03-31-2010' , 'mm-dd-yyyy' ) statement 3: and trunc(     to_date( '01011970' , 'mm/dd/yyyy' )+( trandate + 2 *3600000 )/( 86400000 )) between to_date( '03-01-2010' , 'mm-dd-yyyy' ) and to_date( '03-31-2010' , 'mm-dd-yyyy' ) suprisingly, different results these statements when select using these conditions. doing wrong?? hi, it seemed using oracle, ...

i've had vs2005 installed quite time purchansed sql server 2005 developer , installed it.  how accomplish integeration sql server 2005 vs2005?  had c# express @ 1 point , sql express full tool install.  provided me designer sql server (which vs2005) , seperate development environment under c# express.  how integerate them functionality resides within vs2005?   any can provide appreciated.   thanks,   dane r. vinson in visual studio, open server explorer window. connect sql server. you 'should' able use server explorer in vs write , test sql code. SQL Server  >  SQL Server Setup & Upgrade

so i'm running write tests against san using sqlio. in parallel i'm watching machine using performance monitor. see during write tests reads shown in perfmon. can me understand? discussed sqlio results infrastructure vendor , results didn't build lot of trust in tool... thomas pagel hi thomas pagel, i test in environment, shows following screenshot. i trying involve more familiar topic further @ issue. sometime delay might expected job transferring. patience appreciated. for more information, there example san performance tuning sqlio, can review following article. http://www.toadworld.com/platforms/sql-server/w/wiki/10406.san-performance-tuning-with-sqlio.aspx regards, sofiya li if have feedback on our support, please click   here . sofiya li technet community support SQL Server  >  ...

hi there, everyone have permissions, want revoke doesn’t need have it. can grant roles need need?  how that thanks the starting point users not have permission anything. however, if working in existing database, sorts of permissions may have been granted on various level. maybe simplest create new database , make sure user access database. however, keep in mind logins member of sysadmin or have server-level permission control server can access database on instance. SQL Server  >  SQL Server Security

hello there, i know there post this, couldn't find looking for... i'm trying create report linked sharepoint form library. list contains form have repeating fields. these fields published columns library. data of these fields merged make 1 row form. accomplish separate these fields , make 1 row each of values of fields. there exemple of i'm trying : title                                     startdate                                        enddate ---------------------------------------------------------------------------------------------           ...

hello, i need regenerate oracle schema data modal, never complete job.  process ends before complete model made available.  half schema, , regeneration stops. i don't know life of me why that's happening, , don't know turn to. does have resources can go help?  i've don google searches , come empty each time. there plenty out there report model, i'm trying generate data model.  don't tell me synonymous... they? thanks in advance can point me in right direction help. regards, gary f. paychex dba hi gary f, according description, failed create data model using oracle database. right? as said, trying create data model instead of report model. did create data model? in sql server reporting service or oracle database? if trying create model in reporting service. data model said synonymous report model. should know since reporting service 2012, report model feature has been deprecated. reference:  https://msdn.microsoft.com/en-us/librar...

pertaining silverlight applications use data web service, has tried overriding path of service in xaml , accessing code? it seems me our group going need in order move from through the dev/test/prod process. ok, want change webservice path depending on develpment mode, testing mode or in production. can use init parameters , web.config file. this, have appsetting in web.config file <appsettings> <add key="serviceuri" value=http://localhost/yourwebservice.svc/> </appsettings> in code behind file of aspx page host silvelright control(say xaml1), , assign initparameter of sl control this, protected sub page_load( byval sender as object , byval e as system.eventargs) xaml1.initparameters = "serviceuri=" & configurationmanager.appsettings( "serviceuri" ) end sub go app.xaml.vb(or .cs) file , write application_startup event this,    private sub application_startup( byval o ...

environment ·          sql server 2008 (tried sp1, sp2, & sp3; seems make no difference) ·          report viewer 10 (tried sp1 release well; seems make no difference. asp.net framework 4.0 sp1, c# web application, being viewed in ie9 ------------------------------------------------------------------------------------------- we've had sql reports/report viewer in production 2 years in commercial web app. of ie9, rendering of report , handling of within report viewer changed drastically our prior experience. i first noticed rendering problems in venerable report viewer 9.0.0.0 had been relying on. major issue failure respect sizing of layouts, resulting in text wrapping , other undesired attempts renderer display report in minimal shrunken space.  i decided because aging reportviewer didn't support more recent browsers, , upgraded reportviewer 10.  this has f...

i know whether metro apps can call apis in print spooler api of win32 or not , how informations such installer printer drivers , printing jobs monitored. when testing on developer preview, test app c++ can call print spooler apis such openprinter(). but spooler apis are not listed in apis metro style apps ( http://msdn.microsoft.com/en-us/library/windows/apps/br211369.aspx ) i’m wondering spooler api can called metro app or not. also, windows.devices.enumeration namespace ( http://msdn.microsoft.com/en-us/library/windows/apps/windows.devices.enumeration.aspx ) doesn't mentioned printing devices in deviceclass found. have doubt how find out installed printer driver informations such list of print name , related information on metro ui. if it's not possible call spooler api metro app, how installed printer driver information , print job information via winrt apis? and how to search actual printers on network via same way windows 8 using upnp...

  what test parameters should consider effective test report or dashboard our customer? manas,   since have mentioned communication of actual test progress purpose of test report/ dashboard, might want consider following parameters/ data report:   1) testing scope (for current release or time period etc.) 2) team members involved in test 3) test environment(s) used 4) tests designed/ developed 5) test held (with reasons), tests executed, tests yet executed 6) defects reported (broken portal/ product, severity, priority, status, reporter, assigned etc.) 7) issues faced while testing (with reasons/ possible solutions) 8) analysis of test far   out of items above, item # 4 v/s 1, 5 v/s 1 , 6 can represented graphically in simple manner.   your report/ dashboard design might or might not able satisfy data requirements of people in distribution list. if receive suggestions them, might want incorporate suggestions in report/ dashboard.   if possible, sho...

hello, planning use tfs, use mantis, want use tfs bugtracker know experience, why better or worse tfs?, advantages? need know benefits can justify project. thanks! mcpd enterprise applications developer http://wantmvp.blogspot.com/ tfs much more bugtracker. complete application lifecycle management product wide range of features helps project , organization managing projects. when want use bugtracker. here advantages: 1) customizable in fields, ui , workflow 2) accessable via web, excel, ms project & visual studio 3) rich eco system of third party vendors enrich experience 4) integration development environment 5) traceability ewald - please remember mark replies answers if help. Archived Forums V  >  Team Foundation Server - General ...

in sql server 2008, have create tcp endpoint if want sql server listen specific ip address , specific port? in sql server configuration manager, tcp/ip protocol enabled , dynamic tcp ports , tcp port fields each ipx has been cleared except 1 ip address. (as directed in http://msdn.microsoft.com/en-us/library/ms177440(printer).aspx ) on 1 ipx tcp port has been set 2505 , on ipall tcp port has been set 2505. if “listen all” property set “no”, remote client connections cannot connect server. if “listen all” property set “yes”, remote client connections can connect server. sql server listening on ports or having tcp port set on 1 ipx , ipall stop sql server listening on ports? concern external firewall (not windows firewall) requires specific ip address , port number. article ( http://msdn.microsoft.com/en-us/library/ms191220.aspx ) seems indicate tcp endpoint needed override default tcp endpoint. installation sql server 2008 (64-bit) developer edition cu3 on windows server 2008 standard s...

i have access db (.accdb) temp tables connecting sql server tables.  there form uses serveral crud queries , generates report.  there few macros , modules running behind scenes.  goal convert access process ssrs report. i'm new access , ssrs migration. approach should taking tackle this? i have access db (.accdb) temp tables connecting sql server tables.  there form uses serveral crud queries , generates report.  there few macros , modules running behind scenes.  goal convert access process ssrs report. i'm new access , ssrs migration. approach should taking tackle this? SQL Server  >  SQL Server Reporting Services, Power View

i have sql 2005 standard sp2 w/ ssis installed on 64bit 2003 server.  have built ssis package can run while in bids/visual studio, when package built job on sql server, fails following message: message executed user: domain\user . microsoft (r) sql server execute package utility  version 9.00.3042.00 64-bit  copyright (c) microsoft corp 1984-2005. rights reserved.    started:  2:41:45 pm  error: 2008-11-07 14:41:45.76     code: 0xc0012024     source: file system task name      description: task " file system task name " cannot run on edition of integration services. requires higher level edition.  end error  dtexec: package execution returned dtser_failure (1).  started:  2:41:45 pm  finished: 2:41:45 pm  elapsed:  0.625 seconds.  package execution failed.  step failed. from i've read, job should run w/o problem.  simple delete file job.  appreciated. mnicolaes do have ssis installed on server agent running on?  sorry unclear if installation on server bids or ser...

is tag used link work items, mean epic, feature , feature requirements , on? tag defined on go while creating work item? or defined elsewhere prior? ask because read wrongly spelled tags deleted in 3 days hi vinosh, >> tag used link work items, mean epic, feature , feature requirements , on? the tag used work items categorize , filter lists, isn’t used link work items. >> tag defined on go while creating work item? we add tags exist work item. we bulk remove tags through web access. # add tags work items categorize , filter lists https://www.visualstudio.com/en-us/docs/work/track/add-tags-to-work-items regards starain we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Archived Forums V ...