Lun

i feel i'm close on 1 can't quite it. i want have empty stack panel, user selects items control add representation of item stack panel - item added compostie of say, check box, a label , image. i need able dynamically add , remove the items stack panel , don't mind (actually rater) solutuion code driven rather buch of complicated classes. i've used datatemplates have custom items in data grid, , seem recall itemtemplate brain fried @ point... ;) create custom object contains data want display in datatemplate. ex.  object something, has imageuri, title , boolean of sort. when add items, store these in collection of custom type in viewmodel bound ui element.  in datatemplate bind each property value desired ui element.  update collection on view model, changes propogate ui , vice versa long binding set 2 way binding. here's example using listbox itemtemplate , building custom stack panels want.  datasource custom collection , see binding each pro

i new srss, bear me if stupid question. we have web application written in silverlight points urls on report server. trying lock down database access single domain account security purposes. created data source use "credentials stored securely in report server" , specified domain account "<domain>\user1". created login in sql owner role database. rdls created reports and uploaded report server. each report pointed to the "shared data source". since using domain authentication, check marked "use windows credentials..." , tried checked , unchecked "impersonate authenticated..." no luck. i guess expected request link website report server initiate report report server run using "shared data source" using "stored" credentials. example if domain user george logged pc , lauches report website, website invokes report service url. report server query database using "stored" credential (user1) data

i'm working on project put data sent in on xml files database computer i'm working on bit dated , i’m trying make things little more efficient.   in order unselected columns in outputs not used in each data flow task.   after weekend however, ssis no longer validate correctly unless @ least 1 column each output selected error :   title: package validation error ------------------------------   package validation error   ------------------------------ additional information:   error @ (data flow task name) [dts.pipeline]: "output "(output name)" (19)" contains no output columns. asynchronous output must contain output columns.   error @ (data flow task name) [dts.pipeline]: layout failed validation.   error @ (data flow task name): there errors during task validation.     (microsoft.datatransformationservices.vsintegration)   ------------------------------ buttons:   ok ------------------------------   is ther

hi  all, we getting below alerts these days. can suggest issue , root cause, , how resolve it. checked in error log there no information @ time. service: mssql query - check master db deadlocks host: xyz address: 1234 state: critical info: critical: query expected 0 got 1. date/time: 10/10/2014 15:57:25 thanks in advance... hi latheesh, reply, server sqlserver2000 . think dmv's not working in in version.  think error came because of deadlocks . right? if on sql 2000, there no way can find out deadlock happened in past, if had no tracing set up. use enterprise manger add these startup parameters: -t 3605 -t 1204 restart sql server. own, deadlocks logged in sql server error log. then again, whether cryptic thing had in first post has deadlocks far clear. there nothing query deadlocks on sql 2000. did alert? third-party tool? erland sommarskog, sql server mvp, esquel@sommarskog.se

  hi,   i'm tearing hair (what's left of it!) out trying achieve in ssas 2005, , wonder if can before go mad! basic scenario i'm trying model is thus:   funds , made of number of: investments , made of number of: allocations , represent unit holdings.   now there may many allocations per investment, , each of these allocations (hence unit holdings) may change @ various points in time. fact table i'm using has entries representing current unit holding @ given date. example of fact table i'm using:   date            fund id  investmentid   allocationid   unitholding 2008-08-01        1                1                     1                     10 2008-08-03        1                1                     1                     20 (representing 10 unit holding increase) 2008-08-07        1                1                     1                     15 (representing 5 unit holding decrease) 2008-08-01        1                1                 

hi team, for azure website high availability, have option deploy on multiple datacentre across globe. different region based website & use traffic manager provide unique url. but sql azure? how achieve same? have fault tolerance or failover scenario or backup high availability? 1) need deploy sql azure in multiple region data centre , use traffic manager create unique link? if yes, 2) updates on database (may schema or data change scripts) need update of there? 3) geo-replication? need create geo-replication of regional's sql azure instances? regards, brijesh shah hi brijesh, at present, failover decision delegated application because may cause 5 sec of data loss (due asynchronous replication involved). assumes application monitors own connectivity status data tier , uses guide failover call.  in case of major incident in region see alert in portal take operations team time identify impact of outage, won't immediate. let me ask this.  if (azure) p

