Lun

hi, ssis package has only sendmail task. when run sendmail package ssis solution working fine  when deployed sql server , try run sql agent job not working. giving following error message. executed user:domainname\sqladmin. microsoft (r) sql server execute package utility  version 10.0.1600.22 64-bit  copyright (c) microsoft corp 1984-2005. rights reserved.    started:  11:14:19 am  error: 2009-12-30 11:14:20.17     code: 0xc002f304     source: send mail task send mail task     description: error occurred following error message: "unable send recipients.  system.net.mail.smtpfailedrecipientexception: mailbox unavailable. server response was: 5.7.1 unable relay abc@abc.com".  end error  dtexec: package execution returned dtser_failure (1).  started:  11:14:19 am  finished: 11:14:20 am  elapsed:  1.032 seconds.  package execution failed.  step failed. the user domainname\sqladmin not have relay permissions send domains outside of server domain.  please work smtp serve

 hi, i new silverlight , designer no coding knowledge. have 2 text boxes , 1 combo box , 1 slider callout, using silverlight 4 , expression blend 4. i made chages callout using styles, in place of thumb replaced callout controller. want want selected item combo box should appear in text boxes , callout in slider controller. should happen data binding how this.   thanks earlier responses appreciated . hey!  try use feature called "element binding" , u want. and have use "selected item" combo box, in order display selected item text box, easy thing implement. Silverlight  >  Getting Started with Silverlight

hi, my interface has actions, start(), b(), c(), d(), end(). i want generate tests start start() , ends end(). in between start , end, want b() or d() not c(). how specify in cord without declaring "except" in config. of course, not want to explicitly enumerate actions in cord. any thoughts? thanks, dharma hi dharma, you try this ( (_)* |?| !call c()*) || model) hope helps. Archived Forums M  >  Model-Based Testing with Spec Explorer

ok @ this: for p = 1 2   turn = 1 3     put = 1 turn       setdown()     endfor   endfor endfor i doing game battleship. little thing there must this: - progressively player 1 , 2 (p) asked put ships. - both put, 1 time ship type1. 2 times ships type2 , @ last 3 times ships type3 on boards.   ok setdown subroutine. in other parts of program created buttons in each spot. so getting bit of trouble making sub has this... - controls.lastclickedbutton , if value in button right, "you hit it" or if not "missed". whatever. now don't know how smallbasic works (still noob). want program wait click set down ship1, after click pass next waiting next ship. mean.   ^^ can more experienced give me little help? a bit first did put x value everywhere: for p = 1 2   = 1 10     j = 1 10       boxes[p][i][j] = controls.addbutton("x",i*width + positionx[p],j*height)     endfor   endfor endfor   so if u give me answer u

i having difficulty requiring client certificates on vstf web services. there known issues this? attempting have users authenticate smart card contains cert. ok, ain't good. got word microsoft can't done in v1. what!?!? department of defense required authentication internally-facing https resources secured through use of certificates (pki). we've been using vsts year , product on chopping block because visual studio doesn't pass certificate authentication vstf application tier. Archived Forums T-U  >  Team Foundation Server - Setup

