Lun

  hi all,   i've got question.  i've been using customrollupcolumn in 2000 , 2005.  i've seen still exists in 2008, when in books online shouldn't use more.  instead should start using mdx scripts.   can point me document more information on topic? maybe example of how mdx statement source mdx script?   regards, nico     SQL Server  >  SQL Server Analysis Services

hi, is sp1 sql server 2014 available on wsus ? if not when available ? guess there time slot between when available on download center , wsus? /regards andreas hi thanks reply. yes have done now, customer wants have sql updates fra wsus now. if not recommended need faq regarding that, can show customer this... want deploy manually, customer wants automatically wsus :) /regards andreas i can fiind below thread user confirmed had issue installing sp windows update https://social.msdn.microsoft.com/forums/sqlserver/en-us/2d219aeb-20db-41a6-9a05-146b084616d5/sql-server-2012-service-pack-2-constantly-fails-with-windows-update-code-84b30002?forum=sqlsetupandupgrade please mark reply answer if solved issue or vote helpful if helped other forum members can benefit my technet wiki article mvp SQL Server  >  ...

we have application have front end using microsoft technologies , middile tier using java technologies. want keep cvs source repository of middle tier , tfs front end . can use  tfs 2010 meet scenario . if how? if team explorer everywhere plug used purpose,any documentation on helpful   thanks   c team explorer everywhere lets java developers use team foundation server eclipse. martin woodward did great presentation @ tech*ed on this. see http://www.msteched.com/2010/northamerica/dev308 sure understand question. tfs 2010 can definetelly used repository front end part of project. tfs clients cannot use cvs repository , vise versa. regards, --vladimir     Archived Forums T-U  >  Team Foundation Server - Setup ...

i'm using logshipping , have running on 2 databases fine.  the job created when set , testing logshipping called lsalert runs every 2 minutes , fails because referencing old database used set testing of logshipping. how stop trying find database (rep_test)?  the script run is: exec sys.sp_check_log_shipping_monitor_alert  and error in logs is: date 17/02/2011 1:50:00 pm log job history (lsalert_sqlserver) step id 1 server sqlserver job name lsalert_sqlserver step name log shipping alert job step. duration 00:00:00 sql severity 16 sql message id 14420 operator emailed operator net sent operator paged retries attempted 0 message executed user: office\dw. log shipping primary database sqlserver.rep_test has backup threshold of 60 minutes , has not performed backup log operation 27380 minutes. check agent log , logshipping monitor information. [sqlstate 42000] (error 14420).  the step faile...

hello i had sql server 2008 r1 on system win 7 home premium 64-bit. i uninstaled contorol panel . now, have reinstal agatin , saw error : sql server setup has encountered following error:   invoke or begininvoke cannot called on control until window handle has been created..  please tell me how can solve problem. http://blogs.msdn.com/psssql/archive/2008/08/11/sql-server-2008-visual-studio-2008-sp1-and-net-framework-3-5-sp1-explained.aspx 1) if don't have visual studio 2008 installed , have never installed sql server 2008 ctp build,  sql server 2008 rtm comes need , should not encounter problem. 2) if have visual studio 2008 installed, must install vs 2008 sp1 before install sql server 2008 rtm (or don't pick features require it). 3) if not have vs 2008 installed encountering problem, not attempt install vs 2008 sp1.  rather, uninstall visual studio 2008 shell (integrated mode) , visual studio tools applications 2.0....

hi,    i want set deadlock priority of stored proc low when ever 1 calls entity or command object should use same priority. some body sugested put  set deadlockprioirty low  go exec yoursp() but in case have change bussiness layer. is there other way database task? yours sincerley. you can modify stored procedures , add code line set deadlock_priority low @ beginning of sp. olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Database Engine

greetings! i have 2 expressions trying chart, cumulative amount , cumulative percentage. when create table using 2 following expressions, data. however, when chart both of expressions, cumulative amount. percentage not render. =runningvalue(fields!humancase.value,sum,"dataset1") [works on both table , chart] =round(runningvalue(fields!humancase.value,sum,"dataset1")/sum(fields!humancase.value,"dataset1")*100,2)&"%" [works on table not display in chart] columns humancase = 1 on rows week vary year vary, filter/parameter can point out missing? many thanks! hi john, i have tested on local environment , can reproduce issue, issue can caused 2 factors, 1 in chart "value" support numeric values, expression "round(runningvalue(fields!humancase.value,sum,"dataset1")/sum(fields!humancase.value,"dataset1")*100,2)&"%" returns string values, if got error, issue...