Posts

A critical database corruption due to disk IO Drop table by mistake Unresponsive SQL Server

critical database corruption due disk io drop table mistake  unresponsive sql server  so question here ? cheers, shashank please mark reply answer if solved issue or vote helpful if helped other forum members can benefit my technet wiki articles mvp SQL Server  >  Database Mirroring

How to re-start transactional replication

  i have clinet using transactional replication in sql server 2000 broke year ago. have been called re-sync 2 databases. best options. cannot delete replicated database have written lot of custom reports on replicated database not exist in source database. ther triggers , sp's on replicated database. one-to-one replication.   what best approach keep structure , load fresh set of data , start getting transactinal data copied on . thank sin advance. best thing script out database objects on subscriber , reinitialize publication. once snapshot applied reapply script. SQL Server  >  SQL Server Replication

Key file import and assembly references after branching in Team Foundation Server

i branched source code within tfs.  within tfs converted folder housing source code branch making "main" branch.  created 2 children "dev" branch , "5.5" branch.  when check out main branch , try build getting key file import errors "cannot import following key file..." , referenced assembly errors.  referenced assembly errors 5.5 branch error "could not load referenced assembly.  system cannot find file specified" while main branch error "assembly x has higher version referenced assembly y." the main branch in same local location before branch while other branches have new locations locally. also main branch has lot of errors "x ambiguous in namespace y" besides frustration of trying correct these errors can coding, there best practice avoid key file , assembly errors when checking in/checking out , merging branch? well, noticed key files import errors .pfx files created .snk fi...

Drag and Drop for 360` Image animation

hi, here code xaml: <usercontrol x:class="moveimagetest360.page" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" width="2000" height="112"> <canvas x:name="layoutroot" background="white"> <image x:name="myimage" source="team.jpg" width="2000" height="112" stretch="fill" mouseleftbuttondown="thedragon_mouseleftbuttondown" mouseleftbuttonup="thedragon_mouseleftbuttonup" mousemove="thedragon_mousemove"> </image> </canvas> </usercontrol> c# code is:         bool isdragging = false;         point offset;         void thedragon_mouseleft...

Performance / Stress testing tool for windows desktop application

  hi guys   is there any free performance &  stress testing tool available test windows desktop application ( not web application) ?...   thanks senthil it depends on you're trying do. can find free tool consume disk space or memory test application under circumstances. windows application verifier can find many of same types of issues (download here ). note appverifier native code only.   for performance testing, can take advantage of windows performance counters, or use stopwatch - again, depends on want do. Archived Forums A-B  >  Archived: Software Testing Discussion

Facing issue "The SSIS runtime process crashes when you run the SSIS package under a low-memory condition" with SSIS 2008 R2 32 bit (C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe)

Image
i facing  memeory problem while using ssis 2008 r2 sp1 32 bit error like     microosft acknowledges error on above link , takes appropraite cumulative update ssis 2008, working ssis 2008 r2 cumulative update should install probelm solved? you need access microsoft updates via internet explorer , scan missing updates based on see missing sp2 sql server 2008 r2 arthur my blog SQL Server  >  SQL Server Integration Services

Derived Column and #n/a

i have relatively data flow, imports data csv.  pipeline has derived column , data conversion transformation before importing data sql server.  csv came excel , of columns populated vlookup, , when there isn't match, there #n/a.  string columns, not problem , derived column transformation able null values, however, have 1 column dt_ui4, , when pipeline reaches #n/a in column, chokes.  formula below, error message.   (dt_wstr,50)(personnelnumber) == "#n/a" ? "" : personnelnumber   i have tried (dt_wstr,50)(personnelnumber) == "#n/a" ? null(dt_ui4) : personnelnumber but did not work either.   my error:   onpipelinepreendofrowset,,data flow task 1,{b60822ad-776c-49b6-ba4c-3609280d9acf},{43207801-47d0-4108-a812-75c2c2f0bef1},8/26/2008 12:49:36 pm,8/26/2008 12:49:36 pm,0,0x,a component given end of rowset signal. : 89 : data conversion : 90 : data conversion input onerror,,data flow task 1,{b60822ad-776c-49b6-ba4c-3609280d9acf},{43207801...