Lun

error message: (i changed names slightly) message executed user: ***. delete statement conflicted reference constraint "fk_child_table_detail_id". conflict occurred in database "abc", table "dbo.child_table_detail", column 'parent_table_master_id'. [sqlstate 23000] (error 547)  the statement has been terminated. [sqlstate 01000] (error 3621).  the step failed. so have 3rd party system process involves several procedures.  these procedures responsible "archiving" data several tables, , in specific sequence.  the detail tables archived first, main table.  not sure why getting error. its obvious the constraint is preventing delete on table in question.   however, child table giving error, not main table. i not want remove constraints, ive seen mentioned before elsewhere online. any suggestions? sorry, after looking bit further, there yet detail table had foreign key references child table.

hi everyone, i have 2 dimensions, product , store. product dimension hierarchy follows category->subcategory->product. have base measure called "[numberofactiveproducts]" (which gets me active products count).  my problem need create calculated measure should count no of subcategories under particular store @ same time should have active products. whenever try getting sum rather count. how achieve using mdx query? please me on this . thanks, latheesh latheesh exists ( [product].[subcategory].[subcategory]               , filter ( nonempty ( [product].[product].[product]                                              , [measures].[sales] )                          , [measures].[numberofactiveproducts] > 0                          )            ).count this using have mentioned or implied (sales measure) - , assuming have adequate attribute relationships within product dimension. however, not yet clear how active product defined within cube , h

i have field in database table contains xml string. not formatted. in report need display formatted xml xml, highlight option, tree view expand/collapse  option on each node. able achieve formatting below script public function formatxml(file_content string)as string  dim doc new system.xml.xmldocument()  doc.loadxml(file_content)  dim sb new system.text.stringbuilder()    dim settings new system.xml.xmlwritersettings()    settings.indent = true    settings.indentchars = "    "     ' includes 4 non-breaking spaces: alt+0160    settings.newlinechars = system.environment.newline    settings.newlinehandling = system.xml.newlinehandling.replace    settings.omitxmldeclaration = true    using writer system.xml.xmlwriter = system.xml.xmlwriter.create(sb, settings)      doc.save(writer)    end using    return sb.tostring()  end function but not working ie version.mainly trying  tree view expand/collapse  option on each node in report .  please me

sql 2005 sp2  looking @ locking report identify users locking resources long. see many users lock type "database" sleeping? if locking db, wouold dead in water since every db listed way @ least 1 user. object id "0". mean? thx, rick_806 hi rick, whenever there new connection made, there new database shared lock obtained.. and if application using connection pooling connection not closed, connection retained , same connection willl used for, other request same application. may reason seeing lots of slipping sessions. basically, slipping means sql waiting command. - chintak ( my blog ) SQL Server  >  SQL Server Database Engine

hi using tfs 2008 sp1. i've created new buildproject, fails create workitem. tf42097: work item not created due field error. following fields have incorrect values: field: 'found in' value: 'smarttools_20090908.2' it's default settings. if i delete build, , try again same buildnumber, works, the value in 'found in' now exist. we have condition states tha 'found in' must filled when creating bug. so me looks tries create bug, before has put buildnumber global list. how fix that? regards kim hi kim, where did set value of property buildnumber ? can set value in target buildnumberoverridetarget. best regards, ruiz please remember click “mark answer” on post helps you, , click “unmark answer” if marked post not answer question. can beneficial other community members reading thread. sincerely, ruiz yi Archived Forums V

hello, i'm starting analyze application queries tuning advisor , manager wants know if recommendations returned applicable across servers, instances, , databases of different sizes? meaning, if analyze query on development workstation against copy of our live database running on local sql instance, results returned equally applicable to the database running on our production server? likewise, results applicable different size dataset located on different sql instance @ 1 of our customer's locations? we're trying figure out if tuning advisor providing recommendations universally applicable, regardless of database , application running. i've done few tests against 2 different servers/instances, , index recommendations seem consistent, statistics being recommended close but not identical, though data identical across servers. any feedback helpful. thanks! bill hello, i'm starting analyze application queries tuning advisor , manager wants know if r

