Lun

hi all, i have dataform , want catch event when user trying edit data on dataform. i i.e. maybe ideally when clicking pencil icon on dataform to start editing data.   can give me hint how can catch event? hi, i suggest use  textinputstart event of textbox. hope helpful. Silverlight  >  Getting Started with Silverlight

hi, i need have print view or fax view of 3d drawings...for using kit3d library. can suggest how have black , white view of 3d model. thanks  hi rpadma,                 there no print function such presently.ie 7 directly supports print of silverlight content firefox doesnt. http://silverlight.net/forums/p/3905/11458.aspx#11458 http://silverlight.net/forums/p/12240/39427.aspx#39427   http://silverlight.net/forums/p/13917/45559.aspx#45559   Silverlight  >  Programming Silverlight with .NET – General

hi, i have following calculated field expression (from sharepoint) use witin ssrs report: =if(([due date]-today)>2,"green",if(([due date]-today)>=0,"amber","red")) how i change above valid ssrs expression?? thanks you use immediate iff construct =(([due date]-today)>2 ? "green":(([due date]-today)>=0 ? "amber":"red")) chuck SQL Server  >  SQL Server Reporting Services, Power View

hi, i have 2 machines here on lan. both used connect , log on remote (internet) sql server 2012 successfully. client using ssms. as of yesterday, 1 machine can still connect server, , other cannot. before attach error dump let me have 'repaired' sql server files, , have 'restored' os point 4 days ago - no avail. have scanned viruses - norton did not find any. running out of ideas. short of re-installing - have ideas?? the 'bad' machine running windows 7 pro of latest updates. running ssms off of sql server 2012 developer edition. here error dump. feedback welcome. thanks, pb title: connect server ------------------------------ cannot connect <server name>. ------------------------------ additional information: a connection established server, error occurred during pre-login handshake. (provider: ssl provider, error: 0 - wait operation timed out.) (microsoft sql server, error: 258) for help, click: http://go.microsoft.com/fwlin

i have list of main categories , sub categories in going have repeater load main categories , sub categories within each main category. don't know best way start sql. tried following: table1 (maincategories) maincatid (pk) maincatname table2 (subcategories) subcatid (pk) subcatname maincatid (fk) started idea , couldn't write stored procedure load data correctly, can let me know kind of process can do? thought of using 1 table main , sub categories wasn't sure how that. in advance. hi elbasha, sean has pointed out table structure looks fine, nothing wrong in it.  thing add - result getting whatever query wrote fine , showing result expected to. issue talking display issue, , guess should put question on forums of whatever front end application using.  sql not meant handling display issues. of xml can subcats in comma separated format in single field, guess not want. if creating report out of, advance reporting tools can fulfill requirement groupin

i playing around log shipping , cant find anywhere... can browse data if database in restoring state.. (read only). if put database out of of state (restore database <dbname> recovery;) can not put back, right? thank can please write example how can switch that? microsoft msdn  / technet web sites contains many samples: restore database backup description: http://msdn.microsoft.com/en-us/library/ms177429.aspx restore syntax: http://msdn.microsoft.com/en-us/library/ms186858.aspx sample: restore database mydatabase disk='c:\demo.bak' norecovery go -- restore log backups. restore log mydatabase disk='c:\demo1.trn' norecovery go -- standby db not accessable restore log mydatabase disk='c:\demo2.trn' standby go -- standby db accessable readonly restore recovery default behavior leaves database ready use rolling uncommitted transactions. additional transaction logs cannot restored. select option if restoring of necessary b

hi, i confused difference between snapshot , snapshot replication. when need use snapshots in sql server 2005 hi michael, 1.database snapshots : database snapshots new enterprise edition-only tool, introduced in sql 2005, provide read-only, "virtual" copy of database, @ given point in time. 2.snapshot replication: snapshot replication distributes data appears @ specific moment in time , not monitor updates data. when synchronization occurs, entire snapshot generated , sent subscribers. 3.major difference: snapshot replication can used itself, snapshot process, creates copy of objects , data specified publication, commonly used provide initial set of data , database objects transactional , merge publications. 4.the purpose have use snapshots in sql server 2005: database snapshots allows create read-only copy of database can used other purposes, such reporting, auditing or recovering data. currently, can running backup , restoring database. however, big

