ferlinco's Q&A profile

• SQL Server SQL 2005 Express Database Creation

  Hi guys, i`ve just downloaded a copy of MS SQL 2005 Express. I'm relatively new to programming and DB management. can i create a DATABASE using SQL 2005 Express itself Or do i need other software You have everything you need. You may want to download the graphical tools to make things a bit easier: http://go.microsoft.com/fwlink/ LinkId=65110 Then just start in the samples area of Books Online for Express and you'll find out how to get started. Buck Woody ...Show All

• Audio and Video Development New HD DVD players

  Toshiba recently announced new HD DVD players, the cheapest one is $499. But unfortunately True HD tv's are still very expensive. BTW anyone knows if they support persistent storage, or do all hd dvd players have this as default and how much http://www.hardwarezone.com/news/view.php id=5455&cid=5 It is not good to must have HD DVD encrypted in AACS to use this option :( I made some test with possibilitie to have JS application downloaded from the web on persistant storage and it didn't work (with HD XA1 and HD A1). I understand it because the option must be crypted (the JS application work on HD DVD project). Golgot13 ...Show All

• Visual Studio Express Editions Validating info from a serial port

  Im trying to validate some info from a serial device such as version info, but I’m EXTREAMLY new to programming so I cant figure out, first if I should try to pull the data out of the terminal window with the richtextbox.find or use something like serialport.equals or stringcompare. If any one knows where I could get a gentile nudge in the right direction that would be great. Ok to explain what I’m doing I’m working with a device that does gps and when it first powers up it gives the firmware version I am making a small app to change some of the settings but I would like to validate some other info from the device as I do it. I'm not sure if serial ports are a good way to get started when you're new ...Show All

• Software Development for Windows Vista <Glyphs>

  In XPS if I am printing to a legacy device I understand that all the XPS elements get translated to corresponding GDI functions. What does the <Glyphs> element get translated to DrawText No. DrawText is not a GDI32 function. It's from USER32.DLL, for drawing simple text (paragraph) on user interface. Glyphs element will be mapped to GDI ExtTextOut function normally. If the conversion is not possible, it can be translated to FillPath with the glyph outline. Feng Yuan ...Show All

• Visual Studio Team System Build Integration clarification

  moved from: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=509175&SiteID=1 I'm wondering how to handle task-bug and task-requirement / task-scenario relationships. Thus far, we've gone with the mandate that all developer work should be tracked by tasks (for bugs / requirements) except in quick (< 1 hour) situations (where it could be linked to a requirement or a bug). In short, developers are closing tasks, not requirements or bugs most of the time. so the question arises, how can i have requirements and bugs "integrated" into a build, if developers are checking code against tasks.... I think all i need is some some clarification on how build integration works. can anyone point me to a document thanks, jcran jcran ...Show All

• SQL Server Importing Access table into SQL Server 2005 Express table and adding one field

  Hi all, Hopefully I am posting this question in the correct forum. I am still learning about SQL 2005. Here is my issue. I have an access db that I archive weekly into and SQL server table. I have used the dst wizard to create an import job and initally that worked fine. field I have as the primary key in the access db cannot be the primary key in the sql table since I archive weekly and that primary key field will be imported several time over. I overcame this initally by not having a primary key in the sql table. This table is strictly for reference. However, now I need to setup a unique field for each of the records in the sql table. What I have done so far is create a recordID field in the sql table that is an int and set as yes to ...Show All

• .NET Development Update Multiple TableAdapters in One Transaction

    (VB.Net 2005 & SQL server 2005) i need to update several tables in a database, using several TableAdapters (each for one table). Since all the tables should be updated, or all fail to update together, i need to update all these tables in ONE TRANSACTION.  can anybody help me please thank you very much     thank you very much alazela. TransactionScope was the key. but still there is one question: "cant we use more than one TableAdapters with an explicit transaction " ... i've studied the thread you mentioned, somebody has offered a way to solve it. but is there an easier way just being curious! thank you very much again ...Show All

• .NET Development VBScript Native FTP

  Hi People I'm looking for help in developing a process that use ftp transfers to solve a problem. Unhappy, there is no alternative to the use of FTP. The question is how i can develop this process using VBScript with just use the native resources. At the moment i'm used sucessfully the filesystem operations (copy, move, delete, create, and others) nativelly, but now i need to use FTP process inside a windows script. Anyone have ideia as i can do it Thanks in advance, Flavio Not really the right forum, but here's the answer anyway... All you can do is write out the raw ftp commands to a text file, and then shell out to ftp.exe passing the text file as the commands to run. Its a crappy solution, b ...Show All

• Visual C++ Linking an app in debug mode against libraries built with /MD

  Here's the situation:  I have some third party DLLs, built with Visual Studio 2005, and which were compiled with the /MD switch (multithreaded DLL CRT libraries).  I want to build my application in debug mode, using the debug CRT (/MDd switch), linked against the libraries above. In VS 2003 .NET I could get this to work, but not with VS 2005. I continually see the message "MSVCR80.DLL not found" when I try to run the app. The third party DLLs were built using nmake and so have external .manifest files that are in the same directory as the DLLs. The directory containing these DLLs in on the PATH. My app is built using the VS 2005 IDE and so has an embedded manifest. If I use the "depends" tool that comes with ...Show All

• SQL Server Why does "READ UNCOMMITTED" still seem to block other transactions?

  We heve a lot of sql queries which are real pigs, using DISTINCT and GROUP BY, and lots of views in their joins. They seemed to run forever so some know-it-alls added "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" to the beginning of these queries and declared "Victory!" Well, these same jobs do behave a little better, but they still seem to block other jobs, including Replication Distribution (causing time-outs.) My obervation is that the above Set statement is not the equivalent of "read with no impact upon other transactions." What do you think Has Microsoft published anything on this subject that is useful If so, where is it so I can read it Thanks alot, Michael ...Show All

• Visual C++ window xp boot options

  hi Is there is any function in VC++ which can tell on which mode windows is running (e.g wheather windows is running on Safe Mode or Safe Mode with Networking or VGA Mode or Debugging Mode etc.) Regards Pankaj Call GetSystemMetrics with the SM_CLEANBOOT parameter... ...Show All

• SQL Server Manuel Identity system

  Hi, I have a table (TABLE_A) like this: MY_ID int unique Field1 varchar(10) I am using manuel identity system like this: INSERT INTO TABLE_A (MY_ID, Field1) SELECT MAX(MY_ID) + 1, 'Field1 Value' One row insert there is no problem, but more than one row how can I use insert statement ( TABLE_B have more than one record ) INSERT INTO TABLE_A (MY_ID, Field1) SELECT (SELECT MAX(MY_ID) + 1 FROM TABLE_A), FieldX FROM TABLE_B Iron: I normally use a stored procedure for retrieving identity values from identity tables. In this way I can have the procedure retrieve single identifiers or a list of identifiers and maintain the identity table. ...Show All

• Smart Device Development Datagrid in PPC2003 that wrap line in column.

  How I wrap line in datagrid and only set border color for one row in compact framework Is autowrap available in Windows Form only If not, is there any control that someone has done that replicate datagrid but with ability to autowrap line, and set border for row . And how do I detect a row is not visible in datagrid thank There's no good way to change row height. You might use reflections for that – it was discussed before on this forum, I'm sure you'll find it in no time. ...Show All

• SQL Server call store procedure from another store procedure

  I know I can call store procedure from store procedure but i want to take the value that the store procedure returned and to use it: I want to create a table and to insert the result of the store procedure to it. This is the code: Pay attention to the underlined sentence! ALTER PROCEDURE [dbo] . [test] AS BEGIN SET NOCOUNT ON ; DROP TABLE tbl1 CREATE TABLE tbl1 ( first_name int , last_name nvarchar ( 10 ) ) INSERT INTO tbl1 ( first_name , last_name ) VALUES ( exec total_cash '8/12/2006 12:00:00 AM' '8/12/2006 12:00:00 AM' 'gilad' , 'cohen' ) END PLEASE HELP!!!! and God will repay you in kind! Thanks! Let's say @res1 is output parameter ...Show All

• SQL Server Install problem

  I am having a problem installing SQL express. I have 2.0 framework installed as well as the other express software. I also have Visual Studio 2003 installed. Do I need to uninstall other version of Visual Studio Do I need to uninstall other versions of SQL. I get an error but it does not tell me what the problem is. Thank you Dee Try posting to http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=95&SiteID=1 . Fols from the setup team monitor that forum but don't always monitor the other forums. ...Show All