RookieDBA's Q&A profile

• SQL Server Query VS Stored Procedure problem

  Hello. I am having a strange problem with SQL Server 2005. I have written a SELECT query that contains unions, joins and group functions. when the sql query is run using t-sql statements, the query completed execution in about 10-12 seconds. When the same query is written in a stored procedure without making any changes in the SELECT query (only adding a date parameter), it does not generate any result. I waited for about 1 hour for the stored procedure to give me the result but it did not. Can anyone help me out with this problem Thanks in advance. Raza: Please provide a listing of your stored procedure. Dave ...Show All

• Visual C++ 16 bit windows subsystem error

  when trying to install vc++ 6.0 on xp sp2 machine, i get this error: "16 bit windows subsystem c:\windows\system32\autoexec.nt. the system file is not suitable for running ms-dos and ms windows applications. choose close to terminate the application." can anyone help thank you. B. John ...Show All

• Visual Basic A question about the CheckedListBox.CheckedItemCollection

  Hi, I would appreciate it if somebody could give me some insight to my question. What is the best (safest) way of saving a CheckedListBox.CheckedItemCollection outside of the created (and used) CheckListBox, such that, if the user clicks numerous Checkboxes and then clicks a "Cancel" button... the CheckedListBox.CheckedItemCollection will be repopulated with the checks that existed before the user made changes Also, please let me know if I have the wrong idea about how to go about finding a solution to this problem. Thank you! Hi, Thanks for your solution. Are there any classes that I can use instead of the Systems.Collection.Generic.List class supported in .NET Framework 1.1 I am developing on ...Show All

• Visual Basic XML or a database?

  I'm creating a program that basically parses textfiles and stores them into a database for easier manipulation (so I can run queries on a DB instead of parsing/comparing/etc raw text on-the-fly) Currently I am using an Access database to store everything, but now that I realize .NET has such great XML support, I figure this may be a better option.  I'm thinking of storing each file into its own XML file then loading the selected file into a dataset and pulling info from it.  This is basically what I'm doing now, but instead of XML, it's the Access db. Does anyone have any advice on which method is better  EDIT: Wow, I forgot to mention something important.  What I wanted to know is, how do I han ...Show All

• Windows Search Technologies Fix for roaming profiles

  Hello all, I'm happy to announce that Microsoft has introduced a hotfix that addresses the problems that occur when users with roaming profiles attempt to access WDS from a new machine. The hotfix, as well as further information about the fix can be found here: http://support.microsoft.com/default.aspx scid=kb;en-us;287497 It should be noted that this fix is intended for enterprise users currently running at least WDS version 2.6.5. Home users and enterprises that do not support roaming profiles do not need to install this hotfix. Paul Nystrom - MSFT I install the fix list in the article http://support.microsoft.com/default.aspx scid=kb;en-us;287497 ...Show All

• Visual Studio Team System Encrypt source code with TFS

  Hello, We are working in a solution where each developer of the team has restricted access to the projects he can read. For security purposes we need to extract all the code and backup it regularly, however this code must be encrypted and the person that executes the extraction should not be able to see any of the code. Is it possible to perform something like a get entire solution encrypted within TFS Regards Eduardo Pocas This is definitely possible using the Team Foundation Server SDK. However, if you wish to integrate it with Visual Studio 2005 it's going to be a timely task. It might be best to use the SDK and create a custom application that handles the tasks you are trying perform. SM ...Show All

• Visual FoxPro reading a directory for a existing files

  hi there! im new to vfp and i want to make a programm that reads a certain directory and which gives me back the number of the files in that directory and the filenames. can someone tell me how it works in vfp it will really be great... thanks in advanced! novelle You can use ADIR to put the filenames into an array: local cDirectory, arrFiles[1] cDirectory = "c:\temp\" nFiles = adir(arrFiles, cDirectory + "*.*") for nCount = 1 to nFiles     arrFiles[nCount, 1] next ...Show All

