Posts

Showing posts from April, 2012

Animations and async webservice calls

hello @ all,   hope fine ;)  i have little problem animation. have silverlight app hostet in sidebar gadget. silverligth app consumes webservice. try connect webservice this   1 // set loading animation visible 2 loading.visibility = visibility.visible; 3 4 serviceclient proxy = new serviceclient(); 5 proxy.jobcompleted += new eventhandler(proxy_jobcompleted); 6 proxy.jobasync(); 7 8 // later @ source in jobcompleted event handler 9 loading.visibility = visibility.collapsed;   check if service availible again, use dispatchertimer calls every minute method show in example above. so hope clear do. my problem now, when start app, , service isn't availible, see loading spinner, when start webservice, loading spinner (animation) stops , stay on top. don't see data send web service in app, know (see in debugger , in behaviour of gadget) data send app. whats happening here? why silverlight app dosen't refresh layout

for each month show the last day in month

hi everyone, i want create calculated measure shows cube's measure , on y axis last day of each month i tried closingperiod function no success i appreciate assistance! eventually result should this: [time].[time h hirarchy].[date]              [mymeasure] 10/20/2013                                                150 09/30/2013                                                120 08/31/2013                                                95 etc... here's 1 example of tried: with member [measures].[mynewmeasure] as   (  closingperiod  ( [time].[time h hirarchy].[month]  [time].[time h hirarchy].currentmember  ), [measures].[mymeasure]  ),format_string = "currency" select   { [measures].[mymeasure]  } on columns  , [time].[time h hirarchy].[date]    on rows [daily] only recieved in result on y axis days 10.20.13     150 10.19.13     250 10.18.13    40 etc' hi gilboa , try next code last non

when scrolling element off canvas ensure it isnt visible

hi,   i have user control in want scrolling text.  way implemented simple, gust have canvas , place text in there , create animation canvas moving across screen starting in position off main canvas on right hand side and scrolling position off canvas on left hand side. this seemed work fine, when included user control larger usercontrol, found text scrolling visible when supposed to right or left of container canvas. is supposed happen?  how can resolve text seen when hits canvas belonging usercontrol on?   thanks yep... can. canvas, in silverlight, not clip content (in wpf cans), can this: <canvas height="115" horizontalalignment="left" margin="324,79,0,0" name="canvas1" verticalalignment="top" width="221"> <canvas.clip> <rectanglegeometry rect="0 0 221 115"/> </canvas.clip> <textblock canvas.left="-41"

View Source MDX when browsing a cube through AS

this should easy one. when browsing cube through analysis services 2005 , after dragging , dropping measures/dimensions etc. there way view background mdx generated in order create resulting view? jake hey there,   you can use sql server profiler, , open connection as server see queries being executed.   chris. SQL Server  >  SQL Server Analysis Services

AdventureWorks2012 OLTP Database Diagram

Image
is there 2012 version for: http://www.microsoft.com/en-us/download/details.aspx?id=10331 where adventureworks2008_conceptual.pdf?  2012 version ? thanks. kalman toth sql server 2012 & bi training new book: beginner database design & sql programming using microsoft sql server 2012 hi kalman, i cannot find oltp database diagram 2012, too. hope be published soon. stephanie lv technet community support SQL Server  >  SQL Server Documentation

GotFocus and LostFocus

i working on own textbox control, , found gotfocus , lostfocus events. i add rectangle variable ( obackgroundtext = (rectangle)findname("edit"); ) but don't know when events trigger. think element (rectangle, textblock) onmouseclick automatic focus , event gotfocus triggered. but whatever do, gotfocus event never triggered. from sdk documentaton: note gotfocus event can defined root canvas object in silverlight control. you need create kind of custom focus based on click events contol. Silverlight  >  Programming Silverlight with .NET – General

Should I use Notifications for this?

i'm new learning notifications architecture , know how heavy learning should go project.   i have service allow websites send info client application.  app gets downloaded members of service.  there client , website module client.   the user can have mutliple website modules.   the websites send soap update of info want send client server.  server acts messenger , relays info client.  server performs stat , security on updates prior sending appropriate client.   the updates within window of 10am 10pm , updates can occur @ every 60 minutes durring timeframe.   the server host account uses mssqlexpress , offer 1 db @ 50mb.  accounts bandwidth 2g per month.  should adequit until membership service pick , more power needed.   the ide express c# , vwd.  vs2005 standard used later wont change mssql version.   ado.net implemented in client , webserver code.   besides website updates there plans allow websites send alerts members cell phone, email, pda.  the

