Posts

Showing posts from June, 2015

SQL Server 2008 R2 Enterprise?

hi, for sharepoint want install sql server 2008 r2 enterprise edition can provide me link. hi, for sharepoint want install sql server 2008 r2 enterprise edition can provide me link. farhan, you can download sql server 2008 r2 enterprise if have msdn subscription. not free edition cannot download free. unfortunately sql server 2008 r2 evaluation not available. either go sql server 2012/2014 evaluation edition or buy enterprise edition please mark reply answer if solved issue or vote helpful if helped other forum members can benefit my technet wiki article mvp SQL Server  >  SQL Server Setup & Upgrade

Installing a R&D TFS Server

  i want install tfs server on vm r&d purposes self contained unit. db, web access, on 1 machine.   i want in order prepare 2008 migration.   what licensing impliocations of this? can install "production" media have ms? if yes, great.   if no, suppossed use workgroup version team suite msdn subscription? functionality losing using version?   thank you. hello david starr,      know installing tfs on vm has same licensing requirement others.     more             the  january 2008 microsoft product user rights document       for detail licensing policy better consult sale.      thanks. Archived Forums T-U  >  Team Foundation Server - Setup

Datagrid actual width

on aspnet page, have following plugin:  <div id="div_container" >   <asp:scriptmanager  runat="server"></asp:scriptmanager>   <asp:silverlight  source="mysilverlight.xap"   runat="server"></asp:silverlight> </div> page.xaml.vb code:    private sub loadgrid() dim ub as new uribuilder( "myurl" ) dim wc as new webclient() addhandler wc.downloadstringcompleted, addressof mydownloadstringcompleted wc.downloadstringasync(ub.uri) end sub private sub mydownloadstringcompleted() 'code populate datagrid .. . . end sub private sub mygrid_sizechanged( byval sender as object , byval e as system.windows.sizechangedeventargs) handles mygrid.sizechanged mygrid.dispatcher.begininvoke( addressof updateui) end sub private sub updateui() myxamltext.text = mygrid.actualwidth 'uncommenting 1 of 2 lines below, return incorrect

SQL server 2000 performance issue

while executing restore command in sqlserver 2000 (windows 2003 server)  taking around 3 hours complete restoration. if connect same instance in other server, 2008 managment (windows 2008 server) studio taking 22 mints. what problem in windows 2003 phisical server  , sqlserver instance ? check following issues , check not functioning at same time of restoration process  any additional jobs are scheduled during time of restore anti-virus check  are using log shipping ship transaction logs between servers   service pack level of sql server  try defragment database @ regular time period fragmented items not harmful of performance  also can refer article bad performance of sql server http://www.brentozar.com/archive/2012/06/sql-server-poor-performance-checklist/ SQL Server  >  SQL Ser

programming x button to close

hello want know how can programming x button message box confirm close hi dereklouis, are trying messagebox confirm exit winform? if please write below code form's formclosing event. hope helps you. private void form1_formclosing(object sender, formclosingeventargs e) { if (messagebox.show("exit or no?", "confirm exit", messageboxbuttons.yesno, messageboxicon.information) == dialogresult.no) { e.cancel = true; } } thanks, sabah shariq please remember mark replies answers if help. if post helpful please vote Learning  >  Small Basic

How to list all TFS available on the network?

hello everybody, how possible api list tfs servers running ? thanks, cheers i not sure of scenario think require registry uddi. imagining otherwise how query each machine in internet , find if running tfs if apis made available. may different issue if need know in subnet only which servers are tfs happens in case of sql servers. difference tfs uses http/s whereas sql uses port other 80 (1443?). there no built in apis listing of tfs in subnet / network /internet. vp, technology, seed infotech ltd. mvp - team system http://www.dotnetcurry.com/showarticles.aspx?catid=60 Archived Forums V  >  Team Foundation Server - Project Management & Work Item

Creating silverlight project failed.

