My fan

how upgrade sql server 2008 r2 express 2008 standard edition how upgrade sql server 2008 r2 express 2008 standard edition hello, 2008r2 => 2008 would downgrade , (directly) not possible; database files not backward compatible. have new installation , have copy objects + data new sql server; restore not possible. or mean 2008r2 express => 2008r2 standard? that's possible, see version , edition upgrades olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Setup & Upgrade

hi all what sql sintaxe query table this: select * table1 date between , last 24 hours -- order date --not sure if needed or better yet, where date between max(date) , last 24 hours thank you   jcd try: select fields from table1 where [date] between dateadd ( hour , -24, current_timestamp ) and current_timestamp for every expert, there equal , opposite expert. - becker's law my blog SQL Server  >  Getting started with SQL Server

i'm building silverlight application requires server-client communication. i created policy service these instructions http://weblogs.asp.net/dwahlin/archive/2008/06/08/creating-a-silverlight-2-client-access-policy-socket-server.aspx  but works when policy service runs exe. i cannot run exe on hosting server i've got figure out solution the server runs normal web application. when try run policy service in thread in server, policy service gets request, sends policy file client still throws "access denied". any ideas? ok after more 2 weeks of trying sort problem, it appears has incorrect policy xml file. Silverlight  >  Programming Silverlight with .NET – General

i have .sdf database file on sd card read/write application on mobile computer. i want put sd card laptop not have visual studio or sql server installed , able read in way program write in java. is part of possible? you must use oledb or .net based sqlceclient open , read sql compact database files. if can program against of these in java, yes. otherwise no.   SQL Server  >  SQL Server Compact

i setting up a hp proliant server 3 sata hdds 3 separte volumes/partitions , w2k8 svr std r2 standalone server in workgroup.  role activated fileservices. there 4 users - administrator (no password) , 3 other users (user1, user2, user3).  users configured belong administrators group.  2 folders in last 2 of each hdds/volumes shared 16 workstations accesses server's shared folders using of 3 server/ user accounts. the questions are: 1)  need confirm need add 2 x 5clt device cals + 1 x 1clt device cals.  though not using server domain controller. 2)  server operate @ optimum level file services enabled standalone server ?  there other components or roles ideal enable ? 3)  local site security not issue, main advantage of configuring server domain controller rather standalone server ? some feedback appreciated.  thank in advance. edgar hi, regarding license problem, we’d better confirm ms license team. please ref...

hello, i need come powershell script create file gets imported application. found vb version of script, it's limited , need have input file script calls csv file or excel file need import more servername, need have connectionname specified, description, , folder. here link thread vb script , below vbscript code, can me out? have no idea how this.. http://forum.visionapp.de/showthread.php?tid=193 ************************ '*************'set basic scripting objects**************************** 'option explicit dim objshell, objfso, objwshnetwork dim computername, username, userdomain, scriptname, scriptnamefull set objshell = createobject("wscript.shell") set objfso = createobject("scripting.filesystemobject") set objwshnetwork = createobject("wscript.network") computername = objwshnetwork.computername username = objwshnetwork.username userdomain = objwshnetwork.userdomain scriptname = wscript.scriptnam...

hello, we have encountered situaton manually created dns record, pointing website, got overwritten win xp dhcp client having same hostname website. rendered website unavailable. using win 2008 dhcp / dns. dhcp set update dns on behalf of client (and member of dnsupdateproxy group). dns set allow secure updates. we have tried stripping rights of static dns record, since dhcp can take ownership "re-registers" record. is there anyway prevent occuring? (other turning of ddns or dhcp updating dns :) ). there someway can protect records ever being overwritten? hi. have same problem in ms windows 2008 r2. solution ms environment: found article 246804 "how enable or disable dns updates in windows 2000 , in windows server 2003" (registrykey: disablereplaceaddressesinconflicts), tell how microsoft clients not overwrite static dns records. however have mixed environment linux , ms, open call @ microsoft. ...