i looking through speechclient dll associated sample project , trying sense of can modify of parameters. literally don't see location or enum exposes of elements described such changing n-best returned, , getting exact confidence value. i did notice microphonerecognitionclient extends conversation base class, takes in 'preferences' parameter, isn't obvious me can wrap additional post request information object, or how pass preferences without creating new conversation base class. for speechrecognitionservicefactory.createmicrophoneclient object, there url parameter, after looking @ api - refers accoustic model endpoint. anyway, question makes sense. succinctly i'm looking @ can modify c# code adjust or modify request , of parameters. regards, michael Bing  >  S

i have tabular model created in visual studio , running in ssas.  model exist powerpivot model in excel 2013.  don't see way move models in direction, although there documentation moving model excel/powerpivot ssas. can done? thanks stan stan h hi stan, firstly, suggest refer following articles tabular model vs powerpivot model, please see: when choose tabular models on powerpivot models: http://blogs.msdn.com/b/cathyk/archive/2011/10/27/when-to-choose-tabular-models-over-powerpivot-models.aspx sql server 2012: tabular models vs powerpivot models: http://beyondrelational.com/modules/24/syndicated/499/posts/12670/sql-server-2012-tabular-models-vs-powerpivot-models.aspx we can convert powerpivot model 2012 ssas tabular model. i'm not test office 2013 workbooks. here article reference, please see: http://joshuafennessy.com/2012/04/01/converting-a-powerpivot-model-to-a-tabular-cube/ thanks, bin long bin long technet community support

hi, what difference between shrinking db of file. when select db shrink not shrink files in it. because when select files shrink not prompt me with a specific file. so confused why sql server 2k5 asks if need shrink db or file tnx shrink database shrinks files in database, shrink file shrinks 1 specific file in database. the way data files(.mdfs) , log files(.ldfs) shrink different, should read in books on line it. SQL Server  >  SQL Server Express

can lead me in direction can find in-detail documentation in how use tool? i cant seem able connect datazen running on server , posts on ssrs team blog doesn't help. i trying test migration of datazen azure sql server (the ssrs technical preview on azure) thank in advance. hi seongj, from description, seems know how use microsoft sql server migration assistant datazen tool, right? based on research, please refer following steps: 1.first, you’ll need connect datazen server. here, we’ll need enter instance id, hostname , encryption key (these same settings we’d entered in our datazen server service configuration file) 2.next, we’ll enter our information reporting services instance we’ll publishing content to. same information you’d enter when connecting report server using mobile report publisher . 3.select empty folder on report server you’ll want place content.          4. select content datazen server wish migrate , hit migrate button. content transferred ne

hi, i've got issue web service updates/changes in sl2b2  each time make changes webservice or clicl update webservice error: could not find default endpoint element references contract 'mtsl.dataaccessservice.dataaccessservicesoap' in servicemodel client configuration section. might because no configuration file found application, or because no endpoint element matching contract found in client element. when compare reference.vb fils before , after update see changes made (i guess has b2): added:         private onbeginopendelegate beginoperationdelegate                 private onendopendelegate endoperationdelegate                 private onopencompleteddelegate system.threading.sendorpostcallback                 private onbeginclosedelegate beginoperationdelegate                 private onendclosedelegate endoperationdelegate                 private onclosecompleteddelegate system.threading.sendorpostcallback                 publ