i'm trying create silverlight project vs 2008 beta. i'm getting following error.  account has administrator right doesn't work.. great if helps fix issue. in advance.         --------------------------- microsoft visual studio --------------------------- access path 'c:\program files\microsoft visual studio 9.0\common7\ide\projecttemplatescache\csharp\silverlight\1033\silverlightproject.zip\testpage.html.js' denied. --------------------------- ok   ---------------------------   1. solution found turn off avg free edition , kill avg*** services task manager. then, works. (killing avg processes important because won't work if turn off avg ui.) if using other anti-virus softwares other avg may need turn off , stop services. 2. found trick link visual studio 2008 beta 2 denied access silverlight 1.1 alpha project template . it's changing testpage.html.js testpage.js in project template. 3. another post found hiding extension

what ports need to be open for a remote dhcp to connect to Active Dirtectory

i have installed new file server in remote office needs run dhcp server.  when attempt activate service message dhcp service not contact active directory.  there no issue remote users authenticating dc's or new local server after had networking team open firewall.  guess need additional ports open well.  know ports need open?  server running 2008 r2 enterprise sp 1. thank you. hi, you need open udp port 67 , 68 connect dhcp server. cheers! Windows Server  >  Platform Networking

How to implement Group Policy to all users?

we running vbs script in group policy management when users log off script being utlized. works on local system not work users on domain. need know how apply script can send email users log off , log in script applied. is there need in active directory or gpo? thanks nasir. hi nasir, is group policy working now? if no, can use command line in command promt gather group policy rsop report. you can open cmd , them type: gpresult /h xx.html (xx here means file name). and can post report here , can have together. best regards, elaine please remember mark replies answers if , unmark them if provide no help. if have feedback technet subscriber support, contact tnmff@microsoft.com. Windows Server  >  Group Policy

Network boot into virtual desktop

sorry new microsoft vdi. if deploy microsoft vdi solution, how enable diskless client network boot virtualization host server image directly? do require have os streaming solution citrix provisioning service? in advance if not use provisioning server (from citrix) must use msft windows deployment service server. the microsoft solution not work provisioning server.  requires images sysprep'd, joined, set them differently.   brian ehlert (hopefully have found useful) http://itproctology.blogspot.com learn. apply. repeat. Windows Server  >  Hyper-V

Internal DNS not picking up external DNS modifications

hi folks, we have 3 ad dc's handle our internal dns example.com. have additional domain hosted offsite ( production.com), , dns external @ 1 of dns service providers. when ip address changes made production.com, propagated worldwide however, our internal dc's , network still don't see changes 24 hour later. i've run flushdns , registerdns on 3 dc's, restarted dns service on 3, etc. 2 of 3 dc's see correct info not appear updating throughout internal environment...??! there few specific production.com hosts listed internally don't see how affect external information of other hosts. feel though have missed obvious.... many in advance any/all input. bd one correction: forwarder, not conditional forwarder. bd Windows Server  >  IPAM, DHCP, DNS

IF i provide to one user to change group membership delegate on Domain then that id would be able to change enterprise admin domain admin members and make its id in enterprise admin group?

if provide 1 user change group membership delegate on domain id able change enterprise admin domain admin members , make id in enterprise admin group? if asking, if granted ability modify enterprise admins group able add themselves?  answer yes , no.  believe can temp change group system reset permissions on group via adminsdholder.  security control mechanism within ad. http://technet.microsoft.com/en-us/magazine/2009.09.sdadminholder.aspx -- paul bergson mvp - directory services mcitp: enterprise administrator mcts, mct, mcse, mcsa, security+, bs csci 2008, vista, 2003, 2000 (early achiever), nt4 http://www.pbbergs.com     twitter @pbbergs http://blogs.dirteam.com/blogs/paulbergson please no e-mails, questions should posted in newsgroup. posting provided "as is" no warranties, , confers no rights. Windows Server  > 

"Unhandled exception" when modifying a GPO

