Lun

hi in reports print values of paramters used generate report @ top of reports. i've written report usuing mdx , 1 of parameters multivalue list based on hierachy. problem have when join parameter label values it's bringing through indenting preceeding whitespace. i've been struggling while try , trim off anyone have suggestions?? =join(parameters.sites.label,", ") results in   head office,      branch 1,            subbranch 1 etc if put =join(ltrim(parameters.sites.label),", ") error overload resolution failed because no accessible 'join' can called these arguments cheers matt after bit more searching clear wasn't going possible directly functions expression editor instead used custom code as described in post http://www.sqlservercentral.com/forums/topic647539-147-1.aspx   public function jointrim(myarray as object ) as string dim ...

hi i have notices our build machines have semi regular (1 or 2 day) event 206 messages, e.g. build machine vd-buildxxx-03 lost connectivity message queue tfsmq://buildservicehost-53/. reason: tf400324: team foundation services not available server xxx-tfs01\oosa. technical information (for administrator):   the underlying connection closed: unexpected error occurred on receive. exactly 5 minutes later connectivity restored.  when repeat occurs within day seems 5hr period . >> should worried these ? (my concern happen if build running @ time) >> how dedug , find out reason ? context: vs2012 up5 + vs2013 up4 + vs2013 ip4 build agents tfs 2013 build controller. thanks   hi greg, thanks reply. you try clean cache on build server , re-register build service tfs collection again? could close post? we trying better understand customer views on social support experience, participation in interview project appreciated if...

well...i don't know table select , aggregrate function should use here question:   - use requiredby date , shippeddate select orders shipped after customer needed them. how many have shipped late? so sql should this, won't work: select shippeddate, requireddate, count(shippeddate) [late shipped] from orders where shippeddate > requireddate group shippeddate; sql server 2005 , up select o.*, count(shippeddate) on () [late shipped] orders o shippeddate > requireddate ----------------- the above select late orders , give count of late orders additional column (all same). if want count each shipped date instead, add partition shippeddate. also, original code didn't work because needed put requireddate group too. premature optimization root of evil in programming. (c) donald knuth naomi nosonovsky, sr. programmer-analyst my blog SQL Server  >...

i have silverlight lib contains bitmaps (in "images" sub-directory) in project ("myproject"), include custom usercontrol ("mycontentzone") other assembly ("mytools")   < usercontrol x:class= "mynamespace.myproject" xmlns= "http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x= "http://schemas.microsoft.com/winfx/2006/xaml" xmlns:contentzone= "clr-namespace:mytools;assembly=mytools" > < contentzone:mycontentzone x:name= "myzone" > < contentzone:mycontentzone.controls > < image x:name= "mypicto" source= "images/myimage.png" /> </ contentzone:devicepanel_contentzone.controls > </ contentzone:devicepanel_contentzone > </ usercontrol >   (note : mycontentzone.controls main canv...

hello. new tfs, , i'm hoping can me out little (i'll grateful). have 6 month trial version of tfs installed on relatively powerful machine. there 6 developers maximum @ time working on machine. there 1 project working on. working until added folder full of images. it's several folders full of images, , it's close 10,000 images.   ever since added images folder, tfs slow. when right click on top level project, visual studio hangs 30 seconds before displaying context menu. when right click on "images" folder, see same results. however, when right click on folder @ same level "images" folder, application repsonds immediately.   the other big problem getting latest. after right clicking @ top level , waiting 20 seconds or menu appear, clicking latest hangs visual studio (in "not responding" state) 5-10 minutes. begins getting latest, goes relatively quickly.   i have no clue wrong , beginning impact our productivity team. have absol...

i have company dimension.  within company dimension company code , company name attribute.  want create multi-value parameter report company name displayed parameter caption, yet company code used parameter value.  to include member in list.  any ideas?  thank you. hi, in report data pane, right click cube datasource , select "show hidden datasets", parameter dataset available under datasource. right click paramter dataset , select "dataset properties", pop dataset properties box, click query designer button open query designer box, in it, can modify mdx query, however, default, parametervalue,parametercaptionindented,parametercaption , parameterlevel available when specify parameter' available value's value/label. so, can overwrite parametercaption calculated member expression as want, example, [company].[companyname].currentmember.member_caption instead of default one. thanks, jerry ...

