My fan

i read single row in table can hold 8000 bytes of data. want import data table , data pipe delimited. data maps 500 columns maximum byte count of 21,400 bytes. unless 90% of data columns empty may run trouble sql limits during import.  thoughts on how avoid trouble appreciated. tia, edm2 this restriction has been relaxed starting sql 2005. however, performance adversely affected when data overflows 8060 byte limit. also, 8060 byte limit doesn't apply varchar(max), varbinary(max), etc beware of adverse performance implications. after importing data, try normalize data, if possible. can read more row-overflow data here:  https://technet.microsoft.com/en-us/library/ms186981(v=sql.100).aspx satish kartan www.sqlfood.com SQL Server  >  SQL Server Database Engine

help plz. please refer below threads: http://www.telerik.com/community/forums/winforms/gridview/radgridview---save-changes-to-a-rows-data-back-to-database.aspx http://www.codeproject.com/questions/182052/sort-contents-of-the-radgridview Silverlight  >  WCF RIA Services with Silverlight

**** posting again moved previous post vb forums, the reason here on c#, vb code that can  fit ssis script task**** hello, i have been strunggling find solution convert xlsx files multiple sheets csv file. can 1 please me. requirements >> convert xlsx file multiple sheets csv file >> csv file names : xlsx filename + '_' + sheet name >> scirpt has in vb using ssis 2005 >> started develping scirpt using micorosoft.office.interop.excel.dll . dll referenced script task. >> found bellow web link useful.. because not god @ progarmming, couldn't understnad of it. http://www.mssqltips.com/sqlservertip/2772/importing-data-from-excel-using-ssis--part-2/ http://www.dreamincode.net/forums/topic/278621-help-convert-xls-to-csv-vbnet-by-worksheet/ thanks in advance jai ' microsoft sql server integration services script task ' write scripts using microsoft visual basic ' scriptmain class entry point of script task. impor

  hi   team expert,   i working on asp.net , c# project.   i creating page allow user add new workitem tfs   and so.   now implement way email notify user new wi added …. know how or have example of how implement that. any appreciated.     thanks much   ddee you did right thing posted same question in team foundation server forum   http://forums.microsoft.com/msdn/showpost.aspx?postid=3230127&siteid=1 because question has nothing sql server clients. SQL Server  >  SQL Server Data Access

hi all, using sql server 2008 r2 in multiple servers. 1. script (links) creating manual maintenance plan? manually run script databases in multiple servers. 2. way collect statistics before , after maintenance? show improvement after plan running. 3. missing in maintenance plan steps? - full backup of database. - transaction log backup. - check db integrity - cleanup backups more 2 months - rebuild indexes - reorganize indexes - shrink databases - update statistics thanks in advanced. best, this best plan have check... http://ola.hallengren.com/ raju rasagounder sr mssql dba SQL Server  >  SQL Server Database Engine

hello, we using office 2010 in language lab.  when students open word 2010, switch english chinese simplified prc , start typing, word randomly switch english.  shift not being touched during time, language switch.  i wondering if had ideas out there might help.   when switch english, mean keyboard or input language? happens word? this due conflict short key, please have check on first. Microsoft Office  >  Word IT Pro Discussions

