mkrtchyan.arsen's Q&A profile

• Visual Studio Team System Team Foudation Server Scheduled Backup + Disaster Recovery Scenarios

  Hi, We have Team Foundation Server installed in our premises. We arranged with all the people working on TFS to make sure that their connection to TFS is closed before they leave work, so that to enable our SQL Server Full Backup Schedule to work correctly at around 03:00 AM. Our questions are: 1. Do we have to back up the Reporting Services Encryption Key every night as well Or we do that only once in a life time 2. Is there anything else to backing up TFS - in order to gurantee successfull recovery in the case of a hardware crash - other than backing up TFS databases and RPT Service Enc. Key 3. Can we still reuse the files that exist in users' worksapces in the case of a TFS crash I mean after we recover/restore TFS , ...Show All

• SQL Server Another Mysterious issue in SQL 2005 & SSIS

  Explain this: Package runs successfully from BIDS It runs successfully in SSIS store It runs successfully when I manually execute the Job JOB FAILS EVERY FREAKING NIGHT I just dont get it ( I used to think myself as a moderately intelligent guy but MS has really made me feel like a complete dumbass whenever I try to start using their new products - talking about that the Vista RC2 installation just hanged on me the other night with no apparent reason ) 2 jobs and both have issues running automatically: 1st - runs on BIDS, runs on SSIS, runs as Manual job, Automatic Jobs fail 2nd - runs on BIDS, runs on SSIS - jobs (manual and automatic) always fail And in do not have that DTEXEC installed on that machine to troubleshoot it according ...Show All

• Windows Forms an item with the same key has already been added

  I am trying to change the BackgroundImage property of a UserControl but when I try to do that from properties window VS throws "an item with the same key has already been added" exception. I did that several times in the same project. But it started to complain now. how can I solve that... Hi, I have solved the problem in an interesting way. I have only removed the resource file completely and added it again with renaming my image file. Now it works. thank you very much... aen ...Show All

• SQL Server Cannot change server authentication in Management Studio Express

  I use the Mangement Studio Express to manage a MSDE 2000 instance and notice that the Server authentication area in the Security is disabled for that instance. But for an Express instance, the Server authentication area is enabled. Is this difference caused by some settings Thanks, Peter You will more then likley find that there are several differences in the way that the engine handles things. In this some of the features and systems that the management studio uses will not work on the older engines. For example the maintenance plans as we know them in sql server 2000 can not be created in the sql server management studio.... but they can be maintained and edited if you create them using one o ...Show All

• SQL Server sd update

  hi i cant use update like this. how set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo] . [tt] AS BEGIN SET NOCOUNT ON ; DECLARE @t1 TABLE ( a int , b int , c int ) DECLARE @t2 TABLE ( a int , b int , c int ) insert into @t1 select a , b , c from table_1 where a = 1 insert into @t2 select a , b , c from table_1 update table_1 set c = @t1 . c where ( @t2 . b = @t1 . b ) END You logic is missing some things. What if two values will evaluate from the join It would be something like this: UPDATE table_1 Set c = @t1.c FROM Table_1 t1 CROSS JOIN @t1 INNER JOIN @t2 ON @t1.b = @t2.b HTH, Jens K. Suessmeyer. --- ...Show All