hello using tfs 2010 msf cmmi process template. want leverage tfs software development life cycle.  want capture use case review comments in tfs , know appropriate work item template. there work item template reviews. i'm not sure if can used capture use case review comment. per microsoft documentation, used capture results of design or code review. planning use "requirements" work item template define use case. please advice effective way capture use case/requirement review comments in tfs. thanks rasheed       there no particular constraint on use of review work items. can (and time) use them manner of reviews. typically, create work item child of requirement reviewing , set called date date review held on. items come during review, create tasks children of review work item can track completion of items discovered during review. in addition, tend update review work item have start , finish date not default. useful if doing offlin...

dear friends i using sql server 2000 reporting services. but customer not output reports he want reports excel 2007 output format or third party tool crystal xcelsius designer output format. i deploying reports share point server. how can make dynamic reports see with/without using excel 2007 or third party tool. thanks oz hi oz, try sql server reporting services forum answer question: http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1 thanks, mauli Archived Forums V  >  Team Foundation Server - Reporting & Warehouse

hi,   i use scope member calculation. example: scope ([1].[2].&[delta3 %]); this = ([1].[2].&[delta3], [measures].currentmember) / ([1].[2].&[3], [measures].currentmember); end scope;   how can alter member format_string "percent" ?   thx,   radu. my apologies, mixing query based calculated members , script based. try...   scope ([1].[2].&[delta3 %]); = ([1].[2].&[delta3], [measures].currentmember) / ([1].[2].&[3], [measures].currentmember); format_string(this) = "0.00%"; end scope;   SQL Server  >  SQL Server Analysis Services

we have number of databases run under sql 2012 database server, in sql 2005 compatibility mode. currently, database team switch compatibility mode higher version, since sql 2005 @ end of support. if experience issues applications connecting these databases, possible switch compatibility mode sql 2005? implications?? thank in advance time , in answering these questions. hi, yes, can change compatibility mode , forth between 2005, 2008 , 2012. compatibility mode doesn't convert database inner file structure. it tells sql engine treat t-sql code in database if running in sql 2005, sql 2008, etc. for example, following line fail in sql 2005 compatibility mode (because date type wasn't available) declare @x date -- fails in sql 2005 compatibility mode -- succeeds in sql 2008 , sql 2012 compatibility modes SQL Server  >  ...

hello, i started having problem 1 database morning in cannot open table in design or right click , "script table as...".  after either of these actions, ssms thinks long time , times out, popping error message shown below.  this occurring single db, other db's can both of these actions.  other developers having same problem. i tried restarting service, restarting ssms, nothing seems help.  checked memory in perfmon , there plenty available.  ideas on other troubleshooting steps appreciated! mark   error: script failed table '<table>'.  (microsoft.sqlserver.smo) for help, click: http://go.microsoft.com/fwlink?prodname=microsoft+sql+server&prodver=10.50.1600.1+((kj_rtm).100402-1540+)&evtsrc=microsoft.sqlserver.management.smo.exceptiontemplates.failedoperationexceptiontext&evtid=script+table&linkid=20476 ------------------------------ additional information: an exception occurre...

hi, i've built enterprise data warehouse using multi-dimensional hypercube , mdx.  it works fine, , performs well, supporting raft of ssrs. the business wants self-service.  well, suppose could wait until i've got powerview on mdx . . . wouldn't address issue of provisioning simple , easy access data structures each business function. so, i'm thinking of creating number of data marts using bism tabular, , using hypercube dw 1 source of truth.  certainly, since has calculations , kpis in already, not want lose loading data marts underlying relational constellation. anybody tried , has experiences share? cheers, donna kelly http://www.donnapkelly.com/ donna kelly hi donna, tabular solutions use relational modeling constructs such tables , relationships modeling data, , xvelocity in-memory analytics engine storing , calculating data. multidimensional solution use olap modeling constructs (cubes , dimensions). tabular models provide data ...

  when try install sql server 2008 february ctp (german) using command line   e:\servers\setup.exe /q /action=install /features=sqlengine,tools,bol /instancename=z1 /securitymode=sql /sapwd=xxxxxxx /installsqldatadir=c:\ /sqlsvcaccount="nt-autoritÄt\system" /agtsvcaccount="nt-autoritÄt\system" /browsersvcstartuptype=2 /sqlsvcstartuptype=2 /agtsvcstartuptype=4 /sqlsysadminaccounts="vordefiniert\administratoren" /tcpenabled=1   the installation aborts return code 0x84b10001.   afterwards file   c:\programme\microsoft sql server\100\setup bootstrap\log\20080306_1609\z1testxpsp2_20080306_1609_detail_componentupdatesetup.txt   contains these messages @ end:   03/06/2008 16:11:12 slp: ---------------------------------------------------------------------- 03/06/2008 16:11:12 slp: running action: preparelaunchbootstrapsetupaction 03/06/2008 16:11:12 slp: completed action: preparelaunchbootstrapsetupaction, returned true 03/06/2008 16:11:1...

