Lun

hi, i want add 1 more data file user database growing rapidly daily, , want add data file default table space without limiting file growth, , 1 more main concern system under merge replication. regards jakd   regards jak by table space (more of oracle term) presume mean filegroup. agree in part jeff, although suggest :- 1. there scope housing second file on second drive array/lun provide added io throughput - dependant upon storage controller bandwidth, storage subsystem setup etc. 2. in high volume circumstances there can benefits having multiple files overcome contention allocation pages (e.g. pfs, gam , sgam) issue in tempdb due frequent allocation , deallocation occurs in it. 3. if running enterprise edition, should contemplate having separate filegroup user objects due possibilities piecemeal restore , partial availability. hope helps. regards, mark broadbent. contact me through ( twitter | blog ) please click " propose answer " if post solves

 hi can tell me  how integrate paypal api in silverlight application both directcheckout , express checkout   thanks, vinay   hi vinay, i'm not familiar paypal api, fast glance. api group of webservice. since silverlight use wcf client access service, have possibility consume paypal api silverlight. however, note there additional security limitation silverlight access network resource, , silverlight version wcf sub set of wcf, binding cannot used. so, it's still question whether it's possible silverlight communicate paypal. there several talk paypal , silverlight may have see, may find research direction. http://forums.silverlight.net/forums/p/57700/146512.aspx http://betaforums.silverlight.net/forums/p/159428/357432.aspx#357432 and silverlight new feature: embed html in silverlight protential solution. http://www.silverlight.net/learn/videos/all/hosting-html-content/ thanks,

 with image tag, set source image displaied. put image file @ same folder xaml file , set source as: source = "test.jpg" it works fine. when created folder named "images" , put image file folder, , set source point new location, xaml can find image , got runtime error when run testing page: source="images/test.jpg" what's wrong folder image files?     is the test.jpg build action set resource?  folder name case sensitive images/test.jpg should work while images/test.jpg not Silverlight  >  Getting Started with Silverlight

hi, i have question tfs in cloud should sync tfs in orginization. here situation. suppose we want to manage project (project plan, dashboard,wit, scrum board) on tfs cloud , connect project server cloud but their tfsin organization contain all source code. is senario achivable ? don't want save source on cloud . i know how can keep synchronization between tfs developers wit tfs on cloud ?the wit in cloud should updated when developer finish work local wit? is there more issues compilcated manage architacture? please advice/ br,zvia hi zviaa, team foundation service not support customization of process templates e.g. if organization has own customized template not viable solution. there tool called team foundation server integration tools ( http://visualstudiogallery.msdn.microsoft.com/eb77e739-c98c-4e36-9ead-fa115b27fefe ) can sync work items , source control items between project collections. running requires constant monitoring if have two-way synchr

hi all, i working vs 2010 there want add my own dashboard project portal. how can achive this. regards shetty   if want add ssrs report use http://www.ewaldhofman.nl/post/2009/06/02/add-ssrs-report-as-dashboard-to-sharepoint.aspx if want add excel reports use http://msdn.microsoft.com/en-us/library/ms244713(v=vs.100).aspx ewald - please remember mark replies answers if help. blog: www.ewaldhofman.nl Archived Forums V  >  Team Foundation Server - General

i have other problems project in tfs source control, i'll later. my problem have file showing not downloaded in latest column , grayed out in source control explorer. i verified file present in local space , on tfs.    there have been no changes particular file, tried doing get, hoping take care of problem. when resolve conflicts window displayed conflict type = target local pending , description saying "the target has pending change".  far can tell there no pending changes on file - i'm 1 has worked on project past year.   i tried resolve conflict using ignore conflict option, showed conflict resolved. however, back @ source control explorer, still shows file not downloaded.   what "not downloaded" mean , why can't resolve this?   we looking blockages in current pending changes, not shelved changes hua chen suggested.   target local pending means local item being renamed/moved , target of rename/move has pending change which blocks ren