after making change gpo , attempting commit change, following error displayed.  i've tried various changes different gpos different dcs , give error.  dcs windows 2008 r2 domain , forest functional levels have not been been upgraded (still @ windows 2003 level). thanks :) ----- error  ----- unhandled exception has occurred in component in application.  if click continue, application ignore error , attempt continue.  the process cannot access file because being used process. (exception hresult: 0x80070020). [details] ************** exception text ************** system.io.fileloadexception: process cannot access file because being used process. (exception hresult: 0x80070020)    @ microsoft.grouppolicy.admtmpleditor.igpmadmtmpleditorcallback.applychanges()    @ microsoft.grouppolicy.admtmpleditor.editor.savechanges()    @ microsoft.grouppolicy.admtmpleditor.editor.buttonok_click(object sender, eventargs e)    @ system.windows.forms.control.onclick(eventargs e)

Virtual Processor (%Guest Run Time)

i getting alert please kindly tell me solution of it. instance computername:hv vp 1 object hyper-v hypervisor virtual processor counter % guest run time has value 3 hi syed, according information , recommended using tool "performance monitor" monitor virtual processor of vm . here steps monitoring: open the run dialog (launch start menu or press windows key + r) type perfmon.msc expand monitoring tools , click performance monitor , on right panel click "green cross icon" add counters. expand object " hyper-v hypervisor virtual processor " choose " % guest run time " select instance name of selected object(e.g test1:hv vp 1) click "add" click "ok" now in monitor dash board can analyse situation of virtual processor . may vp usage can help figure out problem of alert . hope helps. best regards elton ji we trying better understand customer views on social support experience,

Window 2008 server rebooted unexpectedly

i have windows server 2008 r2 enterprise server rebooted unexpectedly last night. i have gone through the  event viewer system logs & found below error message  - event id - 109 source  - kernel-power error message -  kernel power manager has initiated shutdown transition. we observing unexpected reboot issue on server. have found 7 logs last jan 2016 on server. so please suggest on how can fixed.... <v:shapetype coordsize="21600,21600" filled="f" id="_x0000_t75" o:preferrelative="t" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f">  <v:stroke joinstyle="miter"> <v:formulas>  <v:f eqn="if linedrawn pixellinewidth 0">   <v:f eqn="sum @0 1 0">   <v:f eqn="sum 0 0 @1">   <v:f eqn="prod @2 1 2">   <v:f eqn="prod @3 21600 pixelwidth">   <v:f eqn="prod @3 21600 pixelhe

Need to extract computer names from a text file

i have text file has computer names need extract from, text file has ton of other non-essential data in don't care use.  all computer names follow naming convention there 5 6 characters hyphen , either 2 or 3 numerical characters.  so, naming standard this: abcw7-01 or abcw7d-100 anyway, how may go extracting these using regex? thanks okay, think found it.  it appears able extract info needed using following regex pattern: '\w+-\d+' Windows Server  >  Windows PowerShell

GPO - Printer deployment installing incorrect driver for clients

hi all, i'm running server 2012 r2 using print management (print server) gpo printer deployment (per machine connection type). on server it's installing correct printer (hp) driver, on client machines (windows 7) it's installing incorrect driver (ms enhanced point & print compatibility driver). in gpo i've messed around "package point , print - approved server", "only use package point , print", , "point , print restrictions", doesn't make difference. thoughts on how correct driver installed on client machines? thanks hi, please offer detail settings how , configured "package point , print - approved server", "only use package point , print", , "point , print restrictions". in experience of similar problem, pleas have try disable "point , print restrictions" under computer\admin templates\printers\ , see if helps. best regards, wendy please remember mark replies answers

Word 2010 Folder Redirection issue - Possible BUG

our company publishes application interacts microsoft word generate word documents based on data backend database. our application calls windows api launch word - works great (mostly). some of our clients using gpo folder redirection policies safekeep users' data for users running windows vista/7/server 2008 , office 2010, we're facing problem microsoft word fails launch, yet winword.exe appears in background running process.  the event viewer logs don't suggest wrong. if disable application data folder redirection, issue not occur. here's bizarre part, appdata folder redirection on - , if delete normal.dotm  in \\server1\user1\appdata\roaming\microsoft\templates generate word document using our app, works !   word re-creates normal.dotm (which expected) - if try , generate document using our app, issue occurs again.   it can replicated on computers we've tested on several environments vista/7/2008 - issue not occur on machines running windows xp/