i have visual studio 2005 solution contains web project. i have tsfbuild project called 'fullbuild' builds solution configuration of 'release' , solution platform of 'mixed platform' as part of configuration the web project has the following settings: configuration : debug platform : .net build : checked when tfsbuild project runs web project gets compiled (aspnetcompiler called) correctly. i create new solution configuration called 'serveronly' include server components in build. configuration still includes web project settings same release configuration the new tfs build project called 'serverbuild' builds solution configuration of 'serveronly' , solution platform of 'mixed platform', web project not build. instead following messages in tfs build log. task "aspnetcompiler" skipped, due false condition; ((false) or ('$(aspnetconfiguration)' == 'debug') or ('$(aspnetconfiguration)'

hello, i'am working on project , need generate tables data in separate files in form of inserts can executes files in other dbs have same shemas. also, want edit insert queries can have : insert table_name ('val1','val2','val3') instead of : insert table_name ('column 1','column 2','column 3') values ('val1','val2','val3') all using smo. thank :). you'd better off using 3rd party product red gate sql data compare. can come close using smo, there isn't option script data , remove column list. here's a powershell script script create tables plus data: add-type -assemblyname "microsoft.sqlserver.connectioninfo, version=10.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91" add-type -assemblyname "microsoft.sqlserver.smo, version=10.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91" add-type -assemblyname "microsoft.sqlserver.smoextended, version

this has been answered before, but... i have local sql server 2005 instance running, , have user on network connect instance.  however, when tries connect, receives same error message: "an error has occured while establishing connection server.  when connecting sql server 2005, failure may caused fact under default settings sql server not allow remote connections. (provider: sql network interfaces, error 28: - server doesnt' support requested protocol)" so, checked properties server, , under connections tab allow remote connection box checked. any clue next? check using surface area configuration tool , make sure remote connections enabled. if enabled named pipes, example, tcp remote connections won't work. thanks laurentiu SQL Server  >  SQL Server Security

hello,   i'm trying retrieve relationships between tables of access database. this, i'm using getoledbschematable method of oledbconnection class. working fine, can information tables , columns. relations however, cannot find relationship (or join) type.   my database design contains left joins , inner joins, cannot programmatically find out which.   any ideas?   with kind regards,   maarten SQL Server  >  SQL Server Data Access

  when using copy database wizard and connecting destination server have error message been displayed.. i trying transfer  2000 databases to 2005 databases.   cdw error message   cannot connect server.please check server name , try again.       sureshv wrote:   backup database test_suicide to disk 'e:\backup\backup2000\test_suicide.bak'       you missed " =" symbol. command should be:   backup database <db name> disk = 'path , filename'   backup database syntax: http://msdn2.microsoft.com/en-us/library/ms186865.aspx SQL Server  >  SQL Server Setup & Upgrade

hi every 1 need write below exp in ssis condition how possible .in this  (pst_prd_strt_dt) numeric . i tryed using (dt_date)((dt_str,250,1252)pst_prd_end_dt) == calendar_dt ? fiscal_period_sid_tmp : -1 but giving error [ssis.pipeline] warning: output column "calendar_year" (32) on output "ole db source output" (11) , component "ole db source" (1) not subsequently used in data flow task. removing unused output column can increase data flow task performance. tried increasing length of out put column also  qus:if( todate(tochar(pst_prd_strt_dt), 'yyyymmdd') = calendar_dt, fiscal_period_sid_tmp,  -1) thx regards dinesh vv hi dinesh vv, suggest you adding error flow redirection redirect failed row processing path using error output, , can see why data flow task failed, more details how handle error in data flow, please refer following link: handling errors in data flow: http://msdn.microsoft.com/en-us/library/ms141679.aspx th

for table holds orders, have following columns: orderdate: date , time customer placed order shippingdate: date , time goods shipped difference: difference in days of above 2 columns   i have overview of day intervals in orders shipped. example, know how many orders shipped in following intervals: 0-2 days 3-5 days 6-10 days 10+ days   the number of days calculated in fact table, there specific way can handle categorization in dimension? the result this:   2008 2009 0-2 days 339 384 3-5 days 145 138 6-10 days 25 22 10+ days 4 2 thanks! last time impleted someting gaming company there ranges on dimension --> created dimension based on ranges customer wanted see --> add 1 more column fact table --> update new column correct interval range keys you might able produce in mdx on fly performn better when @ relation level , bring data cube. ashwani roy my blog please click mark answer button if post solves problem!

presently in cube grain set on order id. however , there multiple order line items under main order id. presently due grain of fact table amount each line item showing total amount related order amount . , looking solution @ cube level can amount split each order line item based on percentage allocation . last 2 columns show expected output , formula want use it. surya bose you want @ database design , etl stages, not in cube. you need column in line item contain percent @ each line item, , make sure add 100. etl use percent distribute value order header line item column line item amount. then, cube aggregate line item, nto grain. grain @ order header not work. thomas leblanc twitter ( @thesmilingdba ) SQL Server  >  SQL Server Analysis Services

dear all, need define process self service ssis , agent jobs process. have 10 applications , each of them have separate ssis developers create packages. each pkg has source ftp , api, connect source system, developers uses own lan credential. loading data sql server, developer uses sql server authentication destination connection, developer has write permission provided. part of self service server process, want create 10 windows service accounts, 1 each application run jobs sql server agent. ssis pkgs each application run separate service account sql agent. now permissions should given service accounts ssis pkgs runs agent without fail. self service server in case pkg fails service account detail can shared user trouble shooting. also, 1 service account should not able execute or modify other service account jobs. please suggest best practice here. thanks anky i recommend create proxy account , use run jobs. https://www.mssqltips.com/sqlserver

hi friends, i have column in excel source length around 1000. but when selecting .xls file source ssis component automatically setting the datatype of 1 of column 'cosmetic part' to unicode , length 255...which can check from "advance editor -> input , output properties tab" the original length of column  is around 1000 or more... how can avoid truncation of data ?? pls !! thanks bunch ! sweta open connection manager representing excel file , change length in there suitable length (i.e. increase 255)   -jamie http://jamiethomson.spaces.live.com/ | http://blogs.conchango.com/jamiethomson SQL Server  >  SQL Server Integration Services

hi all i'm degrading few databases sql server 2008r2 sql server 2008 have followed these below steps 1. import tables sql server 2008r2 sql 2008 2.generate script sp's , users, roles , views,functions finally new database created  on sql server 2008 here problem is  i need grant permission each , every user , role  manually , is there (script) possibility grant permission @ time users , roles old server  kamal hi, to transfer logins please refer below link http://support.microsoft.com/kb/918992/en-gb edit: guess need manually script out permission , provide http://sqlschoolhouse.wordpress.com/2010/04/13/script-logins-with-user-permissions-and-roles-in-sql-server-2005/ please mark reply answer or vote helpful, appropriate, make useful other readers my technet wiki articles SQL Server  > 

some of several sources of data i'm importing ssis 2008 have text in wrong fields, including country names in postcode field, data source had no county field hold them.  i've written 'transformation' script component uses regular expressions recognise , correct these, , write county name new output field called country.  country appear in country field of result should not there - e.g. usa against valid london address.  on short test runs, problem occurred real data (200k rows). wasted hours debugging code before realising there nothing wrong regular expressions: seemed happening output field in old buffer still set when buffer re-used - hence no problem until there enough data use lots of buffers! if record (about) 10,000 rows earlier had 'usa', , current row did not, old usa still there! i'd assumed new output fields empty, wrote country if these country name store.  fix set  row.country=nothing  rows there no country name. analysis correct: data flo

i've integrated nice contextmenu in surface application, window/grid doesn't seem responding windows 7 gesture right clicking , context menu works fine normal mouse right click , assume if can recognize windows 7 built-in gestures not case here. appreciate help  musaab hashim ok tehre confusion side. if building application surface sdk control control working under normal windows 7 touch pc, need create project starting standard wpf application not surface application. by building project surface 2.0 template main window call surfacewindow , usable on pixelsense unit or surface silmulator have describe. if build standard wpf window, main windows input called mainwindows , touch input use stndard windows 7 touch layer. remember touch have heigher priority mouse even. means if touch screen finger touch event raised , touch device recognized stylusinout , not finger in surface sdk. so solution creat project using standard wpf window , go regards your knowledge

i want install sql server 2008 express advanced services on clean (just reinstalled windows) xp pro system. have small home workgroup network. use dbms development/learning purposes. test access dbms pc on network. more interested in being easy use tight security, nothing of value ever in db, , person uses dbms. develop with visual studio 2008 (c# , asp.net), visual basic 6, , asp, , in cases want able access sql server db's i  create. don't need more used access.   in past have installed 2005 express version, , management studio, , in general accepted defaults - choice ever had make windows authentication vs mixed mode comfortable about. able needed.   this installer wants me choose couple of things don't understand: 1. default instance vs named instance? i want one ordinary sqlexpress, got default 2005 express. make difference whether choose 'named instance' name of sqlexpress, or 'default instance', the sqlexpress name seems assigned automatic

i report strange thing. in parent-children dimension, if set aggregatefunction=null, can not select fact value associate the leaf-member. whenever select, null back.   please simple test this:   prepare:  1. prepare fact table: create table [dbo].[minitest](  [tableid] [bigint] not null,  [agentkey] [bigint] not null,  [factvalue] [real] null,  [sexkey] [bigint] null,  constraint [pk_minitest] primary key clustered (  [tableid] asc )with (pad_index  = off, ignore_dup_key = off) on [primary] ) on [primary]   2.prepare 2 dimension table: dimension a: create table [dbo].[olapagentdim](  [olapkey] [bigint] not null,  [fatherkey] [bigint] null,  [maindemoname] [nvarchar](50) collate chinese_prc_ci_as null,  [sourcekey] [varchar](50) collate chinese_prc_ci_as null,  [starttime] [datetime] null,  [endtime] [datetime] null,  [edittime] [datetime] null,  constraint [pk_agentdim] primary key clustered (  [olapkey] asc )with (pad_index  = off, ignore_dup_key = off) on [primary

hi all, i need on count() function. need count based on 2 columns. let have data below customername   customertype a                          temporary a                          temporary a                          permanent b                          permanent b                          permanent i need result like customername   customertype      count a                          temporary          2 a                          temporary          2 a                          permanent          1 b                          permanent          2 b                          permanent          2 i need group both customername , customertype columns count. columns need group by from different dimensions. how can write mdx query achieve this. thanks in advance avenash.m.g hi, is value want not equal : [measures].[total charge] / numberofdaysselected also, first have 2 dimensions , in query there many more, 1 it? how come have 3 dimensions

hi sorry if dummy question, trying use new sql server ce 4 database in vs 2010 sp 1 project. installed vs2010 sp1 , tooling support sql server ce 4. can create database , io can connect db via server explorer. unfortunately when try access db entity framework designer ( try generate model db). entity framework designer not show sql ce framework 4.0 driver in list of supported connections.  is there missing?   thanks help.   there nothing missing, , have required software, edm wizard supports version 4 directly in web projects, noted in blog post: http://blogs.msdn.com/b/sqlservercompact/archive/2011/01/12/microsoft-sql-server-compact-4-0-is-available-for-download.aspx   you can use workarounds describe here: http://erikej.blogspot.com/2010/11/using-entity-framework-with-sql-server.html or generate edmx in web project , move class library / windows project. visit sql compact blog - http://erikej.blogspot.com - please mark answer, if it.

hello guys i try build connection informix (informix2000) database sql server 2012. i dont know how this... the plan build job in night in data beeing copied informixdb sql server 2012 the sql server should "archive server" (same data informix db , data should stay 2 years) any idea if possible ? (what im trying do) can odbc connection ? thanks a  lot , regards, dominic hello, i have not migrated data informix below links might helpful http://technet.microsoft.com/en-us/library/cc917718.aspx http://www.ispirer.com/products/informix-to-sql-server-migration http://stackoverflow.com/questions/4669852/informix-to-microsoft-sql-server-2008-schema-and-data-migration hope helps please mark reply answer or vote helpful, appropriate, make useful other readers SQL Server  > 

i new both asp.net , sql server. i have iis8 installed on windows 8 pc, sql server express 2012. given ignorance, have set using default values. i have small web site set in own folder , set in iis 8 virtual folder under default web site. have set simple database called 'stockcontrol' via ssms, contains 1 table called 'colours' has 2 columns. one page in website simple asp.net form runs on localhost without problems. on second page in website added gridview asp.net control, letting expression web 4 generate connection string , place in web.config file. tested sql query , connection went along , both came successful. far, good.however, when try run page in browser error message: server error in '/' application. cannot open user default database. login failed. login failed user 'iis apppool\defaultapppool'. description: an unhandled exception occurred during execution of current web request. please review stack trace more inform

hi, i facing big problem in tfs 2010, can me out if possible. scenario: 1. have 2 branches of code in tfs 2010 such enhancement , support 2. of developers work on enhancement support. 3. now, want create 2 different work spaces , map 1 local folder have our virtual directories mapped local folder , dll registered location. however, tfs not allow this!! alternative? also mapping 2 different local folders occupy more spaces on each individual developer's machine.  regards, chandan hello chandan, i sorry can’t map 2 workspaces on 1 local folder, or subfolder of 1 working folder. in tfs version control, system keeps track of version of file have @ given location on disk in workspace.   if same local path in 2 different workspaces, results confusing.   for scenario, consider structuring local folder structure following? d:\localworkspace\ d:\localworkspace\virtual directories& dlls d:\localworkspace\enhancement (map tfs server) d:\l

why new data base , visual studio connect . saying name in correct ,am new @ please help hi norma, if you've created database,  1) modify firewalls rules enable vs client connect ( step 3 ) 2) connection string database can found in portal.  click on "db" icon, database you're attempting connect to, click "dashboard" on ribbon on top of screen.  from here click "show connection strings" on right-hand corner of screen. 3) here getting started vs project that can use connection string information in 2) Microsoft Azure  >  Azure SQL Database

the task easy use (i.e. dba oriented) available in control flow pane.  same task exist in data flow (and if not, why not?)     tia,   barkingdog         there important difference between control flow , data flow.   in data flow, data, in form of recordsets, flows between transforms. the transforms operate on each of input recordsets , produce 1 or more output recordsets.   now, can imagine having transform sql statement. it sql statement operates on each row on input stream , moves output stream (like of built-in transforms) it sql statement join of 2 inputs recordsets. these scenarios not possible ssis 2005/2008   do have specific scenario or transformation in data flow trying achieve sql statement?   SQL Server  >  SQL Server Integration Services

hello, i working driver jdbc , have strange error can't find in google example. caused by: com.seeburger.smarti.util.smartiejbexception: nested exception is: com.seeburger.smarti.dao.daosysexception: java.sql.sqlexception: [microsoft][sqlserver 2000 driver jdbc][sqlserver]must declare variable ' @p2group '. i don't know variable '@p2group'. does know ? thanks thanks reply. the problem use driver in eai system (sap pi) , can't change code source of application need it. we find solution using opensource jdbc driver call jtds. SQL Server  >  SQL Server Data Access

hi all! plz me below questions. 1) need key definition           replication(app't definition)           builtin\administrator           database mirroring 2) , need use of sa 3) consider scenario delete builtin\administrator , disable sa, how login in sql server. 4) diff between log shipping , replication , database mirroring? regards rm thirunavukkarasu answer 3: http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx most of other answers can found sql bol. didn't want q1. elaborate further? this posting provided "as is" no warranties, , confers no rights. my blog : troubleshooting sql SQL Server  >  SQL Server Database Engine

hi all, i've installed fresh copy of ssrs 2008 first time (sql server 2008 express sp2). straight install. no changes. , of course, doesn't work! able report manager page, after removing rswindowsnegotiate , rswindowsntlm rsreportserver.config file , changing rswindowsbasic. don't know why worked, did. but can't authenticate web service. keep getting 401 errors, , nothing seems work. @ wits end here. here have tried: fyi, using windows xp sp2, , vs 2008. 1) changed rsreportserver.config file uses "rswindowsbasic". 2) have opened computer management tool, , in 6 sql server groups, have added "administrators", "nt authority\system", "aspnet", , "nt authority\network service". 3) execution account in ssrs config "[machine]\localsystem". 4) report server service account "local system". 5) on "services" dialog, rs running "local system". 6) rs code is: rs.credentials