hi,   what best way have native win32 code tell sql server 2005 express synchronize merge replication?  api should use?  should exec distrib.exe and/or replmerg.exe command line utilities?  should use "windows synchronization manager"? other options?   thanks,   bryan there alternative called windows synchronization manager, coverd below microsoft.  there little info on subject because think replication not needed in cases.   http://technet.microsoft.com/en-us/library/ms165686.aspx SQL Server  >  SQL Server Express

hi , my requirement data server , put serverb. have somany joins in source query , temp tables if run query in ssms runs fine, put same query in data flow ole db source task, receive error. below code, lareg dont think need worry code @ working fine select dbo.hs_claim.hsclaimnumber claim_number, min(hs_payment_vw.hscheckdate) min_check_date,dbo.hs_claim.hsdatecreated into ##1 from dbo.hs_claim left outer join dbo.hs_transaction trans on hs_claim.hsclaimid = trans.hsclaimid left outer join dbo.hs_transaction_code_vw tcode_vw on trans.hstransactioncodeid = tcode_vw.hstransactioncodeid left outer join hs_payment_vw on trans.hspaymentid = hs_payment_vw.hspaymentid where hs_payment_vw.hsstatus = 'payment complete'and tcode_vw.hstransaction = 'payment'and tcode_vw.hstransactiontype ='indemnity' group dbo.hs_claim.hsclaimnumber,dbo.hs_claim.hsdatecreated select distinct dbo.hs_claim.hsclaimnumber claim_number,t.min_che...

 i have datetimestamp in sql database. when select * personinfo datetimestamp column 0x00000000000007d8 how can see time is. because binary data, help me on this thank you max just add reddy has mentioned... timestamp in sql server has time or date. kind of misguiding naming convention. ts in sql server sequence binary number @ db level. not same current_timestamp in oracle madhu mcitp, mcts, mcdba,mcp-- blog : http://experiencing-sql-server-2008.blogspot.com/ SQL Server  >  Getting started with SQL Server

hello, what steps turn off strong password restriction policy in sql server 2008 r2 ? thank you. hello, the force of password policy defined per sql login, it's not global sql server setting. olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Setup & Upgrade

hi ,  i tried restore database in sql server 2012 in windows 8. getting error , there several files worked before in restoration not working : title: microsoft sql server management studio ------------------------------ restore of database 'classifiedspak' failed. (microsoft.sqlserver.management.relationalenginetasks) ------------------------------ additional information: system.data.sqlclient.sqlerror: backup log cannot performed because there no current database backup. (microsoft.sqlserver.smoextended) help, click: http://go.microsoft.com/fwlink?prodname=microsoft+sql+server&prodver=11.0.2100.60+((sql11_rtm).120210-1846+)&linkid=20476 ------------------------------ buttons: ok ------------------------------ thank , shan ali khan you getting error because database trying restore not same backups taken. backups taken different database , trying restore different database. you have 2 options here. use replace whi...

is there way have curling effect 1 corner (for example: right-bottom) in canvas or image?   frank wu hi frank, by " curling " believe effect you're looking refers more kind of page flip corner  effect... right? if that's effect want recreate can have @ following links http://blogs.cynergysystems.com/2009/11/13/the-secret-behind-the-page-flip-technique/ http://antonidol.wordpress.com/pagecurl/ hope helps recreate effect want.  if answers question, please mark answer . thank you. Silverlight  >  Designing with Silverlight