i upgraded sql server 2005 standard sql server 2008 r2 enterprise. after install done said "mssqldbdefaultuser" created time ago didn't exit. looking @ active directory user exist , active. <o:p></o:p> so let install finish , noticed of services not started went in , restarted them. of them restarted except sql server agent service. came saying couldn't start. error 2: system cannot find file specified.<o:p></o:p> hello, please share content of following files us: c:\program files\microsoft sql server\mssql10_50.mssqlserver\mssql\log\sqlagent.out c:\program files\microsoft sql server\mssql10_50.mssqlserver\mssql\log\errorlog please read following article also: http://blogs.msdn.com/b/sqlserverfaq/archive/2009/06/12/unable-to-start-sql-server-agent.aspx hope helps. regards, alberto morillo sqlcoffee.com SQL Server

hi, i have etl package have ~10 data flows each within loop container.  each container loops 20 times running data flow subset of data based on customer id.  data flows pretty run of mill source shape detination shape left join avoid inserting duplicate rows.  they run fine when run each loop container sequentially, when run them in parallel speed package, strange error dataflows.  description: "either bof or eof true, or current record has been deleted. requested operation requires current record.". i understand in essence means, not sure why happen in ssis package. any great. what purpose of having loop? to speed processing running in parallel ought create several dfts not connected rather. regarding error, @ these odd times when occurs typically remedied applying retainsameconnection set true: arthur my blog SQL Server  > 

we using transactional replication sql server 2008 r2 publisher sql server 2008 r2 subscribers. publisher , distributor on same server.  not using updateable subscribptions the queue reader agent appears have been created , running there error "the replication agent has not logged progress message in 10 minutes.  ..."  stopped agent , deleted queue reader agent job running since not used publisher still shows error in replicatio monitor.  there else have clean queue reader agent stop showing error. since updateable subscriptions not used don't needs agent run? can try delete contents of msqreader_agents msqreader_history in distribution database? looking book on sql server 2008 administration? http://www.amazon.com/microsoft-server-2008-management-administration/dp/067233044x looking book on sql server 2008 full-text search? http://www.amazon.com/pro-full-text-search-server-2008/dp/1430215941

have ssis package created in visual studio 2008, has not changed in months.  i installed visual studio 2010.  now when open package in visual studio 2008 following validation error on xml source component in data flow task. error 2  validation error. manual version xml file: manual version xml file: "component "xml source" (1)" missing required property "accessmode". object required have specified custom property.   standardstorefileconversionpackage.dtsx  0 0 w hen @ component, accessmode set.  if open advanced editor , refresh component, error clears (i.e. stop sign white x on component), when attempt execute task, receive following error: information: 0x40016041 @ standardstorefileconversionpackage: package attempting configure xml file "k:\programming_department\selfservice\standardstorefileconversion.dtsconfig". ssis package "standardstorefileconversionpackage.dtsx" starting. information: 0x4004300a

can anyone me below problem ?. actually, want hide row group total horizontal in last column of matrix total. below more detail explanation.                              employee 1                 employee 2                  employee 3                   total mumbai                         3                                6                                7                              16   <-  want hide row group total delhi                             2                                0                                5                               7   <-  want hide row group total bangalore                     1                                 2                                9                               12   <-  want hide row group total total                             6                                 8                               21                             35   <----need show total   i tryied using inscope function control ,