when attempting create merge replication, snapshot failing create. how complete? sql 2008. have deleted , recreated replication did not help error messages: message: error raised during trigger execution. batch has been aborted , user transaction, if any, has been rolled back.  command text: sp_mssetartprocs parameters: @publication = broadcasts2 @article = schedule_lto_backup stack:    at microsoft.sqlserver.replication.agentcore.remapsqlexception(sqlexception e, sqlcommand command)    at microsoft.sqlserver.replication.agentcore.agentexecutenonquery(sqlcommand command, int32 querytimeout)    at microsoft.sqlserver.replication.agentcore.executediscardresults(commandsetupdelegate commandsetupdelegate, int32 querytimeout)    at microsoft.sqlserver.replication.snapshot.createarticleproceduresworkitem.makearticleprocedurestransaction(sqlconnection connection)    at microsoft.sqlserver.replication.retryablesqlservertransactionmanager.executetransaction(boolean bleavet

hello, i'm using c# express sql express. i can create database, create tables , can delete database cannot create database digrams. error says don't have valid dbo user or permissions impersonate. asks me if impersonate fails. ideas? thanks   in case first course consider error might telling problem is. account you're logging server have dbo rights? another idea may database doesn't have valid owner, check out post @ http://forums.microsoft.com/msdn/showpost.aspx?postid=120849&siteid=1  for discussion issue. regards, mike wachal sql express team ---- please mark thread answered when solution. SQL Server  >  SQL Server Express

hi experts, find below requirement, please suggest how go it? 1. first source sql server joining 2 tables (query) 2. second source mdb database (table) 3. delete matching rows table mdb database linking source mentioned in step 1. 4. insert rows step 1 table in mdb scenario: loading data query (sql source, step 1) table in mdb (step 2). if run package again & again, should not insert data mdb, instead, should remove matching rows target (matching rows determined 3 columns) , re-insert matching source rows target that, multiple run should not result in duplicates in target. please let me know steps go this. thanks in advance regards, naveen naveen j v you can of merge statement in code below, here comment out part can join multiple tables in step 1 create table #source (id int, srctexts varchar(10)) create table #dest (id int, desttexts varchar(10)) insert #source values(1,'test1'),(2,'test2'),(3,'test3') merge #

how see sp parameter values in profiler? suppose, sp2 called inside sp1 value in variable. begin declare @arg2 set @arg2 = 2 exec sp2 @arg2 end how see value of @arg2 in sql profiler while sp2 being called? ashru http://asharafaliptb.wordpress.com you need capture sp:completed   , sp:stmtcompleted event , in textdata column in profiler. SQL Server  >  SQL Server Tools

my company has software team , firmware team. software team uses microsoft visual tools. they have msdn licenses, , have standardized on tfs version control , work item tracking. on other hand, we, firmware team, use no microsoft tools. however, thinking of using tfs version control , work item tracking well. have been told firmware team needs purchase cal $500 per person. true? or should pay full price of tfs each user? thanks for licensing issue, best consult microsoft partner or local reseller. can find 1 http://www.microsoft.com/licensing/contact-us.aspx . ewald - please remember mark replies answers if help. blog: www.ewaldhofman.nl Archived Forums V  >  Team Foundation Server - General

i have main report calls 12 subreports.when preview main report , export pdf, 12 pages of pdf each report in each page.this works in windows 7, 96dpi setting. when migrate same solution windows xp- 96dpi setting, 13 pages including blank page first page. checked page width , page setting , seems quite fine. kindly 1 me in resolving issue regards, swathi acually page width , height correct.the problem in "font".sounds wierd???? yes, font used problem the reports developed in windows 7 uses font not available in list of fonts in ssrs the same has installed in migration server , reports worked fine:)   regards, swathi SQL Server  >  SQL Server Reporting Services, Power View

hi all we want create separate web server customer feedback outside of our intranet. result, need change tfs_url generated in customer feedback request email: mfbclients://<tfs_url>/collectionname/p<project_name>?rid=<work_item_ids> how can this? also, how can install services related customer feedback on web server in our dmz? thanks help nick thanks hi nick,  thanks post. tfs 2010 server url http:// servername :8080/tfs/ collectionname , do  mean want change servername in tfs url?    john qiao [msft] msdn community support | feedback us Archived Forums V  >  Team Foundation Server - General

hello everyone, i'm working power view in spain, trying have maps , problem name of spanish cityes granada, guadalajara, amd others.  all of them appear in american continent, because there somes cities there names.  any solution? i'll have same galicia "comunidad autonoma" in spain, if use galicia, apear in north of europa. thanks help ricardo   to solve conflict please read page . "map data can ambiguous. example, there’s paris, france, there’s paris, texas. geographic data stored in separate columns – column city names, column state or province names, etc. – bing may not able tell paris which. fix making geographic values unique. the place fix in data model, , not in power view. if data model in excel file (xlsx), in power pivot, create calculated column concatenates values in 2 columns create 1 unique value." SQL Server

