trucktrax's Q&A profile

• SQL Server copying table in a database

  Hi good day to everybody, Can we copy a table from a database and saved it into a diskette Because i did not find or maybe i miss or doesn't know how to do it from EXPORT/IMPORT tools.  The computer to where I attach the table is not connected on d'same network, and if I backup & then reinstall the whole database into that PC, all records in their will be overwritten by the new one which is not I wanted to be. H ...Show All

• SQL Server Stored Procedure being saved in System Stored Procedures

  We recently upgraded to SQL Server 2005. We had several stored procedures in the master database and, rather than completely rewriting a lot of code, we just recreated these stored procedures in the new master database. For some reason, some of these stored procedures are getting stored as "System Stored Procedures" rather than just as "Stored Procedures". Queries to sys.Objects and sys.Procedures shows that these procs a ...Show All

• Visual Studio How to synchronize 2 VSS 2005 Servers

  Hi All Is anyone there who could give me a hint how to sync 2 SourceSafe Servers (or in detail: one project on Server A has to be synchronized with a copy on Server B). The script I wrote for that works fine until the project changes (adding files/projects), so I'd like to know if there are working solutions for synchronizing projects on 2 different VSS 2005 servers, or if I've to code a tool/script for that. Regards, Sebastian ...Show All

• .NET Development GC does not work in Console Application with STAThread specified.

  I have a host that is a Console application. To exit the host the user has to press enter.  I ran into what I thought was a remoting memory leak . In the end, the garbage collector was running but was unable to collect objects created on main thread as I had it blocked by Console.ReadLine() to prevent the console window from closing. The solution was to change the Main method attribute from [STAThread] to [MTAThread] which allows the garba ...Show All

• .NET Development File.CopyTo throws Operation Successful error

  Hi all, I'm currently developing an application that transfers a file from a local machine to a remote server via UNC using the System.IO.File.CopyTo command. What seems to be happening is that with larger files (test file is 80+ megs) the command throws an error during transfer with the message "The operation completed successfully" and is coming from mscorlib StackTrace = " at System.IO.__Error.WinIOError(Int32 ...Show All

• Visual Basic Help me converting simple VB6 code to VB.net

  Hi! This code is obviously VB6 code. Im desperately trying to get the width and height of an AVI file, and i found this code. This is the errors i getting. Maybe it will make things easier: error BC30802: 'Type' statements are no longer supported; use 'Structure' statements instead. error BC30678: 'End' statement not valid. error BC30828: 'As Any' is not supported in 'Declare' statements. error BC30002: Type 'AVIFILEINFO' is not defined. Can ...Show All

• .NET Development Write Text File with the same Culture

  Hi, I developed a windows form application which writes a txt files with portuguese words with accents. The applications was developed in Windows XP in english and it writes the file correctly. But, when it runs in Windows 2000 Portuguese, the portuguese words have the accents changed to ascii simbols. How to fix it Regards, Marcelo. You need to install the font file in the machine under %System32%\fonts. You probably got the fon ...Show All

• SQL Server Lookup including looking up on null values possible?

  In order to insert datekey values in I lookup datekey in the datedimension table. I join on the 'Date' column that contains dates. The datedimension contains one record for 'unknown date' for which the value of the 'Date' column is null. The behavior that I desire from my lookup transformation is that for input records with a date the corresponding datekey from the datedimension is looked up and for records with date = null, the datekey for 'unk ...Show All

• SQL Server How to calculate percentages on a dimension?

  I have a dimension table USER which has various attributes such as Grade, Location, Employee Class. My cube is constructed to analyse what types of users are calling the help desk based upon these USER attributes. For example, users of Grade E make x number of calls in a month. To make this more meaningful I need to be able to determine what percentage of ALL employees each grade represents. For example, if Grade E employees total 2% of al ...Show All

• Visual C# Error sending filled form via email

  This is the code I use to send my form via email: protected void sendMail(string strFrom, string strBody) { //create the mail message MailMessage mail = new MailMessage(); //set the addresses mail.From = new MailAddress(strFrom); mail.To.Add("myEmail@myDomain.com"); //set the content mail.Subject = txtSubject.Text; mail.Body = strBody; mail.IsBodyHtml = fal ...Show All

• Visual Studio Team System You are not authorized to view this page

  Hello, After installing tfs I found the team foundation server admin site at port 8080 but while trying to access that page from another system always give the forbidden http error 403  I configured teamserver to allow anonymous access and I invited the person trying to access the page from another system. (the basic teamserver webpage is also unreachable from the server itself). the same goes for the sharepoint server which was installed a ...Show All

• Visual Studio Team System source control- adding empty folder

  Hi Is it possible to add empty folder to source control Thank you all I wasn't able to find out how to do this. However, if you create a dummy file and put it in the directory then you can add the  folder + file in the usual way. I found it useful to create a file called 'index.txt' for each folder and add a few lines to describe its purpose. Will     ...Show All

• SQL Server DATABASEPROPERYEX is not a recognised function name

  I am trying to write a report in reporting services 2000 which access a sql server 7 database.  It all workes fine with the connection and creating a dataset but I cannot seem to get the results displayed in the preview section.  I get the following error: "An error occured during report processing query execution failed for dataset XXXX DATABASEPROPERYEX is not a recognised function name "   Any help greatly appreciated ...Show All

• .NET Development Moving the file while it's still being created

  Hi everyone, I have the following problem. I use FileSystemWatcher.Created event to call a procedure that needs to move that file. Well, Created event should be called Creating, because it raises when file creation begins, and while it is being created. So, my problem is that I can not move the file until process that is creating the file ends. This is my solution: Dim Success As Boolean While Success = False Try Succe ...Show All

• Visual Basic Question about setting bits.

  I have the following: Dim bit As Byte = b(1733) If have1.Checked = True Then bit = bit Or 1 Else bit = bit Xor 1 If have2.Checked = True Then bit = bit Or 2 Else bit = bit Xor 2 If have3.Checked = True Then bit = bit Or 4 Else bit = bit Xor 4 If have4.Checked = True Then bit = bit Or 8 Else bit = bit Xor 8 If have5.Checked = True Then bit = bit Or 16 Else bit = bit Xor 16 If have6.Checked = True Then bit = bit ...Show All