hello, i have 2 windows 2012 servers hyper-v installed. have used replication 1 of virtual machines had turn off momentarily making disk adjustments. trying enable replication again, met error: enabling replcation failed hyper-v failed enable replication. hyper-v not in state accept replication on replica server virtual machine 'servername' under details virtual machine id listed, , using id can find replication files previous replication (under \virtual hard disks\hyper-v replica\virtual hard disks\<id>\ , under \virtual hard disks\hyper-v replica\virtual machines\<id>.  has run before? maybe should rid of old replica files , try replicate anew? or perhaps old reboot might trick :p thankful insight. hi, > hyper-v not in state accept replication on replica server virtual machine 'servername' when click enable replication virtual machine, pops enable replication wizard. there steps should configure in wizard, @ step did encoun

hello, i setup rds , every tings work fine computer browser... when try add rds web fee it's give me error:   the remote computer cannot authenticated due problems security certificate. security certificate problems might indicate attempt fool or intercept data send remote computer. so problem? link : https://servername.domain.local/rdweb/feed/webfeed.aspx thanks. hello amin, i think if want publish on internet please use external certificate bought under public certificate , install same in rdms configuration. regards, pankaj singh connection broker Windows Server  >  Remote Desktop Services (Terminal Services)

i have vmware vm 2008 r2 sp1. internet explorer 8 installed , when trying install ie11, installer complains there pre-requisite needs installed. when examining c:\windows\ie11_main.log, error is: error installing prerequisite file (c:\windows\temp\ie1715d.tmp\kb2834140_amd64.msu): 0x800f081e (2148468766) the patch in question , kb2834140 pertains situation mix of graphics cards may exist in server, not case here (a vm standard vmware svga adapter). when trying manually install kb2834140, gives error "the update not applicable to computer", seems fair since has 1 virtualized display dapter. still, ie11 requires it. what have tried: * re-installing sp1 (failed event log entry "service pack installation failed error code 0x80070bc9.") * running microsoft system update readiness tool , examined checksur.log file (no errors detected) * resetted windows update components ( https://support.microsoft.com/en-us/kb/971058 ) right not sure whe

i need implement following password policy on active directory domain: 1.   domain users:       a. age - 15 days       b. password length - 9 characters       b. complexity enabled 2.   admins       a. age - 15 days       b. password length - 15 characters       c. complexity enabled now how can achieve implementation of these 2 different type of password policies 2 different group of users....?   hi,  this can achieved in single domain windows 2008 or later functional level using fine grained password policies (or fgpp). more information can found here:  http://technet.microsoft.com/en-us/library/cc770394(ws.10).aspx http://technet.microsoft.com/en-us/library/cc770842(ws.10).aspx   thanks, guy Windows Server  >  Group Policy

setup: 2 ssids: official , guest 1 dhcp server 2 scopes: scope (10.0.0.0) , scope b (172.10.0.0) requirements when user connects official ssid, issued ip scope a. when user connects guest ssid, issued ip scope b. my 2 thoughts could implemented using dhcp policies? does nap need in picture. if so, how? hi dmwaigi, >>could implemented using dhcp policies? you deploy dhcp server nap burak mentioned. nap has called-station-id attribute, , configure restrict connection user. here information called station id reference: dhcp server callout dll mac address based filtering https://blogs.technet.microsoft.com/teamdhcp/2007/10/03/dhcp-server-callout-dll-for-mac-address-based-filtering/ best regards john please remember mark replies answers if , unmark them if provide no help. if have feedback technet subscriber support, contact tnmff@microsoft.com . Windows Server

hi there, i'm quite new i.t field please bear me. my client has sbs 2003 server service pack 2, had disable mcafee firewall blocking critical file o/s, , opted enable windows firewall. my problem comes in if enable windows firewall no-one on network can access mapped network drive server, , remote desktop connections via vpn not work either. i have given exceptions to: 1.) tcp port 1723 (pptp) 2.) udp port 4500 (l2tp) 3.) udp port 1701 (l2tp) 4.) udp port 500 (ipsec/esp) 5.) tcp port 3389 (remote desktop) 6.) tcp port 443 (sstp) even after giving exceptions these ports firewall still refuses let me through when enable firewall. any gratefully appreciated. hi green,   thanks posting here.   > my problem comes in if enable windows firewall no-one on network can access mapped network drive server, , remote desktop connections via vpn not work either.   have modified settings before issue occur ? i’d suggest temporarily remov

lab server specs: cpu: intel g3220  3 ghz memory: 20 gb ram hdd: 2x 250 gb ssd , 1x 500gb ssd (for vm's) running above server lab server , works fine labs speed not  issue. running hyper-v 2012r2 latest patches. have 1 lab-network , 1 production-network . using internal vswitch, , using virtual gw/router/fw (or correct term is) protect network , external switch (see diagram below). using pfsense , windows server 2012r2 rras , vpn service activated. problem getting very, slow speed if transfer data between lab-network , production-network. using nifty program called netio benchmark, , speed between dc01 in lab-network to svr1 in production-network is 192 mbit (24 mb/sek). if connect computer gs108v3 switch , run netio dc01 in lab-network i staggering 424 mbit (53 mb/sek). my conclusion is virtual routers the bottlenecks in lab-setup. if transfer files within network ~800 mbit, aswell between hypervisors 850 mbit or better. cant see cpu, or memory peaks in re

hi i'm having issue org certificate authority we used have 2003 server called dc02 deprecated, if try open certificate service management there error because target dc02 dose not exist anymore  and get  error 0x6ba (win32 : 1722) i can see in event viewer : log name:      application source:        microsoft-windows-certificationauthority date:          24/02/2017 03:12:33 event id:      44 task category: none level:         error keywords:      classic user:          system computer:      mail.nextage.local description: "windows default" policy module "initialize" method returned error. specified domain either not exist or not contacted. returned status code 0x8007054b (1355).  active directory containing certification authority not contacted. event xml: <event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">   <system>     <provider name="microsoft-windows-certificationauthor

... during installation of essentials connector client onto windows 7 ultimate box.  connector downloads server, installed .net 4.5, errors out.  has worked in past.  uninstalled client because backups failing daily.  tried re-install , that's when got error. hi, according description, understanding if failed re-install connector on windows 7 client. make sure have followed steps mentioned in below link remove connector - disconnect computer or reconnect computer server: https://technet.microsoft.com/en-us/library/jj713510(v=ws.11).aspx#bkmk_14 recommended have reboot after connector uninstallation. , check see if essentials related scheduled task , service have been removed. if connector still failed installed, check event viewer see if related event has been logged. besides, want confirm if windows server 2012 essentials or, 2012 r2 essentials. best regards, eve wang please remember mark replies answers if , unmark them if provide no help. if h

hi ; want @ rid allocation table dc. do ? regards umesh further research indicates ridallocationpool pool used next. pool rid's allocated determined ridpreviousallocationpool. in cases find 2 attributes identical. script should be: option explicit dim objridset, objallocpool, objprevallocpool set objridset = getobject("ldap://cn=rid set,cn=myserver,ou=domain controllers,dc=mydomain,dc=com") wscript.echo "myserver next rid: " & cstr(objridset.ridnextrid) set objallocpool = objridset.ridallocationpool wscript.echo "start of next pool: " & cstr(objallocpool.lowpart) wscript.echo "end of next pool: " & cstr(objallocpool.highpart) set objprevallocpool = objridset.ridpreviousallocationpool wscript.echo "start of prev pool: " & cstr(objprevallocpool.lowpart) wscript.echo "end of prev pool: " & cstr(objprevallocpool.highpart) again, rid's allocated "previous" pool. ca

hello, i running rds farm 2 windows server 2008 r2 session hosts. i using following 2 policies within gpo under computer configuration | policies | administrative templates | windows components | remote desktop services | remote desktop session host | session time limits - set time limit disconnected session - set time limit active idle remote desktop service sessions i went rdp-tcp settings on both servers , checked top checkbox called 'override user settings' on 'sessions' tab. seems working expected set 'override user settings' through gpo tried not able find policy in gpo that. through google not able find either. is there such policy? thank you mc2102 hello tp, i not sure if missunderstanding each other. looking cetain setting in gpo. thank marcus hi marcus, based on original post understanding setting time limit disconnected sessions time limit idle sessions via group policy , override user settings, however, notice o

i found regular expression in pattern think need social security number. (?!000)(?!666)^([0-8]\d{2})(\d{2})(\d{4})$ my files not have spaces within numbers or hyphens. i want find ssn in all. txt document in specific folder , replace them x except last 4 digits on right.  nice tell user how many found , replaced.  (that might bit ask know.) my folder path here \\shared\e_drive\process\scrub. can point me in right direction 1)excecute expression , find social sec numbers 2)replace matches xxxx except last 4 numbers. 3) message of completion.   help. i found couple similar examples via google not same. here replacement within line: 'this line 23-456-1234 , end' -replace '\d{2}-\d{3}-(\d{4})' ,'xx-xxx-$1' \_(ツ)_/ Windows Server  >  Wi