• Visual Studio Team System TFS Pre-Development - Early Observations :-(

  Hi all We have recently installed TFS in our development team. We are going to be using it on a large multisite project that starts the tech spec/development activity sometime in December. At present we are still in the requirements analysis and planning phase. I am sorry to say that at this stage I am yet to see any benefit from using TFS (although I fully accept the picture to change once we begin development) because; - I cannot put my documentation into source control, I have to use Sharepoint's version control. The integration between the two seems very limited. - Work Items; they are very clunky to input using Team Explorer (especially maintaining the relationship between one Work Item and another through Links). I am yet ...Show All

• .NET Development CLRProfiler crashes aspnet_wp

  I'm trying to use the CLRProfiler to profile an ASP.Net application. Somehow, it's gotten into a state where it crashes aspnet_wp. Running the same app without profiling works fine. The event log entries when it crashes are: Event Type: Error Event Source: .NET Runtime 2.0 Error Reporting Event Category: None Event ID: 1000 Date: 12/7/2006 Time: 12:46:25 PM User: N/A Computer: AFORS1 Description: Faulting application aspnet_wp.exe, version 2.0.50727.210, stamp 45063b16, faulting module profilerobj.dll, version 0.0.0.0, stamp 436a3905, debug 0, fault address 0x00006860. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . Data:.. [clipped] Followed by: Event Type: Error Event Source: A ...Show All

• Visual C# Parallel Port

  Hi, I need to send to all data pins in the parallel port 255 bytes(make all pins enabled), how can I do this Thanks check this out and see if it helps you at all: http://www.codeproject.com/csharp/csppleds.asp most likely you will need some drivers/API's to access parallel port since the SerialPort classes will of course not work I believe ...Show All

• SharePoint Products and Technologies Link Bar automatically adding link to other link bar

  Hi, This is a bit confusing, so please bear with me. I have created three link bars in sharepoint designer which each have links to point to different pages. My problem is that the first link bar is automatically including a link to the second link bar and the second is including a link to the third link bar. When I remove the link to the second link bar, from the first link bar, then it deletes the entire second link bar. Does anyone have any ideas how to prevent this from happening. Thanks, Aoife ...Show All

• SQL Server Update with Inner join

  I have an MS Access query that needs to be converted ot SQL Server 2005 Access Query: UPDATE tblCheckNumber INNER JOIN tblHistory ON tblCheckNumber.Autonumber = tblHistory.AutoNumber SET tblHistory.CheckAmount = ([tblchecknumber].[amount1]), tblHistory.CheckNumber = [tblchecknumber].[checknumber], tblHistory.CheckDate = [tblchecknumber].[checkdate], tblHistory.AccountNumber = [tblchecknumber].[AccountNumber], tblCheckNumber.Updated = "YES" WHERE (((tblHistory.CheckAmount) Is Null Or (tblHistory.CheckAmount)= 0 ) AND ((tblHistory.CheckNumber) Is Null ) AND ((tblHistory.CheckDate) Is Null ) AND ((tblHistory.AccountNumber) Is Null )); SQL conversion: UPDATE tblC ...Show All

• Visual Studio Express Editions Trouble populating a ComboBox with an Enum

  Okay VB Experts, I know that this should be very simple, but I can't find the solution. I have an Enum & want to populate a ComboBox with the Enum's members. Public Enum Stuff stuff0 stuff1 stuff2 End Enum ComboBox1.Items.AddRange(Stuff) The above code bombs, but I have successfully added each item in the enumeration individually. ComboBox1.Items.Add(Stuff.stuff0) ComboBox1.Items.Add(Stuff.stuff1) ComboBox1.Items.Add(Stuff.stuff2) There must be a way that .NET will allow me to iterate through the members without listing each one. Your assistance will be appreciated, thanks. Or you can simplify the loading in this way: ComboBox1.DataSource = System.Enum.GetValues(GetType(MyEnum)) Regards Kapalic ...Show All

• Visual Studio Team System Error 28806. Something is wrong with Reporting Services

  I have read through many of the posts on this Forum, but none have helped me solve my problem. I am installing TFS using a single-server configuration. I am unsing SQL Server 2005 Standard Edition. Windows 2003 Server is 32 bit (not x64). I have followed the guide to the letter (this is the 2nd time I have tried installing). When I go to http://localhost/Reports/ I receive the error posted below. I have already looked into giving Network Service Full control to the ASP.NET Temportary Directory, but that did not work. Any other suggestions Server Error in '/Reports' Application. Hi, The error belongs to sql server error.. check sql server error.. Because I am getting same error executing sql on sql server connecting my server from ...Show All

• SQL Server Trouble with Transfer SQL Server Objects task

  I am struggling to copy a 2000 DB to 2005 using transfer sql server objects task. I can get it to work, but without the foreign keys, which I also need. When also copying the foreign keys, I get the following message:" [ Transfer SQL Server Objects Task] Error : Execution failed with the following error : "ERROR : errorCode=0 description=There are no primary or candidate keys in the referenced table 'SVS' that match the referencing column list in the foreign key 'FK_WRM_SVS_WRM_SVS'. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}" . Apparently, SQL tries to create a foreign key on the WRM table, while the primary key on SVS is not there yet. Since ...Show All

• Visual Studio Team System I cant remove default Document folders at custom process template

  Hi folks, I'm customizing my process template and I removed at wsstasks.xml some default folders like requirements and general documents. However, I create my own folder named Conception. Ok. But when I upload the process template and then, create a new team project, the project was created with the default folders again. anyone know whats happens I believe that is a bug at pluggin for WSS. Tks a lot, Thiago http://www.tritech.com.br Ok Bill and Paul. Thanks a lot. I thinked about this, but I were looking for someone with more expertise about that. ;) ...Show All

• Visual Studio Tools for Office Help with Pulling in data from Access to Word & Excel!

  I'm trying to be able to pull in data from Access into a Word & Excel templates. I want this information to auto populate corresponding fields in the templates by inputing one primary key data. Help! I would be pulling the data from Access into Word & Excel. The templates are made from scratch and some have Macro's. Unfortunately I'm not very experianced with VBA or ADO. Any tips on how to use either of those easily In other words, if your not a programmer. Thanks so much! ...Show All