Posts

Showing posts from July, 2013

FTP Task moves files but does not change the file to ASCII

i have ssis package picks text files linux ftp directory , returns them local sql server further processing.  problem seems though i  set "istransferascii" operation in ftp task editor "true" file still not useable after move.   way can make work open manually in wordpad , save it. conversely if use utility winscp , set transfer settings "text" file usable.  not sure issue files suspect has unix style lf conversion windows style crlf linebreaks. am on right track?  , if know how fix in ssis? this first post here let me know if picked wrong catagory here.  thanks! hi, the ftp task comes ssis not work unix/linux. there compartibility issuse. there wrote :: "it seems likley incompatability between ftp client/servers. there many flavors , versions of ftp on unix , our client not 100% compatible of them." please visit following link more clarification:: " https://connect.microsoft.com/sqlserver/feedback/viewfeedback.aspx?feedbackid=150196&w

unable to identify Silverlight controls using CodedUI plugin

hi, using visual studio 2013 codedui project. have code automation out-of-browser silverlight 5 applciation. silverlightuihe lper.dll has been added in actual silverlight applciation , code has been built using reference dll. after installing updated code , trying use object spy visual studio 2013 plugin installed, still unabel object properties. see following error: missing here? please help.... "no silverlight controls detected. verify application under test built using silverlight assemblies version of 4.0 or greater , reference microsoft.visua lstudio.testtoo ls.uitest.exten sion.silverligh tuiautomationhe lper.dll assembly has been added project. more information, see http://go.micro soft.com/fwlink / ?linkid=204562 " unique identification has been added controls. hi, i think may caused application. debug application loacating problem. besides, here has tutorial microsoft visual studio 2013 coded ui test plugin silverlight,please have see: http://vi

replication issue (log reader agent is not running)

we have upgraded sql server 2000 2005. after upgrade, replication not working following symptoms: 1. subscription status show 'not running, performance critical'. 2. when try re-sychronize option "start synchronziing" , error encounter below : replication montior not start job '..................' additional informtion : sql server agent error : request run job stx-t01-stl_newcc (from user sa) refused because job running request user sa. (microsoft sql server , error: 22022) anyone kindly ? or idea further troubleshoot issue ? thanks , best regards, can stop sql server agent, , in task manager , see if see instances of logread running. if see there kill them. restart sql server agent , see if works time. if continues occur need stop log reader agents , check  select * mslogreader_history see if agents have value of 1. if so, set 2. can identify problem agent query: select id, name   mslogreader_agents looking book on sql server replicatio

Realtime record count for table...