several of our users have had problems outlook 2007, after installing ms kb980376. outlook symptoms are: no new emails downloaded (stuck, "waiting update folders"). clicking inbox or public folders cause outlook stop responding. fix is: remove kb980376 add-remove programs. has worked on 6 of our computers far. computers xp sp2, office 2007 sp1. has else seen this? know how prevent other computers getting these symptoms? ps: have declined update on our wsus server, lots of computers had downloaded update. all computers xp sp2, office 2007 sp1. i argue first complicating factor. given july, 2010, update, can reasonably assume update developed in current operating environment. neither sp2 xp or sp1 fo office 2007 current service packs. suggestion re-test update on xp sp3 / office 2007 sp2 system , see if can duplicate problem. can assure if try engage microsoft in particular issue, that's going response -- "install latest service pa

we have several powershell scripts large, , linked external scripts. there way list of external .ps1 scripts reaches out to, can clean excess scripts lingering without breaking core script. in other words, have bunch of scripts in directory.  have man script, need see scripts in directory reaches out (which ones essential run), without deleting may use. is there way run command against see files or other .ps1 files may invoke when running.  rid of extra/unneeded files not accessed script. this display lines contain string '.ps1' in mainscript.ps1 get-content mainscript.ps1 | select-string -pattern '.ps1' -simplematch inspired heineken. Windows Server  >  Windows PowerShell