created table 3 fields: system_name, start_date (datetime),close_date(datetime). start_date , close_date present downtime of several components same system_name. down time systema: a | --------------------|b c | ------|d e | ----------|f g | --------|h want string line a-f , g-h. want string line using geogrhpyic index or spatial data dont understand how use parallel events system_name if understand asking.... are thinking of ( http://blogs.solidq.com/dsarka/post.aspx?id=150&title=interval+queries+in+sql+server+part+2)  for purpose of interval processing? kind of interval processing datetime, you'd need encode datetime number of (hours or minutes or seconds or ?) since starting time. have @ other entries in blog series; might see way better. cheers, bob SQL Server

hello everyone, i have 1 datagrid auto generated column true , have column dynamatically in end of column have 1 image within hyperlinkbutton , have click event of hyperlinkbutton. i tried var mytemplatecolumn = new datagridtemplatecolumn(); mytemplatecolumn.header = "view"; mytemplatecolumn.celltemplate = (datatemplate)xamlreader.load("<datatemplate xmlns=\"http://schemas.microsoft.com/winfx/2006/xaml/presentation\"><hyperlinkbutton navigateuri=\"\" x:name=\"hlink_btnview\"><image source=\"http://localhost:37947/images/icon-pencil.png\"/></hyperlinkbutton></datatemplate>"); accountinggrid.columns.add(mytemplatecolumn); private void mygrid_loadingrow(object sender, datagridroweventargs e) { datagridrow datarow = e.row; foreach (datagridcolumn datacol in mygrid.columns)

i have designed custom silverlight control extends standard datagrid.  control provides method populate grid accepts instance of custom class have created.  control housed in number of different silverlight pages each of call web service obtain instance of custom class , pass off datagrid control populate itself. my problem when silverlight container page receives object webservice, object's type tied service reference silverlight application.  so, example, if "silverlightcontainer" page calls webservice, type of object returned "silverlightcontainer.servicereference1.customdataobject".  gets passed data grid, because data grid in it's own class library, not part of "silverlightcontainer.servicereference1" namespace.  it, therefore, not know object. i have tried importing identical service reference class library , casting shown below, receiving casting exception. classlibrary.servicereference1.customdataobject obj =  (classlibrary.se

hi all, we planning upgrade sql version sql 2012 sql 2014. have db size of 220 gb , db hosted on sql 2012 db compatibility level showing 100 (sql 2008), not sure why our earlier dba not changed sql 2012 (110). now have host above db on sql 2014 environment (rtm version) , have change compatibility level 110 or 120 (sql 2012 or sql 2014). one of our team member said may face performance issues in sql 2014 because of new cardinal estimator of sql 2014 not handling database well. true? please share comments , suggestions on this. please note that, using crm 2015 , have apply sql 2014 rtm version not sp1 because sp1 not compatible crm 2015. if crm 2015 not support sql 2014 sp1, cry , shame, not least if mean microsoft dynamics crm 2015 - microsoft should better. suggest attempt verify in dynamics forum. it true new cardinality estimator has caused upheaval. saying not handling database taking things extremes, though. there cases there improvement. but, alas, more prone noti

 i wann know how can create volume slider media player hello, quick sample:  <mediaelement margin="33,21,26,130" x:name="me" source="expressionstudio.wmv"/> <slider height="32" margin="32,212,27,56" maximum="1" value="0.5" valuechanged="slider_valuechanged" d:layoutoverrides="verticalalignment"/> private void slider_valuechanged( object sender, routedeventargs e) { me.volume = (( slider )sender).value; }   Silverlight  >  Silverlight Video and Media

hi, my hosting cie sugested upgrade access sql wich did. i downloaded fullest version (trial) of sql find, not knowing realy needed. the trial has expired , when try install "microsoft sql server 2005 express edition advanced services " sais need uninstall stuff (the error message trunckated). my use connect , manage live database. , have local copy of database on devellopement , testing machine can play around with. since i've install "big version", find i'm using "sql management studio". but when go "add or remove prgms", says use "frequently"! so not want uninstall realy using "frequently"... here have in list: sql server 2005 sql server 2005 backward compatibitity sql server 2005 books online sql server native client sql server setup support files sql server vss writer visual studio 2005 premier partner edition -enu this takes 1121.62 mb ! i not see in list sql management studio...? what need

as of working on ssas 2008 r2 want migrate cube solution ssas 2012 confused should ssas 2012 introduces new tabular model , not aware of tabular model needs followed here start ssas 2012  hi, you'll need install  analysis services in  multidimensional mode if want migrate existing olap cubes.  more ddetails here -  http://msdn.microsoft.com/en-us/library/ms143708.aspx .  also, please go through server_2012_upgrade_technical_reference_guide  for upgrade/migration questions. hope helps. shahfaisal muhammed http://shahfaisalmuhammed.blogspot.com SQL Server  >  SQL Server Analysis Services

i have of weird requirement, , thought ask community see if has done before, , perhaps assist. i have several sql environments particular system (prod, dev, test etc) , out of sync in way of data, more importantly, changes made sps, views , other objects can pain find. use redgate's sql data compare, or built-in features of visualstudio compare of objects, looking @ building ssrs report if possible, outline objects different, , 1 drill down on object, show actual differences. example: database 1 dbo.somestoredproc dbo.someotherstoredproc database 2 dbo.somestoredproc dbo.someotherstoredproc clicking on "dbo.somestoredproc" drill-down, , show cell have source sp on 1 side, , target sp on other, or that. can give me few ideas started? hi taylor, according description, want create report show difference in records between source database , updated database. right? in reporting services, can use lookup() function return fields dat

hi,  i have d3d application work on have bunch of multiplayer mini-games. these mini-games work on web page also. mini-games 2d basic sprite animation. have been looking @ flash games in because use 3rd party scaleform gfx app have flash games work in our 3d environment on web page. have been able connect c# server in flash using xml sockets. questions this:  1) read somewhere silverlight doesn't support networking until 2.0 release. if true when release? networking mean have ability use tcp/ip socket connections silverlight on web-page? 2) there way me create silver;ight games , have them run in full-screen direct 3d application?   thanks,    keith i read somewhere silverlight doesn't support networking until 2.0 release. if true when release? sometime in next 37 days, although there's chance happen march 5 (start of mix '08 in vegas) also networking mean have ability use tcp/ip socket connections silverlight on web-page? check out

dear all, i facing problem related bulk copy program utility. have both sql server 2000 , sql server 2005 installed on pc. current registered bcp.exe of version 8.0. when give command bcp.exe database of sql server 2005 on command prompt check database in sql server 2000. problem resolved if complete directry path selected i-e c:\program files\microsoft sql server\90\tools\binn. want enter command on every selected directry on command prompt. regards haseeb ahmad i'm not you're asking here - if want 2005 version of bcp default, change path variable in operating system have binary directories sql server 2005 above ones sql server 2000. can create batch file in operating system use instead of calling bcp.exe has full path in if don't want change path variable. SQL Server  >  SQL S

i'd set service broker queue in 1 database (dbrespond) on server events in database (dbevent) on same server instance can post messages queue.  problem i'm having that: the begin dialog conversation needs reference contract in current database, , want call begin dialog conversation dbevent the target service in dbrespond.  based on "hello world" service broker example comes sql 2005, in dbrespond need specify contract in create service call creates target service.  here, too, contract must defined in current database. how deal needing have same 1 contract in 2 different databases?   i'm not sure understand problem. contracts, message types , services scoped database. therefore, can create same contract on each database, running create contract statement twice, once in each database. you can give try service listing tool @ http://blogs.msdn.com/remusrusanu/archive/2006/04/07/571066.aspx , has option create message type , message types you. also, @ e

i have master detail page datagrid , dataform. there text box users can enter client reference number. if th reference bumber not found, child window pops uo d ataform insert. want when new record inserted, , child window closed, current record in datagris should set inserted record.. how possible private sub addnewclient_closed(sender object, e eventargs) dim clients cwclientadminadd = sender dim dd domaindatasource = ria_clientselection if not clients.newtbcbi_client nothing dd.dataview.add(clients.newtbcbi_client) dd.submitchanges() else dd.cancelsubmit() end if end sub private sub ria_clientselection_submittedchanges(sender object, e system.windows.controls.submittedchangeseventargs) if e.haserror messagebox.show(e.[error].tostring(), "submit error", messageboxbutton.ok) e.markerrorashandled() else me.dgclientsearch.itemssourc

hi, i have column in date format. later on, changed nvarchar , existing date changed format "yyyy-mm-dd 00:00:00". how update dates mm/dd/yyyy format. should use expression? thanks.  i highly recommend change back date/time type storing. ms sql server has many ways return dates , times formatted want depending on want see , how want see having data date time infinity better. case in point current predicament. sorting , filtering , comparisons on date/time types more efficient , less error prone date/time types have built in validation, trying enter date of february 30 not possible or 27 hours etc. you can execute date/time functions adding year or subtracting month useful when start make use of dates/times writing code against databases dates/times stored strings horrible experience not wish on anyone! i have maintain db created predecessor date , times everywhere varchar , nightmare, don't if have chance revert back!!! :) -igor

i have database server running 64 bit windows server 2008, , intended support sql server platforms.  i've installed them , set compatibility level of each database on each instance.  application setup support (in qa environment) requires odbc.  not sure driver use version of sql in odbc.  the new sql server native client 10.0 accessing sql server 2008 databases.  i have asumed sql native client intended use sql server 2005, has questioned , i'm unable find clear guidelines online.  able tell me whether correct following assumption? sql server 2000 - sql server - sqlsrv32.dll sql server 2005 - sql native client - sqlncli.dll sql server 2008 - sql native client 10.0 - sqlncli10.dll thanks! sql server native client 10.0 (sqlncli10.dll), fully supports connectivity , functionality of 3 of versions of sql server: 2000, 2005, , 2008. i'd recommend use 3 platforms. that said, sql server 2008 , sql server 2005 support connectivity sql server native client (sqlncli.dll), , "s

i read should try not use user instance connection string going forward sql server 2008 (i may have misunderstood) i have tried change connection strings in app no luck can me here this have been using. how accomplish string below without user instance? string destconnectionstring1 = "data source=.\\sqlexpress;attachdbfilename=|datadirectory|fbasic8.mdf;integrated security=true;connect timeout=30;user instance=true"; tried got error database exists or specified file cannot opened or located on unc share string destconnectionstring1 = "data source=.\\sqlexpress;attachdbfilename=|datadirectory|fbasic8.mdf;trusted_connection = yes"; thanks jon hello, i found thread answered mike wachal http://social.msdn.microsoft.com/forums/en-us/sqlexpress/thread/2b31e578-03ab-49c4-90be-9cf1fcb3326c please, try idea ? ( simple prefered retrieve old  thread before post ) i hope you. don't hesitate more or explanations have nice day ps : have sucee

hi all, i installed tfs 2013 on server joining domain , added project successfully. but of our team members have local administrators credentials same  as domain admin account when connect tfs auto log in domain admin account. also not entry appear in 'manage credentials -> windows credentials'  for tfs modify, if added on self on each development machine current team member credentials still log in domain admin. a solution know change domain admin's password not applicable in case now. note: environment -> tfs 2013 , visual studio 2013 well found workaround i used wireshark know exact credentials vs uses auto log in tsf , neither member's machine local admin nor domain admin. tfs machine local admin account (same password rest). edited web.config tfs service hosted on default port 8080 deny account (<deny users="dev01\administrator" />) in packet wireshark. when team member opens visual studio , connect tfs rejects connection , pro

hi all! i'm playing silverlight mvvm light , have basic question experts out there: my layoutroot grid contains tabcontrol 3 tabitems (pages). in each tabitem/page have listbox want fill data 3 generic lists available viewmodel: <sdk:tabcontrol grid.row="1" width="auto" height="400">                 <sdk:tabitem header="search result 1">             <grid>                 <grid.columndefinitions>                     <columndefinition width="200"/>                     <columndefinition width="auto"/>                                         </grid.columndefinitions>                                      <listbox grid.column="1">                                          </listbox>              </grid>                     </sdk:tabitem>      <sdk:tabitem header="search result 2">  <!--listbox search r

hi, i have hardware configuration question on microsoft bi components. we have bi solution end end on microsoft . has: 1)sql server 2005 sp2 database 2)ssis 3)ssas 4)ssrs 5)excel 2007 6)wss 3.0 (portal). can tell me how split hardware alll components above. mean components can/should kept , other should residing on other widows servers performance imporved. as of thinking of having database , ssis on 1 server box , ssrs , wss on box. please suggest. thankyou for maximum performance, of things should on own machines, gigabit ethernet (or faster) connecting them. if had 2 boxes work with, i'd put sql server on box itself, , put rest on another.  sql server focus , should hardware resources can. -ryan / kardax SQL Server  >  SQL Server Database Engine