Cleaning Up Active Directory Groups

group cleanup thankless , time-consuming task , there no easy way it.  1 problem continiously face customer customer.  advise customers clearly mark group used under description field avoid domains getting state of having thousands of unknown groups. i wondering if there third party tools have ability scan computer objects in active directory domain , enumerate security groups attached following items: files , folders local groups printers registry shares user prifles user rights sql permissions exchange mailbox permissions this aid in process of cleaning unwanted security groups!  if not continue advising customers "change group security group distribution group, if breaks change back, if nothing breaks delete group". kind regards, clint boessen mvp - exchange server, mcse, mcitpx4, dip network engineering perth, western australia blog: http://clintboessen.blogspot.com/ please remember click “mark answer” on post helps you, , click “unmark answer” if

Application crash with KERNELBASE.dll

Image
hello all, we running ibm sterling commerce edi application on windows 2012 data center version, server on vm , since installation time (did 3-4 months back) have not done windows patches or updates. since last few days observing when working on our edi application, application crashes message " ibm sterling gentran server microsoft windows has stopped working" , when checked event viewer found because of kernelbase.dll, please see event viewer information.  we have tried start application run administrator, no use. request kindly resolve issue. faulting application name: edimgr.exe, version: 5.3.1.5, time stamp: 0x55ba3bcc faulting module name: kernelbase.dll, version: 6.3.9600.17055, time stamp: 0x532943a3 exception code: 0xc0000005 fault offset: 0x00011d4d faulting process id: 0x1374 faulting application start time: 0x01d219ca26c03237 faulting application path: d:\gensrvnt\bin\edimgr.exe faulting module path:  c:\windows\system32\kernelbase.dll

Smart Cards issued from different PKIs

can use smart cards issued 3 different pkis authentication (one internal, 2 external)? i've read info regarding internal issued cards internal ca or third party issued cards external pki. do smart cards need issued same pki the dc certificates? internally issued smart cards will probably use the user's upn external cards not have correct upn. i beleive the external cards would need auth certificate mapped user's account in ad, correct? information regarding the environment: domain: 2003, upgraded 2008 r2 clients: xp , 7 internal ca: 2008 thanks much! yes, possible. there minimum requirements: 1) pkis must trusted clients , servers (including domain controllers). can accomplished publishing pki's root certificates ad rootca container. 2) issuing cas certificates must published ad ntauthca container (actually record in ad). regarding upn's. smart card logon certificates should contain correct upn. because smart card logon don't support explic

Server2008R2 - Remote Desktop Services Properties - The Home Directory Was Not Created Because You Do Not Have Create Access

i logged in administrator on server2008r2 machine via remote desktop. not have physical access server. i'm setting user accounts have remote desktop services access. have made them members of remote desktop group. when setting remote desktop services properties enter (on "remote desktop services profile" tab) \\servername\sharename\username profile path under remote desktop services user profile , want connect q (from dropdown) \\servername\sharename\username\documents under remote desktop services home folder.  when apply settings above dialog stating "the {specified user} home folder not created because not have create access on server. user account has been updated home folder value must create directory manually after obtaining required access rights." error not apply setting until appled patch thought fix (http://support.microsoft.com/kb/2545735). @ least setting can saved. the 2 odd things i'm logged in admin full rights server , error after

Terminal server (RD) setup on DMZ environement

hi everyone, good day you, seek on following item puzzling with. the requirement have load balance access 3 terminal server include rd license server in workgroup environment. ask how guys setup on environment. looking forward on reply.:) regard ck ck hi there, workgroup deployment permit on host configuration mentioned here http://social.technet.microsoft.com/forums/en-us/winserverts/thread/f3d0543a-edab-4eb2-8360-3658a3351bb0 if need 3 servers, need active directory... cheers, sam Windows Server  >  Remote Desktop Services (Terminal Services)

Replica - target server hung