i porting actionscript code silverlight , ran problem. in flash inherit socket , create game socket handles parsing incoming data etc...and gives me nice clean interface game development. however, keep getting error when try in silverlight:  inheritance security rules violated type: 'omegahyperonclient.ohsocket'. derived types must either match security accessibility of base type or less accessible.  if base class has non-transparent default constructor, derived class must have default constructor, , method inheritance rules apply across 2 methods.   what's deal? how fix this? can see class declaration of socket class?     sorry, discovered reason. silverlight running in transparent security mode can inherit other transparent classes. socket in safecritical mode cannot inherit in silverlight application. Silverlight ...

i developing custom report item special esri mapping project working on. have map rendering , able create "click-through" action via createactioninfowithdynamicimagemap , action.instance.hyperlinktext options, sends report viewers out related google map @ translated lat/lon coordinate. that's gravy. the problem have i'd modify send users separate report, or child report, gives them additional detail. example, if user clicks in virginia region sent virginia report , parameters of current report (some of multi-valued) passed on well. in other words can see sales country (us) > user clicks on va region > sales state (va). pretty easy canned controls action property configuration. however, noticed action property of custom report item "greyed" out. noticed case in polygonscri example well. normal functionality or neglecting set in designer? restricted doing in renderer involves building static url each action instance place in cri image map? have...

hi,   can regarding following error message: source db: sql 2005, using ms oldedb provider sql destination: oracle 10g, using oracle provider oledb.   in table “eventlog” have 800,000 rows , using oledb source(sql) , oledb destination(oracle) controls. after loading 702,000 rows getting following error , stops flow:   [d-eventlog [32443]] error: ssis error code dts_e_oledberror.   an ole db error has occurred. error code: 0x80004005. ole db record available.   source: "oraoledb"   hresult: 0x80004005   description: "row-00060: internal error: [dainsert,16]7". [d-eventlog [32443]] error: ssis error code dts_e_inducedtransformfailureonerror.   the "input "ole db destination input" (32456)" failed because error code 0xc020907b occurred, , error row disposition on "input "ole db destination input" (32456)" specifies failure on error. error occurred on specified object of specified component.   there ...

hi all, i have a  source csv file 1 million binary id's this.. 0x0000000000000002 0x0000000000000011 0x0000000000000020 now issue want avoid '0x's infront of these binary id's before loading destination csv file , need ssis logic convert these id's to.. 0000000000000002 0000000000000011 0000000000000020 thanks in advance, rh     sql if source being read strings (dt_str or dt_wstr), need add derived column transform data flow replace([column], "0x", "") expression in it. talk me on SQL Server  >  SQL Server Integration Services

hi all    how create server , client application in  silverlight please give me useful link . means when  a client has sent request server server has accept connection , reply client . thanks g dinakaran hi thanks reply got solution form url http://petermcg.wordpress.com/2008/09/03/silverlight-polling-duplex-part-1-architecture/ this 1 more full me thanks g dinakaran Silverlight  >  Hosting and Streaming with Silverlight

hi, can install sql server on nano server? or core edition supported? and question sql2016 , sql 2012, ssas 2016, ssrs 2016 , ssis 2016 (i have multiple stuff install) thanks. sql server 2016 not installable on windows server 2016 nano. olaf mentioned, can find more information regarding installation of sql server 2016 on servercore https://msdn.microsoft.com/en-us/library/hh231669(v=sql.130).aspx. this posting provided "as is" no warranties, , confers no rights. SQL Server  >  SQL Server Setup & Upgrade

any limit on sqlcecommand limits per sqlceconnection? wanted know if have limit on concurrent commnads can execute on single connection? may dumd question, new ce!! anilg hi, if you use only single connection access sql server compact database, 1 transaction have completed before start, restricting concurrency transactions. however, i’m not sure concurrent commands mentioned. think concurrency problems occur when multiuser access. if misunderstand issue, provide me more information situation? reference: multiuser access http://technet.microsoft.com/en-us/library/ms171750.aspx concurrency http://technet.microsoft.com/en-us/library/ms171845.aspx if there more problems, please let me know. thanks. ***xiao min tan***microsoft online community*** SQL Server  >  ...