how attach database file in network related applications im getting following error system.data.sqlclient.sqlexception: attempt attach auto-named database file \\pc-1\d\db.mdf failed. database same name exists, or specified file cannot opened, or located on unc share. how solve error... the databas files need local sql server service - no network shares. tibor karaszi, sql server mvp | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi SQL Server  >  Getting started with SQL Server

i want set current month default member in time dimension. every time see data should display most current data. i've tried lot in default member property not getting success. thanks in advance here example using adventure works cube.  can add cube script adventure works cube , default day current date using now() function.  had use (now() - 1000) set date 3/25/2004 due fact adventure works cube date dimension ends @ 8/31/2004, think idea.  other thing note here [date].[date] attribute has "valuecolumn" defined of type "date".  allows filter statement use straight date vs. date comparison. -- now() = 12/19/2006 -- now() - 1000 = 3/25/2004 alter cube currentcube update dimension [date], default_member = tail ( filter ([date].[date]. members ,[date].[date]. membervalue < (now() - 1000)),1)(0); hth, steve SQL Server

hello, starting play customizing of tfs reports , have been able create couple of simple ones on own. trying head around mdx , learn basic syntax playing of the box reports. having simple problem , don't understand wrong. i trying modify remaining work report , add in filter in clause returns items where exit criteria set false. i.e. [work item].[microsoft_vsts_common_exitcriteria].&[yes]. modified query looks this. ---start with member [measures].[date key] as     [date].[date].currentmember.uniquename select   {     [measures].[date key],     [measures].[cumulative count]   } on columns,   (     [work item].[system_state].[system_state],     (strtomember(@startdateparam):strtomember(@enddateparam))   )   on rows from [team system] where (   strtomember("[team project].[team project].[" +@project +"]"),   strtoset(@iterationparam),   strtoset(@areaparam),   strtoset(@workitemtypeparam), [work item].[microsoft_vsts_common_exitcriteria].&[yes] ) -