i keep getting error backup exec when backing 1 of databases. have no idea should fix it. contacted backup exec tech support , stated problem database , not software. can give me guidance how should troubleshoot , or resolve issue?  backup- \\sqlserver2.contoso.com\d: new volume unknown or unexpected database error occurred while attempting dbcc. internal error occurred in dbcc prevented further processing. contact customer support services. unknown or unexpected database error occurred while attempting dbcc. dbcc results 'contoso'. dont typically sql databases appreciated. running dbcc updateusage fix incorrect space usage stats (the errors checkdb refers dbcc updateusage). seem have more problems that, though (from quick reading of posted errorlog) have fall backups and/or contact ms support. tibor karaszi, sql server mvp http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi

not sure correct forum, i'll give go.  in process of deploying series of databases development environment production environment.  i've done searching around best practices, haven't found calls out best.   looking find out best approach moving code/tables/views/sp's, dev environment production environment.  due complexity , large number of objects created, backup/restore production server be more prudent creating batch file type thing creates objects through series of scripts?        n. edmonds wrote:   due complexity , large number of objects created, backup/restore production server be more prudent creating batch file type thing creates objects through series of scripts?    scripts best practice since can backup/restore (no matter how tempting) only 1 time, @ beginning. once have data in production database have scripts, time used process. scripts have advantage: can save them, modify them , rerun them.  related art

in order use silverlight c#, download silverlight toolkit , open visual studio, right?  close -- need software developers kit. http://msdn.microsoft.com/en-us/silverlight/bb187452.aspx sure service pack visual studio. (both links on same page.) silverlight toolkit downloaded codeplex collection of few more business controls -- it's not whole thing. Silverlight  >  Programming Silverlight with .NET – General

hello there, whenever try on azure databases windows azure portal, takes me database login screen (xxxxx.database.windows.net, attached below), in put user name , and password , click on "log on" button, takes near 10 minutes login database. why taking long time connect database azure portal ? thanks ashwin you try few things here: 1. try connecting different computer 2. try connecting different database (if possible) 3. try connecting different user account (if possible) if still experience same issue, please raise support ticket microsoft. Microsoft Azure  >  Azure SQL Database

hi friends, please want know total space (summary) allocated each objects in sqlserver free space can reclaim table drop still space occupied sqlserver . searching query . asad i use own sp_tableinfo , sp_dbinfo these purposes:  http://www.karaszi.com/sqlserver/articles.asp tibor karaszi, sql server mvp | web | blog SQL Server  >  SQL Server Database Engine

