Laxmi.'s Q&A profile

• SQL Server Full-text Index Question

  Hello all, I just created a new Full-text index on a column, and I set Change Tracking to Auto. When I do this, do I still need to have an Incremental Population schedule, or does SQL Server handle the population in the background on a continuous basis when Change Tracking is set to Auto Thanks for your help, Jason See inline. EXEC dbo . sp_fulltext_table @tabname = '[dbo].[Log]' , @action = 'start_change_tracking' GO -- If you have timestamp column on the table, start_change_tracking will start incremental crawl, otherwise, it will kick off a fullcrawl and set changetracking to manual. You should see the index is populated. EXEC dbo . sp_fulltext_table @tabname ...Show All

• SQL Server Plz Clarify my query in SSIS

  Hi There, I have Task in SSIS to import the flat file to the table and break the table and insert and update the other tables in the same database. I searched every where i couldnt find appropriate tutorial for this. Please advice me how to achieve this task. Thanks in Advance Regards Savera HI Jamie, Thanks a lot. I have some more queries to clarify. I have some complicated criteria like join the tables and set the flag in main table if any of the table updation tasks fails.Will it be done in Conditional split Transformation if its not please let me know how to get this task done. Thanks in Advance. Regards ...Show All

• Visual Basic data storage

  As posted in another thread, I'm planning to build an accounting program. I'm wondering what would be the best way to store the data, using databases or perhaps XML There will be over 50 administrations and several users. Would one database per administration be most efficient considering one administration will usually be accessed by one user at a time Using XML probably means smaller file sizes and therefore less network traffic, but databases offer more functionality. Anyone has experience with this Any help would be welcome. Regards, Eric Stephen, after doing some research, I'm beginning to think SQL would be the best choice, using a single database for every business. The structure of all the databa ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Collision Detection in 2D Games

  Hi, So far I have figured out how to get object moving on the screen. I have also figured out how to detect colissions at the edges of the screen. However, I am having trouble figuring out how to detect the collision between two objects. Say for example, two bouncing balls in a 2D game. How can I detect the collision of this two objects I imagine it has something to do with sine and cosine Thanks, Oblivion. When you have a lot of 2d objects in your scene then a more generic approach becomes worth-while. If you want to read up on it check "sweep and prune" collision detection algorithms. These work with bounding boxes in a first step when they basically determine which objects might colli ...Show All

• .NET Development Threading fun ;)

  Hello threading professionals, I have something "clean" and interesting for you... please help. I will appreciate it.. I want to solve the problem and (more so) learn about how this thing works.. very interested in the details. In my simple notes-taking simple, once in a blue moon it happens that the GUI stops responding.. I finally took the courage and attached a debugger earlier today when it happened again. With my newly acquired debugging skills I found out where the problem lies and what is happening. However I still don't understand WHY it happens. I imagine that it should be too hard of a challenge for someone with a lot of experience in this subject. Here we go: In my NotesForm, I use a System.Threading.Timer which fires every 20se ...Show All