we have server here in uk running windows 2008 r2 - have office in malta connect our server using remote desktop connection... need able print files server in office (have new canon 3250 printer installed , running no problems on local machines - windows 7 pro) the printer has redirected across remote desktop connection , can see within 'printers , devices' however, nothing sent printer prints... remove print queue. local machines running on 32bit , server 64bit - i've installed 64bit drivers using 'local resources' option remote desktop. any suggestions how can resolve issue? thank you hi, is rds server on domain controller? suspect default easy print driver may not work properly. let’s disable easy print test. computer configuration -> administrative templates -windows components -> remote desktop services > remote desktop session host -> printer redirection , set “use remote desktop easy print printer driver f

i using win2008 server 2 ethernet card, 1 connected office lan , cable modem connected internet. i hav used nat make pcs on lan access internet. now need filter web sites... need block web sites , need block sites/contents based on words. plz let me kno soln issue. thanking you mukteswar patnaik hi mukteswar, posting in microsoft technet forums. can check suggestions in thread below: need web filtering advice http://social.technet.microsoft.com/forums/en-us/itmanager/thread/682e3f5c-ce9c-4f80-865a-7785a3adc66e/ if use microsoft forefront tmg, can use http filtering: http://technet.microsoft.com/en-us/library/cc995081.aspx in meantime, can seek in our networking forum. there can more effective suggestion other experts familiar topic. understanding appreciated. network infrastructure servers http://social.technet.microsoft.com/forums/en-us/winservernis/threads/ regards kevin

hey all, have been having difficulty installing server 2k3 (180 day evaluation version btw), try explain happening.  boot cd starting computer, press enter boot cd, @ bottom of screen there grey bar files being loaded, after screen comes screen tells me evaluation version , press enter begin installation.  here problem, next screen should come hard drive , formating screen, does, none of letters on screen show up, blank blue screen....so can't choose , move on process?  thank input. hi steve,   thank reply.   can use disk install windows server 2003 on other computers?   i suggest contacting computer manufacturer confirm whether windows server 2003 supported computer.   if so, please refer following article check whether there incompatible hardware devices installed on computer: http://www.windowsservercatalog.com/ in addition, may reload bios settings, unplug unnecessary devices such sound card, network card, printer , external hard drives before installation.   hope h