hello experts,   i'm new ssas 2005. i need following calculation , i'm wondering if possible in ssas 2005?   dinstinctcount (set a intersect set b)   set as: select distinct student-id table cond1 , cond2 , cond3 set b as: select distinct student-id table b cond1 , cond2 ... for now, have 2 tables in dsv both fact table , dimension table, student-terms and student-programs, have created measures distinctcount of student-id in these 2 tables. default thought create 2 named sets set , set b,do intersect , calcuate a measure somehow. however, couldn't create named set conditions following   existing ([student terms].[student id].[student id]. members , [student terms].[ftds].&[yes])   is there way create set conditions, set functions , count number afterwards?   could shed light me?   thanks lot in advance!!!   cherry-tree sounds lot homework question me. as hint, how many sets talking???   have set a, , set b. draw picture show

we have number of sql 2005 clustered server instances using following collation sql_altdiction_cp850_ci_ais   new sql 2008r2 enterprise cluster created , after cluster put in 'production' , databases added it, found out collation set incorrectly sql_altdiction_cp850_ci_ai.   without wanting perform full reinstall able find following commands run rebuild instance in cluster change it's collation. setup.exe /q /action=rebuilddatabase vs=#clustername# /instancename=#instancename# /sqlsysadminaccounts="domain\user"  /sqlcollation= sql_altdiction_cp850_ci_as while user databases detached , instance offlined in cluster above command worked in changing servers default collation.  problem this, of older vb tools created, worked before running command above no longer work.  error displayed says: [sql-dmo] server object not connected. i can load sql management studio 2005, connect instance rebuilt, can see database have attached. it's collation matches of serv

