Lun

hi all, i trying install sql server 2012 evaluation copy , getting error message the following error has occurred:   unable open windows installer file 'g:\1033_enu_lp\x64\setup\x64\sqlncli.msi'.   windows installer error message: system cannot open device or file specified. .   click 'retry' retry failed action, or click 'cancel' cancel action , continue setup. system specs windows server 2008r2 enterprise. 8 gb ram 64 bit os intel(r) xeon(r) cpu e5320 @ 1.86 ghz (2 processors). thoughts atif yasin lamp/sqlserver engineer hi, is g drive local or network? have rx permission on drive? try copy installer local drive , try installation again. if not work, recommend another install media. i hope helps. janos there 10 type of people. understand binary , not. my blog SQL Server  > 

i building server respond custom sql batch messages. have constructed various tds messages , responses based on official ms-tds documentation. example, able construct table result based on https://msdn.microsoft.com/en-us/library/dd341261.aspx. these messages works fine on ssms , sqlcmd. however, when try use sqlcommand.executereader on c# client, error: system.invalidoperationexception occurred hresult=-2146233079 message=internal connection fatal error. error state: 15, token : 0 source=system.data stacktrace: @ system.data.sqlclient.tdsparser.tryrun(runbehavior runbehavior, sqlcommand cmdhandler, sqldatareader datastream, bulkcopysimpleresultset bulkcopyhandler, tdsparserstateobject stateobj, boolean& dataready) using tds proxy, ran simple select returning table single int value on proper sql server, bytes returned way longer 1 documented @ msdn: 04-01-00-3d-00-37-01-00-e3-03-00-12-00-00-81-01-00-00-00-00-00-00-00-09-00-26-04-07-41-00-67-00-65-00-6e-00-74-00-4e-00-

we running third party sql server 2000 system has sp4 build 2195. received 17883 error last weekend put database in suspect mode , on. after restart came fine , has not caused issue since. read things hotfix error , build sp4 addresses issue 2187 believe. since our build newer hotfix build next step in resolving issue? hello, can see error 17883 common on sql server 2000, fixes posted fixes sp4 only.    you can see microsoft have released fixes error , no workarounds. if consider sql server 2000 not supported anymore, , no more fixes released, recommend consider installing fixes , see if issue disappear first step. hope helps. regards, alberto morillo sqlcoffee.com SQL Server  >  SQL Server Tools

i have asp.net server using wcf web services want call silverlight 1.1 application. i can standard winforms application using httpwebrequest. can javascript using activex objects. life of me can't figure out how working in silverlight 1.1. 1 important part code needs dynamic, must able call adhoc service , method on server should choose. easy enough javascript or httpwebrequest. i don't want have write comms part of 1.1 project in javascipt :/ the "any server" bit going in trouble sl right now. sl has same limitations ajax - no cross domain calls allowed in current version. definition of constitutes domain strict, too. similarly, silverlight 1.1 alpha must use json endpoints. (support soap has been announced future versions.) i assume since make calls via javascript, doing - or activex controls using soap endpoints. what have tried date, , problems did run into? on dynamic bit, if services have arbitrary methods , paramters, you'll need

hello! write on c#, ado.net, dataset. have dataset , dataadapter filled it. in dataadapter override insert, update, delete commands. when use stored procedures, these commands, well. however, when use transactionns in stored procedures, exception: "concurrency violation: deletecommand affected 0 of expected 1 records." can please tell me do, , common solutions problem there? sample code , db  http://dl.dropbox.com/u/46828938/datagridsample.zip reproduce problem: delete row datagrid , press "update" button. dbconcurrencyexception ("concurrency violation: deletecommand affected 0 of expected 1 records.") reproduce on:"productdataadapter.update(dataset, "products");" string. ps: 1. sorry offtopic :) 2. example single-user: works on 1 machine / run 1 instance. best regards! hi , i think not silverlight issue. i've found 2 links might solve problem. http://social.msdn.microsoft.com/forums/en-my/adodotnetdatapro