hi team, i m trying increase log file size (ldf) im getting error modifiy file failed. specified size less or equal current size (mss sql server, error: 5039) tx subu hi team, i m trying increase log file size (ldf) im getting error modifiy file failed. specified size less or equal current size (mss sql server, error: 5039) tx subu from error it occurs when use alter database modify file , specify file size less current size , results in an error. way can reduce file size give storage operating system using dbcc shrinkfile . if want increase log file size use use master go alter database testdb modify file (name = testlog, --logical filename log file size = 2048mb) --specify target size > current size go SQL Server  >  SQL Serve...

i need pass table_name select statement.  doesn't work.   declare @variable set @variable   select * from @variable     bill please post t-sql questions forum: http://forums.microsoft.com/msdn/showforum.aspx?forumid=85&siteid=1   have tried using sp_execute_sql. argument procedure sql query string:   code snippet declare @variable set @variable   declare @query set @query = 'select * from' + @variable   exec sp_execute_sql @query     hope helps shuvro SQL Server  >  Data Mining

hi, dont have option sql compact 4.0 connecting db in web developper 2012 express. downloaded 4.0, ,  visual 2012 express desktop have option , works fine. how can activate web developper? hi edgarjupiter, you can refer following example create web application sql server compact 4.0. walkthrough: working sql server compact in visual studio: http://msdn.microsoft.com/en-us/library/gg606540(v=vs.100).aspx allen li technet community support SQL Server  >  SQL Server Compact

i have used dts in sql server 2000 import mdb filed (ms access) of table.  when table imported primary key lost , memo field data gone.  i use tranformation option in dts wizard add primary key , make sure data type memo field varchar , has size of 8000.  need large size since storing lots of html code.  when preview data see html code supposed imported.  however, when return rows table in enterprise manager field empty. so tried manually copy data ms access database sql server.  not figure out if sql server has interface ms access copy data table.  linked tables ms access sql server table.  when opened linked table see data in description field.  however, if return rows within sql server no data present. i have asp code trying read data in sql server table.  however, nothing returned , when run sql statement, nothing gets returned.  sql statement returns rows.  other data present nothing in description field.  what doing wrong?  any suggestions anyone, please! tia  it ...

database engine services failed the following error has occurred: object or column name missing or empty. select statements, verify each column has name. other statements, empty alias names. aliases defined "" or [] not allowed. change alias valid name. hi ecg2012, seems encounter similar issue described in following connect item. https://connect.microsoft.com/sqlserver/feedback/details/736753/error-installing-database-engine-services-instance-features-in-sql-server-2012-developer-edition-rtm-an-object-or-column-name-is-missing-or-empty work around issue, please use mixed authentication , not add local user during setup, try add users after installation finished. if computer part of active directory domain, can add domain user, not add local user account. however, if still fail install sql server 2014, please post sql server setup log other post. thanks, lydia zhang lydia zhang technet community support ...