hi,   i developing application takes data yahoo web service below code: string symbol; string yahoourl = @"http://download.finance.yahoo.com/d/quotes.csv?s=" + symbol + "&f=sl1d1t1c1hgvbap2" ;             httpwebrequest webreq = ( httpwebrequest ) webrequest .create(yahoourl); httpwebresponse response = ( httpwebresponse )webreq.begingetresponse();   the response object not expose getresponse() method use in asp.net httpwebresponse. please let me know how use httpwebrequest , httpwebresponse in silverlight.   thanks jaspreet singh   when try implement same functionality in silverlight causing me issues why???. because of mentioned in last reply. silverlight obeys written in policy file , doesn't allow request. sample works asp.net, not restricted in same way, works.  you can put code in page class in wcf service same (then query wcf service silverlight).

i have cordova app test on windows , iphone 4. however when test on iphone 6 screen scrolls , cannot see top of screen. can scroll the screen can see top dragging screen on simulator, when let go of mouse screen scrolls original position. i missing header bar have in ion-nav-buttons. i have seen posts setting cordova.plugins.keyboard.disablescroll( true ); but have tried different settings , makes no difference. problem persists. thank help. i found out wrong. on imac have set scale 50% works. iphone 4 scale of 100% ok. Visual Studio Development  >  Tools for Apache Cordova

is there equivalent datatype in sql .net stringbuilder raamakarthikeyan no there isn't way send contents of file parameter bulkinsert.  don't believe there's other method accepts contents of file parameter. jeff wharton msysdev (c.sturt), mdbdsgnmgt (c.sturt), mct, mcpd, mcitp, mcdba blog: mr. wharty's ramblings mc id: microsoft transcript please mark answered if i've answered question , vote helpful other user's find solution quicker SQL Server  >  SQL Server Application and Multi-Server Management

we have single sql server 2008 4 instanses. users , applications connect mssqlsrv\<instance name> . we plan migrate sql server new sql server failover cluster same 4 instances. test such migration. clustered instance server name in format mssql-<instance name> (services , applications - sql server (<instance name>) - server name). cluster name sqlcluster.domain.com. is possible use format mssqlsrv\<instance name> while connecting clustered instance? hi egoncharov, >> possible use format mssqlsrv\<instance name> while connecting clustered instance? yes, can uri mentioned. please check windows error log, if default instance can see server name below, if named instance can see server name , instance name log well. 2012-05-22 20:01:31.35 spid8s server name 'cccdwhdb01' . informational message only. no user action required. 2012-05-22 20:01:31.36 spid8s netbios name of local node running server 'cccdwhdb02'.   regar

how ata or ahci driver handle crc error reported disk drive when following cases occurred? 1. crc error occurred during 1 or more udma bursts, device reports error address(lba) first error occurred. 2. crc error occurred during 1 or more udma bursts, device reports error address(lba) starting address of command regardless first error occurred. besides, if device detects crc error has occurred before data transfer command completed, suggest device complete transfer anyway or abort command (stop data transfer immediately)? if choose complete data transfer whatever crc error detected during udma write bursts, there problem if write corrupted data media? -- ming-jiun your understanding not quite right. either of data committed permanent storage or none of it.  if there crc error in data fis, none of data shall written command.    there no way report part of write succeeded , part of write failed in ahci.  driver cannot find out the error at, , has no way tell file system part of th