my datagrid uses alternatingrowbackground. causes selected row color different depending on whether odd or row. find annoying. there way fix selected row colors regardless of whether odd or row? this same problem exists mouse hovers on rows. shows 1 color odd row , different color row. i'd fix also. thanks hi, you can try use blend modify rowstyle meet requirement. here sample modified. <usercontrol.resources> <style x:key="datagridrowstyle1" targettype="sdk:datagridrow"> <setter property="istabstop" value="false"/> <setter property="template"> <setter.value> <controltemplate targettype="sdk:datagridrow"> <sdk:datagridfrozengrid x:name="root"> <sdk:datagridfrozengrid.resources> <sto

hi everyone!! i've got database in sql 2008 populated data... these tables on network various companies uses these tables. created local tables (in visual studio itself) have copy information belonging company local tables... know how can send/copy information 1 database another? the local tables same database on network.... any appreciated!!! thank in advance!! kind regards rising storm technologies you have number of options can used separately or in combination. things consider: use ssis create package periodically move data. use sql server transactional replication keep tables on 2 servers synchronized or perhaps snapshot replication create original copy. use bcp copy out data text file, , use bcp copy data new server. use linked servers , execute select ... create copies of tables. rick byham, microsoft, sql server books online, implies no warranty SQL Server

all i have moved production db's. recovery mode = simple. xxxxx.mdf - 1.8gb xxxxx.ldf - 800mb when run full log file not reduce in size, normal? i have quite large db's still move , set correctly. ps, quite new have manage db's. thanks -graham all i have moved production db's. recovery mode = simple. xxxxx.mdf - 1.8gb xxxxx.ldf - 800mb when run full log file not reduce in size, normal? i have quite large db's still move , set correctly. hello graham, since database in simple recovery cannot take transaction log backup.point here in simple recovery log truncations happen after checkpoint , after when log file grows 70 % of size.800 mb of log file not big file since data file 1.8 g log seems little on me.but seems normal. full backup never truncates log transaction log backup does. please mark reply answer or vote helpful, appropriate, make useful other readers

i stumbled across entry in bol topic: behavior changes analysis services features in sql server 2008 "calculation precedence rules have changed previous versions of analysis services. because of above custom rollup, expressions may return different results previous versions of analysis services." http://msdn.microsoft.com/en-us/library/ms143682.aspx can explain means?  also, change between sql 2000 -> 2008 or sql 2005 -> 2008? thanks mike yes calculation precedence rule changed in ssas 2008 ssas2005 (which believe has same rule ssas 2000). to better understand rule change, please read  http://technet.microsoft.com/en-us/library/ms145539.aspx hope helps. chu -- posting provided "as is" no warranties, , confers no rights SQL Server  >  SQL Server Analysis Services

hello, i caching sqlcecommand objects in data layer. after executenonquery etc clear sqlcecommand.parameters collection , add new instances of sqlceparameter on next execution. does have impact on cached plans ? not observing performance improvement cache. my plans being rebuilt every few minutes when after sync. regards, kamil nowicki hi, i'm not sure if helps, idea of preparing sqlcecommands improve performance define parameter's name, data type , length each needed parameter in commandtext instruction, invoke prepare method, , each time need execute command, have assign value each parameter. clearing parameter collection won't let take advantage of keeping sqlcecommand in memory between calls. alberto silva microsoft mvp - device application development - http://msmvps.com/albertosilva moving2u - r&d manager - microsoft certified partner - mobility solutions - http://www.moving2u.pt SQL Se

i have tablix in rdl file, want add 1 column right of tablix same rows, different dataset.  how do this?  mean tablix returns records based on classroom data.  assume total abscenses per classroom. i know example might not make sense far why broke out separate table, merely simplified version of situation.  want student totals column appear right of tablix, if part of same tablix.  however, student totals comes *different* dataset! i tried making student totals separate tablix @ first, making first column invisible , including total column, didn't seem allow me this.  note student totals column should data jan-mar of 2008. classroom totals student totals school jan08 feb08 mar08 total total 3 6 4 13 5 b 3 1 2 6 2 c 4 5 8 17 7   ryan d ryan,   you can use 2

