Lun

hi all, we fetching data in our cloud server internal server through packages developed through import/export  wizard scheduled through agent. all these schedulers running fine, yesterday few schedulers failed due tds error. could please check below error , suggest me work around executed user: nt service\sqlserveragent. microsoft (r) sql server execute package utility  version 11.0.5058.0 64-bit  copyright (c) microsoft corporation. rights reserved.    started:  5:30:00 am  error: 2015-05-19 05:46:40.74     code: 0xc0202009     source: data flow task 1 source - xxxxxxxxxxxxxxx [33]     description: ssis error code dts_e_oledberror.  ole db error has occurred. error code: 0x80004005.  ole db record available.  source: "microsoft sql server native client 11.0"  hresult: 0x80004005  description: "protocol error in tds stream".  ole db record available.  source: "microsoft sql server native client 11.0"  hresult: 0x80004005  description: "p

i rebuilt our workflows in new rm 2015 install. contain few custom powershell scripts created tools/actions , installed throughout 6 stage deployment (3 stages per environment, stage 1 machines, 2 odd numbered machines included in stage 1, stage 3 numbered machines included in stage 1). worked fine in rm 2013 seems custom tools installed remote machine (agent driven) on first stage. tools part of stage 1 installed on machine , tools part of stage 2 (same machine) not installed , deployments fail. what doing wrong? did change or what? the reason deploy way keep half of our machines in order customers access our system without interruption. i able track down cause of tools not deploying. since entire process went through included building new 2015 rm environment talking agents assigned previous rm server, , re-assigned... tools directory in user/account/appdata/local/rm/t/rm had existing folders/tools. agent not smart enough create new folders or whatever tools. once dele

hi all, i have stored procedure returns 3 output parameters later want to use parameters next subsequent inserts. stored procedure. 1 create procedure [dbo].[sptransactioninsert] 2 @transactiontype varchar (255) , 3 @transactiondate datetime , 4 -- .... (more fields) 5 @transactionid varchar (50) output , 6 @transactionno varchar (50) output , 7 @transactionserialno bigint output 8 9 as 10 begin 11 12 -- transaction id if parameter value 0 13 -- (i.e) first time generate transaction id , send 14 -- next time same transaction id used 15 if @transactionid = '0' 16 select @transactionid = [......] from transactiontable 17 else 18 set @transactionid = @transactionid 19 20 -- transaction no if parameter value 0 21 -- (i.e) first time generate transaction no , send 22 -- next time same transaction id used 23 if @transactionno = '0' 24 begin 25

hi all- quick question: how export data first row of excel spreadsheet?  have tried: 1) making named range in target spreadsheet.  not work data export row beneath named range. 2) using openrowset property (sheet1$a1:d).  think should work, problem cannot map fields field appears in destination on mapping page "f1". i not need/want field names in destination spreadsheet. thank you! bonediggler ok - it.  there no way stop creating fieldnames - there connect issue open on problem , not fixed in 2012 either. http://connect.microsoft.com/sqlserver/feedback/details/573247/ssis-export-to-excel-creates-column-names-even-first-rows-has-column-names-is-unchecked see here couple work arounds: http://social.technet.microsoft.com/forums/en-us/sqlintegrationservices/thread/2aa5769f-f4f6-43a1-9481-afdd98346dc6 chuck SQL Server  > 