hey there, i gone long time , i'm ;) within last month developed email client library smooth linq imap provider runs on .net 4.0 , mono 2.8.  if interested can read on codeproject  . point i'd create complete email client , need ui, obviously. , since lib "relatively platform independent" mono hoping able keep client itself platform independent too. the issue ui libraries run on mono , windows ugly imho or outdated in terms of capabilities. know there have been posts topic several years old , things have changed since then. we have oob allows nice stuff still restricitve provide needs of email client. on topic had idea, why not implement client ui less server runs on "localhost" , ui oob application communicating server on webservices, sockets or whatever possible nowadays. since haven't been around quite time, hoping informations "construct", whether it's possible, not possible, crazy or ingenious ;) many than

i browse using source control explorer , expand few levels down. once 2 levels down "hangs" , refreshes root - collapses tree , starts refreshing screen every 5 seconds. this happening on vs rtm , tfs update 1 well. upgraded see if issue resolved it's still happening. i've done typical reboot server & client still happens. visual studio enterprise 2015 14.0.25029 update 2 rc tfs 2015 14.95.25029.0 (tfs2015.update2.rc2.2) *edit devenv.exe continuously uses between 10 , 20% cpu hi jean francois l ， thank feedback. maybe try create new workspace. by way, have tried cleaning cashes: 1. clean cache folder on client computer. folder path is: c:\users\username(team explorer user name)\appdata\local\microsoft\team foundation\6.0\cache. 2. clean cache folder on server machine. folder path is: c:\tfsdata\applicationtier\_filecache after cleaned, on server machine, click start , select run… open dialog box, input iisreset.exe , click ok, wait