• SQL Server Error when importing data from Excel File

  Hi! This is what i'm doing: IF EXISTS (SELECT srvname FROM master.dbo.sysservers srv WHERE srv.srvid != 0 AND srv.srvname = N'ExcelSource') EXEC master.dbo.sp_dropserver @server=N'ExcelSource', @droplogins='droplogins'; - EXEC master.dbo.sp_addlinkedserver @server = 'ExcelSource', @srvproduct = 'Excel', @provider = 'Microsoft.Jet.OLEDB.4.0', @datasrc = @Chemin, @provstr = 'Excel 8.0'; EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = 'ExcelSource', @useself = false, @locallogin = NULL, @rmtuser ='ADMIN', @rmtpassword = NULL; set @NomServ = 'ExcelSource'; This create a linkedServer to read my ExcelFile. Then i'm doing this: EXEC ('Insert into Elements (No_element, Nom_elem, Desc_elem, Code_grpe_classe, Tps ...Show All

• Software Development for Windows Vista Is VB6 supported on Vista?

  Has anyone tried to install VB6 and compile VB6 scripts on Vista I am attempting to install VB6. Contents of CD has been copied to a local folder. I right click on setup.exe and choose Run as Administrator. Within a couple of seconds, I see a window saying setup.exe has stopped working and sending information to microsoft. Log file wmi.txt had: instance of Win32_NTLogEvent { Category = 100; ComputerName = "QBGQA019"; EventCode = 1000; EventIdentifier = 1000; EventType = 1; InsertionStrings = {"SETUP.EXE", "6.0.0.8167", "358665a9", "ntdll.dll", "6.0.5308.17", "43f6ed1d", "80000003", "00021b10", "110c", "01c6761e5c1ee98a&qu ...Show All

• Visual Studio Tools for Office Which way to go?

  I have a project to make a Settlement Statement in this format. Column1 Column2 Column3 Colume4 Adv Deposits Guest City Monthtoday forColumn 3 Previous Balance 0.00 0.00 300.0 - Settlements ---The Settlements Section will be Manual Entry Net cash 0.00 0.00 0.00 450 Checks 0.00 0.00 0.00 600 Paid Out 200.00 0.00 0.00 500 F&B Paid Out 0.00 0.00 0.00 0.00 Lockbox 0.00 150.00 0.00 150 American Express 0.00 0.00 150.00 150 Discover 0. ...Show All

• Windows Forms Auto Format DataGridView

  Hi, I was reading through a bunch of resources on Visual C# 2005, and one of them said that I could enter an Auto Format window to change the look and feel of the DataGridView in my application by right clicking on the DataGridView and selecting Auto Format. My context menu doesn't have a Auto Format, and I was wondering were I can get this feature back I tried to find it in Visual C#, and spent a great deal of time looking for more information on this on the net and in C# help, but couldn't find anything. Any help would be greatly appreciated. Thanks, -Matt I don't get this... I am trying to learn this program, and when following instructions, I keep getting to points where features arn't there that the ...Show All

• Visual Basic full file path of running process/instance

  Hi Experts,                   Can anyone know how to findout the full path( ex: c:\rama\bbc.xls) from the curently running instance "bbc.xls". I dont mind accepting VB6\.NET\Windows script solution for the same as i'm desperate to find the full path from ruinng instance. Lets say I've opened saved bbc.xls file and i know the currently opened instances from Process library and i can get the title("bbc.xls") but i dont know how to get the full path("c:\rama\bbc.xls") For more details please have a look at the following link. http://forums.microsoft.com/MSDN/showpost.aspx postid=1206503&siteid=1 -- Cheers, Rama If you are not starting the instance fro ...Show All

• .NET Development PingReply is slow

  I have developed a Ping application using C# and it worked fine but after sometime, let's say a day it will be two slow so i have to restart the machine. i am currently using DOS ping command without any problem!! what's the solution.. Have you verified that PingReply is slow, or does your application simply slow down over time If you're using .NET 2.0 you'll probably want to use the SoundPlayer class instead of PInvoking PlaySound.... Since the String type is Unicode, you should use Encoding.Unicode instead of Encoding.ASCII. It's not a good idea to do lengthy operations on a tick event; this event is processed by the GUI thread; you're neednessly causing your GUI to be unresponsive while it processes the ...Show All

• Visual Studio 2008 (Pre-release) Representing an scRGB value in C#

  Hi guys, How would I go about representing something like <GradientStop Color="sc#1, 0.510580361, 0.6042812, 0.8815889" Offset="0"/> in C# I have the following method in my code... private LinearGradientBrush GetGradientBrush() { LinearGradientBrush gradientBrush = new LinearGradientBrush(); gradientBrush.StartPoint = new Point(0, 0.5); gradientBrush.EndPoint = new Point(1, 0.5); TranslateTransform translateTransform = new TranslateTransform(-0.5, -0.5); ScaleTransform scaleTransform = new ScaleTransform(1.011352654002956, 1.011352654002956); SkewTransform skewTransform = new SkewTransform(0, 0); RotateTransform rotateTransform = new RotateTransform(9 ...Show All

• SQL Server Verify Client connectivity File versions

  Is there a way to verify the version of the files that are used to connect to SQL 2005 This stems from an ongoing problem I am having with having SQL 2000 and 2005 on the same machine... It has come done to the client connectivity files.... Thanks Verifying the version of files (operating system) is a huge task, on the SQL Server aspects with compatable client tools it is possible to connect between SQL 2000 and 2005 instances. What sort of problem you have to handle the multi-version SQL instances. ...Show All

• Visual Studio Team System Filename Collision nightmare

  Here's my situation: Trunk |__ Branch A |__Branch B Branch A was baseless merged in to B Branch A was merged into trunk. Trunk was merged into B resulting in hundreds of filename collisions because the files were created from Branch A via baselss merge and then when merged in via the trunk, TFS doesn't recognize them as the same file and so now my only option when checking in the file is to undo local changes or ignore, neither of which is what I want to happen. I want the changes from the trunk to establish the merge relationship of those files that were baseless merged in from A. However, the only way I can see to do this is to undo the changes on each file force a baseless merge from trunk to B, then resolve the conflict.. ...Show All

• Visual C# Writing to multiple files

  Hi, I want to read in a file which contains words ending with ';'. And after that, i want to write the content of it to multiple files. Depending on what the letters the word contains. Suppose the word is 'reader'. Then i want it to cute and paste this word to a doc called "EA-words". I declared and created the files. And i read in the document called "mixedwords.txt" and put its content to an arraylist. This is as far as i got: //declared 15 files to write to. while((linesInArray = sr.ReadLine()) != null) { compareLines.Add(linesInArray); } Anyone any ideas Thanks in advance! Hi , I got the elements in an arraylist so i can be able to sort them. Want i want to do with the words in ...Show All