the target server - 1 being replicated - in 2012 hyperv replica environment seems have hung on 24 hours , replica has been failing result. steps required if going reboot target?  do have pause replica or can reboot?  even if don't have in theory pause replica procedures both circumstances - reboot pause , reboot without pause. hello, do have other vm replicating same target server? you reboot target replica server , initiate resume re-synchronization manually, because if hyper-v not able send disk changes across in timely fashion, replication relationship put failed state. @ point in time need perform re-synchronization replication relationship normal. i prefer use manual re-synchronization because it's heavy weight operation on cpu , disk i/o. waiting feedback. hope helps. regards, Windows Server  > 

Not enough storage is available to complete this operation

Image
i have windows server 2008 r2. have created disk mirroring (only 1 drive mirroring) earlier ok, last 6-7 days not able access windows services (computer management, services.msc) gave me error "not enough storage available complete operation"  and when run program shows me entry point not found. in computer drive have enough space available still show me not enough storage when trying access services. i have check list disk & show me wearied result. (it show me 1024 kb free) how can possible?  diskpart> list disk   disk ###  status         size     free     dyn  gpt   --------  -------------  -------  -------  ---  ---   disk 0    online          931 gb  1024 kb   *   disk 1    online          931 gb  1024 kb   * here list volume diskpart> list volume   volume ###  ltr  label        fs     type        size     status     info   ----------  ---  -----------  -----  ----------  -------  ---------  --------   volume 0     e

Cannot Remove User from Built in Administrators group

hi, our network admin left , want make changes share folder. want remove 1 of user administrators group. once removed comes group automatically after couple of minutes. can me sort out problem thank in advance jibran ishtiaq i believe have restricted groups group policy applied on server controls local administrators group members.  i have described here: http://social.technet.microsoft.com/wiki/contents/articles/20402.active-directory-group-policy-restricted-groups.aspx you can use rsop.msc and gpresult to list of applied gpos , settings. this posting provided no warranties or guarantees , , confers no rights. ahmed malek my website link my linkedin profile my mvp profile Windows Server  >  Directory Services

Defragmention for Servers Through GPO

hi.. currently have win2008r2 dc , automate defargmenation through gpo.  kindly assist how can configure defarg gpo ? i have seen sits talking scripts.  dont want go script options we want within gpo thanks hi msadmin, please refer to: disk defragmentation using group policy http://social.technet.microsoft.com/forums/en-us/winservergp/thread/1fe3d427-ad8b-4ee6-acca-b5526dcbfa06 brent 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. ” Windows Server  >  Group Policy

Failed feature removal

Image
in attempt repair rds web server tried uninstall component. when did i, got error 0x800f0922, , did not uninstall. prevented re-installing because still on computer. the story installed lync webapps server, , step in process removed pools , sites. in 1 step lost webpages had on machine, of sites knew pool add them , find root folders. how ever have no idea where/how rdweb services located.   thanks jack is essentials role/sku server? if restore backup, , attempt repairs again. robert pearman sbs mvp itauthority.co.uk | title(required) facebook | twitter | linked in | google+ Windows Server  >  Windows Server 2012 Essentials

Object NotFound Command not found

i don't know scripting or powershell, can find simple scripts , modify them environment. i found script: $dns="dnsserver" $zone="zone" import-csv adddns.csv | foreach { dnscmd $dns /recordadd $zone $($_.name) $($_.ip) } this need, have 250 static entires need make in dns. i put name of dns server between quotes in place of dnsserver i put name of zone file between quotes zone. i have csv file named adddns.csv  i saved file adddns.ps1 directory , put csv file in same directory.  i try run script powershell, , doesn't work. the error message is: "the term 'adddns.ps1' not recognized name of cmdlet, function, script file, or operable progrma. check spelling of name, or if path included, verify path correct , try again, at line:1 char:19 + adddns.ps1 <<<< +categoryinfo :objectnotfound: (adddns.ps1:string) []        commandnotfoundexception +fullyqualifiederrorid :commandnotfoundexception can ex

How can i get back to my Windows 7?