hi all, we have production sql server 2005 64bit standard edition sp3. moved database virtual machine, after facing lot of problems sql queries timing out has brought down performance. sql server runs 100% cpu usage. while trying debug problem came across procedure 'sp_cursoropen' in sql server profiler.    declare @p1 int set @p1=180150021 declare @p3 int set @p3=1 declare @p4 int set @p4=16388 declare @p5 int set @p5=287164 exec sp_cursoropen @p1 output,n'select * statusmessages',@p3 output,@p4 output,@p5 output select @p1, @p3, @p4, @p5 the procedure executing select query on table 'statusmessages'. profiler says query being executed 'operating system'? when ran standard report 'performance - top queries total cpu time & average cpu time' results show query taking maximum cpu select query on statusmessages table 'select * statusmessages'. i'm not sure why query being executed? use ado connect dat

hi, i have .net project. have resx files. i need write method generates satellite assembly (targeting silverlight). can me on this? thanks in advance help..       the question how use satellite assemblies silverlight, means how localize silverlight applications:   the .net framework silverlight uses hub-and-spoke model package , deploy resources. hub main assembly contains nonlocalizable executable code , resources single culture, called neutral or default culture. default culture fallback culture application. represents region-neutral language such "en" if default language english or "fr" if default language french. spokes connect satellite assemblies, , each satellite assembly contains resources single supported culture, not contain code. @ run time, resource loaded appropriate resource file, depending on value of application's current user interface (ui) culture, defined cultureinfo.currentuiculture property.   the primary