hi all, have datagrid in silverlight application binded row group header.what wanted add hyperlink in group header beside group header text binded now... faced problem before??? thanks, prasant hi prasant, to add hyperlinkbutton datagrid groupheader, can edit style of groupheader below <datagrid:datagrid x:name="peoplelist"> <datagrid:datagrid.rowgroupheaderstyles> <!-- style groups @ top level --> <style targettype="datagrid:datagridrowgroupheader"> <setter property="template"> <setter.value> <controltemplate targettype="datagrid:datagridrowgroupheader"> <stackpanel orientation="horizontal"> <textblock text="{binding name}"/> <hyperlinkbutton content="xxx" /> <

hi all, i have column in table of type varchar(255). need insert data table table , column type @ destination int. used following sql says columnname  conversion failed when converting varchar value '212' data type int. select  case when columnname in ('na', '') '0' else cast(columnname as int) end  from table i have value 212 in column why having trouble converting it? please advise, in advance. there invisible characters in column, numbers ok here. take @ blog post extract numbers string extracting numbers sql server premature optimization root of evil in programming. (c) donald knuth naomi nosonovsky, sr. programmer-analyst my blog SQL Server  >  Transact-SQL

hi, can tell me if sql server 2012 availability groups can used sql clustering, i.e if can use shared storage availability group opposed mirroring local copies each server? thanks so sql 2012 availability group cannot use shared storage (considering enchancement of sql mirroing based technology).   sql clustering requirement fact each participating sql server instance must in same windows domain, because must create windows server failover cluster (wsfc) contains participating sql server instances. sql server uses underneath uses several wsfc features quorum model etc. in sql 2012 alwayson availability group. as there not shared storage availability group offers readable replica's ability take backup on secondary database. SQL Server  >  SQL Server Database Engine

hello i new world of databases. design database basic accounting system , payroll. deeply appreciate if refer tutorials/samples design of accounting system in sql server (or in general, databases) can model system in professional way. many why in world want this?  there many apps cheaply out of box.  mean, can buy accounting @ costco.  take @ least year make basic accounting system payroll - , payroll very, complex. aaron alton | thehobt.blogspot.com SQL Server  >  Getting started with SQL Server

is there doc on topic? hi danny i not sure expecting us, please give more details. if looking remove database mirroring completly here command remove database mirroring... how remove database mirroring ? 1.         connect to   either   partner. 2.         issue following t-sql statement. 3.         alter   database   < database_name >   set   partner   off nareshkar pakanati  mcts , mcitp specialist my blog : www.mssqlfix.com twitter: @mssqlfix ------------------------------------------------------- please mark post answered if answers question. ------------------------------------------------------- SQL Server  >  Database Mirroring

i have 2 related partition elimination questions. 1. how can know whether sql server (2005 or 2008) making use of partition elimination when executing query?  plan somehow show this?  if so, looking in plan?  i'm not @ reading plans @ point more descriptive better. 2. in terms of performance, isn't partition elimination (if possible) going produce better, in terms of performance, results?  if so, there way somehow force sql server make use of partition elimination?  provided me link: http://msdn.microsoft.com/en-us/library/ms345599.aspx and impression sql 2008 going better job @ partition elimination v.s. sql 2005 because of how partitions treated in sql 2008.  true?  of initial tests aren't proving out way , i'm wondering whether i'm not providing sql appropriate information such can make use of partition elimination.  i've provided sample query @ bottom this post.  there results after query interpreted microsoft db consultant.  , yes, eav type schema. kind of

hi all, i have faced different issue in cluster server 2008.  unfortunately msdtc has corrupted on windows 2008 server(cluster). my query how resolve msdtc issue , @ same time impact on sql server cluster 2008. can reply issue asap. thanks in advance. ram doe help? http://support.microsoft.com/kb/294209 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 SQL Server  >  SQL Server Replication

