Lun

i'm new user , want build query mining model wizard. feature says go analysis manager tree pane. can't find analysis manager tree pane. how it? thank you.... "enterprise manager" , "analysis manager" 2 different tools. (i guess working sql server 2000). need first launch analysis manager sqlserver menu (analysis services sub menu) , connect analysis server instance before can see tree pane. SQL Server  >  Getting started with SQL Server

im importing txt file. of date columns have empty values. i'm getting erro when try import date field has empty value. what can insert empty values datetime column? qeqw use derived column replace column "01/01/1753 00:00" use expression: len([datecolumn]) == 0 ? "01/01/1753 00:00" : [datecolumn] hope helps !! sudeep      my blog SQL Server  >  SQL Server Integration Services

hi, thanks in advance. we attempted detach team project collection (tpc) , noticed following error alert. our objective detach collection tfs admin console, detach database name sql mgmt studio, delete sql transaction log file (huge size), attach database name sql mgmt studio , finally, attach tpc tfs admin console. doing so, new sql transaction log file created considerably less in file size.  is our understanding correct? kindly advise.  tf14103: internal error: database procedure prc_savecatalogchanges returned wrong number of rows hi mahesh, thanks post! i not familiar with sql transaction log file, however, link , said, you cannot remove file database unless file has no existing data or transaction log information; file must empty before can removed. i suggest ask question if sql transaction log file can deleted or not if not empty in sql server forum. could please post the configuration log files stored in "%programdata%\m...

i have sql 2000 server running on windows 2003 computer , i'm getting error when try connect through asp file on iis (on different server).  can connect sql 2000 server through enterprise manager , query analyzer on computer on network , can connect okay through windows program have using vb 6.0 or dot net.  however, i'm getting error when connected through asp. the sql 2000 server setup authenticate allow both sql , windows.  when netstat -a on sql 2000 server, don't see entry port 1433 , can't telnet server using port 1433.  named pipes , tcp/ip enabled on server , port 1433 set in tcp/ip properties. any appreciated. nick thanks replying.  got problem fixed.  did install latest sql 2000 service pack 4. the strange thing is, sure i've installed same service pack before.  also, after i've installed service pack 4, did "select @@version" , still show service pack 1.  @ least asp works now. ...

hi, here, i having question ole db provider , ole dm provider. what ole db (ojbect linked embedded database) provider  , ole dm (object linked embedded data mining ) provider mean ? expert here give me some explanations how works or giving me some example code for it? also, difference between ole db , ole dm?  with best regards,   it's ole db dm provider.  ole db standard specifying interfaces data.  ole db data mining specification extending ole db use data mining, , includes schema rowsets necessary , language (dmx) used query mining models.  information on both in msdn. SQL Server  >  Data Mining

hi,      i using mysql , while writing below query error ="select * table1 whereparameter in "+"('"+join(parameters!parameter1.value, "','") + "')"+" " and error is an error has occurred during report processing. cannot set command text data set 'dataset1'. error during processing of commandtext expression of dataset 'dataset1'. i have used same query in other reports working fine there.what reason? hi madhavib, please try expression below: ="select * table1 parameter in"+"('"+join(parameters!parameter1.value, "','") + "')"+" " or ="select * table1 parameter in('"+join(parameters!parameter1.value, "','") + "')" if have questions, please feel free ask. regards, charlie liao technet community support ...

our dba has deployed cubes client system, cant see them in mangement studio.  has confirmed can. presumably permissions problem.   i member of olap group on server, presumably admin can allow group full access analysis services?   ideally members of group should have full ssis , ssas rights.  selective permissions in databases seem under control no 1 seems know other areas.   i hope makes sense, im not dba , no expert on security (obviously!) cheers.     if olap group supposed have admin rights within ssas instance, can add them fixed server role. this, open ssms, connect ssas, right-click ssas instance, , select properties.  in dialog pops up, can select security option , add group there.   the fixed server role grants lot of rights.  need more selective, can set roles within database , give them appropriate permissions there.   b. SQL Server ...