here's little sql 2005 script i wrote: 1. start running script.... declare @x int select @x = 1 while ( @x < 75000) begin  insert into  mytesttable  values (@x)  select @x = @x + 1 end   2. while script still running, want know how many records in table. same query window script,  i have run both of following statements.   select count(*) mytesttable witn (nolock) select count(*) mytesttable witn (tablock)   instead of getting the answer immediately, run after original script has completed. seem "blocked". how can near realtime count of number of records in table while script populates table?   thanks,   barkingdog               barkingdog wrote: yes, opening new window did enable to the "select count(*) ...."  run  why is case? (after all, i couldn't run "select  count(*) .."  from the window invoked original script. seems orignal script "blocks" conneciton need open new conneciton (windo

Only one CUBE in Team Foundation Server

when open analysis services in bi studio see 1 cube tfs. per book should seeing multiple cubes. wonder if knows going on here? thanks hi there, there 1 cube tfs.  however, in sql enterprise, there views on cube called "perspectives" show parts of cube -- example there perspective "code churn" show measures , dimensions relevant churn in checkins.  these show in bi studio.  if not using sql enterprise see 1 perspective, whole cube. which edition of sql have installed? mauli Archived Forums V  >  Team Foundation Server - Reporting & Warehouse

SQL 2005 components used by Team Foundation Server

the installation of team foundation server installs following sql 2005 components: analysis services data transformation services reporting services can more information provided on how these components used team foundation server please? thanks help.   analysis services used in our warehouse processes.  allows create cubes on data pushed report database (bisdbdw) data transformation services not used tf (as far know) reporting services used display reports in team foundation. Archived Forums T-U  >  Team Foundation Server - Setup

Limit number of subfolders users can create

we're looking way limit number of subfolders user can create in given share.  have large number of users regularly create massive amounts of subfolders within shares. there doesn't appear easy way limit - we're open third party applications or thoughts on customized group policy if needed.  here overview of latest quota management microsoft  http://www.windowsnetworking.com/articles_tutorials/configuring-volume-folder-quotas.html while quotas @ folder level rather @ volume level, believe still focussed on amount of disk blocks used rather number of folders i dont know of off shelf solution, should relatively straight forward build 1 using wdk samples. major issue getting solution signed microsoft loaded on 64 bit servers.  dilip naik   www.msftmvp.com Windows Server  >  File Service

Help working with CSV files

i have csv file 3 columns jobtitles ----- adrole1----- adrole2 title1---------role1---------role4 title2---------role2------- -- role5 title2---------role3--------role6 and have list of active directory users in other variable $users. i need ad users jobtitle match ones in first column of csv "jobtitles" i like: import-module activedirectory $csv2= import-csv e:\mycsv.csv | select-object jobtitles $jobtitles = @() foreach ($line in $csv2) { $jobtitles += $line.title } $users = foreach ($user in $result){ get-aduser $user.loginname -properties title, samaccountname } foreach ($user in $users) { if ($jobtitles -contains $user.title) { write-host $user.samaccountname $user.title } } this works fine. what don't know how reference same row in csv for example if user jobtitle matches title1, add user ad group role1 , role4 (because in same row roles) any idea? thanks in second line in script, " | select-object jobtitl

Windows Server 2003 with a domain ... intermittent 553 errors

hello, i have client windows server 2003 domain in office.  the dns there has settings global domain (domain.com).  his email through website host (dotster).  we see intermittent issues getting 553 errors when sending email.  his receipt of email seems work..  this happens both on laptop off network @ house , gets error , desktop on domain. his office , home internet connections both through time warner.  i have server setup primary dns server (it dc , dns server) , time warner dns servers secondary , tertiary. from office (also on time warner) can ping smtp.domain.com , pop.domain.com.  from office "could not find host".  from office has no trouble getting anywhere else on internet makes me think local dns issue server looking smtp , pop inside domain. is there change dns on dc need make work consistently him?  i'm programmer, not networking guy (sorry i'm sure simplistic question) know how business goes. hello, please post unedited ipconfig /all pro

Server config file

can please help, need know can find configuration file. windows server 2008 , i need provide configuration file particular server. thank in advance. are looking system information ? if answer yes, can use  systeminfo command fetch details systeminfo:  http://technet.microsoft.com/en-us/library/cc771190(v=ws.10).aspx if not looking for, please elaborate needs i not represent organisation work for, opinions expressed here own. this posting provided "as is" no warranties or guarantees , confers no rights. - .... .- -. -.- ... --..-- ... .- -. - --- ... .... Windows Server  >  Windows Server General Forum

Public Folder Query

i trying capture information in single command from: get-publicfolder get-publicfolderstatistics using following command. i'm struggling getting replicas have in bold. get-publicfolderstatistics "\intern" -server mail02-bh | select-object name,folderpath ,@{label="replicas";expression={(get-publicfolder $_).replicas}} ,itemcount,totalitemsize,creationtime,lastaccesstime any ideas on i'm doing wrong? very strange, using -join for? i'm joining array that's returned single string: ps c:\scripts\powershell scripts\misc testing\12-3-2014> get-publicfolderstatistics '\scanning' | get-publicfolder | select -expandproperty replicas exchange-pfdb1 exchange-pfdb2 ps c:\scripts\powershell scripts\misc testing\12-3-2014> (get-publicfolderstatistics '\scanning' | get-publicfolder | select -expandproperty replicas) -join ',' exchange-pfdb1,exchange-pfdb2 don't retire technet!