Image
before upgrade, created system image , checked save windows says here: http://windows.microsoft.com/en-us/windows/back-up-programs-system-settings-files#1tc=windows-7 "you can create a  system image , contains copy of windows , copies of programs, system settings, , files." now, can use old windows or no? , if can, how? i have on partition of 1tb hard drive.  thanks.  hi pulime, here have option called system image recovery. press shift shut down or restart machine, can screen: or if can use windows 7 install media boot computer winre, can use method restore computer: alex zhao technet community support Windows 10 Insider Preview  >  Windows 10 Insider Preview General

Firewall service keeps changing from manual to automatic

Image
i trying set firewall service manual in server 2012 stand edition keeps flipping automatic , starting on reboots. while it's on have turned off 3 settings in control panel, stopped , set manual it's still flipping automatic. is there bug this, else missing differs 2008 ?? thanks niamh hi, thanks post. change startup type, , restart services. in addition, may try use powershell command. please check below article. using set-service cmdlet http://technet.microsoft.com/en-us/library/ee176963.aspx you can disable firewall on control panel. best regards, aiden aiden cao technet community support Windows Server  >  Windows Server 2012 General

Windows 2012 servers error on check for updates

while checking  on of our windows 2012 /r2 servers error code 800b0001. have run sfc /scannow , dism checkealth tool. /scannow repairs corruptions , sometime there no integrity issue found. the wsus has hotfixes kb2720211 , winse368126 installed . can please advise nothing seems working out of many kbs googled. am 23.09.2015 schrieb kay55: while checking  on of our windows 2012 /r2 servers error code 800b0001. have run sfc /scannow , dism checkealth tool. /scannow repairs corruptions , sometime there no integrity issue found. wsus has hotfixes kb2720211 , winse368126 installed . pls check build wsus. don't use ?-menu, @ the startpage: http://www.wsus.de/images/wsus-version.png your wsus, if installed on w2008r2 or lower, must have build .274. pls install updates coming build .274: wsus 3.0 (sp2) + kb2720211:     build 3.2.7600.251 wsus 3.0 (sp2) + kb2734608:     build 3.2.7600.256 wsus 3.0 (sp2) + kb2828185:     build 3.2.7600.262 wsus 3.

How to set up a compute node only application network

i setting compute cluster using hpc server 2008 r2 cluster manager , have compute nodes isolated on private network, head node connected, have high-speed application network running between compute nodes only. how configure networking cluster? can't use topology 3, head node has 2 network adapters. thanks hi, from description suggestions regarding compute cluster network setup. moved thread cluster forum. in meantime please see if article provides help: compute cluster network requirements http://technet.microsoft.com/en-us/library/cc720171(v=ws.10).aspx if have feedback on our support, please send tnfsl@microsoft.com. Windows Server  >  High Availability (Clustering)

Lazy Schema Validation

i have scenario need create sp in db1 references table in db2 before db2 created. db2 referenced via linked server, not have recreate if/when moves server. seems lazy schema validation allow me create proc without checking linked server validation. unfortunately, not work. @ least tell me why it's not working? , perhaps tell me need make work? i following error when try create sp msg 7314, level 16, state 1, procedure testproc, line 4 the ole db provider "sqlncli" linked server "lnkdb2" not contain table ""testdb"."dbo"."testtable"".  table either not exist or current user not have permissions on table.       sample code:   use master go if exists(select * sysservers srvname = 'lnkdb2')                         exec sp_dropserver 'lnkdb2', n'droplogins' exec sp_addlinkedserver           @server       = 'lnkdb2'         , @srvproduct   = ''         , @provider='sq

SSRS 2005 - Hiding Parent Group Based on Conditions from Child Groups while exporting to PDF (to avoid blank pages)

Image
hi, i using ssrs 2005 first of all. i have groups ordered below :- parent group = customer first child group = cg1 second child group = cg2 fourth group = detailed one now want hide data parent group (customer) based on conditions below :- condition 1) first child group (cg1)'s closing balance = 0 condition 2) there no transaction in fourth group (detailed one) i.e. count(transaction) = 0 @ detailed level group. is possible hide parent group based on conditions other child groups ? pls note while exporting pdf (to avoid having additional blank pages, if there no closing balance + no transaction selected period) in nutshell, blank pdf pages should not printed such customers, save pages. regards, hi, according description, want hide parent group based on condition, right? in reporting services, can use custom expression control visibility of tablix. in scenario, can add visibility expression @ parent group level achieve requirement, please refer f

