Raudhah's Q&A profile

• SQL Server Stored Procedure Version Control

  I am running SQL 2005 and Sourcesafe. I want to automatically add the sourcesafe version number to the individual scripts stored in sourcesafe that generate stored procs, sql agent jobs etc. Anyone got a code snippit to show how this is done What you also need to do is include the VSS keywords in a /* */ comment block. You also need to enable the keyword expansion for the .sql extension. ...Show All

• SQL Server how to add a where clause by parameter in a stored procedure

  What i want is to add by parameter a Where clause and i can not find how to do it! CREATE PROCEDURE [ProcNavigate] (  @id as int,  @whereClause as char(100) ) AS Select field1, field2 Where fieldId = @id    /*and @WhereClause */ GO thx Personally, I dislike the above mentioned method. Besides the fact that it opens you to all sorts of bad stuff. What you can do is make the parameters nullable, and do a case statement on the where part of the clause: create procedure pSomethingOrAnother (    @p_lID integer,    @p_lWhereItem1 integer,    @p ...Show All

• SQL Server Search with %t%y% => Error, %ty% => ok...

  Hi! I have a problem with a Select statement: In a ordinary table there is a column called NAME. I want to make the following search: SELECT * FROM TableName WHERE NAME LIKE '%t%y%' this should give me all entries that have a "t" and a "y" in the NAME column. However, it gives me no entries. If I instead run this search: SELECT * FROM TableName WHERE NAME LIKE '%ty% it gives me the correct result. Since the wildcard character % means no or all characters it should work. The problem only seems to occur when the wildcard character is used between "t" and "y", other characters are ok. ...Show All

• Visual Studio Express Editions Naming threads not working

  Hi. In my code, I name my threads so I can tell if one hangs when the program exits. This used to work fine with the old IDE, but now my threads are all called 'No Name' again. Can anyone help I'm setting Thread.Name before I start the threads and that has always worked for me. Setting the name after the thread starts is not allowed, so what's the go I'm also still getting random 'system unable to transition from COM state ... for 60 seconds' crashes. Could probably offer more on this if I knew which thread was which. I doubt it is bug, such should have not been slipped in the RTM but if you believe it is, try searching the ...Show All

• Visual Basic How can I install a program I wrote on a USB device?

  I want to install a program I wrote in Visual Basic 2005.net on a USB device. I built the program and published it. When I run the set-up, it automatically installs the program on my hard drive. I want it on my removeable device so I can use it on several other computers, but I don't want to install it on other computers. What am I overlooking Help!! Dan The dot net framework supports what they call xcopy deployment. You can copy all the files neededor your application and it will work as long as the dot net framework is installed on the computer you insert the usb drive in ...Show All

• SQL Server what is incremental export/import in DTS ?

  Hi all, I have new project asking me to export incremental data from one sql server to another sql server. what does we mean by incremental export do it mean that only updated rows should exported each time when package run or do i have to truncate table and export entire table again regards bharat An incremental export would be, in my team, an export that only takes changed data from the last time the package ran to this time. How you identify that data is up to you but a trigger on a table would be a good way (non heavy transactional system), maybe you flag changed row in your procedures for ins ...Show All

• Visual C++ Problems with BMP: RGB to gray in C

  I'm trying to make a program in which I convert an RGB image into an gray image. I have made my algoritm properly but I think I have some problems with the bmp file format, I've read and search on internet aboout it but I cant't find my mistake. I post my code in order to see if anyone can find it... I think the problem must be in the writing of the header, if I put 24 in the line I signal (with this <----) the output image is a perfect grey scale image but it's tiny and repeated 3 times. When I put an 8 the size is allright and it's only 1 image but it's not right (it's almost good but it looks like something is missing in my co ...Show All

• Visual C++ Using Bookmarks in VC 8.0

  I am switching to .NET 2005 from using VC 6.0 and for a short while VC .NET 2003, but I use the IDE for also reading through logs and loved the bookmark feature for this. First I had to figure out how to get the function keys back to the way they worked in VC 6.0 (Ctrl+F2 and F2), but now that they are working I was looking for a way to get the bookmark stepping to work as it did in VC 6.0. It used to let me set bookmarks and then step through them in the order that they appear in the log, but now it seems to go through an order list of the bookmarks and shows them in the order that they were set, even jumping to other open documents. ...Show All

• Visual Studio Team System Sharing issue in VSTS Source control

  Hello guys, I'm trying to migrate our VSS database to VSTS Source Control and I don't really understend how can I make "sharing" happen at VSTS For example we have next VSS source tree: $root |-DummyProject |-Includes |-ProjectA |-ProjectB Both of them have shared files from <Include>. My question is: What is an alternative for us in VSTS in terms of do not re-organize our current code Thanks a lot guys. Two basic ways: Use different relative paths. Let's say your layout is: $/root |-Common |-CommonLib1 |-CommonLib2 |-DummyProject |-ProjectA |-ProjectB |-Includes |- [C ...Show All

• Visual C++ MSBuild in x64 environment with vcproj

  Hello, With a quick search in the MSDN, I did not find the issue I am having. If this is already discussed, I apologize. I just got the latest VS2005, and tried to build 64 bit. It fails to build with MSbuild from command line. I have played just short time, and started with very basic. Still I am not successful. I am using VS2005 version is 8.0.50727.42 Here is the very basic scenario. I have created a new blank project "hello", my default is VC++, and added x64 'platform', then removed Win32 from 'platform' and 'active solution platform' via configuration manager. I add a new item C++ file as "test.c" I typed in the famous hello worl ...Show All

• Visual Studio 2008 (Pre-release) Feb CTP TemplateBinding\Property issue

  I keep getting this error Error 7 Property elements cannot be in the middle of an element's content. They must be before or after the content. for the following < Rectangle Fill = " {TemplateBinding Property=Background} " /> Thanks Andy I noticed in one of the posts about the changes in the Feb CTP that all bindings needed to use the property syntax, which may be your issue. Try: <Rectangle> <Rectangle.Fill>{TemplateBinding Property=Background}</Rectangle.Fill> </Rectangle> Or <Rectangle> <Rectangle.Fill> <Template ...Show All

• Visual Basic Btn nothing Event

  I have a WForm with a button, this button pulls up a word document when a letter is chosen...great......now if a letter is not chosen and i click extract i get an unhandled exception error...any ideas on how i can solve this...so that when a letter is not chosen and i click extract a message box will come up and say no letter chosen....... thanks i got the app running now...All i need to do is get my code right so i can input the policy number in the PolNmber.Textbox...then hit extract and it comes out through my Word 2002 field called <<PolNum>> ...Show All

• Visual Studio Team System Automated Build: SQL Error 8152 ("String or binary data would be truncated.")

  Hi, Im hoping someone has encountered this and was able to fix it. We are using VSTS Beta 3 Refresh version I was able to auto build earlier today.  I havent any problems manually checking out all the files and building.   I got the following when I run the automated build that hadnt changed. From a little research, I found the "Error 8152 ("String or binary data would be truncated.") indicates that you have data in the column that is longer than the length you are trying to set it to, i.e. longer than 35 characters."  From http://www.codecomments.com/archive352-2005-6-526479.html I tried using the SQL ...Show All

• Visual Studio Team System Project Creation Problem: Unable to connect to the Windows SharePoint Services

  After installing TFS Beta 3, everything seems ok. Can connect to it, manage it, etc. However I cannot create projects sucessfully. When I try to I get this (excerpt from log): Event Description: TF30162: Task "SharePointPortal" from Group "Portal" failed Exception Type: Microsoft.TeamFoundation.Client.PcwException Exception Message: Unable to connect to the Windows SharePoint Services at TEAMSYS1 Exception Details: The Project Creation Wizard was not able to connect to the Windows SharePoint Services at TEAMSYS1. The reason for the failed connection cannot be determined at this time. Because the connection failed, the wizard was not able to ...Show All

• Visual Basic receiving email with .NET VisualBasic

  How can a .NET VisualBasic application or web app receive email I meant, what object class should my VB application use to receive email Are there any books on how to set this all up Seems like there's 2 main steps: 1) Install an email server. (double-yikes) 2) Develop VB application software to read the email server. 3) Connect the email server to the Internet (yikes). I have Windows Server 2003. Does it have an email server -- Doug Bell ...Show All