Mapped Drive Issue

  i trying distribute office 2007 using windows installer package.  if uncheck disk drives under common rdp settings on remoteapp server , attempt open excel file on local machine mapped drive, receive error message stating "the remote program c:\file.xls not found".  if keep disk drives checked, able open file mapped drive, when try save file, attempts save mapped drive on \\tsclient\ instead of mapped drive on terminal server.  possible open excel file locally mapped drive , have save mapped drive on terminal server?  need type of drive redirection on login? got it.  did have bug in mstsc client when using office 2007 prevent saving file network share.  fixed after vista rtm date.  test launching app off of server 2008 box (don't install .msi takes on file extensions on app server or break things , .xls files no longer launch) , verifying allows save.  if fixes things, when users install vista sp1 or xp sp3 fix issue you.   if doesn't f

ISCSI Target Scheduled Snapshots

i know there cmdlets snapshot target there built in way schedule snapshots? alternatively, there cmdlet list snapshots target can create script run on schedule remove old snapshots , create new ones. i forgot mention i'm using server 2012 r2.  i can't find ui in server 2012 r2 scheduling snapshots. here script wrote.  you can create scheduled task in windows run daily. $daystokeep = 7; $disks = get-iscsivirtualdisk foreach($disk in $disks){ $snapshots = get-iscsivirtualdisksnapshot $disk.path; write-host "" write-host "deleting old snapshots disk" $disk.path; foreach($snapshot in $snapshots){ $snapshotdate = $snapshot.timestamp; $snapshotfound = $false if($snapshotdate -lt (get-date).adddays(-$daystokeep)){ $snapshotfound = $true write-host "deleting snapshot" $snapshot.snapshotid; remove-iscsivirtualdisksnapshot $snapshot.snapshotid; writ

How to size a Scale-out File Server

hi, we looking implement 2-node 2012 r2 scale-out file server cluster (using sas jbod enclosure) primary purpose of storing vhd files accessed 4-node 2012 r2 hyper-v cluster using 10 gigabit ethernet (no rdma).  our environment can characterised having large number of idle vms experience sporadic, low intensity use (this *not* vdi environment).  have 2 questions. 1) extent ram consideration sofs servers?  can't find documentation suggest there benefits gained having more ram in sofs servers don't know if should go 8/16/32/64+ gb ram in each of nodes. 2) need keep costs down, don't think rdma / smb-direct nics going within our reach.  should have 2 * dual-port 10 gbps nics in both sofs & hyper-v boxes? unless vms read-intensive , you're going deploy csv cache memory requirement serving idle vms can pretty low. ram cheap these days going less 16gb per node not sound reasonable. sample, see: windows server 2012 file server tip: enable csv caching on sca

how to folder redirection for xp client from windows 2008 GPO?

hi i'm trying folder redirectoin policy in windows 2008 gpo xp client not work. can tell me how can folder redirection xp client. azad hi azad, first, since have windows 2008 in environment, use group policy management console rsat ( http://www.microsoft.com/downloads/details.aspx?familyid=9ff6e897-23ce-4a36-b7fc-d52065de9960&displaylang=en ) need enable gpmc programs , features after installation. second, when configure folder redirection, there option on settings tab called "also apply redirection policy windows 2000, windows 2000 server, windows xp, , windows server 2003 operatin system. please enable setting , try on separte ou. otherwise please post more specific error message getting in environment. thanks, gunter Windows Server  >  Group Policy

server 2008 R2

i install ie 7 on server 2008 r2...how do that?? hi dnationsr,   why want install ie 7 on windows server 2008 r2? why wouldn’t ie 8 work on server?   if websites support ie 7, can use compatibility view in ie 8 view these websites. more information of compatibility view of ie 8, please refer article below.   introducing compatibility view http://blogs.msdn.com/b/ie/archive/2008/08/27/introducing-compatibility-view.aspx   it possible uninstall ie 8 in windows server 2008 r2. can follow steps below so.   click start , , right-click command prompt , , choose run administrator . note if prompted administrator password or confirmation, type password, or click continue . at command prompt, type following: dism /online /disable-feature /featurename:internet-explorer-optional-amd64 . when prompted restart computer, choose yes .   if remove internet explorer 8, have install third-party browser able browse internet.   however, there seems no versi

Console Reset

whenever approve update group error rest node. causing this? whenever approve update group error rest node. causing this? sounds chronic timeout issue ... suggest starting here: wsus timeout errors lawrence garvin, m.s., mcitp:ea, mcdba, mcsa solarwinds head geek microsoft mvp - software packaging, deployment & servicing (2005-2013) mvp profile: http://mvp.support.microsoft.com/profile/lawrence.garvin http://www.solarwinds.com/gotmicrosoft the views expressed on post mine , not reflect views of solarwinds. Windows Server  >  WSUS

Domain consolidation, and DHCP/DNS config with seperate subnets

so here deal.  we have 2 offices connected via vpn tunnel through 2 watchguard firewalls.  office has domain of "a.domain.com" , subnet of .1  office b has domain of "b.domain.com" , subnet of 0.  the domains have trust setup , things work fine. we want consolidate b domain sake of simplicity.   domain has has 2 dc's running server 2003.  one of supplies dhcp , both run wins , dns. domain b has 2 dc's running server 2003 on one, , server 2008 r2 on other.  with 2008 r2 server handling dhcp, dns  and wins , other running dns , wins well.   i have exchange 2010 running inside of domain b, linked mailboxes attached users in domain. my question this.  lets wanted combine these domains b domain.  i want keep different subnets dont have reconfigure of printers , equipment has static setups, , dhcp server in each office each office handling own dns , replicating other office.  will work simple imagine working?   the other question how move profiles

List COM Objects

in old post ( http://www.vistax64.com/powershell/91583-there-any-script-get-list-com-objects-computer.html ) i've found solution list every com objects in computer these 2 solutions posted: 1) gci hklm:\software\classes -ea 0| ? {$_.pschildname -match '^\w+\.\w+$' -and (gp "$($_.pspath)\clsid" -ea 0)} | ft pschildname , simpler one: 2) get-wmiobject win32_comclass first 1 great because returns pschildname can use in  $xl = new-object -comobject <pschildname> second 1 shorter, , 1 use, far cannot find pschildname in form xxxxxxx.yyyyyyy $xl = new-object -comobject excel.application thoughts ? hi cyreli, the first command doesn't return every com class, those where progid matches pattern of <letters> . <letters>. the win32_comclass doesn't directly contain progid of of classes, time cross reference with the values contained within win32_classiccomclasssetting wind extremely slow executing query.

TerminalServices-Licensing 4105 Error

hello, after have been run windows update in terminal server farm, receive error 4105 regarding licensing, same description in trhead http://support.microsoft.com/kb/2030310?wa=wsignin1.0 . escenario not use licensing in domain controller have installed licensing role in each terminal server. changed scope in licensing manager domain forest because had yellow warning alert gone estatus green error registered in event viewer , receiving email alert scom server. cause of error scenario? sen ceron usually, you'd want single server have licensing role, , terminal servers use server licensing. what reason having licensing role on each terminal server? Windows Server  >  Remote Desktop Services (Terminal Services)

Windows 10 Enterprise Build 10158 won't activate

just got automatic update build 10158 won't activate. error message below. tried different product keys using baked-in preview keys in previous builds have been removed may prompted product key. if prompted, use keys below. action required if prompted product key when installing pc build 10144 or higher, use keys below: • core: ktnpv-ktrk4-3rrr8-39x6w-w44t3 • pro: 8n67h-m3cy9-qt7c4-2tr7m-txycv • enterprise: ckfk9-qngf2-d34fm-99qx2-8xc4k you might want try newly released 10159 http://blogs.windows.com/bloggingwindows/2015/06/30/whoa-another-pc-build/?ocid=announcements_soc_tw_organic_build10159&linkid=15242479 wanikiya , dyami--team zigzag Windows 10 Insider Preview  >  Windows 10 Insider Preview Setup and Installation

File Cleanup Script - Assistance Required

hi all, attempting write file cleanup script , can't seem working how like.  first, let me explain trying accomplish.  cleanup incoming/outgoing folders of our ftp server on regular basis.  folder structure looks this: \\data5\ftpdata\partnername\incoming \\data5\ftpdata\partnername\outgoing partnername have in path different each partner have ftp login setup for.  script delete both files , folders last modified date (.lastwritetime property) of 30 days or older in of incoming/outgoing directories each of partnername sites.  script should not delete of partnername folders or incoming\outgoing folders themselves, no matter date.  so, while have script working primary issue can't figure out way tell not @ partnername folders (which have variable, add additional partner-names ftpdata folder).  below script in it's current form, works, except delete partnername folders (which not correct). $ftpdirs = get-childitem -path "\\data5\ftpdata" -exclude "do_no

driver error on network printer

Image
hi all, having real issue network printer. the printer installed on server , shared therefore accessible users in company. the printer has worked great many years users having issues printing it. prints server work fine prints client machines fail. i cannot send test prints client machines printer in question error occurs, cannot printer properties on local machine error occurs. come exact error dosnt in error. i remove driver local machine , re add driver server again same happens! im @ total loss happening real issue users cannot print. the printer utax cdc 1930 any suggestions appreciated. thanks hi, i think 32/64 bit driver issues. please refer below images , change accordingly. refer link. http://msdn.microsoft.com/en-us/library/windows/hardware/ff556443(v=vs.85).aspx note: check check box follows. regards, md disclaimer: opinion expressed herein own knowledge. deploy @ own risk. whenever see helpful reply, click

Event ID : 1030 and 1006 In Windows 2003

hi all, in isa 2006 server getting below event id os windows 2003 event id : 1030 , 1006. event id : 1030 : windows cannot query list of group policy objects. check event log possible messages logged policy engine describes reason this. event id : 1006 : windows cannot bind xyz.com domain. (timeout). group policy processing aborted. please me fix issue.   mnyash hi,   please refer following microsoft technet articles more troubleshooting information:   event id 1030 — group policy preprocessing (active directory) http://technet.microsoft.com/en-us/library/cc727265(ws.10).aspx   event id 1006 — group policy preprocessing (active directory) http://technet.microsoft.com/en-us/library/cc727283(ws.10).aspx   regards, please remember click “mark answer” on post helps you, , click “unmark answer” if marked post not answer question. can beneficial other community members reading thread.

Excel Remote App - Document not saved. Windows 7 client

i have similar issue these threads: http://social.technet.microsoft.com/forums/en-us/winserverts/thread/029c06b9-652a-4a71-b7e4-2ffcbb6f12b3/ http://social.technet.microsoft.com/forums/en-us/winserverts/thread/0a93c2e5-ff59-49e3-9211-06c0a50dd832 only threads vista or xp client. having issues windows 7 client. the user can open excel files excel remote app. files located on network share on terminal server. when user tries save excel file gets error 'document not saved'. after i've killed mstsc.exe process on client , restart remote app seems te working should. has else encountered such issues? the client, server , office 2007 date. with friendly regards, gwen hi gwen,     based on search, problem may occur if following conditions true:   • saving file network drive.   • connection network drive has been lost.   • workbook contains of following items: • pivottables   • visual basic applications modules   • embedded objects (

Services for NFS on Windows 2008 R2 - Strange Permissions Issue

hello experts, i have had services nfs , running on windows 2008 r2 file/printer cluster on year.  unique configuration because of file permissions being set linux side; therefore, have granted root full access share , perms being set script/daemon running on linux side. for unknown reason, of broke down few days ago.  linux users can still access share , access files within it, root user cannot set permissions on files or change ownership on files. when root attempts this, gets "permission denied" error, if has 777 on files. i have active directory lookup turned on , have user in ad represents root.  verified had uid/gid of "0" , no duplicates of 0 present in ad. i tried restrictchown setting mentioned in 1 of articles, no joy. does have ideas may going on?  thanks! this resolved replacing faulty drive.  drive had become heavily fragmented on time.  if sees errors these services nfs, recommend running defrag <drive letter> /a , seeing how fra

LoginUI.exe has intiated the restart of the computer , but system up time is 32 days

hello, i got alert on server restart , when logged in , checked event log says loginui.exe has initiated restart of computer on behalf of servername\system , says (planned). suprisingly see uptime 32 days. please let me known cause. paramesh ka hi paramesh123, >loginui.exe has initiated restart of computer on behalf of servername\system , says (planned). 1.could provide detailed information event log. reason code, , comment? 2.check if there shutdown script running or applications force restart. 3.also check if there other users have right log on the computer , restart computer. 4.do virus scan check computer's health. besides, there similar post of issue, you may check if can find useful information there: https://social.technet.microsoft.com/forums/office/en-us/2d5b25c1-35f5-408b-90fe-f5315643629a/server-instability?forum=winservergen best regards, anne please remember mark replies answers if , unmark them if provide no help. if have feedba

the format did not complete successfully with 2.5T iSCSI LUN GPT disk

i unable complete long format on 2.5t iscsi lun gpt disk. said format did not complete successfully. quick format seemed working. if recreate lun less 2t, able format both long , quick method. idea? disk management has no problem recognizing entire disk space,2.5t, on gpt disk. details windows server 2003 sp2 ms iscsi initiator 2.08 thanks hi,   i seems using basic gpt disk, please try use dynamic gpt disk check whether same issue. following post discussed similar issue, can refer to:   passthrough disk format error http://social.technet.microsoft.com/forums/en/winserverhyperv/thread/2ff31372-4354-4aa2-9189-46a310ef353f     best regards, vincent hu   Windows Server  >  File Services and Storage

Domain shutdown for extended time frame

hi all, i have weird question can't find answer to.  @ house i'm running 2008 r2 domain 2 domain controllers.  i'm selling house , need out within next 3 weeks wont moving house 3-4 months (maybe longer if contractors have way).  i'll staying in short term wont able setup network due lack of environmental controls , noise pollution.  i know single dc can't away network x amount of time (i'm forgetting time frame @ moment), if dc's removed same amount of time?  in 20 years of server administration i've never had power down entire network 3-4 months.  can suggest course of action? thanks hi, maximum duration depends on tomsbtone lifetime , depends on os version of first dc in forest , either 60 or 180 days. can determined tombstonelifetime attribute. recommended not keep dc offline longer, introduce potential issues replication failures, authentication delays, etc.. see below articles, happen if specific fsmo down length of time, p

Rename the Computer Name

Image
hi, i renamed windows 7 computer, 2012 ad domain member. see new record in dns management console right ip address , new host name. but doesn’t upper in computers ou in users , computers console. when try delete old name in computers ou associated computer getting error: ‘’cannot delete object because: directory object not found.” can me fix it? how can renamed computer in ad users , computers? thank you, alex are sure ou has been correctly refreshed (refresh top level ad users , computers) need make sure change has replicated dc looking at.  when rename computer, guess mean renamed on computer though computer properties? regards, denis cooper mcitp ea - mct help keep forums tidy, if has helped please mark answer my blog linkedin: Windows Server  >  Directory Services

Incorrect URL entered in Internet Explorer will cause the entire URL address to be sent to “Bing” search engine.

hello, when type url address incorrectly on windows 2003 /2008r2 server, ie 9 cause entire url address sent bing search engine. how disable that? tia tia tp please click tools, manage add-ons. find search providers in left column. highlight bing in right side, uncheck "search in address bar" technet subscriber support in forum |if have feedback on our support, please contact tnmff@microsoft.com. Windows Server  >  Security

Report\Preview Not all the data is displaying

hi reporting guru's report collecting data sql2000 server. there data being replicated sql2000 server. replication broke because there huge network connection problems. data replicated country. in time when had network issues server migrated new sql2005 server. , network issues sorted out , data available on tables (it took couple of days data across , rerun snapshot), if run table (count) compare server in other country data same. below example of 2 expressions in report: old expression =sum(fields!countsuccess.value/fields!hits.value*100) new expression =iif(fields!hits.value =0 ,0, sum(fields!countsuccess.value/fields!hits.value*100)) old expression =fields!countsuccess.value/fields!countmarketing.value*100 new expression =iif(fields!hits.value =0 ,0,(fields!countsuccess.value/fields!countmarketing.value*100)) have expressions? of data have 0(null) values. if change date run report of data display there data doesn't display @ all. when i

BCP truncates record because of 2 extra chars in field read as a CRLF

greeting, we have lots of users copy excel data rows , paste them flat file gets picked store procedure upload.  1 particular field seems contain extraneous characters bcp interprets crlf, bcp truncates rows, , generates row remainder of row. looking through hex editor, see char(20) spaces.  i've tried various solutions nothing helps. any ideas appreciated.. cl hello, did try use sql server import , export wizard? can custom row delimiter , column delimiter in wizard. if issue presists, please post the sample data want import bcp utility. can workaround this. regards, fanny liu we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. SQL Server  > 

Hidden subreports showing up in CSV export

Image
i have main report several hidden sub reports.  the report works wonderfully in browser when user goes save main report csv (did not test other export formats) data comes across of sub-reports including hidden ones.  is there way resolve issue? hi jasondwilson77, per understanding want conditional show subreports , hide other subreports based on key field in report, when export report csv expression not work, right? this design, expression control show , hide not in csv report,detail information below reference: https://msdn.microsoft.com/en-us/library/dd255223.aspx as bhanu_nz suggestted can manually set visibility in subreport set value of "dataelementoutput". i recommend submit wish microsoft connect @ https://connect.microsoft.com/sqlserver/feedback . feedback valuable improve our products , increase level of service provided. thanks understanding. regards, vicky liu vicky liu technet community support

update reports daily

hello tell daily updates in reports through ssrs    thanking u  vijay kolisetty hi vijay kolisetty, it possible update reports daily creating snapshot , using 1 schedule. detail stpes, please refer below 1 msdn article: creating, modifying, , deleting snapshots in report history thanks, sharp wang please remember mark replies answers if , unmark them if provide no help. SQL Server  >  SQL Server Reporting Services, Power View

How to update, preserve a sequence

how update column preserve sequence? column, payororder sequence beginning 1, after rows deleted, there gaps in sequence: 1,3,6,11,23 need update these values 1,2,3,4,5 your appreciated. using row_number() function can   ; with cte as ( select pk, sequence , row_number () over ( order by sequence ) as newseq from payororder) update cte set sequence = newseq where sequence <> newseq   premature optimization root of evil in programming. (c) donald knuth naomi nosonovsky, sr. programmer-analyst my blog SQL Server  >  Transact-SQL

sql server 2008 standard edition small business

we attempting install sql server 2008 standard edition small business on new server has new license 2008 operating system. keep getting 1 error message stating sql version not supported operating system. are installing sql server standard small business? i think other standard editions unsupported. more information please read article http://msdn.microsoft.com/en-us/library/ms143506.aspx cheers, feroz mark answer if helps. posting provided "as is" no warranties , confers no rights. SQL Server  >  SQL Server Setup & Upgrade

Hyper-V virtual machine does not start when losing additional VHD

hello everybody, i seem having trouble starting virtual computer in hyper-v after losing/renaming additional drive added virtual system. how can set in order still boot when additional vhd removed or renamed? any greately appreciated. you need go vm settings , remove there. the vm setting telling vm, there should additional disk :) ich bin viel mobil unterwegs. verzeiht die manchmal mangelnde rechtschreibung. :-) Windows Server  >  Windows Server 2012 General