approach i we implementing saas shared database. having following schemas dbo.tbl_users client1.tbl_users client2.tbl_users dynamic connection string : datasource:local; userid=client1user password=client1pwd (we had created login user in database default schema client1. but though code , connecting dbo.tbl_users. instead of client1.tbl_users. approach ii we can add dynamically schema name based on client. in these case , need changes entire application. is possible approach i   hi, if object (including tables, view , ect.) without explicit schema name specified in query, object located searching default schema , dbo schema. in approach 1, if connect sql server using login client1 default schema client1, query should use client1.tbl_users in case. please make sure make connection using correct login, , default schema configured. fore more information, see how refer objects section in  http://msdn.microsoft.com/en-us/library/dd283095(v=sql.100).aspx . best

  how add accdb system database shown in sql 2008 r2? jason you have migrate access db sql server ! refer http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#access thanks manish please use mark answer if post solved problem , use vote helpful if post useful. SQL Server  >  Getting started with SQL Server

i have video wth markers embedded. each marker has unique name. i'm trying trigger events based on marker reached. so far have: void theplayer_markerreached(object sender, timelinemarkerroutedeventargs e)  {             htmlpage.window.alert("pow!!"); }   what i'm looking like: if (sender == marker1) {             htmlpage.window.alert("pow!!"); }  or if (marker == marker2) {             htmlpage.window.alert("bam!!"); } how done?   movie.markerreached += new void m_markerreached( object sender, timelinemarkerroutedeventargs e) { string mtype = e.marker.type.tostring(); // determine whether // marker 1 or 2 if (mtype == “name”) //suppose let marker1 name "name" { htmlpage.window.alert( "pow" ); } if (mtype == “name2”) //suppose let marker2 name "name2" { htmlpage.window.alert( "poww" ); } }   e.marker.type string name timeline markers ---

hi, i want able run schema comparison using this: https://msdn.microsoft.com/en-us/library/microsoft.data.schema.tools.compare.schema(v=vs.100).aspx   however, don't know dll i'd have import use (or be).  i thought maybe be microsoft.data.schema.tools.dll have no idea find it. does know how can use the microsoft.data.schema.tools.compare.schema namespace? hello joerne, there no public api available in ssdt accomplish this. please go through below msdn thread more details https://social.msdn.microsoft.com/forums/sqlserver/en-us/2512f0b6-c367-4eeb-a74f-ee610d6da911/schema-compare-database-programatically-in-c if post answers question, please click mark answer. if post helpful please click mark helpful. SQL Server  >  SQL Server Data Tools

i trying correct sub-total , grand total calculation product of calculated measure represents current running quantity * standard cost of item valid if calculated per site. tried using calculated measure after lot of research decided go cell calculation works item/site calculation , should honor sub-selects etc opposed scope doesn't. need sub-total sum of totals per item , site , not re-calculation of formula. able degree total end being individual item/site calculations plus item totals added in double amount. tried using except remove member , several other strategies. here code: create cell calculation currentcube.[balanceamount] '([item].[item groups - items].members,[site].[sites].members,[measures].[balance amount])'     as         case             when [item].[item groups - items].currentmember [item].[item groups - items].[all]                 then                     9999 // should total on                                 when [i

hi, have syntax error in this, please advise select #temp.*, select  distinct inv_id,             (                  select    '  ' + inv_id + ' (' + inv_type + ') '                  oth_inv_details a                  where    a.inv_id = b.inv_id                  xml path('')              )inv_type_description,              sum(inv_qty) over(partition inv_id) totalqty temp from  oth_inv_qty_loc b; select temp.*,         case when a.inv_usage = 0 0                     else cast ((t.totalqty) / a.inv_usage int)              end dsb  from   oth_inv_details  join temp t on a.inv_id = t.inv_id        1=1  or t.totalqty <= a.inv_rol try following... select distinct inv_id, ( select ' ' + inv_id + ' (' + inv_type + ') ' oth_inv_details a.inv_id = b.inv_id xml path('') ) inv_typ

dear all, a part enterprize manager how can query number of user connected prticular database. regards sufian you can use sp_who, sp_who2 , select user_name ( uid ),* from sys.sysprocesses where dbid = db_id ( 'somedatabase' )   madhu   SQL Server  >  SQL Server Database Engine

  hi i'm new analysis services , intall application start learning it.  have manage create cube dimensions.  issue when ever trying view data within cube or dimensions giving me following error msg:   "unable browse cube sales. unspecified error"   any idea missing?  while creating cube, manage view data in creating fact table step, tells me have connection database.  using access database source database analysis service example "foodmart 2000".   many thanks k hi, did manage deploy , process cubes?   radim SQL Server  >  SQL Server Analysis Services

hi i want temproraly stop cacheing when test stp procedure, there "set nocount" also need determine execution time of stored procedure, managment studio thinks 0!!, think there stoping performance measurment there , default. thanks help set nocount has nothing caching. asking set statistics on , set set statistics time . if yes check this http://www.sql-server-performance.com/articles/per/statistics_io_time_p1.aspx madhu mcitp, mcts, mcdba,mcp-- blog : http://experiencing-sql-server-2008.blogspot.com/ SQL Server  >  SQL Server Database Engine

hi, experts here, i wondering if bad practice put user tables master database? pros, cons? any suggestions or discusstions please? thanks. i looking forward hearing you. best regards, yours sincerely,     yes, bad practise.   go through idea. master database   master database records existence of other databases , location of database files , records initialization information sql server. therefore, sql server cannot start if master database unavailable.   so happened master sure whole server in trouble.  better keep safe normal user.   regards SQL Server  >  SQL Server Database Engine

hi we have scenario following: iis 7.5 server in dmz separated internal domain. each application on iis runs under separate application pool. ms sql 2008 r2 server member of internal domain questions: is possible use applicationpoolidentity of iis server (e.g. "iis apppool\myappapppool") login sql server using windows authentication considering iis server not part of same domain , network sql server? if not, there way can use windows authentication logins iis server set upin manner (standalone, not part of domain)   p.s. this approach works fine on iis server member of same domain sql server.... hi zam6ak,   is possible use applicationpoolidentity of iis server (e.g. "iis apppool\myappapppool") login sql server using windows authentication considering iis server not part of same domain , network sql server? the login in sql server can created windows account. recommend ask in iis forum see account related applicationpoolidentity. use

i new sql server experienced oracle dba.  have sql server 2000 database connect remotely sql 2005 database.  collation of msdb on sql server 2000 sql_latin1_general_cp1_ci_as , database im trying create view (call scottdb) in sql_latin1_general_cp1_cs_as.  there has not been problems in past doing sort of joins in the scottdb database.  created 2 new tables in scottdb (no problem), few associated indexes , new view joins both new tables existing table in database.  i receiving dreaded error:   cannot resolve collation conflict equal operation there nothing view, couple of easy little inner joins.  deleted tables , view, went machine directly in case 2005 management studio issue , received same error.  issue driving me wall.  can please talk me through best way fix it.  much appreciated scott   hi, you have collation statement before equal operation "casting" 1 coallation other. collation conflict prevent engine joining or comapring 2 values each other, example exp

in sequence queries , sub-queries executed sql engine? which correct ? a. primary query -> sub query -> sub sub query , on b. sub sub query -> sub query -> prime query c. whole query interpreted @ 1 time d. there no fixed sequence of interpretation, query parser takes decision on fly hi accessguru, the query sequence depends on type of query use. post, confused b option, take nested sub query example. nested sub query can nested inside other sub queries, select statement nested within select statement , return intermediate results. sql executes innermost sub query first, , next level. results of sub query query conditions of primary query. in case, query sequence sub query-> primary query, option b right answer. more information nested query, please refer article: http://www.w3resource.com/sql/subqueries/nested-subqueries.php#sthash.o0wi3mau.dpuf . if correlated sub query, sub query uses values outer query. sub query evaluated once each row proce

 all, i have downloaded , installed visual studio 2005 sdk 4.0, using tfs 2005. i creating new application, , can set reference microsoft.teamfoundation.workitem.  shows in list of available references, , bin directory contains multiple dlls , xml files. here's gets interesting.  intellisense doesn't recognize objects, if force creating object get: could not load file or assembly 'microsoft.teamfoundation.workitemtracking.controls, version=8.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a' or 1 of dependencies. strong name signature not verified.  assembly may have been tampered with, or delay signed not signed correct private key. (exception hresult: 0x80131045)   here's what's on machine: microsoft visual studio 2005 version 8.0.50727.867  (vsvista.050727-8600) microsoft .net framework version 2.0.50727 sp2 installed edition: professional microsoft visual basic 2005   77626-009-0000007-41187 microsoft visual basic 2005 microsoft visual

hello i need obtain current @@language within clr code of user defined type. when try execute sqlcommand "select @@language" on connection current context ("context connection=true") error "system.invalidoperationexception: data access not allowed in context.  either context function or method not marked dataaccesskind.read or systemdataaccesskind.read, callback obtain data fillrow method of table valued function, or udt validation method." is there way current sql connection langugae inside clr code of udt? robert hi robert, as error message indicated, please set dataaccesskind.read enable read-only data access user-defined functions. please see: [microsoft.sqlserver.server.sqlfunction(dataaccess = dataaccesskind.read)] public static sqlstring getlanguage() { using (sqlconnection connection = new sqlconnection( "context connection=true" )) { connection .open(); sqlcommand cmd = new sqlcommand( "select @@lan

this morning when arrived in office (6am. gmt) tables, views, ect. 1 of our databases gone without user interaction or scripts running. restore data yesterday in azure management portal, intresting if else had similar problems night. there geral azure sql problem? our server located in northeurope , db azure productive standards2. thank , best regards, michael michael , spoke morning , wanted circle on thread provide context others have hit similar issue. there bug in ssms such when 1 uses object explorer , right-clicks open query windows particular database, , particular database experiencing unavailability @ time, ssms default connection master database.  thus if 1 executes query in window, query fail , appear tables/schema absent because query executed against master database. this bug understand , fixing.  we releasing sql server management studio (ssms) on monthly cadence , newest bits can found here [ link ]. thank again michael raising issue on forums!

was using msde2000 everything worked. upgraded sql server 2005 express. now can't start server.   config file: < configuration >     < system.runtime.remoting >         < application >             < channels >                   < channel ref = " tcp " port = " 2000 " />             </ channels >         </ application >      </ system.runtime.remoting > </ configuration >   server code: remotingconfiguration .configure( "timesheetserver.exe.config" , ensuresecurity);   reboot pc. step through server. above line returns " only 1 usage of each socket address (protocol/network address/port) permitted" i've read blog - talks pooling when opening connections. haven't opened 1 yet, never mind many. i ran netstat -aon. apart few other ip's, says tcp 0.0.0.0:2000 listening   running xp sp2 if makes difference. i'll give 24 hour

this started wanted drop database , rebuild it. deleted database using legacy azure manage portal, disappeared list , drop appeared have completed successfully. we tried recreate new 1 exact same name noticed old resource did not release name. not use same name new database. after waiting few minutes disappeared new azure portal. bit name still tied up. thats when checked in sql management studio. sure enough database no tables name sitting there unresponsive. dropping sql studio resulted in message this: database 'edgeportalazure' on server 'wfhidkkhpr' not available.  please retry connection later.  if problem persists, contact customer support, , provide them session tracing id of 'eff663ea-c350-4d70-b370-9e8b8bf78503'. (microsoft sql server, error: 40613) removing using azure powershell resulted in message this: remove-azuresqldatabase : resource name 'edgeportalazure' not exist. continue, specify valid resource name. we had rep

what doing wrong? i have large table has multiple batch updates of > 100k records ea run, daily.  table bidirectionally replicated (trans w/ upd sub) , causes other subscriptions behind while sends data.  solution seems obvious, replicate execution of store procedure update vs replicating 100+k records every run.  however, problem causes msrepl_trans_version become out of sync between servers , future updates either not made or rolled primary server's values. you can recreate creating table, setting bidi, create simple sp updates rows , replicating execution of simplesp. * run simplesp on server (publisher), changes go server b (subscriber) - yay! * run simplesp or direct update on server b new value , not replicate, instead old values server a! or * run update directly (not using sp) on server new value , not replicate   for sort of high volume updates should use native bi-directional transactional replication opposed updateable subscribers variant using.

i created new database named testdb default properties ( selected "new database..." , pressed ok ). then added new stored procedure , saved it.   the problem stored procedure not displayed in "object explorer" under stored procedure folder. and when try use stored procedure, error " could not find stored procedure 'mystoredprocedure'". where stored procedure ? i'm sorry inconvenience .   i created new stored procedure , works fine new one. it sql server bug.   thank time. SQL Server  >  SQL Server Express

hello team, one of our job failed , can please tell extactly reason failed , should run fine? just read message, there stands clear error in it: login failed user "corp\u4ius288" ; account don't have permissions login data source. olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Tools

hello, on sql versions can see column named encryptor_type in sys.dm_database_encryption_keys indicates if databases dek encrypted either certificate or asymmetric_key. bol indicates column not exist on versions have sys.dm_database_encryption_keys. this quite useful when have mix of certificate , asymmetric key encryption. whats real story column, introduced in 2012 , remain on future editions? thanks dan it looks forgot tell me when added. check , add books online topic. rick byham, microsoft, sql server books online, implies no warranty SQL Server  >  SQL Server Security

hi, i trying connect sql server located on machine ip 172.16.xxx.xx remote machine i.e windows server 2012 r2 machine, each time error shown below. have added port 1433 in firewall inbound settings , enabled it. doesnt shown in list when netstat /a. need immeadiately resolve issue,thanks.   1. make sure sql server service running 2. if named instance, make sure sql server browser service running 3. make sure sql server configured allow remote connections 4. examine sql server error log messages confirming sql listening on expected network interfaces , ports 5. test server connectivity ping client machine 6. test port connectivity using telnet or powershell server , port (from step 4) client machine.  for example a. telnet <server-name> 1433 b. powershell: 1433 | % { echo ((new-object net.sockets.tcpclient).connect("yourservername",$_)) "server listening on tcp port $_" } 7. check firewall settings if step 5 or 6 connectivity test

  hi,   i have 3 packages. - staging package - dimension package - fact package   i wanna embed dimension , fact packages staging package so can run smoothly. how can it?   thanks, jerkus that fine.  change 'location' property 'file system'.   SQL Server  >  SQL Server Integration Services

hi all, hello sql server dba forum members, can 1 please send me u r 2+ , 3+ real time exp on sql server dba resume mail id ( m.kiran2010@gmail.com and  m.kiran2012@gmail.com ) . full me. searched on web didn't perfect match profile. so kindly please send me 2+ , 3+ sql dba resume. thanks in advance. munnuru k hi munnuru, although there no assisted support resume of sql server dba , if have technical questions during evaluation, please visit sql server on msdn for developers , sql server on technet professionals. understanding , support. regards, sofiya li sofiya li technet community support SQL Server  >  SQL Server Database Engine

hello everyone, i have been given new hardware server of mine distributor in replication topology.  going from 32-bit sql 2008 standard to 64-bit sql 2008 standard, , server name need same when upgrade done.  new server , running (with different name), , 'setup' possible migration quick possible. what steps need take to ensure replication start synchronizing left off when take server offline upgrade? i thinking... 1. shut down , disable sql services on current server. 2. rename new server needed name. 3. windows copy of databases old server new server. 4. attach user databases. 5. start replication agents. is possible? is there anything missing? will attaching distribution database work? what happens of sql agent jobs needed replication? thanks in advance. jarret i forgot mention of database files on san drives, makes me wonder if can use upgrade path.  can i... 1. configure new server , create databases on current server. 2. disable sql services , shut down new server. 2. di

hi all, i know if coded ui tests supported silverlight 5 in visual studio 2013.i have goggled a lot fetch information issue didn't proper information. only plugin silverlight 5 available microsoft.visualstudio.testtools.uitest.extension.silverlight   reference not avilable silverlight 5 projects. unable detect silverlight controls of application. it helpful if answer query. hope solution in forum. thanks, rakshitha hi, please see below steps enable coded ui test : 1. setup silverlight application include helper assembly enables ui testing. a. add reference microsoft.visualstudio.testtools.uitest.extension.silverlightuiautomationhelper in silverlight application. b. verify each silverlight control has a unique identification property. detailed description of procedure given in msdn article - how to: setup silverlight application testing. msdn article describes steps applicable silverlight 4 applications. these same instructions apply silverligh

i trying install on dev. box. need create new database, right? have install sql 2016 on y dev. box first? can use database sql 2016 server installed on different computer? thanks hi markgoldin, you need install sql server. you can create database refer below. give database name  you can use database different machine. i hope you. what exact purpose?  please mark answered if answered question or mark helpful if solve problem. SQL Server  >  SQL Server Reporting Services, Power View

hello:    developed website with silverlight 1 in year 2007 , firefox version version 2 then. recently found users upgrade firefox version 3 not view website. "needs install silverlight" mark  appear users install " silverlight 2 rtw (2.0.31005.0) " already.    old firefox version 2 not have problem view website. did mean need recompile silverlight project to silverlight 2 version hence compilent firefox 3?  any comment  appreciated.   dockking   try using newest version of silverlight.js site. it included in silverlight 2 sdk      Silverlight  >  Silverlight Installation and Setup

  hello all,   i have conditional split, there 2 outputs.   first output dataset inserted database.   second output dataset data exists in db. need update data.   i have doubt here. want insertion done first , updation. is there property set insertion or updation, maintains order of execution or priority of execution.   please ask me if need further clarification.   thanks, kapadia shalin p. the easiest way ensure updates occur second put output of updates raw destination file (or temp table) , use data flow (or execute sql task) to execute updates.    why need updates occur second?   SQL Server  >  SQL Server Integration Services

hello all,    case 1 -in place upgrade    in place upgrade windows 2003 64 bit r2 contains ssrs 2008 windows 2008 r2 64 bit. upgrade happened @ os level not @ ssrs level.    know  necessary steps should taken  prior/during/post  upgrade ssrs end  as can not rollback if there issue in place upgrade.   case 2-side side upgrade   side side migration windows 2003 32 bit  that contains ssrs 2008 windows 2008 r2 64 bit. side side  would happened @ both os level ,  ssrs level.   i know  necessary steps should taken  prior/during/post side side migration  from ssrs end. before doing take backups . in case of reporting services.. back symmetric key. more information. back report server databases , configuration files. more information. back customizations existing reporting services virtual directories in iis. please mark answer if solved issue please mark helpful if helps solve issue _____________________________________ thanks, shashikant

hello, i've created dsv based upon data source d use in in ole db data source, possible? when double click upon ole db data source connection manager not display dsv.  shouold able see it?  the data source using oracle view. thank you, rod you need create connection first. right click connection manager , select 'new connection data source'. in oledb source, should see new connection plus dsvs associated it. SQL Server  >  SQL Server Integration Services

i seem have recurring problem when trying load excel spreadsheet exists on network server sql server using ssis package have developed on local machine. if attempt use local c: drive, works fine. if change excel connection manager on excel source network location of file end error. i have altered validateexternalmetadata property options false , have changed data flow task property delayvalidation true. i'm wondering if it's sort of network issue chokes up. is there can try , work file on network server? or has experienced same issue? thanks review , hopeful reply. psulionrp not network issue.it due $ letter in sheet name invalid excel connection. arthur my blog SQL Server  >  SQL Server Integration Services

hi there, i have sql server authentication database in sql server, database need access olap cube using openrowset display results. sql server authentication has select , execute permissions on database. if map credentials sql server authentication login, can retrieve data olap cube. in credentials, have used windows authentication have administrator permissions olap cube. thanks, atrsams hi atrsams, according description, you log in sql server management studio using sql server authentication , write openrowset query retrieval data sql server analysis services database, want know if can connect ssas database or not, right? i have tested on local environment, created sql server login , log ssms , run query below. select a.* openrowset('msolap.5','data source=.;initial catalog=adventureworksdw2012multidimensional-ee', 'select {[measures].[internet sales amount]} on 0, [date].[calendar].[calendar year].members on 1 [adventure works] ') go the r

hi, i working on bi solution , me , mdx don't match take example 2 star-schemas "processes" , "licenses", following design: m1 » processes dimensions  - process, time, person, processstate granularity  process ( 1 row, 1 process tha person delivered in company @ point in time in state "waiting decision" or "done" example ) measures  number of process  cost of process m2 » licenses dimensions  - process, time, license granularity   license ( 1 row, 1 license company created project @ point in time ) measures  number of licenses i have calculate 2 complex measures, , boxing mdx achived ... measure 1 » ratio of processes licenses ( should easy as  number of process / number of licenses , need slice number of processes because want count process in state "done" ... whow can ? ) measure 2 » ratio of process licences ( again want slice number of process because want exclude top 5% , bottom 5% in  terms of cost of process

hey guys! i updating "install shield wizard" (called installtime) @ moment. have 2 problems. hope can me. that's code: ljm030 that's problems: - added few buttons. 4 of them bit special. if click them, should change caption. work first 3 buttons. fourth not want work.  used same code it... - next problem textboxes. added few of them, , everytime change side in them save. but, if go side not in boxes. difficult me explain better, miss right words. try yourself. write in every box on every side , switch between sides. see problem. thanks in advance. greetings timo point 1] i did format program set indentation , put writeline in: elseif caplcb = "no" controls.setbuttoncaption(sbutton[3], sbutcap[1][lang]) elseif caplcb = "nein" controls.setbuttoncaption(sbutton[3], sbutcap[1][lang]) elseif lcb = sbutton[4] 'spezialbutton ja/nein textwindow.writeline("here") capl

hi!  quick question.  have datagrid has "ticketnumber" col want make hyperlink.  need url in form http://somepath/defualt.aspx?numb={value in cell} there way this?  oh , i'm pulling data ria (entity db) if makes difference. thanks! joe, you need write value converter converts property contains number valid url. you can find more information at: http://msdn.microsoft.com/en-us/library/system.windows.data.ivalueconverter%28vs.95%29.aspx http://timheuer.com/blog/archive/2008/07/30/format-data-in-silverlight-databinding-valueconverter.aspx patrick Silverlight  >  Silverlight Controls and Silverlight Toolkit

for years, stuck using vs 2005 editing our ssrs instead of vs 2008.  when visual studio 2010 released, assumed @ least allow development of ssrs 2008 server-based reports.  no, seems ssrs development not included.  the big guestion why not?  ssrs report development considered secondary regular development (or worse secondary to crystal report development)? i felt need rant.  feel little better now. :) mike   hi mike, thank posting. visual studio 2010 allow develop reporting services 2008 based local report. however, mentioned, business intelligence development studio(bids) not part of visual studio 2010. may included in next release. i want suggest using report builder 3.0 instead. report builder 3.0 allow tasks done in bids. also, report build 3.0 lightweight tool. for more information report builder 3.0, please see: http://msdn.microsoft.com/en-us/library/dd207008(sql.105).aspx if have more questions, please feel free ask. thanks, jin chen jin chen - msft

hi, i have query contains 45,611 rows  executes in ssms (sql server management studio) 2008 r2 in 2 sec. in ssrs ,when preview report takes 4 sec,next deployed development server . after deployed same report , configured asp.net application here takes same 4 sec. next published asp.net application  in test server (same no of records), when try open report here takes more time, 10 sec . if again execute report  takes same time. see please clarify ,see doubt reports takes same time in test server asp.net application? or more time? why takes more time? how can solve this? please me new ssrs ? hi samba, from description, when execute query in sql server management studio (ssms) or preview report, takes 4 sec, , when open report on  application, takes 10 sec, right?  when execute query on ssms, query executed directly. however, open report on application, query should pass sql server execute, , return result application.  issue takes 10 sec on applicati

 i using this.content = new xmainpage(); redirect page xmainpage when comes page xmainpage , refresh page f5 page redirects loginpage again not know problem url showing same .aspx page silverlight control hosted, please suggest solution  thanks hi farjack, can set bookmark using code: system.windows.browser. htmlpage .window.eval( "window.location.hash='mybookmark'" ); you can bookmark using code: string currentbookmark = system.windows.browser. htmlpage .window.currentbookmark; now, can use switch case check bookmark using. cheers. happy coding. Silverlight  >  Programming Silverlight with .NET – General