hi, installing sql 2005 x64 standard instance on server. can please tell me or link best practices ? for example, can assign higher priority system resources instance ? are there security related, performance related, maintainance related topics aware of, adding instance server ? thanks help. regards. hello, consider following balance memory usage across instances: http://msdn.microsoft.com/en-us/library/ms178067.aspx  (running multiple instances of sql server) if planning have multiple instance of analysis services, following link may help: http://msdn.microsoft.com/en-us/library/ms174906(sql.90).aspx if planning have multiple instances of reporting services, following link may help: http://msdn.microsoft.com/en-us/library/ms403426(sql.90).aspx hope helps. regards, alberto morillo sqlcoffee.com SQL Server  &g

hi, i trying use mdx sum across diagonal of cube.  example, if dataset looks like: postmonth........1..............2.............3..................4......................5 jan 2010......$10............$15..........$20 feb 2010.....$25............$30...........$35..............$40 mar 2010....$45............$50............$55..............$60................$65   in row "mar 2010", column "5", want show value $125 ($20 + $40 + $65). in row "feb 2010", column "4", want show value $60 ($20 + $40). in row "mar 2010", column "4", want show value $110 ($15 + $35 + $60).  thing can think of along these lines:   member [test] as [arbalance] +   ( [arbalance], [ar bucket dim].[ar bucket]. lag (1), [date of posting].[fiscal month]. lag (1) ) +   ( [arbalance], [ar bucket dim].[ar bucket]. lag (2), [date of posting].[fiscal month]. lag (2) ) but have kee

is 32-bit ssms (management studio) available download client box? tia, edm2 p.s. have seen sql server express 32/64 bit don't know if version of ssms equivalent version supplied full server product.  hi edm2, please tell if want use sql server management studio (ssms) of sql server express edition manage objects of paid sql server edition? firstly, sql server 2014 express release includes full version of sql server 2014 management studio, ssms in express , paid edition same. result, can use manage other sql server 2014 editions. secondly, can install 32 bit ssms of sql server 2014 express downloading from  https://www.microsoft.com/en-sg/download/details.aspx?id=42299 . sql server management studio express, express tools , express advanced services have full version of sql server 2014 management studio. regards, teige SQL Server

i trying deploy windows azure web site visual studio online. our solution (vs 2013) contains 3 asp.net mvc projects , first attempt deploy using auto generated build definition worked fine deployed wrong project (it took first 1 found). to solve changed "2.1.solution build" solution file csproj file correct project. results in following error: [xxx].csproj (1090): build restored nuget packages. build project again include these packages in build. more information, see http://go.microsoft.com/fwlink/?linkid=317568. searching problem on site gives me http://social.msdn.microsoft.com/forums/vstudio/en-us/bef04ac7-c601-4f00-a701-19cc85298cbb/build-fails-on-nuget-package-restore?forum=tfservice where states run package restore before building. at http://docs.nuget.org/docs/reference/package-restore-with-team-build it states implemented (and work when run using *sln file). how should solve this? perhaps there way specify project deploy azure? hi martinwa, since th

hi  i have installed version silverlight 4 (4.0.41108.0) developer runtime. i have downloaded code:- http://www.silverlight.net/learn/videos/all/network-authentication-trusted-network-access/ when execute code using vs2010 rc, ie prompts me latest version of silverlight available install this " latest version silverlight 4 (4.0.50401.0) do think have more recent version installed? may need restart browser in order detect current version."  once install , run code using vs2010 rc, prompts me error  "silverlight developer runtime not installed". i badly stucked here.  either need silverligth developer runtime version greater than  (4.0.41108.0). where can ? kindly help. thanks in advance! satvir     hi，    may check if silverlight runtime is 89mb large.    http://www.microsoft.com/downloads/details.aspx?familyid=bf5ab940-c011-4bd1-ad98-da671e491009&displaylang=en    installed newest 1 version see in control panel/