hi all, i have created ssis package extract xml data web page. client certificate (pfx file) used authenticate web site. located in folder on local machine. once development done, going move production server. this code in script task:    x509certificate2 certificate = new x509certificate2(@"\\myfilesharing\clientcertificate\my_user_2013.pfx", "mypassword");   when package moved production, can keep certificate file? should deploy production server(certificate store)? if so, guess above code (c#) not work.please advice me on issue. thanks shamen hi shamen, in experience web accessing ssis packages (from server environment) work. i not see problem keeping in file system answer question. thing servers typically protected , going run package local account based proxy can set has access directory. arthur my blog SQL Server

hi, new ssis. need import excel data sql table using asp.net, c# , ssis package. please provide real time examples.  in advance. ssis has excel source can use. why need c# / asp.net ? http://msdn.microsoft.com/en-us/library/ms141683.aspx please mark post answered if answers question | ssis blog: http://microsoft-ssis.blogspot.com | twitter SQL Server  >  SQL Server Integration Services

is there way share team foundation add-in "team" ribbon tab in excel 2007 custom build com add-in? basically, want create custom add-in host controls in tfs "team" tab. know can done on built-in office 2007 tabs, how com add-ins? thanks piko i don't believe there way extend "team" tab in excel 2007 adding custom ribbon groups & tool buttons.  that's suggestion though!  useful several scenarios. i believe post should moved "work item tracking" forum instead of power tools forum.  may generate better response :) ed blankenship, http://www.edsquared.com, microsoft mvp (team system) Archived Forums T-U  >  Team Foundation Server – Power Tools & Add-ons

instead of mentioning file path in flatfile connection possible give variable has file path value?????? you should change delayvalidation property of connection manager true well. talk me on SQL Server  >  SQL Server Integration Services

hi, i newbie , teaching myself basics. 1. i'm following example on net , have create sql service database. 2. add > add new item > sql server database (c#) 3. under server explorer data connection visible 4. when right click on tables > add new table i following error     "the method or operation not implemented"      "loading... design surface loading" what doing wrong ? i not understand why not succeed it. should server explorer , not create new object. should work.. working me * using vs 2013, sql 2014: tested , work charm :-) 1. use server explorer create new connection 2. on server explorer navigate table , select "create new table: 3. create table using windows opend 4. click "update database" in order create table if these images not understand doing, please clarify doing using screenshot, , try find issue :-)   ronen ariely  [ personal site ]    [ blog ]    [ face

