bewA's Q&A profile

• SQL Server Size of datafiles in a MSSQL2000

  Hi, I have a datadabase with 1 datafile from 60Gb. Is it a good thing(preformance) to split up this datafile in smaller datafiles from 6Gb each I don't have separete diskslices so a can't spread my datafiles on my disks but i only need to know if a datafile from 60Gb sin't too big for MSSQL2000. Thanks, Ewoud, Hi, 60 GB is way to much; you should split them in smaller chunks, this would ease up backup restore / performance and maintainance. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Team System Is it possible to create and execute my own SQL-queries against TFS-databases from within VSTS?

  I would like to create a Team Query that is more complex than the wizard inside Visual Studio is able to let me do (I would like to sum the remaining work and the completed work field and group it by users). I've managed to execute such a query against the database directly but I would like this query to be available to the public as a Team Query. Is this posible Regards, Kristofer You can create a report based on your query and deploy it to the team project's Reporting Services folder. The report will show up in the Team Explorer under the Reports folder. ...Show All

• Software Development for Windows Vista CreateProcess not collecting Std Out from Process's children.

  Hi All,    I've been working on creating a program that automates my program building and testing.  A portion that I'm having issues on is collecting the stdout and stderr on process's children processes.    I've attached a portion of *sample* code that I'm working on trying to perfect so that I can incorporate it back in to my program.  I've tried taking care of security access issues (possibly a reason that the stdout handle isn't being inhereted by children process's) by using the Security Descriptor.  Also, I have tried to duplicate the pipe write handle, in hopes that ...Show All

• .NET Development Problems reading array in struct

  Hi, I'm trying to marshal the DS_SELECTION_LIST struct ( http://msdn.microsoft.com/library/default.asp url=/library/en-us/ad/ad/ds_selection_list.asp ) to C#. It works, but only the first element is retrieved. I believe this is because the marshaler can not determine the array size. However, the field cItems in the struct determines the array size. But I can not use the SizeParamIndex with UnmanagedType.ByValArray. So I tried the UnmanagedType.LPArray but then I receive the exception: System.TypeLoadException: Cannot marshal field 'aDsSelection' of type 'ADHelper.DS_SELECTION_LIST': Invalid managed/unmanaged type combination (Arrays field ...Show All

• .NET Development Bug in Serialize() or design problem in .NET ?! Help!

  I have an object which has a delegate (event) declared in it. When I try to serialize it with: MyBaseClass obj = someObject; MemoryStream ms = new MemoryStream (); BinaryFormatter bf = new BinaryFormatter (); bf.Serialize(ms, obj); I get: System.Runtime.Serialization.SerializationException was unhandled by user code   Message="Type 'System.ComponentModel.ReflectPropertyDescriptor' in Assembly 'System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' is not marked as serializable."   Source="mscorlib"   StackTrace:        at System.Runtime.Serialization.FormatterSe ...Show All