hi all, can me. have vs2010 & tfs 2010 installed on local machine , had started use it. tfs setup on local 2008r2 database. all quite simple suspecting issues netbios got domain admin rename machine long name shorter 1 (so netbios name maches dns name). since haven't been able tfs. novice on tfs here bear me. in general getting message "can't connect database" suspecting had hardcoded old hostname in connection string, looked way change it. found tfsconfig remapdbs , set new name, no change. noticed tfs admin console had account applied network system, , (am pretty sure) configured specific domain account on install, set back. both times restarted iis - no joy. first tfs services error in event log: -------------------- server version = microsoft.teamfoundation.framework.server, version=10.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a service account = nt authority\network service machine name = vpc-bgerhardi2 exception message: t

we using ssrs 2008 sp3 applied. our reports using dynamic grouping , showing/hiding columns based on parameter values. have page number expression in page footer, , expression in page header creates display string report parameter values. without fail, if run report , select print layout, rrrenderingerror in report viewer component. if remove page number expression page footer, , remove header expression, report works fine. also, without changes, report works without error in ssrs 2012. i've included of output reportserver log file. there fix problem, or work around not include removing header/footer expressions? library!reportserver_0-4!1750!04/30/2013-10:50:35:: info: renderfromsession('/open purchase orders') webserver!reportserver_0-4!700!04/30/2013-10:50:35:: info: processed report. report='/open purchase orders', stream='' reportrendering!reportserver_0-4!1750!04/30/2013-10:50:36:: e error: throwing microsoft.reportingservices.reportproce

ok, love language, something's been bit of pain me, , cant find in documentation.... if have string, how program recognise formatting. for example, if want program interpret list, , break down: "sausages, ham, bacon" how program recognise comma list seperator, or lets want length of string, or want split off every second char seperate var... ok, love language, something's been bit of pain me, , cant find in documentation.... if have string, how program recognise formatting. for example, if want program interpret list, , break down: "sausages, ham, bacon" how program recognise comma list seperator, or lets want length of string, or want split off every second char seperate var... choo, not sure you're looking exactly, but... to split string based on sub-string, you'd this: split="," string = "one,two,three,four" result = "" splitit() item=1 array.getitemcount(result)   textwindo

  hi.   i'm converting desktop application access ssce using powerbuilder ide. when try establish database connection using ole, message:   test connection failed because of error in initializing provider. database file has been created earlier version of sql server compact. please upgrade using sqlceengine.update() method.   i created database using latest version of sql server mgmt studio express , installed ssce 3.5. same messasge if try connect database using excel.   one odd thing after installed ssce 3.5, not see provider: "microsoft sql server compact ole db" in available providers list. found out registry entry missing ole db provider key. when inserted key see provider when set database connection profile error.   any suggesstions appreciated.     thanks,   john hi,        when said latest version of sql management studio, sql 2005 or sql 2008 ctp etc... dont think general ole db access sql compact supported. because, sql com

hi all, i have scenario have bound users accessing cube based on department belong to. a particular use should able see own department's data when uses organization dimension. my far though solution create multiple db views each filtered department wise, , have many cubes have department, @ time of deployment each cube connected appropriate organization view, use see organization data. is there better approach in someone's mind, wondering if possible apply role security on data , 1 step more applying on dimension itself. thanks. yes can restrict access elements of dimension.   this can done via roles.   hope help.   pierre SQL Server  >  SQL Server Analysis Services

hi, experts here, thank kind attention. i having question how create many-to-many relationship between 2 different attributes within cube? (e.g. in insurance case, want create many-to-many relationship between attribute broker , attribute assured company , as 1 broker may have many different assured companies insured under each of them, and each insurred company may insured under different policies under different brokers). seemed create 1 way relationship between them, cant make way around. common case in data though. please experts here shed me light on it? thank in advance , , looking forward hearing shortly. with best regards, yours sincerely,   hi helen, take @ great paper marco russo:   http://www.sqlbi.eu/portals/0/downloads/m2m%20revolution%201.0.93.pdf   there many examples in it, , probably also looking (may 1 bank accounts).   francesco     SQL Server