hi, i want know sqlserver tracelog can 1 give me details or reference read it. searched 1 complete day believe didn't search @ right place. sql server default trace enablement sql server default trace how use sql default trace security auditing sql trace -vaibhav chaudhari SQL Server  >  Getting started with SQL Server

apologies if don't state teh question or overlooking obvious answers - started working ssas , barely beginner level. i'm working on cube show student enrollments in different subject areas on time - purpose i'm concerned academic years , semesters.  in underlying dimension table have data like key acad year     term          descr 1 2006          summer  summer 2006 2 2006          fall  fall 2006 3 2006          spring  spring 2007 (note spring 2007 part of 2006 academic year) 4 2007          summer  summer 2007 5 2007          fall  fall 2007 6 2007          spring  spring 2008 , on i've set simple hierarchy 2 levels - acad year->descr for cube have 1 measure: 'enrollments' shows sum of students have enrolled what i'd able show following change on time:  - year year % (2005 2006)  - term term % (fall 2006 spring 2007)  - term same term % (fall 2006 fall 2007) preferably if possible i'd have set such percent change sho

hello, i've seem examples on setting sqlfacetattribute on return values of sqlfunctions in c#. can not make work in vb.net. compiler always notes attribute can not used on declaration type. vb.net 2005 lack feature? you put between keyword "as" , data type, this: _ <microsoft.sqlserver.server.sqlfunction()> _ public shared function function1() <sqlfacet(precision:=5,scale:=2)> decimal return 123.45d end function cheers, bob beauchemin sqlskills SQL Server  >  .NET Framework inside SQL Server