• Visual Studio Express Editions making a default button

  Hi!! I’m writing an application that the user write a number in a textbox and then press a button to process a sub. I want the user write in the textbox and when ends press Enter and call the same sub. Is this possible Thanks for the help. Well, You could do something like this (I'm sure there is probably an easier way): Public Class Form1 'Global Variable for checking for Enter Private enterEntered As Boolean = False   Private Sub TextBox1_KeyDown( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyDown   ...Show All

• Visual Studio Team System Bug Reporting

  Maybe I'm completely missing something, but does anyone know how to see if a bug has been reported and to submit new bugs for vsts BTW: So instead of /server:<oldname> you'd need to use /server:http://<oldname>:8080. I did try this, but the command came back with an entry not found message. Since I've already deleted the entries and its pretty difficult to reproduce I can't give you the exact message, but if you can think of an easy way of reproducing the entries I'm game to test it for you. ...Show All

• Visual Studio Express Editions Does VBEE handle this DateTime?

  I use a webserver that uses these datetime structures: DATETIME_NONFORMATTED 200605012006 DATETIME_FORMATTED 05-01-06 20:06 From the help, this non-formatted doesn't seem anything like VBEE's standard non-formatted datetime. I thnk VBEE's structure is the number of seconds since 01-01-00 midnight or some such structure. I need to add like 6hrs 55min to the above and get 020201 and then convert to formatted. Am I stuck writing my own code or can someone point me to a help link that explains how to handle the above structure Convert.ToDateTime will probably work on the formatted one. T ...Show All

• Smart Device Development saving wave files to DB and retrieving it back

  Hi. I need help in tackling a problematic scenario in my PDA application. I'm recording wav filezs thru my application. The wav files will be stored in the application folder. Instead of storing it in the application folder, is it possible to convert the files into byte array and save to DB DB can be SQL CE or SQL Server. Later I shud also be able to fetch this byte array, convert it back to wav files and save them in my application folder. If anyone has tried saving n retrieving wav files from DB [need not be SQL CE, SQL Server is also Ok], please guide me. Any downloadable code samples will be of great help. Thanx. ...Show All

• SQL Server Loading multiple files

  I have a security system that creates log files in a dbf format. I need to report from a weekly collection for files. I am trying to do this through Integration Services 2005. My hope is to use the for each loop.   My problem is the only way I know how to get the data out of the dbf file is to use a .Net ODBC provider connection. In this connection I use a select statement to pull the data from the dbf file and then an OLE DB connection to move the data into a SQL table. When only processing one file everything works just fine. The statement is: select * from c:\datafiles\security\20051107.dbf.   When adding the for loop ...Show All

• Windows Forms Verisign Certificate unavailable in Store

  Greetings: I've purchased a Verisign Class 3 certificate for code signing. We've used it for deploying Win32 applications. If you right click on the installed certificate is states the following: Ensures software came from software publisher Protects software from alteration after publication 2.16.840.1.113733.1.7.23.3 I would like to use this certificate for deploying a VS2005 C# project. I understand that what I have is a PKCS7 and VS2005 requires a PKCS12 (a .pfx file). If you check out this thread ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=81494&SiteID=1 ) you can see he had the exact problem and us ...Show All

• SQL Server How to turn off logging

  Hello, did anyone know how to turn off the logging of the reportserver It writes the logfiles into the ...\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer directory. Thanks for your help. Christian Niehaves Since there are two processes, there are two places you need to go to in order to disable logging to a file. The first is in the web.config file in the ReportServer directory. You should see something that looks like this: <RStrace> <add name="FileName" value="ReportServer_" /> <add name="FileSizeLimitMb" value="32" /> < ...Show All

• Visual Studio Express Editions Search a DataBase

  In access you have a field search facility. I have a dvd collection database in VB 2005 now. How can i search the title field to see if i have already entered the title . Please point me in the right direction I'm new at thisThank you   You must use SQL : "SELECT * FROM DVDCollection WHERE Name ='" & TextBoxName.Text & "'" ...Show All

• Visual Studio Express Editions Lost form

  My god this must be the stupidest question you've ever seen. In the new express version, i have lost the userform, i know it exists because i can run the program but i cant see it How do i bring it back up Cheers, and sorry for my ignorance. Do you have the solution explorer visible In there you should have all your items in the project and solution. If you double click on the name of the form it should appear. If you do not have the solution explorer visible you can make it appear by the View->Solution Explorer menu option. Hopefully you'll find your lost form. ...Show All

• Visual Studio Express Editions Not able to create or open a project

  Hello, I just installed Visual C# Express, but I'm neither able to open nor create a new project. When I try to create a new project, the VC# shows the following error in german language (because the version is running on a german winxp sp2)! 'Die Syntax fur den Dateinamen, Verzeichnisnamen oder die Datentragebezeichnung ist falsch. (Exception from HRESULT: 0x8007007B)' This means something seems to be wrong with the filename, folder or volume label. When I try to open a project, the File dialog is freezing every time I'm going to change a folder for some seconds. Any idea Thanks Stefan Thank you very ...Show All