hi , i need create report in format. product1#: serial1#    serial2#  serial3# serial4#   serial5#   serial 6#(depending on howmany serial numbers attached product) product 2#: serial1#    serial2#  serial3# serial4#   serial5#   serial 6#(depending on howmany serial numbers attached product) could suggest best way go in ssrs 2008 thanks i able solve it. in case needs http://blogs.msdn.com/b/chrishays/archive/2004/07/23/horizontaltables.aspx i able solve it. in case needs http://blogs.msdn.com/b/chrishays/archive/2004/07/23/horizontaltables.aspx hi spydy2011, firstly, sharing such valuable solution scenario, horizontal tables good workaound achieve requirement, there no such build-in data region control. if else has innovative idea supply a better solution, great sharing. thanks, challen fu challen fu [msft] msdn community support | feedback us get or request code sample microsoft please remember mark replies answers if , unmark them

my model:   i try entity "entitytype" with referenced collections(entitymetadata, entitypartclrtype). in this way:             var objectcontext = new metadataentities();             var entitytype = objectcontext.entitytype.include("entitymetadata")                 .include("entitypartclrtype")                 .first(et => et.tag == "buildingorganizationstype");   all work correctly. entity and inside collections loaded. when realize in rias server side service:     [enableclientaccess]     public class entitymetadataservice : linqtoentitiesdomainservice<metadataentities>     {          public iqueryable<entitytype> getentitytypebytag(string entitytypetag)         {             return context.entitytype.include("entitymetadata")                 .include("entitypartclrtype")                 .where(et => et.tag == entitytypetag);         } client side code:  

hi all—— i know wf, wpf , silverlight based on xaml language……but different kinds of applications on things……so kind enough introduce them me？ can reguard wf, wpf extended silverlight？and silverlight "mother" of these products？ reguard , anyway！ hi timoyang. wf foundation develop workflow application, more information: http://msdn.microsoft.com/en-us/library/bb628474.aspx wpf desktop application development. silverlight web application development. i know wf, wpf , silverlight based on xaml language xaml xml holds information. xaml in wpf , silveright for ui display. xaml in wf workflow display       Silverlight  >  Getting Started with Silverlight

hi all, i'm starting work spatial in sql server, have hit wall.  have database of 16 million x/y points each in different record, want buffer (stbuffer) each point 10 metres, overlap (stoverlaps) each other, create new geometry polygon record in different table using stconvexhull.  can in mapinfo 10,000 points, looking t-sql solution. cheers, bill hi there, everything state possible t-sql in sql server, 16 million points it's going pretty intensive operation (or, rather, set of operations). i'm curious know reason why want (and also, going one-off operation only?) some other questions/clarifications: you're stbuffering each point 10 metres, , testing stoverlaps of buffered geometries. in case, you're trying in first step identify points in dataset a.stdistance(b) less 10 metres? (do want buffered geometries other reason?) you said want create polygon convex hull points overlap. want in case of 2 points buffers intersect? stconvexhull of these

i have silverlight app, , in same project have silverlight enabled wcf service (.svc file). trying deploy production web server, , restrict page using windows authentication. enable windows authentication in iis, , remove anonymous access, following error... security settings service require 'anonymous' authentication not enabled iis application hosts service. i've read many posts , articles none of them apply me i'm not using full wcf service, silverlight enabled one. have played around various configurations various posts have read nothing has helped. changes need make web.config or servicereferences.clientconfig files allow windows authentication? thanks hi muthu, i aware silverlight supports basichttpbinding. not trying secure communication between silverlight application , service, secure page silverlight app running on. looks might have put service on 1 website , silverlight page on another.

i installed sql2005 x64 default instance on clean install of windows 2003 64bit standard on machine dual 64bit amd processors , 4gb ram. when bring server properties in sql mgmt studio, shows "microsoft sql server standard edition (64-bit)", platform=nt amd64, 4gb ram. rest of properties show if 32-bit. shows 4 processors instead of actual 2. in memory page of instance properties, shows awe box ready checking , maximum memory listbox not allow value more 2gb, if sql2000 standard. is there else need make sqlserver 2005 instance realize sql2005 , 64-bit , can address ram above 2gb limit? or seeing memory screen not show it? going on? on machine max memory box allows value of 2147483647 field in mb allow 2 peta bytes of memory. the number processors 4 because cpus dual core, i.e. 2cpus = 2x2cores = 4 cores , reported. on intel box can end 2 cpus, = 2x2cores x hyperthreading = 8 SQL Server

1. in project while loading 10000k records java app seems getting later in stored procedure tooks lot of time process it, please let me know general causes performance delay sample blogs, url's. 2. examples how, order by is better sort , group in sql server. thanks in advance!. to start off analyze problem query using execution plan , /or profiler. give details of costly steps within it. see how can optimize steps adding proper indexes, rewriting logic,filtering required data etc. please mark answer if helps solve issue visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/vmblogs SQL Server  >  Getting started with SQL Server

i have web app has 2 database connections. one default connection used identity models. they both uses same database in local development environment , works fine. however when publish azure, identity model creates separate s1 standard tier sql database when run application. how prevent creating new sql database , uses 1 have? could explain languages , tools using develop application , publish azure?  thanks, -eli Microsoft Azure  >  Azure SQL Database

hi all, trying use rollupchildren function , not working expecting. please see blow sample mdx, based on understanding same value rsa ressler sales amount measure, here rsa giving null? with member [measures].[rsa] rollupchildren ([measures].[reseller sales amount],"+") select { [measures].[reseller sales amount], [measures].[rsa] } on columns, { [geography].[geography].[country].&[united states] } on rows [adventure works] thanks, gaurav http://gauravsqlserver.blogspot.com this because have passed measure rollup children , measures not have children. need pass member in hierarchy has children. rollup children using supplied unary operators. so not create measure function, instead create calculated member in dimension. eg. with member [geography].[geography].[united states test]as rollupchildren ([geography].[geography].[country].&[united states],"-") select      {     

i have stored procedure queries several tables server a.  result set proc inserted sql server table on server b. i'd use stored procedure in ole db source task when throws error because tries validate temp tables (used in stored procedure) exist before created. i have tired setting delayvalidation=true on tasks , retainsameconnection=true on connection.  still error when trying click on columns.  error complains temp table referenced in stored procedure. any suggestions?     hi, where did create temp table, in stored procedure or task? if in sp, should work. if create temp table in task, have ensure processes in same session. possible create , use temp table in same sp? or can refer workaround script componen: http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/thread/3abf19b0-6623-4d41-a19a-98c0ec257cff   hope helps, raymond raymond li - msft SQL Server

after getting latest on project (through h.exe /recursive option) project tries refresh (after clicking reload).  first of all, reload step taking anywhere 5-10 minutes (just reload project visual studio environment). in case, during reload process receive following error: "unsupported behavior warning iserviceprovider::queryservice called on background thread.  unsupported , may cause visual studio crash.  select faile abort call , return error caller. select ignore disregard warning , allow call succeed. additional information provided below. please report problem, details below, , instructions on how reproduce microsoft. (details:) service   : {b61fc35b-eebf-4dec-bff1-28a2dd43c38f} interface : {00000000-0000-0000-c000-000000000046} process id: 4020 (oxfb4) thread id: 1520 (0x5fo) ------------------- it has checkbox options for: - allow background calls succeed - not show message again finally, there 2 buttons can click: - fail - ignore first of all, caused error?  also, importa

i have sql 2005 sp4 (9.0.500) "full database" (all tables included)  merge replication 1 publisher , 8 "push" subscribers. has been working flawless (except fake update bug, is successfully resolved using com resolver) several years (from mid 2005 - started under sql 2000).  for 1 month, have publication, 1 "push" subscriber, replicating subset of tables. but, problems have started before introduction of publication. for @ least 2 months 1 of servers not accepting replicated updates on particular table. not updates, of them, happens. not happening, , leaves no trace anywhere. not in conflict viewer (since not conflicts), nor in replication monitor.  i have no idea how fight that. diagnosing running specific query, , made job to fake update in order real updates transferred, not way. seeking correct procedure on server, , advice can wrong. i've tried delete subscriber , add again, still happens. here am, open questions and advice's, , look

we currently have several cubes , applications deployed.  of our apps delivered excel frontend.  we deliver applications, typically provide training limited brief demo , document that describes application , how use it.  no problems.  no worries.  we have not trained user - or informed them - of ability directly connect cubes using excel pivot tables or functions.  concern in doing related performance.  have pretty large, flat dimensions.  , not quite geared train people on ad hoc usage. we use dynamic security typically allows user see specific list of departments.  there way set security can allow users access cubes via our excel applications optionally allow/prevent them direct access via pivot talbes? thanks, sully   what kind of excel applications have currently? set of excel pivot table reports? if so, want avoid users creating new reports want allow users use existing set of reports , should able change report filters?  it should possible add specific users have acce

  hi all,   i creating simple ssis package in business inteligence studio 2005. in going use webservice task. have assigned wsdl , configured http connection too. have selected service name , method called. have give 2 input values web method. need make dynamic. have planned assign variables input parameters. in webservice editor window there provision assign vales input parameters. how can assign valriables instead of setting values directly.   i have find in blogs there variable checkbox  available. cant find one..   any 1 plz let me know solution this   thankz what version of ssis have installed?  (help->about->sql server integration services) i think on 9.00.1399.00 (rtm) , need install @ least sp1, preferrably sp2. SQL Server  >  SQL Server Integration Services

hi guys, we facing issue production system query server inaccessible during sync. tabular model processed on different server , sql job used run sync command. can please tell me if normal or wrong. default behavior? memory/cpu usage ruled out. any pointers ? thanks. please specify sql server version while posting questions please mark answer if solved issue please vote helpful if helps solve issue can please confirm if works in sql server 2016? please specify sql server version while posting questions please mark answer if solved issue please vote helpful if helps solve issue SQL Server  >  SQL Server Analysis Services

i installed ssrs 2005 , have experience sql.   how come function not work?   select  substring(year_month, 1, 2) expr1 from     table1   i message states command not supported provider?   it works fine other sql tools winsql?   thanks refer responses identical post in transact_sql forum.   often, quality of responses received related our ability ‘bounce’ ideas off of each other. in future, make easier offer assistance, , prevent folks wasting time on answered questions, please d on't post multiple newsgroups. choose 1 best fits question , post there. post newsgroup if no answer in day or 2 (or if accidentally posted wrong newsgroup –and indicate you've posted elsewhere). SQL Server  >  Getting started with SQL Server