hi all i have question , have asked many mcitp trainers  but nobody knows answer. , have asked here in forum didn't result.   exponentially greatfull describe me steps should in turn. my question : i have domain called : mydomain.local .  i  have example 10 users in domain named u1 , u2, u3 , ....    i  have deployed win 2008 r2 sp1 ftp server , joined domain. via iis console , want deploy ftp user isolation using   " ftp home directory configured in active directory " feature (which exist in ftp user isolation section ). i know ftp user isolation don't know feature  " ftp home directory configured in active directory "  do !! may tell me feature ( in simple words please ) my second ask may please tell me steps should in turn  ( whole process deploying ftp user isolation using "  ftp home directory configured in active directory"  ) ? for example if possible , please describe me steps following pattern ( or if not possible ,

hi all, i configured rdp gateway server in our environment on 2k12 dc server. work in domain based system when try connect work group member system not working because of root certificate used rot rdp gateway server self sign domain certificate. so, how can access rdp on work group system using rdp gateway.i need delegate restriction on rdp gateway authentication. { of selected group of users have access rep gateway}. please suggest. regards, koustov c hello, technet wiki forum place technet wiki community engage, question, organize, debate, help, influence , foster technet wiki content, platform , community. please note forum exists discuss technet wiki technology/application. if have question technology (such windows), can ask in forum. if you're unsure forum, bing search often works fastest or ask here: http://social.microsoft.com/forums/en-us/whatforum/threads karl when see answers , helpful posts, please click vote helpful, propose answer, an

as administrator, cannot log on primary domain controller (2008 r2) in normal mode , users cannot access files on server. able log in safe mode. this server virtual machine, primary dc , has operations masters there 2 other 2003 dc's 1 of runs dns. in directory services restore mode have tried removing windows updates night before , disabling mcafee services. restored system state (but not entire system drive) previous nights backup. steps didn't me anywhere. in trying resolve problem noticed whenever boot system time seems freeze , when restart safe mode have reset time , works fine while in mode. the event logs when problem started show these items: system log log name:      system source:        netlogon date:          8/17/2012 1:42:18 pm event id:      5737 task category: none level:         error keywords:      classic user:          n/a computer:      ccaddc2.mydomain.com description: system returned following unexpected error code: int

hi i 1 in work cannot login sbo because of error message get. the error reads follows: sql native client login timeout expired sql server error: '258' sql state: '08001' [microsoft][sql native client] unable complete login process due delay in prelogin response kindly assist auditor , need sap business one. similar issue, http://social.msdn.microsoft.com/forums/sqlserver/en-us/c895335c-9a88-488c-b39c-f54fd6cceba9/298-sqlserver-error-258-tcp-provider-timeout-error-258-sqlstate-08001?forum=sqldataaccess regards, rsingh SQL Server  >  SQL Server Data Access

hi all!  i have project in vso , dev team, , wanted add stakeholder access allow solution users report bugs. for that, created new team under project tree named "support", added new user team. i expected that, since didn't add user "dev team" user shouldn't have access, see, read, modify, etc.. on work itens managed team, yet since settings project, support user can access both teams, not added them , manage or none. i know, if there possible set rules of user can see , manage, because bug tracking, wanted have team or user creating bugs , mark them resolved, alerts during process. thank in advance. ricardo hello ricardo , please check below threads contains discussions related same issue. https://social.msdn.microsoft.com/forums/en-us/ef6617fa-2657-42ac-af05-89f1ad9397cf/default-user-permissions-cannot-see-any-team-projects-or-request-access?forum=tfservice https://msdn.microsoft.com/library/vs/alm/work/connect/work-as-a-stakeholder