i created maintenance plan backup on machine , created job using cmdexec command: copy  e:\\*.bak  \\remote\backup\  but copy job fail each time. i know command works fine when run batch file not seem work job in sql server.  try map remote machine drive , used drive in copy statementcopy e:\backup\*.bak  q:\backup\ still not work.  there need inside sql server? change network service local user/local system account. if have domain, create domain account exclusively sql services , start services account.   from below mentioned link : 1 important    microsoft recommends not use network service account sql server or sql server agent services. local user or domain user accounts more appropriate these sql server services.   read first : ms-help://ms.sqlcc.v9/ms.sqlsvr.v9.en/instsql9/html/309b9dac-0b3a-4617-85ef-c4519ce9d014.htm http://msdn2.microsoft.com/en-us/library/ms684272.aspx     madhu SQ

i have view in oracle reading data , inserting in sql server. when run "desc myview" command returns following: field1 number field2 number as can see both field types number. created similar table in sql server field type "int" when records inserted, in field2 inserting -1861 , 1876 instead of actual value oracle. field1 data fine. i have checked data in oracle fine , have no issues. have tried changing int float still same issue. reason? edit by way "preview" in ssis packages shows wrong values. know when drag , drop oracle source toolbox, select view name drop down list , when click "preview". oracle's number type not convert on directly, have found. there workarounds. http://social.msdn.microsoft.com/forums/sqlserver/en-us/d2ea5097-9cc3-4d84-b2eb-39c5acb80e0b/converting-an-oracle-number-data-type-to-sql-server-numeric-data-type?forum=sqlintegrationservices

hey guys i have storedproc in generate report in data is grouped timestamp. now need to group data day. i need generate report in excel in data grouped day. can advise me on this thanks justin paste sp sample date , can reply asap. otherwise can trying applying same logic sp, saying:- group by              datepart(day, column-name)   please let know feedback. thanks kumar kg SQL Server  >  SQL Server Reporting Services, Power View

we're getting familiar error on our tfs install. we've followed guide closely on win2k3 server running in windows 2000 native mode.   here's full error application event log: event type: error event source: tfs services event category: none event id: 3055 date:  7/19/2006 time:  6:08:16 pm user:  n/a computer: team-foundation description: the description event id ( 3055 ) in source ( tfs services ) 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: tf53010: unexpected condition has occurred in team foundation component. information contained here should made available site administrative staff. technical information (for administrative staff): date (utc): 7/19/2006 10:08:16 pm machine: team-foundation application domain: tfsgssinit.exe assembly: microsoft.teamfoundation.server, vers

we have scenario have agent jobs call ssis packages , override data sources , set vaules in circumstances.  have seen if opens job , looks @ step's properties, , if cancel out, data sources reset before changed them , set values gone.  bug , there rhyme or reason behavior. thanks in advance could please provide more details? 1) sql server version, sql management tools (ssms) version 2) management tools connected local sql instance or remote sql instance 3) if can script out job definition , sample ssis package, helpful understand root cause thanks sethu srinivasan [msft] sql server SQL Server  >  SQL Server Integration Services

we have multiple projects in tfs 2008, have configured few build in 1 of project, configure builds project, howeve there no build agent defined in project. our question can use same build agent defined in first project builds queued?. if define build agent in 2nd project both builds of project 1 & 2 can triggered in prallel, requires additional configuration in our situation. can still queue builds in sequence rather parallel.   yes can use same machine build agent 2nd project. when this, builds run in parallel project 1 , 2. ewald - please remember mark replies answers if help. blog: www.ewaldhofman.nl Archived Forums V  >  Team Foundation Server - Build and release management

hi i have 2 reports propertysearch , propertydetails. in propertysearch have  2 parameters propertynamesearch (textbox) , city (multi-select drop down). takes propertyname , few cities input , displays list of properties matching these two. list has link propertydetails need propertyid passes internally propertydetails. works perfect. but when in second report want go first report ( displaying results based on parameters) choose different property. have created parameters @propertynamesearch , @city in second report , set hidden. i'm passing these 2 values second report actual parameter propertyid.  have placed link first report in second report passes @propertynamesearch , @city first report. can pass @propertynamesearch problem cannot pass multi-value parameter @city between 2 reports. any or suggestions ? thanks! sqluser2011 that's okay, got it. i have created new parameter @citystring , set default t0 = join (parameter!city.value,",") . then i&

