Lun

the mysql holds information concerning item tables acct tables , go_objects world of warcraft private servers )or else suppose( when try run mysql server intance configuration wizard says side-by-side configuration failed please see event log more info....is there fix this this forum dedicated sql server issues. you may have better luck posting mysql forum. SQL Server  >  SQL Server Database Engine

hi, i have requirement set attribute members dynamically @ run time. i describing requirement below - i have date dimension, specifies business date. i have instrument dimension, has attribute called maturity date. now, requirement bucket maturity date based on business date. for example, if business date < maturity date bucket = "expired" if buisness date = maturity date bucket = "active" if datediff(maturitydate,businesdate) = 1w bucket = "1w" , on... i tried following - added dummy attribute instrument dimension called tenorbucket. in dsv, return space. then, using scope statement, tried determine value follows - scope ([date].[date]); scope ([instrument].[maturity date]); scope ([instrument].[tenor bucket]);   this = iif (datediff( "d" ,[instrument].[maturity date]. currentmember , [date].[date]. currentmember ) < 0 , "expired" , iif (datediff( "d" ...

i have created calculation called prior year price actual or ([py avg price : act]). now have been given requirement create calculation, prior year price actual or ([py avg price : act]) period.   how can adjust query complete task. new calculation named prior year period. hi d henson, according description, want create calculated measure price actual corresponding period. right? in scenario, since have average measure prior year, need same aggregation on period level(i assume using quarter). can modify expression like: aggregate( ancestor( parallelperiod([date].[calendar].[calendar year],1, [date].[calendar].currentmember), [date].[calendar].[calendar quarter]), [measures].[avg price actual] ) reference: ancestor (mdx) regards, simon hou technet community support SQL Server  >  ...

i have query reports of data want.  creates 40 columns , 10 rows.  swap display shows 10 columns , 40 rows, cause print out more readable.  can done? hi, in sql server 2000 have use appropiate case expressions, in sql server 2005 can use new pivot functionality- refer below links, http://social.msdn.microsoft.com/forums/sqlserver/en-us/86e4935c-d9cc-4b5c-94a4-e00469429850/how-to-pivot-tables-in-sql-2000 http://social.msdn.microsoft.com/forums/sqlserver/en-us/831611f4-f05f-4467-8afe-865b0048b9ae/pivot-table-in-sql-server-2000-results-page hth, jens k. suessmeyer. --- http://www.sqlserver2005.de --- SQL Server  >  Getting started with SQL Server

there bug in silverlight occurs when out-of-browser (oob) app that has borderless chrome    maximizes the window on a  second monitor .  window either doesn't display @ all or small part of displays.  i developed workaround.  seems work ok laptop , second monitor, haven't tested anywhere else.  caveats : it may not work if primary window attached monitor.  further tweaking address that. it gets information windows, don't know if work computers aren't running windows, such apple. void minimizebutton_click(object sender, routedeventargs e) { // silverlight bug: // supposed work setting windowstate.minimized. // if has borderless chrome, doesn't display when restored tray. // work-around: // set windowstate.normal, , set window reduced monitor dimensions before minimizing. // restore tray using these dime...

hello -    i've developed asp.net  2.0 web application i've recently upgraded from using a sql2000 database sql 2005 express database.    my series of questions relate cache invalidation, i.e. generating notifications delete pages from asp.net cache when database tables change.    1)   does the sql server 2005 express version support the same direct notification technique used in standard sql server 2005 version?   2)  if not, should sql2000 cache dependency polling scheme (using stored procedures) continue work sql server 2005 express database?  (it appears not working after i attached previous sql2000 database.)   3)  if neither possible, changes necessary or how implement cache invalidation sql 2005 express edition?   thanks help,   bill  SQL Server  >  SQL Ser...

hi, i working on problem in odbc application, have isolated ms sql server query analyzer. the problem related deadlock faced 1 of session, when 2 transactions each running 2 sessions trying insert record respective session duplicate values columns icol1 , ccol2 , 1 of session update value of column icol1 in inserted record. after completion of test, see 1 record created in table 1 of session, other session becomes deadlock victim. following table structure: create table [sgarg].[test_buf]( [icol1] [int] null default ((0)), [ccol2] [varchar](30) null, [ccol3] [varchar](30) null, [recid] [bigint] null ) on [primary] following index definitions create unique nonclustered index [test_buf##ixprim] on [sgarg].[test_buf] (  [icol1] asc,  [ccol2] asc )with (pad_index  = off, statistics_norecompute  = off, sort_in_tempdb = off, ignore_dup_key = off, drop_existing = off, online = off, allow_row_locks  = on, allow_page_locks  = on) on...

hi, is there way can set owner of database when it's getting created ssdt? i had in database settings etc coulnd't find obvious. thanks leyton take @ deployment contributors.  can write contributor that'll inject script deployment plan. http://blogs.msdn.com/b/ssdt/archive/2013/06/24/announcing-sql-server-data-tools-june-2013.aspx SQL Server  >  SQL Server Data Tools

hi, we started use fts service on cloud. managed upload code , check-in , out code files.  1 of project have, have reporting services local files (*.rdlc), custom code in assembly referenced rdlc files.  in order build project, custom assembly should placed in vs privateassemblies folder or gac of build machine. on local machine project built successfully. since build done in cloud, on server have no access to, can not copy custom assembly build agent, , therefore build fails error of  :   "error while loading code module: ‘reportscustomcode, version=1.1.0.0, culture=neutral, publickeytoken=efd143059b5dbe27’. details: not load file or assembly 'reportscustomcode, version=1.1.0.0, culture=neutral, publickeytoken=efd143059b5dbe27' or 1 of dependencies. system cannot find file specified."  is there way build the project on cloud, or have use tfs on local  server? thanks in advance hi, based on below link, have install on-premise...

i installed sql server 2005 couple of times before on pc , worked ok time when need fast receiving error during install:         sql server setup failed execute command server configuration. error [microsoft][sql native ciient][sql server]cannot add functional unit 'sp_sqlagent_get_startup_info' component 'agent xps'. unit has been registered component.. refer server error logs , setup logs detailed error information.   i trying install on new copy of windows vista home, can me suggestions? (where can find “server error logs , setup logs detailed error information” ?) seems previous version of sql server installed not uninstalled properly, do complete cleanup of previous installation starting folders registries , try to  install. SQL Server  >  SQL Server Setup & Upgrad...

hi experts , working on ssis 2008. have excel file source . scenario: first 5 rows contain headings dont need actual header starts 6th row , data . how should used excel source take 6th row header , data . note :: receive file every month . name of file same every month number , name of coumns fix number of records not fix  every month i tried using openrowset in excel sourcei.e revenue$a6:d6 a6 =my first column header d6= last coulmn header package executed but  no data loaded in destination sql table ?? hi rihan try openrowset in excel sourcei.e revenue$a6:d don't mention value after d regards j r bhimireddy SQL Server  >  SQL Server Integration Services

hi all, i have report in these report want hide on rectangle if rectangle hide take space between them. for ex.   i have  rect a rect b rect c and want hide rect b  but showing me this  rect a   rect c   i want  rect a rect c i using ssrs 2008   please me, thanks alot hi,   to hide middle rectangle , take no space, 1 workaround place these rectangles in separate table rows , hide row in middle. please refer steps below: 1.     add table in report. 2.     right click handle of detail row, select delete rows . click ok in popup dialog. 3.     right click handle of header row, select insert row -> above . repeat operation add third row. 4.     place each rectangle in first cell of these rows. 5.     select table , click triangle arrow in top-right corner of column groups pane. select advanced mode . 6. ...

here goes: upload excel spreadsheet powerpivot table sharepoint 2010.  spreadsheet displays fine until try set filter.  have read every thread find on issue , far none of them seem work.  stunningly difficult problem wouldn't surprised if has wasted million or more man-hours point.  @ least microsoft should publish decent checklist.  anyway based upon have read have identified following trouble spots far.  feel free add them.  have standalone windows 2008r2/sharepoint 2010/sql server 2012/office 2013 system. starters excel powerpivot app works fine on server outside of sharepoint. created account (call fred)     1. domain account         1a. read permission on active directory     2. local admin on server     2a. user rights assigned         2a1. act part of operating system         2a2. adjust mem...

hopefully, has figured out:   i've implemented , tested cell level security on cube. it's testing level conditions, , returns #n/a (as normal) when user not supposed see cell value. since use .formattedvalue in reports, works fine in report services (and excel , proclarity, etc.)   here's problem:   when rs parameters encounter situation, parameter dataset "breaks" (the following system error occurred: type mismatch.) happening, because parameter fields (parametervalue, parametercaption, parameterlevel) being replaced #n/a, due cell level security. happening, because these defined members, , hence passing through cell level security.   what need find way have these specific members bypass cell level security, parameter datasets still work. (failing that, new way of specifying parameters in msrs.)   i've tried following a cell level security rule, doesn't seem work: [measures].currentmember [measures].[parametervalue] or [measures].c...

  using server management tool/database/tasks/import data wizaard able connect sql 2005 database sql2000 database on private lan.  moves tables , data fine.  drops keys in process.  not acceptable   server management tool/database/tasks/copy database command supposed copy database info.  better solution.  however, when enter exact same connection information used /import data wizard, connection fails.   why same connection information work /import data wizard fails for  /copy database wizard?     ferret, what connection error receiving while using copy database wizard?? you can try database publising wizard copy tables along datas! SQL Server  >  SQL Server Tools

  working ssrs support team @ ms have discovered problem using windows server 2008 64-bit version , sql 2005 32-bit version reporting services. 1 of ideas tossed out using 64-bit sql concern our application setup use sql v8.0 not 9.0 backwards compatability sql2000 clients concerns have if jump onto 64-bit band wagon?   will have issues stored procs, views, tables? looking direction , advice here.   thanks! it has been experience, exception of oracle client , integration services, there no difference in moving x86 x64.  never had problems anything, in fact give x64 migration raving reviews. SQL Server  >  SQL Server Database Engine

hi, i have custom field in work item string type, want apply rule id entered in unique, mean if enter value 123 in field , when create work item of same type , if enter 123, should not allowed or message prompted "this value exists, enter different value. how can achieve it. regards asif sharif president edev technologies hi modern requirements edev tech, thank posting here. there no such rule achieve in tfs now. try create own server side plugin detect if specify duplicate values work item field, after send email alert users or clear value of work item filed directly. see link more info on creating isubscriber plug-in: http://nakedalm.com/team-foundation-server-2010-event-handling-with-subscribers/ or submit user voice following link, tfs product team listening voice there: https://visualstudio.uservoice.com/forums/330519-team-services best regards limitxiao gao msdn community support please remember click "mark answer" respon...

is possible remove single schema schema collection? as far know can delete collection or add schema. //creating schema collection create xml schema collection templatecollection as n'<xs chema>...</xs chema>' //adding schema alter xml schema collection templatecollection add n'<xs chema>...</xs chema>' //deleting schema collection if exists (select * sys.xml_schema_collections c, sys.schemas s c.schema_id = s.schema_id , (quotename(s.name) + '.' + quotename(c.name)) = n'[dbo].[catalogcollection]') drop xml schema collection [dbo].[templatecollection ] i haven't found solution. help!!! danke, anna anna,   in sql server 2005, not support deletion schema evolution option. please send feedback https://connect.microsoft.com/sqlserver . workaround, can create new schema contains namespaces need , execute alter table ... alter column ddls on xml columns , change type new schema collection.   regards, galex yen ...

can remote connection sql sever 2005 developer editio? yes. have enable remoteconnections first: http://www.sqlserver2005.de/sharedfiles/remoteconnection.jpg   hth, jens suessmeyer. --- http://www.sqlserver2005.de --- SQL Server  >  SQL Server Setup & Upgrade

all,         we have merge replication running on sql server 2008...we have retention period set 14 days..but the  conflict_<publicationname>_<articlename> table data not deleted regularly. see conflicts data past 6 months..merge replicaion not cleaning conflicts table....   any suggestions...tia the metadata cleanup in merge replication doesn't cleanup conflict tracking tables.  need periodically review conflicts in conflict viewer reduce size of conflict tracking tables.  if have lot of conflicts, can write purge script. repltalk has article on clearing resolved merge replication conflicts . sqlrepl.com SQL Server  >  SQL Server Replication ...

i've encountered bizarre situation cannot resolve. i have project (let's call libraryproject) want reference project (applicationproject).  built libraryproject , added reference created .dll within applicationproject; appeared work intellisense worked correctly.  however, @ point built applicationproject, build failed missing reference problem relating libraryproject.  intellisense no longer picking libraryproject, , libraryproject no longer visible within object browser. as work-around, tried pulling libraryproject solution containing applicationproject, i'm getting same problem, exception - after failed build - libraryproject still visible in object browser, intellisense still doesn't work after failed build attempt. does know i've gone wrong?  libraryproject works fine , referenced in other projects i'm using no problems. thanks hi, with exception - after failed build - but can't reproduce issue. show err...

hi, have "inherited" custom built ssas solution i've identified peculiar behaviour. assuming following query: measure amount on dimensions costcenter , company filters set on company , costcenter. when company dimension present expected values; cost center 130 present in company , 1000 cost center in company b. when remove company dimension (but still keep same filters) output changes following. i can't see obvious reason why amount cost centre 130 null cost centre 1000 has proper amount. if change filter all, or select 1 of companies, amounts correct. any ideas start looking? regards, johan thanks simon , richard comments. measure setup sum (and a sql query verified fact table returned correct results chosen dimension), when adding simple measure returing 1 (i.e. measure without relations other dimensions) got expected result, therefore pointing us towards dimension setup. turns out thought default member setting company b on company dimens...

hi, i facing issue while trying open editor custom control flow component.  i tried copied dll package resides didn't help.  please let me know if doing wrong or how fix issue. here code: main class inherits task                           namespace ssis.custom.controlflowui {         [dtstask  (        displayname = "copytable",        description = "a custom unzip task demonstration purposes.",        tasktype = "customcomponent",        uitypename = "copytabletaskui, copytable, version=1.0.0.0,culture=neutral, publickeytoken=9097a336d1055e0b")]     public class copytable : task     {          #region override methods             public override dtsexecresul...

  some appreciated. stuck 2 days now. ( got dim view of vista @ point...) running windows vista business, sp1 on dell optiplex 740 (amd tripple core 2.3) 4gb ram.   trying install sql server 2005, developer x86 edition.   on start of install following warniing " this program has known compatibility issues ". recommends online, did , found nothing useful. further says " after sql server setup completes, must apply sql server 2005 service pack 2 (sp2) or later service pack before run sql server 2005 on version of windows "    so assumed install, , service pack , good.  except cannot through install. it goes through prerequisties fine system config check - no problems under components install select sql server database services (i've tried selecting everything...and db engine - same results) i've tried default , named instances i've tried domain accounts ( in local admin group), local system account, network service ac...

when run query below 2 records back. if drop topcount, 508 records. why not giving me top 5 508 records? missing? regs jon with member measures.[emailcount] iif(isempty([measures].[tran count]), 0 ,[measures].[tran count]) member measures.[incomeperemail] [measures].[amount]/ iif(measures.[emailcount] = 0, 1 , measures.[emailcount] ) member measures.[income range] case when sum(existing [dim ifa details].[parent key].[adviser group].members, measures.[amount] ) <= 10000 '0-10000' when sum(existing [dim ifa details].[parent key].[adviser group].members, measures.[amount] ) <= 50000 '10001-50000' when sum(existing [dim ifa details].[parent key].[adviser group].members, measures.[amount] ) <= 100000 '50001-100000' when sum(existing [dim ifa details].[parent key].[adviser group].members, measures.[amount] ) <= 200000 '100001-...