List the Children of Members of a SET

Image
we have concept of spatial hierarchy of   division > market > submarket   not divisions have members @ market level though.   having created set called [top 30], contains 30 divisions, i'd able produce report users can drilldown division market in cases there market members.   the following mdx returns need @ division level   code snippet select { [time].[quarter].&[q1 2007]:[time].[quarter].&[q4 2007] } on columns , { [top 30] } on rows from [qms] where ( [measures].[% occupancy] )     houston las vegas la county indianapolis   what   houston las vegas la county - la central - la north - la south indianapolis   as of 4 divisions above, la county has members @ market level. is possible do... ? it's ok, got it...   code snippet select { [time].[quarter].&[q1 2007]:[time].[quarter].&[q4 2007] } on columns , hierarchize( { descendants([top 30],[division].[div

slider in silverlight

Image
 how see 1 slide in silverlight. have several ppt , need see slide  thanks unfortunately can’t view ppt in silverlight. need create slides silverlight contents. can use powerpoint activex view ppt contents, require users have powerpoint installed on client. Silverlight  >  Programming Silverlight with JavaScript

silverlight does not apper in my master and content page.

 i installed vs 2008, sl2 beta 2 , xpression blend 2.5 june 2008 preview works fine, made "hello world" project i've learned in "winvideo-sl-gettingstarted.wmv" video tutorial.  i run firstsilverlighttestpage.aspx , works fine. here's code: <%@ page language="vb" autoeventwireup="true" %> <%@ register assembly="system.web.silverlight" namespace="system.web.ui.silverlightcontrols"     tagprefix="asp" %> <!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" style="height:100%;"> <head runat="server">     <title>test page myfirstsilverlight (felix)</title> </head> <body style="height:100%;margin:0;">     <form id="form1" runat="server" s

SSTP Remote Access / VPN

hello , i want configure sstp server . have readed article : http://technet.microsoft.com/en-us/library/cc731352(ws.10).aspx but looks need 2 windows server 2008 ( dc1 , vpn1 ) . single server . there no way install , run sstp server on single server ? thank you   hello, check article .   thanks Windows Server  >  Network Infrastructure Servers

read-host -assecurestring | convertfrom-securestring | out-file

  i have tried command on 3 different pc (2008r2 , win7) read-host -assecurestring | convertfrom-securestring | out-file c:\posh\cred.txt i used same user account create cred.txt , run command. in cred.txt just  simple text like  “jhdfjdhjfdhfjdhjfdf” an error got:   ps c:\posh> read-host -assecurestring | convertfrom-securestring | out-file c:\posh\cred.txt convertfrom-securestring : cannot process argument because value of argument "securestring" invalid. change value of "securestring" argument , run operation again. at line:1 char:53 + read-host -assecurestring | convertfrom-securestring <<<<  | out-file c:\posh\cred.txt     + categoryinfo          : invalidargument: (:) [convertfrom-securestring],     psargumentexception     + fullyqualifiederrorid : argument,microsoft.powershell.commands.convertfr    omsecurestringcommand   is there i’m doing improper way? did enter empty string @ read-host prompt?  that's wa

How to migrate AD users with two different Domain.

hi  i want test in lab.i have installed win 2008 server on comp1 , domain name xyz.com & ip 192.168.1.1.and have installed win 2008 on comp2 , domain name abc.com.ip 192.168.1.100,and have created trust relationship between. now want migrate ad uesr account xyz.com abc.ocm. how do??? pls help... thanks anil you can use active directory migration tool (admt) - have @ following articles: checklist: performing intraforest migration: http://technet.microsoft.com/en-us/library/cc974337(v=ws.10).aspx chapter 11: intraforest migration: http://technet.microsoft.com/en-us/library/bb727124.aspx enfo zipper christoffer andersson – principal advisor http://blogs.chrisse.se - directory services blog Windows Server  >  Directory Services

New-NanoServerImage cmdlet does not use -logpath location

i trying create 100s of nanoserver images using new-nanoserverimage cmdlet. parallelize operation running new-nanoserver image cmdlet job within start-job block. new-nanoserverimage -edition datacenter -deploymenttype guest -mediapath d:\ -basepath $basepathnew -targetpath $targetpath -computername $vmname -administratorpassword $pass -logpath $logpath -storage -verbose the $logpath variable changes each iteration of while loop. but, find on execution of jobs start writing logs @ default location , throwing error there n number of jobs running same command simultaneously. process cannot access file 'c:\users\administrator.domain\appdata\local\temp\nanoserverimagegenerator.log' because being used process.     + categoryinfo          : openerror: (:) [out-file], ioexception     + fullyqualifiederrorid : fileopenfailure,microsoft.powershell.commands.outfilecommand     + pscomputername        : localhost i following below article. in solving helpful. h

Server crashes when someone logs in.

Image
i have windows 2008 r2 server, , every time logs in via remote desktop, or on console, crashes.  the way power off, , on. it continue ping, but, file sharing, , network services (it exchange server!) stops.  it never logs in, stops @ "welcome." we cannot trace change. it virtual server on vmware.  there no events in event log point why crashes. any ideas on how troubleshoot? hi, thank posting in windows server forum. occur particular user or every users? there scenario due server got crash during remote session login. please check below article information. please try update following hotfix check result. applications or services start multiple remote desktop services sessions crash in windows 7 or in windows server 2008 r2 an application uses remote desktop connection activex control provide virtualized sessions crashes in windows server 2008 r2 or in windows 7 http://support.microsoft.com/kb/2446026 hope helps! thanks. dharmesh solank

windows 7: local Group Policy setting to restrict the Network properties modification

hello,, i have windows 7 professional systems in network systems users changing ip everytime going network properties.. i want restrict user from accessing  network propertis and ip changing.. i hope possible group-policy editor  how i do that.. thanks in advance.. subbu.  hi subbu, if user account belong administrators group, able change ip. disable them accessing network , sharing center, can still logon locally, change static ip , domain. should not give them local admin permission. or can try config dhcp assign ip via mac address, physical network card can setup ip address. Windows Server  >  Group Policy

Windows Server 2012 R2 and Windows Server 2012

hi, kindly, please if assist below questions? with a license windows remote desktop server cal 2012? questions: 1. requirement of multiple remote session of windows 2012 / windows server 2012 r2 is possible per below scenarios: a single user using remote desktop connection user 1 / user 1 / user 1 / user 1 / user 1 - same user can access 5 different pc's using same login name /password or five different users / user 1 / user 2 / user 3 / user 4 / user 5 can access 5 different pc's. 5 diferent user's login name/password. 2. can i either install 5 license 1 server or segregate 2 or 3 server per need? 3. if somehow format server have installed remote desktop cal’s can change other server ? thank kind support , assistance. regards, nadeem hello, question 1: both possible technically far licensing need contact partner/reseller confirmation. in summary if purchase rds user cals, each user - i.e. person - accesses rds environment need cal. if pur

Need to add a second private network between Windows Server 2008 & 2003 boxes

i have 2 web servers connected internet, , need setup private network between them can share files between boxes.   for security reasons don’t want on internet facing nics.   i have installed additional nic in each box , connected them cross on cable.   one machine running windows server 2003 , other windows server 2008.   i setup additional nic in each box follows:   windows server 2008 box: ip address: 192.168.1.2 subnet mask: 255.255.255.0 default gateway: blank dns servers: blank   windows server 2003 box: ip address: 192.168.1.1 subnet mask: 255.255.255.0 default gateway: blank dns servers: blank   i have couple of questions:   1.      the windows server 2008 box can ping 2003 box, windows server 2003 box cannot ping windows server 2008 box.   what wrong? 2.      the windows server 2008 box shows second network “public network”.   how can make “work network?”   the first nic has link change network type, change internet facing nic.  

How do you migrate from 2011 essentials to 2012 essentials on the SAME machine

i've read through existing documentation , blogs, cannot find how upgrade 2011 essentials (not home server) 2012 essentials on same machine. i've seen 2011e running on source server , 2012 on destination server. sorry dense. :-( thank time. there 1 possibilty... contact www.sbsmigation.com see if can support "swing" migration sbs-e server 2011 essentials.  issue here need hold ad while existing server being repurposed. larry struckmeyer[sbs-mvp] Windows Server  >  Windows Server 2012 Essentials

2012 Server DHCP Imported scope not available for load balancing.

we migrating our dhcp environment single 2008 dhcp server load balanced 2012 configuration.  i used following powershell commands export old server information , import server settings , scope new 2012 server.  we have on 200 subnets , easing this.  we imported existing subnet 2008 dhcp.  the scope 10.#.#.1 254, 1 day lease, no nap, both dhcp , bootp(used pxe boot devices).   the export...  export-dhcpserver –computername 2008dhcpserver.mydomain.com -leases -file c:\dhcpimport\dhcpservername_exp_date.xml -verbose the import new primary server 1 test scope... import-dhcpserver –computername 2012primarydhcp.mydomain.com -leases –file c:\dhcpimport\dhcpservername_exp_date.xml -backuppath c:\windows\system32\dhcp\backup -verbose –scopeid 10.#.#.# (test scope) the settings import new 2012 server load balancing... import-dhcpserver –computername 2012secondarydchp.mydomain.com –file c:\dhcpimport\dhcpservername_exp_date.xml –serverconfigonly –verbose –backuppath c:\windows

Why is this happening whilst configuring RDP

Image
hi, sorry if in wrong forum has happened whilst configuring rds hence thought post here. i am  trying configure rds in lab have roles installed on rds server apart licensing server is installed on dc. don't have clue why happening , @ stage of rds configuration appears. when i initially configured the dns server name e.g. server1 somewhere in configuring rds dns server name changed server1.sco.local (sco.local domain name). does why happening or causing happen  hi, sorry if in wrong forum has happened whilst configuring rds hence thought post here. i am  trying configure rds in lab have roles installed on rds server apart licensing server is installed on dc. don't have clue why happening , @ stage of rds configuration appears. when i initially configured the dns server name e.g. server1 somewhere in configuring rds dns server name changed server1.sco.local (sco.local domain name). does why happening or causing happen  please ignore ....

Unexpected Status after Recreation of DFSR-Replication Groups in 2003 R2

hi folks, i have recreated dfsr-replication group hours ago migrating envoirement 2 2003 r2 servers unsupported one-sided replication two-way replication descibed in http://blogs.technet.com/askds/archive/2009/06/23/recovering-from-unsupported-one-way-replication-in-dfsr-windows-server-2003-r2-and-windows-server-2008.aspx . this 2 local fileservers in 1 site 1 gbe between , 1,8 tb of data (divided in 3 folders). main reason action was, 2 of 3 folders not replicating long time. i have recreated first replication group via following steps: deleting replication group (share in dfs allways deactivated, one-way config) delete data on folder in downstream-server (incl. dfsr_private) restoring last full-backup via backupexec & folder redirection move data correct folder (backup exec allways restores additional dfsr-replicated fodlers subdir , pute data that) recrate replication group setting data on upstream server primary good: upstream reports, repl. group has been creat

Shared PDF printing (64-bit and 32-bit)

i've deployed server 2008 r2 64-bit print server , have worked way through issues surrounding deploying both 64-bit , 32-bit driver versions clients (mix of windows 7 64-bit , windows xp 32-bit).  deploy shared pdf printer them.  i've tried pdf creator v1.01, cutepdf writer , dopdf ... don't seem able find freeware solution can of following: deploys 64-bit , 32-bit driver; , allows user, after printing, save pdf local hard disk @ discretion the closest match i've found far pdf creator v1.01 did #1 above quite well, failed deliver on #2 ... save shared directory , did not give user option on save. can recommend solution me? hi, thanks post. if want users print documents local hard disk @ discretion microsoft xps viewer. for windows xp, download microsoft xps viewer following link: http://www.microsoft.com/whdc/device/print/xps/viewxps.mspx for windows 7, microsoft xps viewer comes preinstalled it. if there unclear on issue, please feel free let m

NFS Server, Mac OS 10.4, and iSCSI = ntfs.sys BSOD

hello everyone!   don't run issue can't take care of, 1 stumping me. able out.   i've got client has interesting storage needs, , deployment little off wall. decided go sbs 2008 machine talks 2 iscsi targets. actual server has 1tb of mirrored storage on ich10r south bridge. both iscsi targets created openfiler, using novell's iscsi stack. in end, newer , faster , bigger iscsi box main storage network, while older iscsi box used backup server backup. i've tested on smaller scale vm's , seems work fine.   catch have several mac os 10.4 machines need access these files also. should know fix upgrade 10.5 , use smb stack, let's face it, 10.5 poo , can't recommend deploying that. so, decided work around smb stack nfs.   have 5 or shares everyone-writeable macs , pcs share, while other shares, usershares, windows. share shares nfs, anonymous, everyone-writeable root-access. had issues getting new iscsi target up, running on single iscsi, , didn't hav

Issued to renew Subca certificate when we used a SAFENET KSP on ADCS 2008r2 SP1 wn a 2 tier offline root scenario

hi i got issued renew same key pair certificate of subca when certificate store in hsm , using ksp instead of legacy csp. and if it's not same sid how generated original key pair @ adcs installation. if same userid work fine. i ksp configuration both got hsm partition register in ksp, both pass vtl cmd run successful. but if try via certificate authority mmc snap-in renew certificate if the sid how install subca workflow work fine , got csr. when try other sid first step ok online submission windows don't appear , no csr generated . can find in certificate enrollment certificate store request pending. any error in ksp log or other  event log entry. someone got ideas ? thx stef71 Windows Server  >  Security

POS for .NET & RemoteApp

Image
is possible redirect opos receipt printers via remoteapp on server 2012 r2?  the can gather @ point yes is, when using remotefx , virtualized desktops. we trying connect opos devices connected via usb windows 7 / 8 clients when connect our application on remoteapp. --wanted add remoteapp server azure hosted vm.  i have found info stated azure cannot usb redirection - true? hi, thank posting in windows server forum. understanding correct need use remotefx feature usb redirection of pos. in case support azure hosted, afraid it’s not possible. azure doesn’t support usb redirection. more information. usb redirection desktop windows azure vm hope helps! thanks. dharmesh solanki technet community support Windows Server  >  Remote Desktop Services (Terminal Services

R6034 Runtime Error from system32\SearchFilterHost.exe Visual C++ Runtime Library

sbs windows 2003 premium sp2 keeps getting r6034 runtime error system32\searchfilterhost.exe saying application has made attempt load the visual c++ runtime library incorrectly. the system doesn't seem degraded in way.  i've been closing window.  it started after series of updates 2 months ago (september, 2009). it happens randomly far can tell.  there dozen in day , none. i have seen posts iis , r6034, doesn't seem case here. any appreciated.  nice rid of problem. thanks, ron hochnadel ron hi intrass, thank posting in windows server forum. have enabled indexing service on server ?, searchfilehost.exe used indexing , windows search . try stopping indexing service services.msc  , try disabling indexing enabled on disk ( if have enabled ) . for further assistance please post query under sbs server after have checked above pointers. for convenience, i’ve included link of windows small business server discussion group: discussions in windows small business server general ht

XP Clients Cannot Print

hello, i'm running windows server 2008 around 30 xp clients , 2 vista clients. i tried using printmanagement.msc deploy printer (konica bizhub c280) via gpo works vista. when xp clients try add tje printer, finds ask disk 32-bit drivers. these install on admin accounts not on domain user accounts. is there way can deploy printer , 32-bit drivers xp clients? thanks alexgeek.co.uk - web design , development blog bump? alexgeek.co.uk - web design , development blog Windows Server  >  Print/Fax

Win2008R2 Cluster Servers (Hyper-V) - swapfile or not

hi guys. we had debate here in office rearding our new windows 2008r2 cluster, it's 3 blades 96gb memory each work our hyper-v farm.. our topic was, servers ram function hyper-v 'agents' should have swapfiles @ all?  , if so, how memory (windows suggest 147.439 mb more 2 local 146gb disks bought system).. what take on this? tia michael møller hi,   nice question!   by way, following post discussed similar issue, can refer to:   should pagefile used if have sufficient physical memory? http://social.technet.microsoft.com/forums/en-us/winservergen/thread/994e9f48-f319-444b-a45e-226030ec3b6e     best regards, vincent hu   Windows Server  >  File Services and Storage

KMS Activation With 'reborn computers' (ctm)

hi guys, i have question, @ school we use comodo time machine reset computers after restart snapshot configured, question can use comodo time machine kms activation for windows , office products thanks, arno hi, don't use ctm don't see why not work. long not using cloning method clone multiple computers single original snapshot, should fine. don (please take moment "vote helpful" and/or "mark answer", applicable. helps community, keeps forums tidy, , recognises useful contributions. thanks!) Windows Server  >  Setup Deployment

Question about SSL Certificate for RD Gateway.

hi: i have issue , believe it's strange , should not behave that: i have certificate issued godaddy, it's ucc certificate following settings: cn = servername1.domain.com san = dns= servername2.domain.com san = dns=servername3.domain.com san = dns=servername4.domain.com san = dns=servername5.domain.com my rd gateway server's internal name is: servername2.domain.com, and external name is: servername4.domain.com if select certificate in both rd gateway server , rd session host , , run bpa on server manager, tells me ssl certificate not valid rd gateway. ------------------ now, have internal ca; if request certificate following settings: cn = servername2.domain.com san = dns= servername1.domain.com san = dns=servername3.domain.com san = dns=servername4.domain.com san = dns=servername5.domain.com (note i'm switching servername2 , servername1 values.) internal name cn. if run bpa, ssl error doesn't appear. what see wrong, fact bpa

I have question regarding to Cipher Changes

i have enabled cipher changes in windows 20012r2 , rebooted server.after rebooting server rdp disabled ,  i not able rdp server. please me on ,if know. hi, thanks post. would please tell cipher changes have enabled? and what's error message received when rdp server? if requirement securing rds connection, refer following articles: secure rds (remote desktop services) connections ssl https://technet.microsoft.com/en-us/library/ff458357.aspx configure server authentication , encryption levels https://technet.microsoft.com/en-us/library/cc770833(v=ws.11).aspx best regards, alvin wang 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

Import excel to SQL through tasks->import-data - Edit SQL button unavailable

i click tasks->import data on database. as data source i choose microsoft excel. as destination i choose sql 'sql server native client 11.0'. when i click 'edit mappings' button 'edit sql' inactive. and problem. i can't choose range of imported data. literally imports empty columns. can't choose data type in column. there other solutions but i import data through creator. hi , have tried tools->import , export settings  ? regards, david . SQL Server  >  SQL Server Data Tools

How to bind combobox control in DataForm?

i noticed one excellent article manish( http://weblogs.asp.net/manishdalal/archive/2009/07/03/silverlight-3-combobox-control.aspx ) . unfortunitely, works in datagrid, there better way in dataform?   thanks in advance!! to access datafield-wrapped control name, use dataform.findnameincontent() method. caveat: method should called after dataform's "contentloaded" event has fired (or else control may not have been loaded yet). example: dataform.contentloaded += (sender, args) => { textbox mytextbox = (textbox)dataform.findnameincontent( "mytextbox" ); // textbox... };   Silverlight  >  WCF RIA Services with Silverlight

SQL Server 2008 Standard - MSDN License

if subscribe "sql server 2008 r2 standard (x86, x64, ia64)" and is accessed by web application used 20 users work. as per msdn subscription, no product key required sql 2008 std. can deployed in multiple servers? hello, this community forum technical questions & issues. for question regarding pricing / licensing please contact microsoft sales partner or licensing expert. call (1-800-426-9400), monday through friday, 6:00 6:00 pm pst speak directly microsoft licensing specialist. http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx http://www.microsoft.com/sqlserver/en/us/get-sql-server/licensing.aspx http://www.microsoft.com/licensing/about-licensing/sql2012.aspx and note : server products (like sql server) from technet & msdn subscription testing & developing purpose, you not allowed use them in productive enviroment . please read license agreement of subscription.  olaf helper [ blog ] [ xing ] [ mvp ]

Having Problems with DATEDIFF in derived column expression

hi all i''m using sql server 2008. 'm using derived column in package , have 2 date fields (dtstartdate,dtenddate) coming flat file source. used derived column difference between 2 dates , add new field. i'm using following function in expression part. datediff("dd",dtstartdate,dtenddate) , reason highlighted in red , when clicked ok showing me following error message: title: microsoft visual studio ------------------------------ error @ data flow task [compute inactive days [370]]: function "datediff" not support data type "dt_wstr" parameter number 2. type of parameter not implicitly cast compatible type function. perform operation, operand needs explicitly cast cast operator. error @ data flow task [compute inactive days [370]]: evaluating function "datediff" failed error code 0xc0047089. error @ data flow task [compute inactive days [370]]: computing expression "datediff("dd", dtwarrantstart,dt

Selecting the same field but filter twice into different fields

i have quick question think... i've got field "user name" need to filter field in row. have return 2 values. need user user role - assessing official in 1 column and need user user role - admin in 2nd column. to first 1 this... select     tablea.[user role], tablea.[user name] from        tablea where     (tablea.[user role] = n'assessing official') but how change both values in 2 different columns. don't want filter once users assessing officials , admins. want col1 have assessing officials , col2 have admins. hi, new data, new query :) please try this, worked me: -- demo, uses tempdb use tempdb; go drop table tablea; -- create demo table , insert dummy record: create table tablea ([contract number] varchar(50), [user name] varchar(50), [user role] varchar(50)); insert tablea values ('xx-xx-123', 'sam', 'admin'), ('xx-xx-123', 'tom', 'assessing official'), ('xx-xx-456', 'jim

Decimal type handling: strange read-only error

i have simple test table defined decimal type (9,9) shown in script below.  i unexpected--and bad--behavior when typing values in via object explorer from management studio (right-click on table, select edit rows).    entering number digits left of decimal gives reasonable looking error expected.  entering number more 9 digits to right of decimal locks cell as read-only cell.  , entering "special" value 0.123456789 converts read-only, 0.123456788 works.    does know what's going on here? thanks.   /****** object: table [dbo].[testtbl] script date: 06/13/2008 21:35:01 ******/ set ansi_nulls on go set quoted_identifier on go create table [dbo] . [testtbl] ( [test] [decimal] ( 9 , 9 ) null ) on [primary] go overall, table grid fragile tables don't have primary key. able enter 0,123456789 in cell, without becoming read-only, first cell entered. i recommend using insert , update statements mainpulate data.

Detail/technical reasons for NAS (CIFS/SMB2 ?) NOT supported for Hyper-V 1.0

the following excerpt in latest (v. 1.2) hyper-v planning , deployment guide (http://www.microsoft.com/downloads/details.aspx?familyid=5da4058e-72cc-4b8d-bbb1-5e16a136ef42&displaylang=en ) implementing disks , storage this section describes various storage options server running hyper-v supports. discusses how plan storage, how create virtual hard disk, , how configure storage. you can use following types of physical storage server runs hyper-v: •    direct-attached storage (storage attached management operating system). can use serial advanced technology attachment (sata), external serial advanced technology attachment (esata), parallel advanced technology attachment (pata), serial attached scsi (sas), scsi, usb, , firewire. •    storage area networks (sans). can use internet scsi (iscsi), fibre channel, , sas technologies.   note: network-attached storage (nas) not supported hyper-v. i have read jose barreto's postings on here , others regarding running vms off cifs (window s

Windows 2008: built-in full system restore on FISMO DC and concern with USN rollback

hello, i have 5 dcs in ad domain , rely on full system restore , replication able dc disaster recovery in case 1 of dcs failed or become corrupted. i planning use windows built-in backup system full os backup on domain controllers , standalone certificate servers once every month , rely on able re-build dcs ca on them, bare metal. my concern don’t understand how full system restore not cause issue update sequence number (usn) , create usn rollback problem? how windows restore handles usn when month old dc system os backup restored? considering vhd backup bad bad idea dcs, simplest , reliable backup , restore approach here? thank you, you taking right approach.  hear asking is essentially "why restoring dc state month ago not put server usn rollback?"  reason windows server backup automatically resets invocationid (and 1 other critical reg key) which tells other domain controllers "hey, have restored database can updates since then?"  if invocat

windows server 2008 r2 sp1 web edition server core and fonts

Image
what fonts included in windows server 2008 r2 sp1 web edition server core? arial, times new roman thank in advance. hi, if want check fonts included in windows server 2008 r2 sp1 web edition server core, use 2 methods below. first, type dir command under c:\windows\fonts folder display list of files , subdirectories. fonts included in system. secondly, open registry editor , check registry keys under [hkey_local_machine\software\microsoft\windows nt\currentversion\fonts] fonts list. hope helps. best regards, andy qi technet subscriber support if technet subscription user , have feedback on our support quality, please send feedback here . andy qi technet community support Windows Server  >  Server Core