Posts

Showing posts from January, 2012

SQL 2005 Standard from "Ready to Launch". Is it x64?

i set server windows 2003 standard x64. have copy of sql server 2005 standard edition got microsoft launch event. on of case, gives version requirements both x86 , x64 versions. when went install it, didn't ask me 1 wanted install. when on cd, see different installers x86 , x64 various pre-requisites, msxml. i'm installing sql server see installing things "c:\program files (x86)" 32-bit programs go.. decided let finish. of binaries , everything, include sqlservr.exe, in program files (x86) folder, did install few things in program files, must aware of difference. i checked task manager and, see sqlservr.exe , sqlagent90.exe not 32-bit processes. so, great, they're running natively in 64-bit mode! when @ server options in sql server management studio, patform listed nt intel x86. memory page shows option use awe according documentation available , relevant 32-bit installations. so i'm pretty confused. points being x86 installation, running processes running nat

TFS2012 New project creation failing with TF30170: The plugin Microsoft.ProjectCreationWizard.Build failed during task BuildTask from group Build. Error

Image
hi , i updated tfs2012 update 3. after if create new tfs collection , not able create new tfs project under collection. getting following error. error tf30170: plugin microsoft.projectcreationwizard.build failed during task buildtask group build. explanation plugin error text: “tf400324: team foundation services not available server in01apvtfsv12\releasemanagement. technical information (for administrator): operation has timed out” user action contact team foundation server administrator.  complete log : 2013-10-15t15:56:36 | module: internal | team foundation server proxy retrieved | completion time: 0.0019532 seconds 2013-10-15t15:56:36 | module: internal | template information team foundation server "in01apvtfsv12\releasemanagement" retrieved team foundation server. | completion time: 0.0302746 seconds 2013-10-15t15:56:36 | module: wizard | retrieved iauthorizationservice proxy | completion time: 0.0009766 seconds 201

Can Exploratory Sessions be their own Work Item and be queried in TFS Web Access?

can exploratory sessions own work item in tfs? can link exploratory session work item other work item? talking actual session we can't find anyway view exploratory mtm sessions in tfs web access. useful reports , tfs web queries , linking sessions other work items. able see user story, exploratory sessions linked in tfs web access... possible? hi myles,  thanks post. as far know there’s no exploratory sessions type work item in tfs. can create custom work item type in tfs team project, please refer article: http://www.dotnetcurry.com/showarticle.aspx?id=755 .   john qiao [msft] msdn community support | feedback us develop , promote apps in windows store please remember mark replies answers if , unmark them if provide no help. Archived Forums V  >  Team Foundation Serve

How to add another row as column header i.e. a calender table, label if if the column is a Public Holiday

