How to check if SP1 for SQL Server 2008 R2 is already installed? -


i have trouble figuring out if sp1 installed. don't think check management studio different application. sql server self has no ui check under "about". :)

any ideas?

there not sp1 sql server 2008 r2 yet.....

but check, can inspect productlevel server property:

select     serverproperty('productlevel')

this contain rtm original rtm version (as in case sql server 2008 r2 now), or contain info service pack installed.

i typically use sql query:

select       serverproperty('productversion') 'product version',      serverproperty('productlevel') 'patch level',       serverproperty('edition') 'product edition',     serverproperty('buildclrversion') 'clr version',     serverproperty('collation') 'default collation',     serverproperty('instancename') 'instance',     serverproperty('lcid') 'lcid',     serverproperty('servername') 'server name'

this lists server version, edition, service pack (if applicable) etc. - this:

product version  patch level  product edition             clr version  default collation     instance  lcid  server name 10.50.1617.0       rtm        developer edition (64-bit)  v2.0.50727   latin1_general_ci_as   null     1033  *********

update: answer correct when posted - july 2011.

by now, november 2012, there's sql server 2008 r2 service pack 2 available download


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more