tried installing in these 3 modes: integrated, pat, negotiate. this error >> connect: enter server url > http://ip:port/tfs enter authentication type (press enter integrated) > connecting server ... expectation failed failed connect.  try again or ctrl-c quit enter server url > http://ip:port/tfs enter authentication type (press enter integrated) > negotiate enter user name > administrator enter password > ********* connecting server ... expectation failed failed connect.  try again or ctrl-c quit enter server url > http://ip:port/tfs enter authentication type (press enter integrated) > pat enter personal access token > ************************************************** ** connecting server ... basic authentication requires secure connection server. failed connect.  try again or ctrl-c quit enter server url > hi meghana, did add user running installation of agent, p...

i getting error message the type or namespace name 'inotifypropertychanged' not found (are missing using directive or assembly reference?) what namespace , reference should add inotifypropertychanged any great system.componentmodel check below example: using system.componentmodel; namespace myapplicationnamespace {    public class myclass : inotifypropertychanged    {     public event propertychangedeventhandler propertychanged;         protected void onpropertychanged(string propertyname)         {             if (propertychanged != null)             {                 propertychanged(this, new propertychangedeventargs(propertyname));   ...

i having trouble trying install silverlight. says installs 99% fails. running current edition of firefox , updated ie - uninstalled current version of chrome since not compatible. when try install current version of silverlight - though says doesn't install... shows in control panel programs. uninstall , have tried reinstall again - after rebooting. have used "ms fix" uninstall in case of not removed it's clean new install. have spent hours researching possibly wrong or possibly blocking install. have tried uninstall firefox , reinstall. have tried install older version of silverlight. have gone on, think!, every support site , trying different things. , nada! appreciated!!  try watch netflix! haha!! ;) thank all!!!!! unfortunately, 1604 means did not complete, no clues there. this temp folder. i've seen problems explained here: http://social.technet.microsoft.com/wiki/contents/articles/30387.silverlight-troubleshooting-installation.aspx#error_1622_w...

hi, experts here, can please here give me idea sql server 2005 agent proxies? they? for? when should practice use them? thanks alot in advance kind , looking forward hearing you. best regards, yours sincerely,   hi,   when user wanted execute sql server integration services (ssis) package job step, sysadmin had enable sql server agent proxy account. after account enabled, sql server agent user create job steps subsystems, such cmdexec, , run them using account. in sql server 2005, sql server agent addresses security concern using multiple proxy accounts. http://www.microsoft.com/technet/prodtechnol/sql/2005/newsqlagent.mspx   and also...   sql server can operate transparently proxy server prevent unauthorized access internal network. using configuration, not have connect computer running sql server directly internet. when run sql server on computer located behind proxy server, sql server protected packet filtering features of proxy server. can configure proxy ...

currently, need calculate delta size while diffing files in teamfoundationserver, don't know wheter there are existed tfs api in msdn. far did not find it. familiar it? or deliver suggestions? thanks in advance !! thanks materials !! here solution below: private int calsinglefiledelta(string strbase, string strshelve) { int nfiledelta = 0; arraylist alorgstart = new arraylist(); arraylist aldesstart = new arraylist(); arraylist alunchangedlen = new arraylist(); diffsegment diffseg = difference.difffiles(strbase, encoding.ascii.codepage, strshelve, encoding.ascii.codepage, new diffoptions()); if (diffseg != null) { alorgstart.add(diffseg.originalstart); aldesstart.add(diffseg.modifiedstart); alunchangedlen.add(diffseg.modifiedlength); while (diffseg.next != null) { diffseg = diffseg.next; alorgstart.add(diffseg.originalstart); ...

hi,   i looking send out custom email  build info @ end of each build.   issue:   is there way add customzed information in project alert email send out @ "buildcomplete" event?   or   is there way subscribers of specific event(thro webservice or other means, don't have access tfs datawarehouse), can email info other means subscribers?   thanks, shiv hello shiv:     please try customize team build type , run customized task send email alert?     Archived Forums V  >  Team Foundation Server - General

can navigate existing sl3 sites , have them work on wp7 emulator (i thinking http://gallery.expression.microsoft.com/en-us/spotthedifference )   since these in-browser silverlight applications and window phone 7 supports out-of browser only, scenario not work describe. however, of code portable windows phone, can copy , paste code windows phone project , many cases, use as-is.  thanks, mike Silverlight  >  Silverlight for Windows Phone

hi all, i trying find solution task. my task is, have flat file source data using flat file source of dft, reading it.  now have validate data of source each row on columns data of different tables of database. for example, data of columna of source file need validate x table data of database. in same way data of columnb of source need validate y table data of database. what want is, each column of source data, have apply different business rules , after passing these validation result data have insert destination table. please me, if 1 have solution this. thanks & regards ashok vallu    hi ashok, it depends on number of column want compare. if rows less can use lookup transformation compare it. while using lookup component cautious selecting appropriate modes(full/partial/no cache). thanks aravind SQL Server  ...

hi, i need migrate large number of test cases 1 project in tfs 2012. i tried using "work item migrator" tool, not migrating selected test cases(it migrated 100 when selected 204 tc's). at many places on forums, found "test case migrator plus", need project project not uploading test cases excel project. even though if i have to download test cases excel tfs, couldn't 'test step expected result' excel. please me here if 1 have solution. thanks in advance. hi, what refer "work item migrator" tool, mean tfs integration tools ? if yes, please refer willy's blog this: http://blogs.msdn.com/b/willy-peter_schaub/archive/2011/10/20/tfs-integration-tools-can-i-migrate-all-work-items-from-one-team-project-collection-to-another.aspx hope helps! best regards, cathy kong msdn community support | feedback us develop , promote apps in windows store please remember mark replies answers if , unmark them if provide no hel...

temporary dev server 2 gigs ram , core2duo. sql server 2005 standard. 1 cube 7 measure groups 6 hierarchical dimensions, 10 - 12 more dimensions , various many many relationships (5 fact tables). when querying on excel starts fime add more , more dimensions (8 - 10 dimensions on 1 query 4-5 hierarchical dimensions) gets painfully slow. tried designing aggregations (in cases 99% until reading other posts on forum made similar issues). dont see how usage optimisation helps @ stage. 1 querying server , there 1 years worth of data (we have load past 17 years of data cube). any more ideas optimisation? do have calculations in cube? size of cube? face performance issues base measures? how big dimensions(number of members in dimensions)? SQL Server  >  SQL Server Analysis Services ...

hi, have enabled blocked_process_report option in ss 2008 , able use sql server profiler information blocked processes. question if possible build kind of notification service when these blocks arose. have e.g. email sent our people responsible notifications. there table polled can same same information blocked_process_report using. found following resource: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/04/06/event-notifications-monitoring-blocked-processes-and-other-events-end-to-end-how-to-set-it-up-and-make-it-work.aspx . in ss 2008 notification service not available more. approach or there other solution? best regards lars lars, tony's example doesn't use notification services. uses event notifications (whihc in turn uses service broker), both of available on 2008. tibor karaszi, sql server mvp http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi ...

the following measure is close want do. sums rows based on value in employmentlevel and accumulate over time. fulltimeequivalentemployeesstarted:=calculate(sum([employmentlevel]);filter(all(tdates[date]);tdates[date]<=max(tdates[date]))) in addition measure above want rows in temployees excluded if have blank value in [datestarted] : i have tried following measure, doesn't work intended. when  i add second filter, 1 on temployees, measure reason no longer accumulates over time. fulltimeequivalentemployeesstarted:=calculate(sum([employmentlevel]);filter(all(tdates[date]);tdates[date​m]<=max(tdates[date]));filter(temployees ;(temployees [datestarted])<>blank()))". i writing measure in calculation area beneath temployees. can me figure out how measure should written work want work? fulltimeequivalentemployeesstarted:=? is there relationship between temployees[datestarted] , tdates[date]. if yes, mark inact...

hello all, im newbie ssas world , trying figure out coding. here scenario: i'm trying pull  only latest value out of result set, of july 2008, tomorrow if august populated need show august vice versa.. guys on this? thanks in advance. thanks, please people when need..!!! mark answered if problem solved. for measure limited applicable calendar boundaries, add 'existing' in front of '[date].[calendar].[month].members'. there times when 1 needs 'global latest' value current syntax produces. also, search 'last non empty' see has been done problem before. SQL Server  >  SQL Server Analysis Services

hi ...........! hope fine.....................  how render html in silverlight popup  ............ scenario :    want send parameter html string silverlight popup .................................... then popup should render html ...........................how possible ............ this silverlight popup calls asp.net code ....................... i send parameter(html) asp.net code silverlight ..............but  it displays html not render html     waiting reply  thankz in advance                                silverlight can't render html, there 3rd party controls out there can this. or overlay iframe html content. go silverlight 4 , use richtextarea show formatted rich text. if elevated trust , out of browser option you, can use silverlight 4's htmlhostcontrol present html site. similar iframe approach doesn't need windo...

hey guys,   can throw light on issue. it's not easy 1 explain i’ll give go.   we have spid appearing on our server, sp_who2 returns;   spid  66   status background   login sa   hostname .   blkby .   command insert   cputime 280313   when execute dbcc inputbuffer returns 'no events'   when @ locks held spid holds locks in database , tempdb [bulk insert]. i've looked @ sqlhandle because appear internal returns nothing.   this spid causing blocking locks takes out.   to remove spid have found if disable service broker spid removed. might red herring have switch database single user mode using rollback immediate.   the reason why think service broker involved because spid returns when service broker re-enabled.   we thought might because of full text search uses materialised view dropped views , issue still persists.   i know vague description please feel free ask questions, on appreciated   ...

hi, is there way can monitor replication via script can use database mail enable mailing if replication fails? kind regards jacques not sure scripts replication has inbuilt different flavors of alerts can configure gui itself. 'replication monitor" - highlight publication - "warnings , agents" - configure alerts     hth regards rishi maini SQL Server  >  SQL Server Replication

hi, so here issue.  if open excel , create new local worksheet , press powerpivot button, powerpivot launches.   if open existing workbook computer , press powerpivot button, powerpivot launches.  if publish workbook sharepoint , open within sharepoint enviornment, slicers work and data updates expected.  far no problems. however, if open excel file directly from sharepoint either using dropdown "edit in microsoft excel" on file name in document library or if choose "open in excel" bar, can't powerpivot window open.  can open excel workbook fine powerpivot won't launch.   in fact, none of buttons under powerpivot tab anything.  checked add-ins , shows powerpivot active.   select edit , click yes connection , refresh questions have come up. any idea happening here?   don't want have donwload file each time , save locally , open excel, modify powerpivot , reload each time want make c...

i've seen few discussions touching on topic of dr solution using datakeeper perform block level replication dr site hundreds of miles away primary data center. though have been helpful, have few questions i'm not sure i've found answer to. here's situation: have 2-node active/active cluster 2 sql server 2008 r2 fcis on each node, total of 4 instances, san storage. have 200+ databases between these instances ranging little 50mb large 150gb. have dr datacenter 650 miles away stand alone server sql server dr databases and need replicate/mirror data in primary cluster dr server. 3 servers (2 nodes in cluster , dr server) identical: 32-core cpu, 384gb ram, however, mentioned, dr server not node in cluster. looking @ database mirroring solution have data replicated dr site there worker threads limitations limit number of databases mirror, on mirror server. also, db mirroring works @ database level , outside (server logins, agent jobs, etc) have kept synchronized manua...

when try detach collection in tfs 2012.2, getting below error: tfs instance operational without issues, reason when try detach collection fails. fails during core framework step. i tried detach collection using tfsconfig, command line execution says detach successful. when go , in tfs administration console, collection still exists in stopped mode. any ideas on how resolve issue? exception message: tf246017: team foundation server not connect database. verify server hosting database operational, , network problems not blocking communication server. (type databaseconnectionexception) exception stack trace:    at microsoft.teamfoundation.framework.server.teamfoundationsqlresourcecomponent.translateexception(int32 errornumber, sqlexception sqlexception, sqlerror sqlerror)    at microsoft.teamfoundation.framework.server.teamfoundationsqlresourcecomponent.translateexception(sqlexception sqlexception)    at microsoft.teamfoundation.framework.server....

hi team...   i have 1 dought how use copy_ony backup...   plz me..   thanks p.ramakrishna reddy     hi, here informative article on copy_only backup http://www.sql-server-performance.com/articles/dba/create_backups_without_breaking_database_backup_sequence_p1.aspx i hope answers questions. regards, alok parmesh SQL Server  >  SQL Server Express

hi, i need install database engine of sql express 2005 or 2008. and, have been asked download setup of sql express engine only, not full setup of sql express. please me, in matter. thanks , regards sachin kumar singh sql server express edition free , redistributable. you should use sql server 2008r2 or 2012 instead of older 2005/2008. you can download here: http://www.microsoft.com/en-us/download/details.aspx?id=26729  , it's available different languages. by size can see, first 3 installer are engine, adv , wt larger. olaf helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * wenn ich denke, ist das ein fehler und das beweise ich täglich blog xing SQL Server  >  SQL Server Documentation ...

hi,  i have 2 xap files hosted in aspx page. in 1 file have silverlight dropdown , on other file have datagrid.based on selection in dropdown values gets passed .xap file. samething have inplemented when hosted silverlight controls in html page using html bridge. htmlpage .window.invoke( "getselecteddata" , x, y); getselecteddata javascipt method in html page hosting 2 xap files but not able achieve same thing when hosted in aspx file.(default.aspx)  please tell me solutio. @ beginner level.      regards, monaps       hi monaps, try refer thread: http://silverlight.net/forums/t/16565.aspx Silverlight  >  Hosting and Streaming with Silverlight ...

hi how can find lowest level of member of hierarchy? note each member of hierarchy can have different number of level.   if want lowest level members(leaf members) can use following statement for getting leaf members; descendants ([dimensionid].[dimmember],,leaves) where dimmember dimension member leaf members need. and dimensionid dimension id. regards, ani SQL Server  >  SQL Server Analysis Services

hi all, we had sso working against standalone msas server ocausql01. added msas cluster called ocausqlcls , sso has stopped working. used setspn utility add spns referencing cluster ocausqlcls rather individual machines. setspn.exe -a msolapsvc.3/ocausqlcls.xxx.local ocausql01 setspn.exe -a msolapsvc.3/ocausqlcls ocausql01 setspn.exe -a msolapsvc.3/ocausqlcls.xxx.local ocausql02 setspn.exe -a msolapsvc.3/ocausqlcls ocausql02 the spns created (see below) h:\>setspn -l ocausql01 registered serviceprincipalnames cn=ocausql01,ou=op center aapt,ou=sql serve rs,ou=servers,dc=xxx,dc=local:     msolapsvc.3/ocausqlcls     msolapsvc.3/ocausqlcls.xxx.local     msolapsvc.3/ocausql01 h:\>setspn -l ocausql02 registered serviceprincipalnames cn=ocausql02,ou=op center aapt,ou=sql serve rs,ou=servers,dc=xxx,dc=local:     msolapsvc.3/ocausqlcls     msolapsvc.3/ocausqlcls.xxx.local i modified connection reporting tool access cluster name rather server name still error. "an erro...

hey i'm getting started xaml/wpf (coming c#) , stumbled across following basic question: how can access members declared in xaml let's button. googled lot , searched through several msdn articles couldn't find hint except can use event instance of button (but want direct access). another question: xaml executed when initializecomponent() method called? thanks help! hello. if you're using  codebehing file, think can access control using name (ie, if use x:name attribute, name codebehind file reference control). can use findname method reference control (though isn't needed in codebehind file). Archived Forums SA-SM  >  Silverlight (formerly WPF/E) Developer Issues

we have vendor encodes our videos on-site, , streams feed internet.  our internal users can connect server on internal network via firewall rule.  using windows media streaming, vendor wants switch silverlight.  know ports need open in firewall allow internal users connect stream? thank you, aaron alexander hi aaron, that depends on how videostream supplied. windows media services can supply stream on http, no firewall rule needed in case. Silverlight  >  Hosting and Streaming with Silverlight

 hey guys n'girls  so im working little around on silverlight(1.0) hompage asp c# .net , these things. i had create firstly login page called 'default.aspx'. there can give username , password login. when login button clicked, handling authorisation , errors handeled in 'sendlogin_click' function in 'default.aspx.cs' everything sounds amazing in ear, how nudge browser these .cs file load new page or load same page failure if login incorrect.   hope understand problem is. sincerely yours  aqa   one way have userid , password textboxes , submit button on aspx page display style of "none" and, in sl code, populate controls values input sl app , call button's click() event.  that's fine if going use sl on login page, but, keep in mind if next page uses sl, too, new sl app have no knowledge of happened on previous page. if you're going keep user in sl after login, though, should consider doing authorizat...

hi,  i upgrade vs2008 express/silverlight 3 vs2010 express/silverlight 4. have questions. 1. have gone uninstall programs dialog , have found million (slight exaggeration) things relating vs 2008 (including sql). 1 uninstall? if need uninstall multiple things, order do it? 2. there are four silverlight 3 things,  microsoft silverlight, microsoft silverlight 3 sdk, microsoft silverlight toolkit november, , microsoft silverlight tools visual web developer. guessing need rid of 4 of these, again in order? 3. express edition 2010 still unlimited usage package, ie wont shut off after 30 days? 4. hobbyist programmer , want put programs on web others can use them. still allowed 2010 edition of vs? if 1 day did want charge couple of bucks 1 of programs, still allowed under express edition of 2010? 5. has else got tips might need know before uninstall , reintstall? jaa   there no need uninstall vwd 2008 , silverlight tools.  have uninstal...

hi everyone, i have created report in ssrs having image logo in footer , working properly, after exporting in excel, footer not showing me image in print preview section of excel. is there way render image in footer of excel sheet while expoting ssrs report. hi, is image embedded report ? regards http://simplesqlserver.wordpress.com/ dj's | please mark answered or vote helpful if post resolved issue. thanks! SQL Server  >  SQL Server Reporting Services, Power View

steps follow call web service silverlight application: 1. create silverlight alpha 1.1 application in visual studio codename ‘orcas’ 2. create new asp.net web service project .net 3.5 framework 3. uncomment line: [system.web.script.services.scriptservice] (for step work fine, add reference system.web.extensions dll , add @ using stmt   “ using system.web.script.services;”) 4. write necessary methods. build web service 5. open iis; create new virtual directory under default web site. set physical path of web service created in above step 6. open silverlight project created in step1. add web reference in project web service hosted in iis in step 5 7.(most important step) open iis; create new virtual directory under default web site (if new web site created in step 5, create virtual directory under new web site only. have because silverlight doesn’t support cross domain calls in version. 8. right click on virtual directory silverlight applicati...

when ms released sl 3.0, posted walk-throughs supposed folks understand how write , access duplex wcf services in sl 3.0:   http://msdn.microsoft.com/en-us/library/dd470105(vs.96).aspx i've been trying work, , i'm running bit of difficulty.  i've created duplex service in question, , far can tell, it's , running, e.g., navigating http://localhost:59363/duplexservice.svc  gives me expected page.  , can reference client, , build proxies. however, in mainpage constructor, demo says should insert following code:             endpointaddress address = new endpointaddress( "http: //localhost:59363/duplexservice.svc");             custombinding binding = new custombinding(                 new pollingduplexbindingelement(),        ...