magrawal's Q&A profile

• SQL Server Transfer SQL Server Objects Errors

  Hi. I'm totally new to SSIS (SP1), and I'm having a raft of troubles transferring DB's using the 'Transfer SQL Server Objects Task', which seems to be the closest replacement for the old DTS Transfer Objects tool. I'm trying to transfer a DB from an SQL Server 2000, where I only have SQL Server authentication (it's a shared hosting environment) to my local SQL Server 2005 server, where I'm logged in using Windows Authentication (although I have the same issues if I use SQL Authentication locally). Here's the list of errors I'm getting. If I don't select 'copy all tables', I receive a "table does not exist at source" error. If I d ...Show All

• Visual C++ UNICODE and RichEdit control

  How can write a UNICODE string in a RichEdit control (ReplaceSel has as argument only a LPCTSTR) sdiaconescu2001 wrote: How can write a UNICODE string in a RichEdit control (ReplaceSel has as argument only a LPCTSTR) If this is a Unicode build, then an LPCTSTR maps to a LPCWSTR (pointer to a const wide character string), which is what you need. Just use the _T macro. pRichEdit->ReplaceSel( _T("...") ); ...Show All

• SQL Server When to reindex

  Hi All, Just a quick question, I am fairly new to the SQL Server world. Can someone tell me when I should rebuild an index Is there some bench mark A magic number Should I be looking at certain statistics Thanks Chris Hi Chris, I'd start with this white paper:  http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx Regards, ...Show All

• Visual Basic IErrorInfo.GetDescription failed with E_FAIL(0x80004005)- What does this error means?

  Does anyone have a clue what does this error means IError Info.GetDescription failed with E_Fail(0x80004005) I am getting this error while using ExecuteScalar method of OleDbCommand Object to execute a nested query against access 2003 database. This error occurs when you use keyword as your table name or field name. For instance Date, Close, Catalog etc are keywords. In order to over come the error, put square brackets around field name and table name in your query. eg [Date] ...Show All

• Windows Live Developer Forums Information / Error messages

  Hi there,   Is there a knowledgebase or something somewhere that holds all the informational or error messages that can tell me further details on the message ie, while signed into Live messenger, I have an information message that says "due to Connection problems changes you make might not be applied to other computers you use", and all my contacts appear offline, and I can't add new contacts.  I've deleted various regenerating dlls and cache.dat files etc and nothing's worked.  I've even shutdown my zonelabs firewall.  I can talk to people, but can't see their status.  I even reactivated my hotmail accoun ...Show All

• Visual Studio Express Editions Serial communications outputting and receiving one byte of data.....

  Okay, I am on deadline here.... 3 days... and for the last 2 weeks I have been trying to find the answer. Apparently there is no easy way to use a serial ports in VB2005 express... Most of the code I have found is for the .net version. It really doesn't port well. I have gone through and for the most part changed what needed to be changed. No Luck.... With the code written below that was copied and I duplicated the form to match the text, combo boxes and everything else it just doesn't want to work correctly. I am trying to write one byte of data to a processor and a few milliseconds later receive the response. the outgoing is the addres ...Show All

• Visual Studio Express Editions Cannot create a new project that opens startup form

  Have been using vb 2005 express final now for a week or too.  Have had no problems using and modifying example code and connecting to a MySQL database.  However i am now trying to create a new project and no matter what form is selected under startup form nothing displays when code f5 is pressed.  Message that build is ok in status bar screen refreshes and back to IDE.  However existing projects work ok.  Even creating a simple one form app leaving default form name as form1 the form will not display.  Any ideas please!    step by step 1 new project windows app 2 add button to form 3 add ...Show All

• Visual Studio lost help

  Dear all, I just installed Visual Studio 2005 (upgraded from beta 2) and now, all the help files are gone. I mean, they are located on the hard drive, i have reinstalled it 3 times, 1.9GB of files, but the help menu in Visual Studio contains only the "help on help". No other topic. And also, I don't know where to download "Microsoft Document Explorer 8" Any help would be great. Specially since it's hard to find anything relevant on the search engines when you are looking for help on help... Hi, keep sure that you have uninstalled all beta 2 components before installing the final version. Here is a link about ...Show All

• SQL Server Deadlock Issues

  You need to post detail about your queries.  Show DDL, sample data, and the two queries that are deadlocking, and we can help you re-write them so that they don't deadlock.   See the following if you need help providing DDL and sample data:  http:// www.aspfaq.com/etiquette.asp id=5006 -- Adam Machanic SQL Server MVP http://www.datamanipulation.net --     < clubberx@discussions.microsoft.com > wrote in message news:41ed2763-84cf-4fa2-94d9-6c611f19ff0a@discussions.microsoft.com ... Hi, We have a site setup using MsSQL 2000 SP4, Coldfusion and IIS. We are se ...Show All

• Visual Studio Team System Static analysis question

  I want to help a coworker in tracking down a spurious crash by using the Statically Analyze commmand in Visual Studio 2005, but I decided to give it a test drive first. On this test, I expected it to report a use of an uninitialized variable.  Is this correct expectation of the /analyze switch   I'm using VS 2005 B2. void foo( int & x ) {    printf( "%d" , x ); } int main() {    int uninitialized;    foo( uninitialized );    return 0; } In order to minimize noise, code analysis doesn't make any assumptions about whether the callee requires an ...Show All

• Visual C# Convert Perl Code to C#

  I have a perl script which I wanted to convert to C# which I can use for my application. Is there any tool/utility which does this. Thanks Imtiaz It's not too big. I am pasting it here.  It reads a pipe delimeted file fetches some data and write it to another file. Following is the complete script   eval '$'.$1.'$2;' while $ARGV[0] =~ /^([A-Za-z_0-9]+=)(.*)/ && shift; $[ = 1;                 # set array base to 1 $, = ' ';            &nb ...Show All

• Smart Device Development C++/CLI?

  I distinctly remember being told that it would be possible in VS2005 to use C++ to develop using the .NET CF. I can't find any way to create such a project however. What gives You sure can use C++, but native only. Managed C++ support was never promised: http://groups.google.com/group/microsoft.public.dotnet.framework.compactframework/browse_frm/thread/a184d802972e440c/d8f4085cc37d6d39#d8f4085cc37d6d39 ...Show All

• Visual Studio Express Editions VISUAL BASIC EXPRESS - 2 COPIES

  Several weeks ago I installed VB Express from a CD On Friday I installed Visual Studio Express from a DVD which I received from Microsoft. Do I now have 2 copies of VB Express on my computer If I do , can I use the Uninstall program to delete the 1st VB Express installation Visual Basic Express Edition is a product that can be individually installed and uninstalled. If you want to uninstall it you should be able to find it in the add and remove programs in the control panel. I have not heard of a Visual Studio Express Edition. Do you mean the full Visual Studio 2005 product If you have VS2005 installed VBEE will be red ...Show All

• Windows Forms GDI+ Error and (JIT) debugging message, help need

  Below is the error message, anyone here know what the problem cause this error how to fix it See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.OutOfMemoryException: Out of memory. at System.Drawing.Graphics.FromHdcInternal(IntPtr hdc) at System.Windows.Forms.MenuItem.WmDrawItem(Message& m) at System.Windows.Forms.Control.WmDrawItemMenuItem(Message& m) at System.Windows.Forms.Control.WmDrawItem(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ToolBar.WndProc(Message& m) at System.Windows ...Show All

• SQL Server MaintPlans on active/active failover cluster

  So I've recently finished setting up a two-instance active/active failover cluster (win2003 enterprise x64 and sql2005 enterprise x64). Basic connectivity, individual db access, and failover tests all appear to be working properly. Now I'm trying to set up maintenance plans for the various DBs residing on each instance. But I can't seem to wrap my head around how maintenance plan creation relates to SSIS. I read Kirk's blog post on making SSIS a clustered service (http://www.sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx). But the steps seem like they'd only work for a single instance failover cluster. And I'm not sure whet ...Show All