i have change image source of multiscaleimage dynamically. i tried put code in page event: if (htmlpage.document.querystring.keys.contains( "id" )) { msi.source = new deepzoomimagetilesource( new uri( "output2.xml" , urikind.relative)); } but  a black sheet because seems deepzoom not read output_files folder in order build initial image. only if zoom in higher level (>8) can see images. any ideas solve issue? thanks reply, figure out problem. set source file called output.xml need folder called output2_files. however have changed source file generic handler (.ashx) , put in clientbin directory. if specified absolute path (eg. http://mydomain/output.ashx ) or parent folder (eg. ../output.ashx) multiscaleimage not work reported in post; http://forums.silverlight.net/forums/p/97805/223854.aspx Silverlight ...

hi, could kindly me ?  i have problems tfs report it should not show work items without changesets linked, show if or work item had changeset linked before, , link removed. worked fine until removed links changesets items. i query factworkitemchangeset table, , problem values of removeddatetime column same magic dates 01.01.9999 l they same both work items having changesets , work items not have changesets (they removed day). does have idea, what’s wrong? may i’m querying wrong table/column? thank in advance, evgeniy. hello evgeniy, thanks post. , still have issue now? and in opinion root cause issue tfs_warehouse not latest version. know data in tfs_warehouse database postponed. think should refresh manually. please refer time more information detailed steps how process tfs warehouse , analysis services databases manually: http://blog.accentient.com/2010/04/08/manuallyprocessingtheteamfoundationserver2010datawarehouseandanalysisservicesda...

can me in how deploy windows azure project on successful build staging in tfs 2010 hi swetha9, thank post. deploytoazure allows automating deployment of windows azure project , making part of tfs 2010 build process without using powershell , azure management cmdlets. solution includes: a set of custom workflow actions wrapping azure management api operations such getdeployment, getoperationstatus, newdeployment, removedeployment , setdeploymentstatus; helper actions such findpackageandconfigurationfiles, loadcertificate , waitforoperationtocomplete; designer activity deploytoazure implementing deployment logic ; reusable build definition template. step-by-step instruction can refer http://deploytoazure.codeplex.com/wikipage?title=how-to%3a%20deploy%20to%20windows%20azure%20from%20tfs%20build%20using%20deploytoazure&version=1 . other articles refer: http://blog.slalom.com/2011/08/19/building-and-deploying-windows-azure-projects-using-msbuild-and-tfs-2010/ http...

hi, i need convert following mdx functionality stored procedure in msas 2005: select { filter([store type].allmembers, instr([store type].currentmember.name ,"*", 0) > 0) } on axis(0) from [sales] is possible use stored procedure "like" implemented under analysis services stored procedure project ( www.codeplex.com )? if yes, equivalent mdx query implementing same functionality? thanks , regards, santosh. hi santosh, the function 1 worked on analysis services stored procedure project. implements pattern syntax used in t-sql function as possible using % wildcard character, following query should work: select { assp.like([store type].allmembers, "%*%", [store type].currentmember.name ) } on axis(0) from [sales] however should aware using builtin instr() function noticably faster using stored proc. stored proc comes it's own when have more complicated filters or if is a user entered filters. ...

hi,   i need on updating table data....i want find out records below table , combine them one. example need combine first 2 records 1 , other 2 records single record. year columns have either null or data want combine such records 1 record instead of having 2 records.   table test division                 div_cd   market       group   year06  year 07 year08 california                 ca      income        donors     null   230           null california                 ca      income   ...

hi, if standalone sql server installation fails, how troubleshoot? causes failure pls explain how resolve taking causes? dear surya,  your step should mentioned olaf.log files gives whole lot of information why sql serevr setup failed.if read logs surely find out reason or clue why installation failed. this link  will give info how read sql server setup log files if follow prerequisites particular software installation chances of installation failiing less. make sure administrator in windows when install sql server setup alternatively can rk on setup.exe file , run administrator. hope helps please mark reply answer or vote helpful, appropriate, make useful other readers SQL Server  >  Getting started with SQL Server ...

hi, i confused.  can some1 me above differences? in addtion, have following questions : q1)  sql database included in vs2005 ? sql compact or sql mobile? , version? q2) if develop netcf app in vs2005 , assumed database sql mobile, then  can database used in mobile phone windows 6.1 may have sql compact , netcf 3.5?? thanks peace fruit of love 1) vs2005 comes sql express - can see in configuration manager. 2) if develop net cf app in vs2005 has db (sql server compact 3.5) yes - can deploy on windows 6.1 phone. you can find "compare sql server 3.5 compact , sql server express edition features" here http://www.microsoft.com/sqlserver/2005/en/us/compact.aspx SQL Server  >  SQL Server Compact

i need ftp-ssl.  can use ftp task ftps? , how?   thank you. newbie we use sftp. by default ssis ftp task doesnt support sftp. there free clients winscp can invoked ssis we use execute process task same. winscp client requires script file pass required commands (put,get etc) transfer of files , server. this blog wrote on same setting filename etc dynamically sftp http://visakhm.blogspot.in/2012/12/implementing-dynamic-secure-ftp-process.html http://winscp.net/eng/docs/guide_ssis and comparison between sftp , ftps , of both sftp easier setup http://blog.goanywheremft.com/2011/10/20/sftp-ftps-secure-ftp-transfers/ please mark answer if helps solve issue visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/vmblogs SQL Server  >  ...

hi ,  i know whether  "always on" can configured on sql2012 standard edition ... please let me know ..  regards k.muthus but not "alwayson availability groups", that is supported in enterprise edition. olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Database Engine