• .NET Development Selecting / Update records - Concurrancy

  I'm new to Visual Studio 2005 (Visual Basic). I'm an Oracle guy but I do allot of development in MS Access. I don't want to use ADO.NET's generic behaviour for record locking, etc. What I'd really like to do is to have the same behaviour as Access has where if a user changes a field, the database locks the record. I was wondering if you had any sample code that would allow me to set up a form that has a combo box on the top of the form where the user selects a record. Then the database fetches the row and displays the data on the screen. If the user changes the data, the form locks the record. What's the best way to accomplish this I've heard that this can be accomplished using transaction control but I haven't found any form / ...Show All

• SQL Server Recursive query problem

  Hi, I am not getting exact result of a recursive query I had written. Script is as below with source Table , resultset I am getting & resultset I deserve. I am unable to find exactly where the problem is. Please assist me to sove this query. WITH barcodeTree ( Barcode , Pbarcode , PacketType , RoughNo , Level ) AS ( -- Anchor member definition SELECT e . Barcode , e . Pbarcode , e . PacketType , e . RoughNo , 0 AS Level FROM [SG-Production] . dbo . PacketMaster AS e UNION ALL -- Recursive member definition SELECT e . Barcode , e . Pbarcode , e . PacketType , e . roughno , Level + 1 FROM [SG-Production] . dbo . PacketMaster AS e INNER JOIN ...Show All

• Visual Studio 2008 (Pre-release) Removing navigation buttons from Frame

  Hi I am designing a tabbed application, where each tab content is represented by a separate xaml file. Currently I am using Frame for displaying each tab content and Page is the root element for each file. Works fine, except that it puts navigation buttons on top of each page. What is the best way to get rid of these buttons Or is there more convenient way to display content ...Show All

• SQL Server OLAP - EXCEL problem - urgent

  Hello, I have a dimension hierarchy with 2 levels, like this: A - X - Y - Z B - U - V - T And I have a cube with the dimension above and one measure (sum). The fact table of this cube has 2 columns (level2,sumvalue) and i have the values: Level2 SumValue X 1 Y 2 T 6 When I access this cube from Excel and use multiple selection weird stuff happends. So, I create a Pivot table, in which i select only X,Y,U: Level1 Level2 Total A X 1 Y 2 A Total 3 Grand Total ...Show All

• SQL Server How to format prediction Expression

  hi, when i make use of predicton functions, the output is formatted in its own.But I want to format that.How to do that Thanks, Karthik. You can try select Flattened ( select $time as TimeStamp, [Performance] as Perf from PredictTimeSeries ([Performance], 5) ) as A from [Stud_Model] This allows you to customize the name of each column, as well as the name of the whole sub-select, and the results should look like A.TimeStamp, A.Perf ...Show All

• SQL Server Converting Data Types

  I have a table with a field of Char(10) Data type this field contains records of work time Attendance in a decimal format Ex. I attend today for 8.30 this means eighthours and thirty mintutes the main problem faced me to make some calculations on those records (sum, subtract, etc) so I want to convert the data from char type to decimal or real using the next code but it doesn't work select (cast (satreg, decimal) + cast (satot, decimal)) from timecard can u please help me in the main issue how to sum char type records or at least how to convert them to decimal Regards create table test ( time char(10) ) insert into test (time) values ('8.30') insert into test (time) values ('9.30') insert int ...Show All

• Visual Studio compile error 45

  can anyone explain this error pls: Error 45 The "GenerateResource" task failed unexpectedly. System.InvalidOperationException: Collection was modified; enumeration operation may not execute. at Microsoft.Build.Shared.ExceptionHandling.RethrowUnlessFileIO(Exception e) at Microsoft.Build.Tasks.GenerateResource.NeedSeparateAppDomain() at Microsoft.Build.Tasks.GenerateResource.Execute() at Microsoft.Build.BuildEngine.TaskEngine.ExecuteTask(ExecutionMode howToExecuteTask, Hashtable projectItemsAvailableToTask, BuildPropertyGroup projectPropertiesAvailableToTask, Boolean& taskClassWasFound) CPSApp Also, please try this workaround: Put this in the project files having the problem (Put it inside the first <Prope ...Show All

• SQL Server SQL Server Service don't start after reboot

  I'm with this problem!!!! when the box is recycled the SQL Server login password is not saved and has to be re-entered Then I have to go to the services and re-enter the pw every time the server is re-started. Windows 2003 / Std - SQL 2000 Any Ideas to solve this problem Rgds... ...Show All