hi, trying generate reports in c# project via reportviewer control not able open wizard. nothing happen when press design new report? doing wrong? i use sql server 2005 express advance  , visual studio 2013 express. i able generate rapport business intelligence visual studio 2005 it's seems report viewer control in vs 2013 not supported ssrs 2005. see: https://www.microsoft.com/en-us/download/details.aspx?id=35747 to create .rdlc report, refer this: https://msdn.microsoft.com/en-us/library/ms252067.aspx work hard, play harder! SQL Server  >  SQL Server Reporting Services, Power View

hi, i getting following error during tfs build creation:   publickeytoken=5c838b77b53f84a0' or 1 of dependencies. attempt made load program incorrect format.   appreciated help!   thanks, pora looks resolved in different thread. can confirm.   this http://social.msdn.microsoft.com/forums/en-us/netfx64bit/thread/d1350911-f554-4299-8244-d54139d18b60   resolved this   http://social.msdn.microsoft.com/forums/en-us/tfsadmin/thread/a66beb9e-df59-4c5c-b202-9bafadce4012 bill boyce Archived Forums V  >  Team Foundation Server - Setup and Administration

hi mates,   code snippet with   member [measures].x avg([measures].[item value])   member measures.parentid           as  [department].departments].currentmember.parent.name  member measures.childrenid as          generate(descendants([department].[departments].currentmember),          [department].[departments].currentmember.name, " - ")   member measures.childrenname as          generate(descendants([department].[department].currentmember),          [department].[department].currentmember.name, " - ")   select         crossjoin([time].year.&[2006],  [time].[datehier].[month].members,        descendants([department].[2],        [department].[departments].currentmember, self_and_before)) on rows ,      {(measures.parentid), (measures.childrenid),  (measures.childrenname),       [measures].x} on columns     from olapdev where ([item].[78])     this mdx query returns following result  year  month  department  department parentid  