hi, i'm having problems adding filter parameters client context in silverlight application. here how doing it:               dc5dn.cachecontroller.controllerbehavior.addscopeparameters("companyid", "test");             dc5dn.cachecontroller.controllerbehavior.addscopeparameters("sessionid", "test2");             var test4 =dc5dn.cachecontroller.controllerbehavior.scopeparameters.current.key; when break after test4 variable assigned, null. why aren't parameters being assigned? also, data returned sync service not filtered (i've configured filters on server , in sync config file). there way set won't return data if scope parameters aren't set? thanks!   hi sekhmeti, you can use while loop loop through scope parameters collection. following:     var enumerator = _context.cachecontroller.controllerbehavior.scopeparameters; while (enumerator.movenext()) {      string value = enumerator.current.

hi, a little curiosity: dashboard build power bi response on office 365 respect performancepoint on sharepoint on premise, isn't it? thanks hi pscorca, there many microsof tools can used dashboard. sql server reporting services, excel, powerview, report builder and performancepoint. different tools used in different scenario. performancepoint dashboard designer tool can use create dashboards, scorecards, , reports , publish them sharepoint site. dashboard designer part of performancepoint services in microsoft sharepoint. the power bi designer new companion application power bi.  standalone windows desktop application that can downloaded power bi site. https://support.office.com/en-us/article/getting-started-performancepoint-dashboard-designer-88a12097-833c-40ee-86b4-beddd65506e6 http://www.jamesserra.com/archive/2015/01/power-bi-designer/ regards, charlie liao technet community support

while installing sql server express 2012 got error "wait on database engine recovery handle failed. check sql server error log potential causes." saw people problem changed service nt authority\system , error warning no longer came up. want change login mode mixed , must done in registry folder mssql. <instance name> not exist. how can problem fixed? how can install sql server express 2012 no errors? hi s. jones25 , firstly, please uninstall previous failed installation fragments of sql server following instructions in article . if not able uninstall sql server completely, please perform steps below uninstall sql server, below steps (about removing reg keys) work correctly sql server having 1 instance.     1. uninstall existing sql server   and components add remove program.     2. backup registry   .     3. delete following keys using regedit:                --hkey_local_machine\software\microsoft\microsoft sql server                --hkey

hi i have sql server 2005 , vs 2005 sp1 installed in machine, however, need sql server 2005 management studio , of key features in it. what correct proccess 'upgrade' system without alter programs referred? thank u help. n. o. hi,   welcome msdn forums.   microsoft sql server 2005 express edition advanced services contains sql server 2005 management studio express (ssmse). can download advanced services here   here links to upgrade from  sql express sql express advanced   http://blogs.msdn.com/sqlexpress/archive/2006/04/20/upgradetoadvanced.aspx   http://forums.microsoft.com/msdn/showpost.aspx?postid=2906497&siteid=1     hth, suprotim agarwal ----- http://www.dotnetcurry.com http://www.sqlservercurry.com ----- SQL Server  >  SQL Server Express

can power pivot , mappoint interact/communicate each other? if not, why not? there large amount of demographic , other data contained in mappoint. accessible power pivot?  unrecognized excel mvp (uem) david, have never used mappoint before, have heard colleagues did. sure product. not seem on roadmap microsoft :-( per http://www.microsoft.com/mappoint/en-us/home.aspx mappoint being discontinued on 12/31/2014 , power bi excel , bing maps suggested alternatives. regards, avi www.powerpivotpro.com SQL Server  >  Power Pivot

hello friends..! i need 1 issue. created oracle datasource using oraoledb.oracle. wrote pl/sql query 1 oracle view , 5 other oracle table. when trying test simple "select * <view name>", returning column names, no data, no error. but, when run "select * <table name>" in same dataset, returning data. dont know why happening? missing somthing? appreciate help. regards, am_it i'm able query oracle view using ole db.  did verify view returning data program toad or sqlplus? also there reason why using ole connection?  because have yet see reason use standard oracle connection available in ssrs oracle datasource. SQL Server  >  SQL Server Reporting Services, Power View

hi group, i've deployed sl oob application , works fine on windows machines (seven, xp, , like). anyway, cannot manage let work in mac's: once installed, find application icon in documents folder, if double click window opens remains totally blank (white), no error indication. tried open webpage firefox rather safari: installed again , worked firefox: if launch application icon same beahviour. further, when application launches ok (in firefox), when try list contents of local directory whole application window goes blank , nothing happens. i'm left in dark: can suggest troubleshoot such issues on mac systems? know similar problems? tested mac osx tiger (10.4.10) , leopard, got same results. instead keeps working fine in pc. suggestion? Silverlight  >  Programming Silverlig

hi all, i have existing wcf ria project built on release candidate; i'm moving release version & have discovered many changes.   david scruggs made following comment on (msdn) blog : "if you’ve written in silverlight 4 ria services, you’ll need rewrite it.  there has been lot of refactoring , namespace moves." having made brief attempt compile old solution new ria framework i'm inclined agree.  current plan to: remove silverlight business application projects solution rebuild ef4 items database create new silverlight business application project re-add files (xaml, cs) old silverlight business application project does sound reasonable approach?  think it's cleaner trying manually alter existing project. yours, duncan bayne  i moved 2 solutions , didn't find hard.  remove broken references , replace them new ones.  global search , replace on 3 or 4 namespaces.  i disagree "you'll need rewrite it"   

i have desktop static library , want use both desktop app , metro app. not use of non-metro apis. is there drawbacks using such desktop static library in metro app? thanks! you can use portable library. see this: what portable class library project in visual studio 2012– .net 4.5 sara silva Archived Forums T-U  >  Tailoring your Windows Store app for hardware and devices (archived)

hi, i keep getting error below login account in local administrators group , in domain admin group can't deploy projects reportserver. however, if logon on local administrator account fine see report pages can't deploy reports. there else need check grant login account (testuser) can go http://localhost/reports/pages/folder.aspx page , able deploy reports.  infor me resolve issue appreciate.  using sql 2012 standard 64 bit. thanks. error: user 'abcddomain\testuser' not have required permissions. verify sufficient permissions have been granted , windows user account control (uac) restrictions have been addressed.   hi nguyen, from error message, know user has no permission access deploy report. please ensure have granted permission user deploy report report server successfully. can refer links below see how tells how step step. http://msdn.microsoft.com/en-us/library/ms156034.aspx http://www.soheib.com/technical-knowledge/sql-server-2012

hi all, i have ssis packages. in packages logging in enabled , logged text file same folder. all works fine on dev , uat on prod 2 of packages missed logfiles. packages run job same permissions. i've got no errors , have no idea, why 2 packages no logging @ all. found no evidence in www issue. ha of idea, can for? update: on prod proxxy account missing in job step, reason why logs not written. SQL Server  >  SQL Server Integration Services

i dynamically creating number of textblock controls. able controls display unable couple of things: 1.  want set name of control. however, when control.name following error: property or indexer 'system.windows.dependencyobject.name' cannot assigned -- read only   i thought maybe doing control.setvalue<string> 'x:name' not see how work 2.  there way draw border around textblock?  not see border or stroke properties.  know can creating rectangle object want dynamically show/hide border , running same problem being able set name property cannot it.  here's code looks like:                 textblock mytext = new textblock();                 mytext.setvalue<double>(canvas.leftproperty, 10);                 mytext.setvalue<double>(canvas.topproperty, top);                 mytext.width = 100;                 mytext.height = fieldheight;                 mytext.fontsize = 13;                 mytext.text = entity.mnemonic;

hi i have business intelligence studio 2008 working team foundation server 2010, there 1 issue, when new developer access reporting services project , create local copy, stored credentials "shared data sources" disappeared, how can preserve data sources (.rds) credentials details when file stored in tfs, when else open project first time, doesn't need enter credentials information data sources again. hi mohammed,   thanks post.   i thinks issue related credentials data source in sql server, please refer to: http://msdn.microsoft.com/en-us/library/ms156450.aspx#credentials . john qiao [msft] msdn community support | feedback us get or request code sample microsoft please remember mark replies answers if , unmark them if provide no help. Archived Forums V  > 

hi, we have enabled on out build infrastructure intellitrace feature , working fine. files generated never deleted. there somewhere option define retention policy deleting old itrace files? br, daniel danielthecoder have tried using  test attachment powertool ? please check blogpost for more details powertools.   Archived Forums V  >  Team Foundation Server - Build and release management

hello!  i use sql server 2012 evaluation want buy developer edition. have searched web cannot 1 buy. please if know. thanks saintgr8 microsoft,  http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx amazon,  http://www.amazon.com/sql-server-developer-edition-2012/dp/b007rfxqam/ref=sr_1_1?ie=utf8&qid=1335173363&sr=8-1 thanks manish please use mark answer if post solved problem , use vote helpful if post useful. SQL Server  >  SQL Server Tools

the installation fails @ first step of updating setup support files. following message redist9_hotfix_kb921896_sqlsupport.msi.log: property(s): installed = 00:00:00 property(s): database = c:\windows\installer\4ca51.msi property(s): originaldatabase = c:\program files\microsoft sql server\90\setup bootstrap\cache\sqlsupport\x86\1033\sqlsupport.msi property(s): uilevel = 2 property(s): msiuisourceresonly = 1 property(s): qfeupgrade = 1 property(s): preselected = 1 property(s): action = install property(s): rootdrive = d:\ property(s): costingcomplete = 1 property(s): outofdiskspace = 0 property(s): outofnorbdiskspace = 0 property(s): primaryvolumespaceavailable = 0 property(s): primaryvolumespacerequired = 0 property(s): primaryvolumespaceremaining = 0 property(s): installlevel = 1 property(s): existingappguid = {982db00a-9c4e-436b-8707-18e113baa44c},{e0a41f96-7231-4ae8-a654-eeb34f935462},{63a5dc0d-1edd-4d69-8f31-87faeb1f7084},{2373a92b-1c1c-4e71-b494-5ca97f96aa19},{90032dd0-abee-4424-a

hi all, since have migrated sql 2014 sp1, figured out our application experiencing cardinality estimator bug.(see link ) after applying tf, sqlpackage experiencing timeout on query: select * ( select schema_name([o].[schema_id]) [schemaname], [si].[object_id] [columnsourceid], [o].[name] [columnsourcename], [o].[type] [columnsourcetype], [ic].[column_id] [columnid], [c].[name] [columnname], [si].[index_id] [indexid], [si].[name] [indexname], [ds].[type] [dataspacetype], [ds].[data_space_id] [dataspaceid], [ds].[name] [dataspacename], [si].[fill_factor] [fillfactor], [si].[is_padded] [ispadded], [si].[is_disabled] [isdisabled],

i looking better solution problem.   what have 200 reports , growing emailed on schedule (most once day possible).   this mean 200 sql jobs on rs box, because each subscription create sql job.    i working on data driven subscription create schedule run after dw has finished processing.   i noticing creating lot of parameters.   i noticing creating type of log table.    reason need exec jobs run every 5 min.   these jobs looking @ dw log table show done , log table tell if have ran or not day.   thus actual report email 1 time day.    (not sure if has better solution this).      the solution @ point create 1 new table hold parameters use subscriptions (for section define query retrieve subscriber data).    the need log table populate once report sent.    thus real problem have 200 plus reports trying run @ same time.   in addition trying process , users trying run stuff.   to balance load rather have 1 or 2 jobs running on reporting services box or edw box generates repo

hello all, this issue posted @ connect log files. i discovered existing installation of sql server 2008 developer had stopped working on developer workstation when dev app unable connect database. further scrutiny showed server not starting when machine booted. sql server management studio gave error not load mmc. decided copy datafiles , uninstall/reinstall. have not been able reinstall product. first error appeared related corrupt event log. recreated event log files using technique posted here http://support.microsoft.com/kb/172156. encountered following error , have not been able proceed after @ least dozen tries, including downloading iso image both sql 2008 developer , standard.     the installer has encountered unexpected error installing package. may     indicate problem package. error code 2331 error occurs @ following installer progress line:      install_sql_common_core_cpu32_action : do_loginstallstart_32. record install start in windows event

one feature think useful in next version of tfs check in approvals.  users should configured change set not checked in until approved.  big new team members making code changes.  helpful core framework code architect wants review code changed before checked in because affects everyone. thanks, andre adding new permissions seems hard justify given features have.  - can add "code reviewer" required checkin note.  same goes "architect reviewer" if core framework in own team project - can write custom checkin policies vary strictness based on path and/or user - can build system gauntlet forces people submit shelvesets review (automated or not) instead of checking in directly Archived Forums V  >  Team Foundation Server - Source and Version Control

i have installed sql 2008 r2 sp1 evaluation edition.now when  have activate running sql setup update evaluation version sql standard edition getting below error : consistency validation sql server registry keys" failed" rule evaluation message: sql server registry keys prior installation cannot modified. continue, see sql server setup documentation how fix registry keys. c:\program files\microsoft sql server\100\setup bootstrap\sqlserver2008r2\x64\fixsqlregistrykey_x86.exe exit code: 1 2013-03-26 15:47:50 slp: rule 'aclpermissionsfacet' detection result: aresqlaclpermissionscanonical= false 2013-03-26 15:47:50 slp: evaluating rule        : aclpermissionsfacet 2013-03-26 15:47:50 slp: rule running on machine: moiuaqdsa 2013-03-26 15:47:50 slp: rule evaluation done   : failed hello, please read workarounds posted on following threads: http://social.msdn.microsoft.com/forums/en-us/sqlsetupandupgrade/thread/fdb33ba1-a67a-4cd7-bccb-90ac0

i have report based on below query.  returns row/loan number every row based on select criteria includes stat_code.  want add column give count of how many loans have loan number code (not code reporting on) e.g.  if loan 123 has 2 records, 1 stat_code , stat_code c want count column 2.  best way this.  cannot count in main query because looking @ stat_code 'a' in clause.   select [age]       ,[loan_number]       ,[prin_loan_bal]       ,[bank]       , [stat_code]       ,[booking_date]   [dbname].[dbo].[mtsr_loan_rpt] substring(age,1,1) in (@age) and stat_code in ('a') , bank in (@bank) (i want count of loan numbers stat_code) i hope explained properly.  appreciate ideas has. hi, you need self join on table in order count of of stat_codes since excluding rows existing clause. assuming loan number unique, here's how it: select mlr.age       ,mlr.loan_number       ,mlr.prin_loan_bal       ,mlr.bank       ,mlr.stat_code

i using bulk insert load csv file our database.    text file has field has value looks this: gol scan - dÉcor 388cm x 274cm but after load database, looks in table: gol scan - d╔cor 388cm x 274cm what option need include in bulk insert statement fix problem?  tried using datafiletype = 'widechar' option did not work. thanks help. romeo SQL Server  >  SQL Server Tools

  hi all, i set attribute permissions role xmla. have no problem in that. role can see data (saturday , sunday). (xmla below)   after settings value how can query roles attribute permissions xmla query. < discover xmlns = " urn chemas-microsoft-com:xml-analysis " > < requesttype > mdschema_cubes </ requesttype > .....??????????? </ discover >   i think have write discover statement couldnt find exact xmla query. request type? i want these restriction list in microsoft.analysisservices.xmlaresultcollection     ------ set permissions ------- public myolapserver as new microsoft.analysisservices.server myolapserver.connect( "data source=" & myolapservername & ";localeidentifier=" & cstr (dwlocaleidentifier)) myolapserver.execute(xmlxmla.innerxml()) myolapserver.update()       < alter allowcreate = " true " objectexpansion = " objectproperties " xmln

i have transactional replication article's "action if name in use" property set "delete data. if article has row filter delete data matches filter". article in fact statically filtered i have custom store procedure "delete" statement delivery article. will application of snapshot subscriber use custom delete in "delete data" phase, or applicable replicated operations in publisher. if not, can somehow "delete data" operation use custom code my custom stored procedure has primary key value input parameter (in same manner default stored procedure ). replication enumerate primary keys "delete without clause" replicated, or stored procedure ignored in case. regards henrietta it use delete custom stored procedure replicate delete after snapshot applied. looking book on sql server 2008 administration? http://www.amazon.com/microsoft-server-2008-management-administration/dp/067233044x looking book on sql server 200

  hello   i'm using sql server 2000 (i tried using sql server 2005 express)   i've table tbla , table tblb.   tblb primary key referred in tbla foreign key.   when tried create script....   drop script deleting relation of tbla_tblb foreign key...   but while creating script of tblb...its not creating relation script.   how script relations in particular table.   plz me out. you can using both enterprise manager , management studio exp edn.  in management studio select script fk option true. database -->> right click -->> tasks -->> generate scripts -->> in choose script option window go down , in tables/view setting can select constraints/pk/fk/index etc script.   madhu   SQL Server  >  Getting started with SQL Server

hello, i have following table:   create table dbo.errors ( id int identity not null , constraint errors_id_pk primary key clustered (id), [application] nvarchar (60) not null , content nvarchar ( max ) not null , created datetime not null , host nvarchar (50) not null , [message] nvarchar (500) not null , [source] nvarchar (60) not null , [status] int not null , [type] nvarchar (100) not null , [user] nvarchar (50) not null ) -- errors   i need "page of errors" given pageindex , pagesize. so if pageindex = 20 , pagesize = 10 start @ the twentieth item , take 10 items. i can't use id index because if delete item, example id = 5, the twentieth item not coincide id. how can this? need change in table? thank you, miguel     with cte as ( select id, [application], content, created, host, [message], [source], [status], [type], [user], row_number () over ( order by id) as rn from errors)

hi got strange problem. today, can't connect remote sql server 2005 server through sql server management studio suddenly. can remote desktop login server , can access other sql server(sql server 2k5). strange thing our developer can access sql server machine. can't access china. china machines can access othere sql server one. stange. can me solve problem. every time when try connect sql server through sql server management studio following error.   provider: named pipes provider, error : 40 - not open connection sql server ) (microsoft sql server , error : 53 )     who can me solve problem. thanks lot!   simon     hi simon 3 possible reasons see error : 53  1. in server name using "/" rather "\" between server name , instance name,      e.g. "server/instance" not correct.   2. name resolution server name not correct, "ping -a server" tell if that's case  3. server machine firewall'ed , file sharing not

hi, i need format date following format: wed, 02 oct 2011 08:00:00 gtm i need rssfeed thanks i agree erland that formatting better suited client side processing.  if the datetime known utc (a.k.a. gmt, not gtm), can hard-code timezone: select cast ( datename (dw, getutcdate ()) as char (3)) + ', ' + cast ( datepart (dd, getutcdate ()) as char (2)) + ' ' + cast ( datename ( month , getutcdate ()) as char (3)) + ' ' + cast ( datepart (yyyy, getutcdate ()) as char (4)) + ' ' + convert ( char (8), getutcdate (), 108) + ' gmt' ;   dan guzman, sql server mvp, http://weblogs.sqlteam.com/dang/ SQL Server  >  Transact-SQL

utility clear database connecton pool, without restarting. i suppose intention break connections database. 1 option set database in single_user mode. alter database dbname set single_user rollback immediate; beyond relational SQL Server  >  SQL Service Broker

i using telerik's trace try , find out why our silverlight app runs oom exception. using tool appears compositeclientformatter in system.servicemodel.dispatcher hanging around , cant figure out why. has seen this? there improvements being done in openria project? thanks, ron hi, could describe exception more specific? think there might wrong in compositeclientformatter,there no such compositeclientformatter in system.servicemodel.dispatcher namespace based on http://msdn.microsoft.com/en-us/library/system.servicemodel.dispatcher(v=vs.95).aspx . please check compositeclientformatter. best regards, we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Silverlight

i changed service accounts , builds failing because new service trying create workspace overlaps directory old service accounts workspace.  want eliminate every worksapce owned old service account regardless of machine on.   i've *found* workspaces command   tf workspaces /owner ldserviceaccount /computer:* /server:myservername   the workspaces spread out on 5 computers , i'm having hard time figuring out exact commandline use eliminate them easy possible.   appreciated.   ok, figured out how using tfs sidekick.  think in hine-site have rather changed owner of workpaces button enabled wasn't working.   ohwell.... @ least have clean house. Archived Forums V  >  Team Foundation Server - Source and Version Control

i've added line @ bottom of report header , displayed when text box above hidden (based on whether there text populate text box). if there text populate text box above line, the  line gets hidden.  there way force line displayed? the reason i'm trying use line instead of header border because don't way header border extends beyond right , left edge of body of report.  line because can make same width report body. kevin hi morrismk, according description, have line in page header (not report header) , hidden when textbox hidden. want line displayed. right? in reporting services, if don't put expression control visibility of line, line supposed displayed. in scenario, informationwe can't figure out reason makes line hidden based on visibiltiy of textbox. tested in our local environment, didn't find problem similar yours. if possible, please post expression controls visibility of textbox or screenshots us. may reproduce issue in our local enviro

we encountered error (as shown below) when attempting install client component of sql server 2005 on xp pc. please, advise.   error : action "launchlocalbootstrapaction" threw exception during execution.  error information reported during run: "c:\program files\microsoft sql server\90\setup bootstrap\setup.exe" finished , returned: 1603 i encountered same problem. wonder can manual install client component setup folder.   SQL Server  >  SQL Server Setup & Upgrade

hey guys, have silverlight navigation application on 1 of pages have form filled out end user, has couple of textboxes filled, problem when hit tab key move next textbox cursor move next textbox in sequence page not scroll down new textbox cant see textbox though cursor in there....does know solution this?? appreciate help. thank you, chetan hi, fisrtly, add scrollview control contains form filled out end user. and create event handle method textbox’s gotfoucus event. sample code below (sv name of scrollview control): private void textbox_gotfocus(object sender, system.windows.routedeventargs e)         {             var tran = ((uielement)sender).transformtovisual(sv);             var svpositon = transform.transform(new point(0, 0));               sv.scrolltoverticaloffset(sv.verticaloffset + svpositon.y);         }   hope work you. Silverlight