i have package in ssis 2012 catalog trying data teradata 13.10. connection not working me , keep getting error: ado.net source has failed acquire connection following error message: "could not create managed connection manager". connection works , package runs local desktop not ssis catalog. ideas why happening? tried oledb, ado.net & odbc connections. none of them work far. please help! hi shree40, when right-click on package under integration services catalog \ ssisdb \ <folder name> \ projects \ <project name> \ pakages \ <package name> , select execute... run package, package run under credentials used connect sql server management studio. please note need run package using windows authentication. as issue, please make sure account connects sql server management studio has required permissions make teradata, oledb, ado.net & odbc connections , access files outside ssis package. please select 32-bit runtime in advanced tab when e...

running ms2k3 webserver iis , php 5.2.5 my php.ini in windows folder containing among other things these 2 entries: extension_dir ="c:\php\ext" extension=php_sqlsrv.dll and file php.sqlsrv.dll located in php\ext directory i've restarted iis server php running , working fine. there else still check ? code snippet if (!extension_loaded('sqlsrv')) {     echo("not loaded"); } produces: not loaded. edit: dug logs: the description event id ( 2 ) in source ( php-5.2.5 ) cannot found. local computer may not have necessary registry information or message dll files display messages remote computer. may able use /auxsource= flag retrieve description; see , support details. following information part of event: php[2144]; php warning:  php startup: unable load dynamic library 'c:\php\ext\php_sqlsrv.dll' - specified module not found.  in unknown on line 0. nevermind didn't realize php installation using thread safe core dll should use extension...

就是我们公司自己封装了一个socket类，那天我们老大叫我把那个里面的异常整改下,它说那个里面的异常抛得不够详细,叫我整改  因为我对异常只能做些简单的处理,他要如果异常一抛出的 话,一看异常就知道是哪里抛了异常,而且是什么异常子类(因为我们所有的异常都是继承exception的,我要它对应的异常子类)，还叫我把异常整改好了写个文档给他看 比如说:throw new bmqexception(0, "socket close fail !");它要把这些异常抛得更详细 ,一看就知道是哪里抛出的,是什么原因导致了改异常？像这种的都要改 叫我明天得给他了 Archived Forums SA-SM  >  Silverlight (formerly WPF/E) Designer Issues (Forum Locked on 4/24/2012)

hi, how should expect have above error on working database? found microsoft employee comment saying should take 8 seconds never close... i ask because our experience error happens every day, 2-3 times in row.  from our experience never took less 20s , many times 1 minute, more. understand considered transient error , have retries in place, in dynamic world cannot expect have transient error retries on minute? nobody waits long. or last "transient" error on 1 of s3 database took 2.5minute. saw in comments on forum not 1 having such long waits. sla 99.99%, 4 minutes of downtime in month. losing users if happens every day, on 100 req/s on frontend visible thousands of users on every occasion... the second thing. wrong on sql db logic, error saying there no db on server name not have , never had... example: 'c87ea20397ca' (tracing id of '{5b1683b3-d1f8-4a0a-bb41-2215fd7c4f09}', today 19:08 utc). i know jan responded on https://social.msdn.microsoft...

hi guys. mi wcf working without issues in vs, in iis 7 present problem 500 my structure in deploy is. service url: http:// myservername /mysite/myservice.svc page url: http:// localhost /mysite/mytestpage.aspx and put clientaccesspolicy.xml file in my wwwroot folder. but not working.  this log iis7 2009-11-08 07:32:41 ::1 /tipificacion/ - 80 - ::1 mozilla/4.0+(compatible;+msie+8.0;+windows+nt+6.1;+trident/4.0;+slcc2;+.net+clr+2.0.50727;+.net+clr+3.5.30729;+.net+clr+3.0.30729;+media+center+pc+6.0;+.net+clr+1.1.4322;+officeliveconnector.1.4;+officelivepatch.1.3) 200 0 0 8 2009-11-08 07:32:41 ::1 /tipificacion/silverlight.js - 80 - ::1 mozilla/4.0+(compatible;+msie+8.0;+windows+nt+6.1;+trident/4.0;+slcc2;+.net+clr+2.0.50727;+.net+clr+3.5.30729;+.net+clr+3.0.30729;+media+cen...