Image
my first table guardbreakupcalc create table tmpguardbreakupcalc ( areaid nvarchar(16), locationautoid udtautoid, clientname nvarchar(100), billingpattern nvarchar(1), asmtname nvarchar(100), sorank nvarchar(25), chargerateperhour numeric(18,2), sellingprice numeric(18,2), d01 int, d02 int, d03 int, d04 int, d05 int, d06 int, d07 int, d08 int, d09 int, d10 int, d11 int, d12 int, d13 int, d14 int, d15 int, d16 int, d17 int, d18 int, d19 int, d20 int, d21 int, d22 int, d23 int, d24 int, d25 int, d26 int, d27 int, d28 int, d29 int, d30 int, d31 int, totalhours int, totalcharge numeric(18,2), totalbillable numeric(18,2) ) insert [dbo].[tmpguardbreakupcalc] ([areaid], [locationautoid], [clientname], [billingpattern], [asmtname], [sorank], [chargerateperhour], [sellingprice], [d01], [d02], [d03], [d04], [d05], [d06], [d07], [d08], [d09], [d10],

how to distinguish read SMS messages from unread ones in Mobile Broadband SMS text messaging platform

hi, want to get sms messages , different  read sms messages  , unread ones ,such identifing these read , unread messages different css style in html. in mobile broadband sms text messaging platform, smstextmessage  includes no property which specifies a message read status:read or unread. should ? secondly, if show messages in html page , click or touch unread message read it, how should update unread message status,just invoke api update message in device store refresh message representation style in html? thanks lot! tatatee, your app need method keep track of read messages.  question? best wishes - eric Archived Forums T-U  >  Tailoring your Windows Store app for hardware and devices (archived)

Upgrade workgroup edition to a 180 day trial standard edition?

hi, we installed workgroup edition , assumed can use 5 named real users. detected, tfssetup licenced user. therefore cannot test tfs in our environment, due 1 person missing. possible upgrade tfs workgroup tfs standard edition 60, 90 or 180 day trial key? need time verify if tfs meets our requirements in small team. reduced number of persons (currently 6 persons contibutor , 2 persons "reader") 5 users. 4 named users foreced throw in towel tfs workstation installation testing. it more helpful, not forced reinstall whole bunch of tfs use trial no usercount restriction. test period of @ least 60 days enough our needs. there way specialized trial standard edition? buy according trial key okay, if possible. regards, hkais hi hkais, lot of people feel account tfssetup account need create. tfssetup name give account use setup tfs. tfssetup account hkais account. not neet tfssetup account. if have used account setup tfs have got 5 user accounts without problems. you can

SQL Server Management Studio 2014 login failed for user Microsoft Account Microsoft SQL Server Error 18456

Image
resolved i had backed computer external wd passport ultra on jan 27. i renamed c:\program files (x86)\microsoft sql server  i renamed c:\program files\microsoft sql server  then copied these folders backup on external wd drive. sql server works. what relief. please help, there no option change connection protocol 3 active: tcpip, namedpipes, sharedmemory there no option change windows authentication account, but same login started sql server service. logging in sql server authentication not work. below screen prints configuration manger , sql server management studio. thank you, robert lorbeer     rlorbeer@gmail.com the sql server service running... when try connect using sql server management studio 2014 ... hello, it seems windows account associated gmail account now, , seems reason behind error. please try fix using following article: http://techguylabs.com/episodes/1222/can-windows-10-log-my-gmail-account hope he

In-place upgrade of SQL Server Cluster (incl. OSver)

hi there, we planning upgrade our platform versions of o/s , sql cluster (windows server 2008 r2 enterprise + sql server 2008 r2 sp3 standard) (windows server 2012 sp3 enterprise + sql server 2012 sp3 standard). could please advise on hurdles might encountered during rolling upgrade. more re; sql server cluster upgrade.  assuming cluster settings resolved existing configuration.ini or there new h/a configuration end-points need configured outside original sql server 2008 r2 cluster installation. from documentation, looks quite seamless, https://technet.microsoft.com/en-us/library/ms191009%28v=sql.110%29.aspx?f=255&mspperror=-2147217396 current elements of sql 2008 r2 cluster configuration, features=sqlengine,replication,fulltext,ssms,adv_ssms ssrs distributed server outside cluster, reportserver databases hosted on cluster, also upgraded same os/sql versions. any information/guidance on process helpful.  some initial concerns guided discussion: from unde

HOW TO AVOID TOO MANY OBJECT CREATION IN Silverlight enabled WCF service,

in silverlight enabled wcf service, i have used 4 classes, each class contain minimum 10 function, if create object each class occupy more space right. how avoid that? example: [servicecontract(namespace = "")] [aspnetcompatibilityrequirements(requirementsmode = aspnetcompatibilityrequirementsmode.allowed)]         public class service1     {          public class1 objc1 = new class1();         public class2 objc2 = new class2();         public class3 objc3 = new class3();         public class4 objc4 = new class4();         [operationcontract]         public void dowork()         {             // add operation implementation here             return;         }        use single object perform task ,      if it's possible , kindly send sample link or code. please see link: http://www.csharp-station.com/tutorials/lesson06.aspx in example had call class namespace.

MIrror database is in "synchoronizing" mode after restart

hello all, i had restart mirror server yesterday , after rebooting database status "synchronizaing" "synchronized" before. question normal or need recreate mirroring restoring new datbase backup? i using 2005 enterprise edition on windows 2008 r1. any appreciate. regards, you can try recycle endpoints. have seen behavoiur in sql 2005 before. cycling endpoints easiest try not interrupt operation. commands be: alter endpoint <endpoint name> state=stopped alter endpoint <endpoint name> state=started you endpoint name in ssms under server objects -> endpoints -> database mirroring   lucifer SQL Server  >  Database Mirroring

How to addTooltip on autogenerated columns in silverlight datagrid

hi, i have been trying tooltip autogenerated columns in silverlight datagrid. i want show cell value, column header  in tooltip. can templated column if columns not autogenerated have not been able find way autogenerated columns. any appreciated. sg hi, try below sample  http://stackoverflow.com/questions/4615081/how-to-add-a-tooltip-for-a-datagrid-header-where-the-header-text-is-generated-d hth nishi Silverlight  >  Getting Started with Silverlight

Using Package Configurations for an OLAP Cube

Image
hello, i have etl package in ssis 2005 that processes cube on ssas 2005 final step. using package configurations store connection strings in configurations table in sql, seems work fine relational databases, yet not olap cube. seems somehow persist initial ssas db used in creation of package, or set there explicitly, , not seem catch new connecion string set in configuration table. tried closing , re-opening solution in order refresh connection , everything. no matter what, connection manager seems catch new name, yet analysis services processing task seems still attempting process database old connection string referring to. has encountered such behavior before? there workarounds that? best regards, katara hello, i have etl package in ssis 2005 that processes cube on ssas 2005 final step. using package configurations store connection strings in configurations table in sql, seems work fine relational databases, yet not olap cube. seems somehow persist initial ssas db used in creation

External Backup keeps throwing error message

hi all, have been backing same 10 databases differential backups on daily biases month , last night, 1 of databases failed following error messages: 112(error not found) [sqlstate 42000] (error 3202) backup database terminating abnormally. [sqlstate 42000] (error 3013). step failed. able let me know why happen suddenly? thank you os error 112 translates "there not enough space on disk." can ensure there sufficient disk space on destination drive sql backups when issue happens? error 3202 points out write failed on destination location. this posting provided "as is" no warranties, , confers no rights. my blog : http://troubleshootingsql.wordpress.com twitter : @banerjeeamit sql server faq blog on msdn: http://blogs.msdn.com/sqlserverfaq SQL Server  > 

SQL Server 2008 Essentials Backpack

welcome sql server 2008 essentials backpack! http://download.microsoft.com/download/9/f/6/9f64be44-292d-43f2-8217-34aeff79ebe8/essentials.zip this pack designed offer essentials may know around sql server 2008.   included find: 1.        a quick facts sheet – learn more great new features resource governor, policy-based management, , transparent data encryption.   discover how troubleshoot , tune instances across enterprise or take advantage of improved integration 2007 office system. 2.        the overview white paper   - details how sql server 2008 helps deliver on microsoft data platform vision enabling organizations run mission-critical applications while lowering cost of managing data infrastructure , delivering insights , information users. 3.        mclaren electronics systems case study – read how mclaren electronics, division of mclaren racing, able simplify data management of terabytes of data utilizing filestream feature in sql server 2008. 4.        business sol

SQL Server and missing MSDTC Service

one of clients had , old version of sql server express 2005 (released in 2006). uninstalled , installed latest version. after installation, msdtc service missing. happened on 2 machines, 1 xp, , 1 vista. did not happen on machine did not have sql express. ideas? hi, http://support.microsoft.com/kb/910229 2.5 msdtc not enabled on windows because microsoft distributed transaction coordinator (ms dtc) not configured in windows, applications might fail enlist sql server express resources in distributed transaction. problem can affect linked servers, distributed queries, , remote stored procedures use distributed transactions. prevent such problems, must enable ms dtc services on server sql server express installed. to enable ms dtc, follow these steps: in control panel, open administrative tools , , double-click component services . in left pane of console root , click component services , , expand computers . right-click my computer , , click properties . on msdtc tab, click s