hello,  i have following scenario: i want upload files webserver via sl app. i'm using simple httphandler endpoint upload (not sure if best way easiest). once file uploaded want trigger web service method within sl app , provide method path of uploaded file on server. don't know how can kind of notification when upload finished (meaning file has been written harddisk on server) know when start web service method perform tasks on file. if there exists solution nicer when solution lets me pass kind of parameter on notification, can pass actual filepath on server sl app. thanks alot in advance!  hi, you can write wcfservice store uplodaed file(may byte array sending). as far notifying silverlight application concerned can specify return type  of wcf service qwhich notify yiour silverlight client asynchronously(silverlight's default behaviot). in return type can specify file name,location , other stuff...  

does sql server support 'true' active/active clustering? i believe sql server supports failover clustering 1 node active @ point of time , next node takes work post failover happens automatically/manually triggered. i got confused today when referred active/active clustering sql server what i understand active/active nodes part of cluster active , accessing same set of database files...like have in oracle rac. no, sql server not support load balanced clustering in oracle rac or vms clustering.  failover clustering only... some people use term active/active indicate have instance of sql server running on both nodes.  is, 2 separate sql server instances separate storage , databases.  term multi-instance cluster because each instance running on either node @ given time.  active/passive (both active on node 1, node 2 idle), active/active (one instance active on each node) or passive/active (both active on node 2, node 1 idle). the problem terminology isn't cle

hello, our tfs warehouse cube has not been updated long time , affects of course our reports. when in event log @ tfs server can see many errors 'tfs warehouse' , 'mssqlserverolapservice'. list event details below , hopefulle here can me it. way - using latest version of tfs single server installation. thanks thomas ------------------------------------------------------------------------------ event type: error event source: tfs warehouse event category: none event id: 3000 date:  2006-08-15 time:  12:11:13 user:  n/a computer: cmmpltapp description: tf53010: unexpected condition has occurred in team foundation component. information contained here should made available site administrative staff. technical information (for administrative staff): date (utc): 2006-08-15 10:11:13 machine: cmmpltapp application domain: /lm/w3svc/3/root/warehouse-1-128000922376692872 assembly: microsoft.teamfoundation.warehouse, version=8.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d5

i using technet tutorial:  how to: loop through excel files , tables using foreach loop container it seems work great, except each file loop isn't picking actual file name of excel file , passing variable. i have each file enumerator, points folder: "c:\current data processing" , files: "*.xls" retrieve qualified name. in variable mappings created variable of type string scope name of ssis package , index in variable mappings 0. (can explain index way, don't understand that.  variable mappings provide range of columns/indexs place stuff in?  how view see options are?  that's less pressing question) now package runs fine, because points hard coded value entered variable.  if remove package fails run. i don't understand why foreach loop container isn't putting name of excel file in c:\current data processing folder variable"excelfile"? thanks! hi, as nitesh suggested put script task , put : msgbox(dts.variables("excelfile").v