My fan

  i'm trying restore database in sql express. backup file, mydb.bak, 3.1 gb. when try restore in sql express, get:   "create database or alter database failed because resulting cumulative database size exceed licensed limit of 4096 mb per database"   ok, understand 4 gb limit... why getting error database that's 3.1 gb? the .bak size smaller database size.   SQL Server  >  SQL Server Express

query use [row]    update dbo.fpts_all   set  dbo.fpts_all.relid  = dbo.fpt_partid_relloc_mapping.relloc   from dbo.fpt_partid_relloc_mapping join        dbo.fpts_all    on  dbo.fpt_partid_relloc_mapping.partid  = dbo.fpts_all.partid  ends error msg 0, level 11, state 0, line 0   a severe error occurred on the current command.  the results, if any, should be discarded.  i re-worked (rearranged) query use [row]    update  dbo.fpts_all   set      dbo.fpts_all.relid   = dbo.fpt_partid_relloc_mapping.relloc   from    dbo.fpts_all  join    dbo.fpt_partid_relloc_mapping    on       dbo.fpts_all.partid  = dbo.fpt_partid_relloc_mapping.partid  and ends in msg 5180, level 22, state 1, line 3   could not open file control bank (fcb) for invalid file id 256 in database 'row'.    verify the file location. execute dbcc checkdb.  that doesn't make sense!!! can explain, please!

can please me syntax building set member not equal value?   for example:     nonempty ([customer].[phone].[phone]. members ,           ([measures].[internet order count],           [promotion].[promotion].&[2],           )     )   in adventureworks give me list of phone numbers have promotion code of 2.  i list promotion code not 2.    i know simple can't find way in mdx.    please if can.    thanks the issue logic finds phone numbers have data promotion other promo 2, rather than  phone numbers no data promo 2, (i think) want. try version of query, removes phone numbers with data promo 2 - remaining phone numbers have no data promo 2:   code snippet with set cpn as except ([customer].[phone].[phone]. members , nonempty ( [customer].[phone].[phone]. members , { [promotion].[promotion].&[2] } * { [measures].[internet order count] } )) select non empty { [measures].[internet order count] } on columns ,

hi, we have existing tfs 2010 instance, forunately , ip address got changed , hostname same. now while connecting, saying server offline. but, admin console working. anywhere , need refersh , please guide me, little urgent. regards,akila have made necessary changes forward zone lookup table (ie. changed ip of host) in dnsmgmt on domain controller? and/or if using fqdn access server, have made necessary changes administration/configuration page on account on dns host's page? Archived Forums V  >  Team Foundation Server - Setup and Administration

hi my header in datagrid lengthy. there way can wrap 2 rows in same column.  suppose header " a  lengthy column in datagrid" want show below. this lengthy column in datagrid how this? thanks anandraj.a. xmlns:localprimitives="clr-namespace:system.windows.controls.primitives;assembly=system.windows.controls.data" <data:datagridtemplatecolumn header="youheader"> <data:datagridtemplatecolumn.headerstyle> <style targettype="localprimitives:datagridcolumnheader"> <setter property="template"> <setter.value> <controltemplate targettype="localprimitives:datagridcolumnheader"> <textblock text="{templatebinding content}" textwrapping="true"/> </controltemplate> </setter.value> </setter> </style> </data:datagridtemplatecolumn.h

i'm attempting use cmanagedcomponentwrapper. setcomponentproperty method programmatically configure parameter in ole db source component, i'm unable work.  configured ole db source use ole db connection manager.  therefore, source query using the placeholder syntax (?) parameter.  have code sample of how done?  possible or not?  if not, there workaround? tia duane douglas, mcad | http://www.ssisbi.com | please mark post(s) answered question. i'm attempting use cmanagedcomponentwrapper. setcomponentproperty method programmatically configure parameter in ole db source component, i'm unable work.  configured ole db source use ole db connection manager.  therefore, source query using the placeholder syntax (?) parameter.  have code sample of how done?  possible or not?  if not, there workaround? tia duane douglas, mcad | http://www.ssisbi.com | please mark post(s) answered question.   duane, specify parameters setcomponentproperty method? ssis tasks

  dear all:   i need develop application flood forecasting   i have following data   daily rainfall , water river need forecast   i not know how can start   mohammed i assume you're planing use data mining sql server analysis services. useful know more details problem. assume have table looks like; date, rainfall, water level   how define flood?   SQL Server  >  Data Mining