WMI namespace marked as RequiresEncryption

i have 2 node file windows 2008 sp2 storage server cluster keep getting these wmi errors on every 5 minutes: log name: application source: microsoft-windows-wmi date: 5/23/2011 1:55:09 pm event id: 5605 task category: none level: error keywords: classic user: n/a computer: fs01a.procopio.local description: access root\mscluster namespace denied because namespace marked requiresencryption script or application attempted connect namespace authentication level below pkt_privacy. change authentication level pkt_privacy , run script or application again. event xml: <event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <system> <provider name="microsoft-windows-wmi" guid="{1edeee53-0afe-4609-b846-d8c0b2075b1f}" eventsourcename="winmgmt" /> <eventid qualifiers="49152">5605</eventid> <version>0</version> <level>2</level> &

Compabillity Issue (Bug?) with rotated Images between Word 2007 and 2010 and maybe more Versions

hi there problems rotated, in text aligned images in word 2007 , word 2010 situation in word 2007: if rotate image, is taller width 90 degrees, vertical space consumtion of "image" not reduced. have white spaces above , below image. as solution inconvinience can rotate image in external program. situation in word 2010: the above stated problem not occur in word 2010. situation files created in word 2010 opened in word 2007: rotation of image lost, space consumption preserved => image cut on top , botton match space if rotated. situation files created in word 2007 opened in word 2010: the effect white space below , above image preseved. problems other versions: i have found other people having similar problems old .doc format: http://social.technet.microsoft.com/forums/en-us/word/thread/6a6d2407-29ff-4736-a8f2-edb59512cfa6 i know issue concerns "old" versions of word nevertheless rather annoying if have share or cowork people older vers