DatePicker - Probably a stupid question

  hi,   this stupid question have spent day trying sort out. here code.   using system.windows.controls.datepicker   ... later...   datepicker m_date = new datepicker();   with using systemsystem.windows.controls.datepicker statement in error:   error 1 the type or namespace name 'datepicker' not exist in namespace 'system.windows.controls' (are missing assembly reference?) c:\_silverlightapps\example\example\mycommon\mybutton.cs 3 31 example   and new statement error   error 2 the type or namespace name 'datepicker' not found (are missing using directive or assembly reference?) c:\_silverlightapps\example\example\mycommon\mybutton.cs 240 9 example   i using silverlight 3 , vs 2008 express. got ideas? (other controls button working fine).   jaa   just want make sure, adding resource mean have right clicked resources folder under project in solution , added there, correct?    if have try removing dat

things to consider when loading a lot of data to a big table

what are considerations when loading large amount of data large table? one thing consider indexes because need rebuilt. 1 advice had drop index, load data, , re-create index. faster loading without dropping index? what other considerations or concerns there? data isolation? if take while load data, users locked out selecting table? try test this, not sure how can come large enough data set play with. it not faster drop indexes first before loading, because have overhead of rebuilding indexes when done. please tell version using. as of sql 2000, there efficient techniques sql server can use internally maintain indexes during bulk load.  should try out own testing. take @ white paper more details. the data loading performance guilde: http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx hth, kalen delaney www.sqlserverinternals.com SQL Server

MSSCCI Provider 12.1.00402.0 without VS 2013 installed

Image
hi, when trying install msscci provider version 12.1.00402.0 vs 2015 installed (and not vs 2013) error. at download location https://visualstudiogallery.msdn.microsoft.com/06c8e056-7f77-4a5c-9b8b-49318c143df8 there note 27 august 2015 says vs 2015 supported. have tried install vs 2013 team explorer error message persists. rather not have install vs 2013 since update vs 2015. is there fix? kind regards jes holm hi starain, thanks help! i have reported problem here: https://connect.microsoft.com/visualstudio/feedback/details/1792076 and try fix problem uninstalling vs 2015 , vs 2013 , install them in chronological order.... kind regards, jes holm Archived Forums V  >  Team Foundation Server - Source and Version Control

Disable windows authentication in SQL Server

how can disable windows authentication mode in sql server using sql query or windows command. i know how using management studio. i.e., security --> logins --> builtin/administrators --> status --> login --> disabled. but need using command. thanks in advance hi huamin, i have checked 1 alter login [ builtin\administrators ] disable  but 1 did not work me if want remove builtin\administrators group see https://www.mssqltips.com/sqlservertip/1017/security-issues-with-the-sql-server-builtin-administrators-group/ but before remove suggest go through understand gotchas https://support.microsoft.com/en-us/kb/263712 please mark answer if solved issue please vote helpful if helps solve issue visakh ---------------------------- my wiki user page my msdn page my personal blog my facebook page SQL Server  &g

Microsoft-Windows-CAPI2 Access Denied Event ID 4110 error

hi team, i need help! have install symantec application windows server 2008 r2 workspace , i'm running error message , on event viewer this.: xml view.: - <event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> - <system>   <provider name="microsoft-windows-capi2" guid="{5bbca4a8-b209-48dc-a8c7-b23d3e5216fb}" eventsourcename="microsoft-windows-capi2" />    <eventid qualifiers="0">4110</eventid>    <version>0</version>    <level>2</level>    <task>0</task>    <opcode>0</opcode>    <keywords>0x8080000000000000</keywords>    <timecreated systemtime="2016-06-20t07:17:05.960875000z" />    <eventrecordid>1491095</eventrecordid>    <correlation />    <execution processid="284" threadid="5460" />    <channel>application</channel>