hi all, sorry basic question 0 in networking. i grateful if guides should make 1 of home pc server. scenario follows: i want give training few students sql server t-sql. i have 1 laptop using sql server 2012 having windows 7 pro(laptop master-want make server). have other laptop running windows 7 pro , got sql server 2008. students have mix of laptops including windows xp, windows vista, windows 7 , windows 8. students have sql server 2008 installed , working. q1: want make laptop master(explained in above paragraph) as server , want other laptops to access master server in home network. install sample exercise database on server , students writing queries access data. q2: can secure sample database students can copy sample database server? q3: can students run queries remotely sitting home? thanks in advance. kind regards a k adnan first of all, need valid ip. can enable remote connections in sql server, students can work on sql server via internet.  mo

i'm trying install sql server 2008 r2 (the 1 dreamspark) on computer local testing on database app i'm working on.  reason when gets form handles service accounts , server collation configuration,  sql full-text filter daemon launcher greys out startup type box, , sql server browser greys out account , password boxes.  can't figure out how change these in way make darn program install.  file told me uninstall existing sql server items on computer, , best of knowledge ones left installed visual studio 2010. i'm using can convert bunch of .dbf files sql server files can import windows form app.  it's not going used kind of networking or connectivity time, need fuse bunch of dbf's coherent vs compatible file (i've read have run them through access or excel first, can do). can explain what's going on or offer better link program?  i'm confused entire set , installation methods. may fleas of thousand camels feast happily on lower regions of enem

as per client requirements. the editor control must supprot these things. 1. images text. 2. images movable. 3. spell check functionality various languages. can you help me in getting supportive link same.    hi, check if helps you: http://www.devexpress.com/products/net/controls/silverlight/rich_editor/ Silverlight  >  Silverlight Controls and Silverlight Toolkit

in vs 2008 c# express while adding new datasource can see , sql server database file & sql server compact 3.5 , but doesnot show sqlclient through i can use sql 2005 server database ,  i trying add linq sql class need connect database. in vs 2005 can connect database thorugh data base exdplorer. would please experiment on machine , provider information need? 1. run "odbcad32.exe". 2. in "user dsn" tab, click "add". 3. check whether there's "sql native client" or "sql server" or "sql server native client 10.0". thanks, hooray SQL Server  >  SQL Server Data Access

i'm trying setup directaccess server on windows server 2008 r2 system windows 7 enterprise client. seems configured correctly according directaccess console, client unable connect. when client outside of corporate network, able ping ipv6 addresses of dns servers, dns servers don't respond nslookup queries. ipv6 dns queries succeed when inside of corporate network.   i have installed microsoft directaccess connectity assistant on client copied result below. main thing seems following error: netsh advfirewall monitor show mmsa / qmsa = no sas match specified criteria . any appreciated!       red: corporate connectivity not working. microsoft directaccess connectivity assistant not configured. please contact administrator if problem persists. 9/5/2011 9:12:35 (utc) c:\windows\system32\logspace\{e716ad8b-69f9-47c1-a918-2186c87d2fc3}>ipconfig /all windows ip configuration host name . . . . . . . . . . . . : nblum109 primary dns suffix . . . . . . . :

where aik windows 2016? don't see on windows 2016 product pages , there no references in ebooks. i've noticed 2012 r2 dism doesn't work 2016 windows 10 1 although system image manager does. ok use this?? confused! gary williams hi gary, i'm not sure if still need found these: http://www.technig.com/install-adk-mdt-in-windows-server-2016/   https://technet.microsoft.com/en-us/windows/dn475741.aspx.   not sure if help? Windows Server  >  Windows Server 2016 General

i have windows server 2008 r2 standard forefront tmg 2010 installed , configured owa publishing. trying install update using windows update keeps giving me 80072ee2 error. have reset ie, renamed hosts file, adding windows update site in trusted site list , still facing issue. any suggestion appreciated. fazal ur rehman shah | senior consultant have tried this  http://windows.microsoft.com/en-ie/windows-vista/windows-update-error-80072ee2 http://social.technet.microsoft.com/forums/en-us/windowsserver2008r2general/thread/f38f9574-f872-4ca5-bd54-cd30fb147121/ http://www.arabitpro.com Windows Server  >  Windows Server General Forum

my msi deployment user config deploys client, when trying computer config install nothing, no errors eithers.. check these items: http://deployhappiness.com/top-10-ways-to-troubleshoot-software-deployment/ i guess either gpo isn't being processed. can run gpresult , ensure gpo applies (and linked ou containing computers). if answer helped you, check out blog: deployhappiness.  subscribe rss  or email.   Windows Server  >  Group Policy

do know cause iis server cached? has been powered off more 2 days (windows 2003 server) , home page still loads. router doing this? has never happened before. http://pwhittle.dlinkddns.com/ hi,   thanks posting @ windows server forum.   if web server offline, other website requests not able arrive @ server. therefore, 1 new user first time browsing website, cannot open page. maybe website cached on ie. please try delete ie browsing history see if can still open page.   in addition, cannot open link provided. hope information helps.   best regards, aiden Windows Server  >  Management

i ran issue earlier today haven't seen before.  current setup 1 forest & 1 domain single domain controller (w2003 r2) has fsmo roles since it's dc in domain ever installed. we're ready decommission old w2003r2 server prepped new machine , installed windows server 2012 r2 on it, patched up.  done followings: 1. joined new server domain (successful) 2. promoted new server domain controller (successful without errors or warnings) 3. verified dns records have replicated primary dc 2nd dc (successful) 4. verified able access ad services on new domain controller, users, ou's, sites etc. (successful) 5. verified replication of ad objects adding users/ou's/distribution groups on primary dc , see them replicate on , vice-versa (successful) i waited hour make sure has replicated on , in sync , decided shutdown primary server (domain controller) make sure things functional on new 1 , old dc shutdown wasn't able open of ad services ad domain , trusts

a customer of ours decided start using .com domain name instead of old .nl name. we made fresh csr using certutil, got shiny new certificate , imported appropriate container, repaired private key tied , wanted start using in iis. iis accepted certificate, stating legit private was present. upon trying access site via https error: connection disrupted (sorry, translated dutch), connection website disrupted while loading page. we placed old certificate back, produced working website, albeit warning certificate out of date. had renewed certificate .nl domain, when places 1 site work requests old name, not new domain name, giving error mismatch in domain names. in end generated new csr, repeated above process, same result. the lack of clear error leaves bit in dark. does have helpfull suggestion? many in advance. wouter@work hello, i think better ask them here: http://forums.iis.net/ this posting provided "as is" no warranties or guarantees , , confe

i'm having difficult time searching usual feature used find in microsoft office tools windows8 in new format , there more windows open lost ... please - thnx! check this  ; http://answers.microsoft.com/en-us/office/forum/office_365hp-other_msftoffice_apps/office-365-where-is-picture-manager/c3831675-acf7-4520-93b7-bc328acfaa8c?msgid=538c3842-0dee-491b-b768-f94f51eb10f8 arnav sharma | facebook | twitter 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

boa tarde,  está é minha primeira pergunta no technet, apesar de frequentar anos, trabalho com redes já faz um bom tempo e sempre que vou implantar um ad com politicas fico confuso, é o seguinte: tenho um domínio, dentro deste domínio tenho várias ou, tenho gpos que se aplicam todo o dominio, porém tenho determinadas ou que quero aplicar tanto gpos dominio como outras especificas, até ai tudo bem, porém quando quero aplicar uma gpo especifica dentro de uma ou que é quase mesma que uma gpo de dominio, porém só altero o caminho de um script, por exemplo, por default qual gpo terá prioridade? e eu posso fazer com que aplique ambas gpo e na gpo da ou especifica aplicar apenas o que está modificado?, ou fazer com que 2 sejam aplicadas cada uma com suas diretivas? essa ultima eu sei que funciona quando se trata de gpos que não se "cruzam" porém quando elas alteram mesmas diretivas fico confuso. eu sei que tem opção de vincular e impor, teste uma gpo de dominio sem impor

wondering if there way automatically sort new , existing computer accounts based on ip range specific ou. have several ous definied location , have gpo attached ous. way can see clear starters to: 1. ping computers obtain subnet 2. move computer account corret location ou problem couple of months down line computers in wrong computer ous. other solution thinking have no location specific computers ou instead have computer gpo process wmi script checked ip network. afraid option add overhead. any suggestion/ideas anybody? hello, you should better ask in scripting forum this. for problem of computers moving out of ous, possible if domain administrators or higher permissions used, able change in company? if in other ous done manual admin. or use scripted, unattended installation ou specified move computer after installing? best regards meinolf weber disclaimer: posting provided "as is" no warranties, , confers no rights.

  the return in function doesn't work expect: function not return value "return", return information printed in function. it's hard debug when print info in the function when added print, treated part of returned value    function a{   "333"   "called"    return 1 }   $b=a     no output in console when run it   function a{   "333"   "called"    return 1 }   $b=a $b   $b is 333 called 1     weird thing, need care it anything don't 'capture' inside function (assign variable or suppress output) returned function.for more information type in console: help about_return   also, there's excellent blog post mvp keith hill topic: effective powershell item 7: understanding "output" shay levy [mvp] http://blogs.microsoft.co.il/blogs/scriptfanatic powershell toolbar

hi all, i've strange problem here. i've lot of windows 7 sp1 computers joined domain, have windows time service disabled. there's not gpo configures this. also, if set automatic , enable service, computers don't sync clocks domain (in hklm\system\currentcontrolset\services\w32tm\parameters, value of "type" "nosync"). way i've managed work running following commands: net stop w32time w32tm /unregister w32tm /register net start w32time after this, value of "type" changes "nt5ds" , time syncs ok domain. don't know why happening, , how fix in w7 sp1 machines. dc's synchronized pdc. any ideas? it seems there may gpo created w32time other administrator , same have been deleted.as gpo deleted setting not reverted client machine. recommend check directory service log if gpo created or deleted.if auditing of directory service access is enabled events logged else not logged. due hotfix or script (cont

hi all, i have question on windows clustering. what happen cluster services if ad fail. cluster services still able service client requests till time failover or cluster services fail. thanks , regards seng leng everything will work on cached credentials while.  using server 2012 or higher, hyper-v cluster guaranteed start , start vms can virtualize ad controllers in hyper-v based cloud. geoff n. hiten architect microsoft sql server mvp Windows Server  >  High Availability (Clustering)

i have used ldifde on article below extend our 2008 r2 schema mstpm-tpmownerinformationforcomputer object , gave the self object write permissions. all succeeds , after installed bitlocker recovery password viewer ad. 1 windows 10 computer wrote it's key mstpm-tpmownerinformationforcomputer can see in adsiedit when go in aduc bitlocker recovery password viewer tab see ' no items in view ' can 2008 r2 bitlocker recovery password viewer not see mstpm-tpmownerinformationforcomputer attribute , value (and windows 7 mstpm-tpmownerinformation) ? so got working , can confirm 2008 r2 bitlocker veiwer can view recovery password of windows 10 machines. just extend 2008 r2 schema ldf mstpm-tpminformationforcomputer , set acl then apply correct gpo enable-bitlocker , recovery key get's put in ad , viewable Windows Server  > 

i have configured active directory federation services 3.0 on w2k12 work forms authentication using domain username , password - the client running ie8 on windows 7. issue: struggling achieve windows authentication ie, however. on adfs server, under "edit global authentication policy", enable windows authentication (and forms authentication) when browse sp web page redirected (302) sts. (/adfs/ls) the sts redirects (302) wia url (/adfs/ls/wia) , www-authenticate negotiate + www-authenticate ntlm header returned (401). at point user prompted username , password rather being sent sp. i have ticked "enable integrated windows authentication" under advanced tab in ie. i have added sts url "local intranet"->"sites"->"advanced" list. i don't know else try. ideas? please consider asking them here: https://social.msdn.microsoft.com/forums/vstudio/en-us/home?forum=geneva this posting provided no warranties or g

hello, i adding windows 2008r2 member server our 2003 native ad domain , promoting dc, understand make our domain 2008 mixed mode.  what differences between staying in mixed mode , full 2008r2 native mode?  i have researched , found out ad recycle bin availbale in full 2008r2 native mode, others? thanks you can run dc's in domain in mixed (windows 2003,2008,2008 r2)mode, not give benefit until upgrade dfl/ffl either 2008 or 2008 r2. few features available in windows 2008 r2 ad recycle bin, branchcache(needs win7), automatic spn management etc. windows 2008 dfl/ffl can have different password policy in single domain, dfsr, offline domain join etc. for raising dfl/ffl need dc's in appropriate version dfl of windows 2008 dc's should running on windows 2008 , above member server can run on version of os. dfl/ffl affects dc not member servers. raising ffl 2008 r2 domain needs running dc's windows 2008 r2 os, if single domain in forest running @ least 1 2003 os