It is just to understand Hash Tables better

hello dear sirs as per subject, tried following code: $computername = "." $physical_specs = get-wmiobject -computername $computername win32_diskdrive | ` select name, maxcapacity, memorydevices, removable, ` replaceable, serialnumber, version -unique $specs = $null $specs = @{} foreach ($spec in $physical_specs) { $specs.add("id", $spec.deviceid) $specs.add("caption", $spec.caption) $specs.add("manufacturer", $spec.manufacturer) $specs.add("type", $spec.type) $specs.add("signature", $spec.signature) $specs.add("model", $spec.model) $specs.add("serial#", $spec.serialnumber) $specs.add("interface", $spec.interface) $specs.add("partitions", $spec.partitions) $specs.add("sectors / track", $spec.sectorspertrack) $specs.add("cylinders", $spec.totalcylinders) $specs.add("heads

Windows Server 2008 R2 > Restrict Session Stealing for Generic Accounts when session is Active

in rdsh server farm have accounts generic (assigned thin client stations).  each station has windows account associated station.  rdsh farm allows single session per user account not have hundreds of sessions same username.  thin client's rdp connection not store credentials user "expected" logon username listed on monitor.  imagine, users have own inclinations. we wanting ensure active session can not stolen user @ different station.  if session disconnected, allow reconnection client.  idea seems simple enough i'd think basic security microsoft remote desktop session hosting. windows server 2003 terminal services had functionality similar with: http://technet.microsoft.com/en-us/library/cc759021(v=ws.10).aspx group policy > computer configuration > administrative templates > windows components > terminal services > sessions > allow reconnection original client only i surprised find microsoft dropped feature in windows server 2008, , m