hi all,        have executesqltask result set stored in object variable called varrec. next in foreach loop container using enumerator foreach ado enumerator , have selected varrec object variable in ado object source variable. have selected varrow object variable in variable mappings map each row in variable each loop.  inside foreach loop container have script task following, 1. read row object variable (varrow), , store each column value in string 2. connect sql server - completed 3. select rows table, insert rows in table can 1 tell me how should achieve this. in advance.   some how know how connect sql server. please see below declaration , assignment source : http://msdn.microsoft.com/en-us/library/ms136018.aspx#y570   dim myadonetconnection sqlclient.sqlconnection         myadonetconnection = directcast(dts.connections("test").acquireconnection(dts.transaction), sqlclient.sqlconnection) sarvan why did mapped each row object type variable aga

i have setup replication in azure iaas environment using sql 2012. have large database of size 1 tb and replications setup  with 5 publications(around 200 tables) have filters few tables well. i see log reader agent , distribution agent jobs failing 'query timeout expired' , high sysyem usage. have changed agent profile setting -querytimeout 50000 , -readbatchsize 1, seeing issue, when ever there huge data update\loads on publisher database. let me know how identify problem , reason job failures. please suggest steps , necessary setting ensure replication agent jobs work inspite of heavy load.  hi divya, as per description, still face timeout issue though change agent profile setting. based on research, blocking result in timeout issue. recommend check if there blocking going on in publication , distribution servers. use sp_who or sp_who2 identify blocking process. blk column of sp_who , blkby column of sp_who2 contains spid blocking process, , use kill statem

hi there, preparing switch sql 2005/server 2003 sql 2008 r2 / server 2012.   took backup of sql database on 2005 (stored @ cloud backup provider nightly) , copied new machine.  unable restore .bak file, error: the media family on device <backup path> incorrectly formed.  sql server cannot process media family. restore headeronly terminating abnormally.  (microsoft sql server, error: 3241) tried 2 different backup files 2 different nights, same error.  i understand error can show when restoring lower version of sql, that's not case here. also, know can occur if bak file corrupt, , can't verify yet, 2 in row failed.  i'm hoping our cloud solution isn't part of problem somehow.   bak file 15 gb in size, don't have ability attempt restore on 2005 production server.   not enough room, , can't afford cause performance issues on box anyway. anyone know of way better handle on what's going on, or, better, how resolve it? thanks robin hi,

hi everyone, i trying make simple validation expression report on 2 datetime input fields start date , end date. need make so begin date<=end date both input boxes otherwise parameter prompt accompanies bad or no input. can assist me? t please refer post, may helpfull. http://gugiaji.wordpress.com/2012/03/26/easy-step-by-step-ssrs-parameter-validation-using-code/ regards, rsingh SQL Server  >  SQL Server Reporting Services, Power View

hi, does knows how make more 25 minutes smo version of scripting procedure @ least near of 2 minutes dmo version of same vb.net code? i've followed recomendations regarding setup setdefaultinitfields() before enumerating objects, etc. but if see profiler output objstoredprocedure.script(msmoscript) see genererates average 16 lines of tsql against database while same dmo operation generates 4 lines only! (multiply difference scripted objects , 2 dmo against 25 smo minutes) the difference between scripter.enumdependencies(objstoredprocedure, smo.dependencytype.parents)  , objstoredprocedure.enumdependencies(ctype(me.mdmoscriptdependencies, sqldmo.sqldmo_dependency_type)) huge... sample results using sql server 2000,  nothwind database, custorderhist procedure: smo code: dim tempscript stringcollection = objstoredprocedure.script(msmoscript) dmo code: dim tempscript string = objstoredprocedure.script(mdmoscript) smo scriptoptions used are:         msmoscript.default = true         ms