hello, i'm kinda new on mdx , wondering if me came across with. have current month, next month, etc calculated automatically depending on today's date.   below can find mdx query have @ momment, can me issue?       with member [total qty backlog] as [measures].[sales order release our req qty] member [current month] as ([sales order release need date].[month attribute ].& [200803] , [measures].[sales order release our req qty]) member [next month] as ([sales order release need date].[month attribute].& [200804] , [measures].[sales order release our req qty]) member [month 2] as ([sales order release need date].[month attribute].& [200805] , [measures].[sales order release our req qty]) member [month 3] as ([sales order release need date].[month attribute].& [200806] , [measures].[sales order release our req qty]) member [month 4] as ([sales order release need date].[month attribute].& [200807] , [m

hi  we having sharepoint server 2010 , custom asp.net application deployed on it. past 2 days, application performing slowly. on investigation, server team told there processes blocking.  the problem here these sharepoint's internal procedures. issue occurs time , goes away automatically. have attached screenshot of processes blocking. any pointers how solve one?  from screenshot, looks cause of block id spid = -1 . not valid spid , looks process outside sql server. may or may not sharepoint process. you need @ processexplorer track down issue. can refer the  link  and you. SQL Server  >  SQL Server Data Access

the following message display  error bc30455 no se especificó un argumento para el parámetro 'comite' de 'public overridable overloads function insert(codigo integer?, modelo string, fecha1 date?, fecha2 date?, fecha3 date?, dias string, comite string, temas string) integer'. error bc30455 no se especificó un argumento para el parámetro 'temas' de 'public overridable overloads function insert(codigo integer?, modelo string, fecha1 date?, fecha2 date?, fecha3 date?, dias string, comite string, temas string) integer'. and im confuse becuase first time appear  hi blu3bleatle, from error message " an argument not specified 'commite' parameter of 'public overridable overloads function insert' (model string, date1 date ?, date2 date ?, date3 date ?, dias string, comite string , themes string) integer  ". seems query not correct. please share query if possible? by way, forum related ssrs, use t-sql query in

how do one backup/day trigger in sql server 2008, for example: want make trigger make backup every day @ 01:00 am. thx hi i solved whit task in windows. running line: sqlcmd.exe -q " declare @nome varchar(255); set @nome = 'd:\backup\banco de dados\bancodadosdptotal ' + replace(getdate(), ':', '-') + '.bak'; backup database [avaliacao] to  disk = @nome noformat, noinit,  name = n'avaliacao-full database backup', skip, norewind, nounload,  stats = 10;" thx SQL Server  >  SQL Server Security

i have time dimension , year, quarter, month, month number, time key,  we have data 2006 2011. years , quarters, month sorting showing correct 2006 2010, since 2011 have 2 quarters, when browsing  time dimension after cube build 2011 sort quarter2 instead of quarter1. 2011 quarter2 quarter1. any idea share resolve issue..   sid... you can have named column in dsv querterkey, of format year+quarterno i.e. 20111 or and use key sort order key in dimension attribute. vinu SQL Server  >  SQL Server Analysis Services

hi all i have date dimension (type time) attributes - [fiscalyear] (type years) - [fiscalmonth] (type months) - [fiscalweek] (type weeks) in addition attributes used in natural hierarchy, have attribute [pertype] containing 1 member comming relational table 'wtd' corresponds 'current date'. other members of attribute hierarchy calculated members (defined in mdx script). examples: --last year   create member currentcube .[date].[pertype].[ly] as null , visible = 1; scope ([date].[pertype].[ly]); scope ( descendants ([date].[fiscal].[all], [date].[fiscal].[year], self_and_after )); this = ([measures]. currentmember , [date].[pertype].[wtd], parallelperiod ([date].[fiscal].[year], 1)); end scope ; end scope ; --month date   create member currentcube .[date].[pertype].[mtd] as null , visible = 1; scope ([date].[pertype].[mtd]); scope ( descendants ([date].[fiscal].[all], [date].[fiscal].[week], self_and_after )); this = aggregate ( crossjoi

< toolkit : chart grid.column ="4" horizontalalignment ="stretch" verticalalignment ="stretch" x : name ="chart1" title ="chart title" legendtitle ="legend"> < toolkit : chart.series > < toolkit : columnseries x : name ="chartdata" itemssource ="{ binding }" title ="abc" dependentvaluebinding ="{ binding price }" independentvaluebinding ="{ binding year }"> </ toolkit : columnseries > </ toolkit : chart.series > </ toolkit : chart >   ------------------------------ observablecollection < chart1 > objchart = new observablecollection < chart1 >(); public mainpage() { objchart.add( new chart1 () { year= "2005" , price= "10" }); objchart.add( new chart1 () { year= "2006" , price= "20" }); o

we dropped a database , restore backup. one of our application returns above error. using 2 servers of sql 2000 sp4.  linkedserver query involved.   after issue command: dbcc freeproccache , problem has gone away. may coincidence problem fixed.  it possible cache has timeout , corrected itself.  possible command here fix it: dbcc freeproccache   my question: 1.what happened? 2.how make sure not happen again? 3.what fix?   SQL Server  >  SQL Server Tools

could solid understanding of automated build process in visual studio/tfs answer few questions me or give me advice?  application , servers taken on different department (along me, thank goodness that) , solution has been put tfs server.  took visual studio 2010 project visual studio 2012 consistent new team, , put code tfs 2010 server in new collection.  of went fine i’m worried getting build process running in new environment.  not have kind of build process in place.  i’m little confused , unsure how build process working.  no unit testing @ issue @ point. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ here’s pre-merger setup far build process concerned; ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ in visual studio 2010 have file called tfsbuild.proj in team build types folder contained lot of xml in defined build (the build machine, team project, build directory path, solution build, files copy, etc…).  created while ago.  believe usi