we running sql server 2008 r2 sp1. there scheduled transaction log backup using sql server maintenance job runs @ time of day. job runs fine on few days , fails few days , there no specific pattern. changed schedule run every 5 minutes , log backups fine first 3 attempts , started failing randomly. -- operating system error 53(the network path not found.) -- i not sure why fails few times , runs fine rest of times. backups going directly san storage , use unc path - e.g. \\vnvx\sql_backups\ sql server errorlog has following messages: backup error: 3041, severity: 16, state: 1. error: 18204, severity: 16, state: 1. backupdiskfile::createmedia: backup device 'n:\backups\userdatabases\database\db _backup_200911111511.bak' failed create. operating system error 53(the network path not found.) if fails on regular basis have checked permissions, sql server agent start id etc. fails few times , runs few times. job set run 1 retry after 2 minutes , 2nd attempt goes t

hi - newbie @ xml coluns in sql 2008 ... i have xml column user that looks this: <isirdatavalues xmlns=" http://schemas.datacontract.org/2004/07/etc " xmlns:i=" http://www.w3.org/2001/xmlschema-instance ">   <valuelist>     <isirvaluetype>       <isircode>aai</isircode>       <isirvalue />     </isirvaluetype>     <isirvaluetype>       <isircode>activedutymilitary</isircode>       <isirvalue />     </isirvaluetype>     <isirvaluetype>       <isircode>transactionreceiptdate</isircode>       <isirvalue>20120215</isirvalue>     </isirvaluetype>   </valuelist> </isirdatavalues> i want write sql statement update 1 of values ... ie: isirvalue isircode of transactionreceiptdate ... i have seen samples on web can't them work using [columnname].modify(replace value of ...) could please write quick update statement