drop failed job ‘xxxxxxxxxxxxx’. (microsoft.sqlserver.smo) the delete statement conflicted reference constraint “fk_subplan_job_id”. conflict occurred in database “msdb”, table “dbo.sysmaintplan_subplans”, column ‘job_id’. the statement has been terminated. (microsoft sql server, error: 547 you can delete job , maintenance plans manualy tsql. here sql fix this: http://www.gudenas.com/2007/04/20/sql-server-2005-delete-maintenance-plan-error/   --note: replace “maintenanceplan” use [msdb] declare @job_name varchar(100) set @job_name = n’maintenanceplan’ --first, delete logs plan delete sysmaintplan_log sysmaintplan_subplans subplans inner join sysjobs_view syjobs on subplans.job_id = syjobs.job_id inner join sysmaintplan_log on subplans.subplan_id = sysmaintplan_log.subplan_id (syjobs.name = @job_name) --delete subplan delete sysmaintplan_subplans sysmaintplan_subplans subplans inner join sysjobs_view syjobs on subplans.job_id = s

  thanks in advance.... how can data fro xml file in visual studio 2008 using datatable please me findout code same in c#,a;so need show data using datagrid.....   here related link:   http://www.java2s.com/code/asp/xml/readxmldataandbindtodatagridinc.htm   let know if helpful.   SQL Server  >  SQL Server XML

i trying write mdx query slices cube based on whether dimension attribute contains string.   in case, have order dimension po attribute.  when aggregate amounts po, looks like: po            amount 123          10 124          30 125f        20 126           5 127f        30 the query looking write needs filter above  result set po contains 'f' (ie return 50)   can in bids browser excel, have been unable find mdx syntax this.  started @ filter function unable craft appropriate expression filter po %f. any thoughts/suggestions? thanks! have few options.  when browsing notice if run trace using instr function members in dimension.  @ using analysis services stored procedure project. refer link additional options , examples -  http://social.msdn.microsoft.com/forums/en-us/sqlanalysisservices/thread/35edea0d-c031-4c6d-a0c7-9cca1561efdc/ dan english -- http://denglishbi.spaces.live.com SQL Server

there several reports user can browse http address view i.e. http://servername ... reports have same security there 1 report non-admin users can not access. when browse it, report comes parameters , heading of report no data. note myself , other developers have admin rights, can access report other users can not. suggestions please? thanks hello, follow thread below security of ssrs reports. may you. http://social.msdn.microsoft.com/forums/en/sqlreportingservices/thread/a7a571d1-ce90-43d5-b7bd-0a5da735681f SQL Server  >  SQL Server Reporting Services, Power View

can me find download of sql server 2005 virtual lab? i'm unable install 1 in microsoft technet... hi, check these links http://nowdownloadall.com/index.asp?q=virtual+lab&pid=92d75e3c-6ff7-408e-8a60-6c1abcebcf98 http://msevents.microsoft.com/cui/advancedsearch.aspx?culture=en-us#culture=en-us;pagenumber=1;sortkey=relevance;sortorder=asc;filtertype=4;pageevent=true;hdninitialcount=1;kwdany=sql%202005;eventtype=0;searchcontrol=yes;s=1 rajesh jonnalagadda http://www.ggktech.com SQL Server  >  Getting started with SQL Server

multiple buffer caches --> have fixed 8 kb page size in ss -- can send multiple buffer caches? perhaps pin 3 tables specific pool of memory important , let other tables go after heap? can in oracle (though part, no 1 does) , db2 , i'm curious sql server   sql server supports single buffer cache in 2000/2005.  in 2008, however, can use resource governor allocate different pools of memory.  i'm not sure how implemented internally, appears each pool isn't isolated own memory section, , queries can read other pools. SQL Server  >  Getting started with SQL Server

hi i having 3 sub package..when 1st package run success 2nd package run..now 1st package having 18rows 2 rows error..16runs insert 1st table..so using execute package task execute 3 package..so 1st package error rows , want stop execute package task 1 st package run want restart same 1st package..but in check point scenario if package error means restart..but 1sts package got succeed only how in ssis hi, you can error bypass 1 of following ways discussed here in thread. hope useful. http://beyondrelational.com/quiz/sqlserver/bi/2011/questions/ssis-package-execution-error-bypass.aspx thanks karthikeyan anbarasan www.f5debug.net free ebook on ssis tutorial - download here ssis step step SQL Server  >  SQL Server Integration Services

hi have been working silverlight.. far silverlight concerned xap file download isolated storage of client. want know how isolated storage modification or update done on server. how isolated storage or client modification automatically.   hi, just correction xap file not downloaded islolated storage not per in case. so question asking how client know of new xap version on server or looking keep data in isolated storage , want dynamically update between client , server? Silverlight  >  Visual Studio & Silverlight Development Tools