Remmie's Q&A profile

• SQL Server SQL Server 2005 SSIS Query Timeouts

  When I use the Import and Export wizard in SSIS to construct a SQL OLEDB Data Transfer I get an error message "Deferred Prepare could not be completed. Query timeout expired". The same query works fine when I run it under SQL Server Management Studio. The query uses linked servers. How do I adjust this so it can complete the Parse without timing out ...Show All

• Visual Studio Team System Data Generation Crach CTP5

  While doing a data generation visual studio will crash. It only crashes when it reaches certain tables and this issue does not pertain to smallmoney issue raised in earlier threads. As anyone else experienced this issue Thanks for the hard work fellas, Pete Orologas Neudesic ################################# Here is one table it hates ################################# USE [Curriculum_Test] GO /****** Object: Table [dbo].[CourseYearCrossList] Script Date: 10/03/2006 17:48:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo] . [CourseYearCrossList] ( [AcademicYear] [smallint] NOT NULL, [CourseRowID] [uniquei ...Show All

• SQL Server Strange ID created by the Subscriber

  Hi all, I have a table (Products), and the table is like this: - Product_ID (Primary Key), Not Null, Identity Specification: Yes, Increment 1, seed 1 - Name ... - Price ... When i insert in the publisher (PC, Sql Server 2005), it inserts correct ex: |Product_ID | Name | Price| Inserted by | | 1 | P1 | X | Pc | | 2 | P2 | Y | Pc | Then i replicate to Subscriber(Pocket PC, SqlMobile ), when i insert in Subscriber, it creates strange and big id's, is it normal is this to avoid conflict inserts Ex: |Product_ID | Name | Price| Inserted by | | 1 | P1 | X | Pc | | 2 | P2 | Y | Pc | | 3000 | P3 | Z | PPC | ...Show All

• Visual Studio Express Editions VC++ Express & DDK

  Is there a template for Windows 2003 DDK Some of us might want to code some device drivers. No, I didnt' install the DDK, don't even planning to do that. ;) Well, of course I did install it, but I am looking for a starter kit providing code template and makefile or whatever it takes to use the DDK tools through VC++E IDE. And, by the way, Win 2003 DDK documentation is a complete mess. Just like other MSDN documentations - they drag you through all that mambo-jambo technologies you may not even plan to use in the near future. Lots of words which do not tell a thing. Not to mention that DDK documentation is slightly harder to find than GUI documentation. Anyway, 9x/Me DDK documenta ...Show All

• SQL Server Can not create maintenance plan

  I have had two SQL 2005 Stnd x64bit servers running without any problems for several weeks now. I just setup two new ones last night. One the two new ones, I get an error message when I try to create a Maintenance Plan. I also get an error when I try to create a plan using the Wizard. The error message is: TITLE: Microsoft SQL Server Management Studio ------------------------------ The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2005 Management Tools on the remote computer, and then try again. For more information, see "How to: Install SQL Server 2005 (Setup)" in SQL Ser ...Show All

• Visual C++ Pointer Syntax Question

  Hi folks, I recently migrated from VS 2003 C++ to 2005 C++ and started a new WinForms project to test a few things. Something I noticed right away was that the design environment was declaring pointers to objects with the ^ character, rather than a * - and my usage of * was causing errors. What's going on here I've seen the same thing in the MSDN Documentation for a lot of the .NET sample code, but I'm not sure what ^ means and when I should use it... and what has happened to * -Zero Please see http://msdn2.microsoft.com/en-us/library/yk97tc08(VS.80).aspx ...Show All

• Visual Studio 2008 (Pre-release) Pasting XML as XElement

  I have LINQ CTP (May 2006) installed and working fine. In watching the latest Lang.NET screencast by Anders Hejlsberg on Channel 9, he demonstrates pasting an XML document as an XElement from a document copied in the clipboard. The "Paste XML as XElement" menu item in the Edit menu doesn't show in my VS2005. Can someone let me know if I am doing something wrong or it will be available in a future LINQ CTP. Thanks On the VS Tools menu, click on the Add-in Manager and make sure that the "Paste XML as XElement" addin is present and loaded at startup. On the VS Customize menu, click on the Addins category. You should see the "Paste XML as XElement" addin (with a smiley fac ...Show All

• Windows Forms ClickOnce Fails with "Value does not fall within the expected range."

  I have a ClickOnce-deployed application installed in offline mode across a range of Windows 2000/XP machines on my network. I now receive an 'Application cannot be started. Contact the application vendor.' error message when I attempt to run the application on my development machine. (It works still on the production machines.) I've run mage -cc, and renamed the '2.0' directory to '2.0x' to ignore its presence. Add/Remove Programs still shows it, and clicking Change/Remove pops up a window for a moment, but otherwise does nothing apparent. I've changed the installation path to be a network path instead of a website, and it still fails. The following is the error log: PLATFORM VERSION INFO Windows : 5.1.2600.131072 (Win32NT) Comm ...Show All

• SQL Server Help with syntax please

  Creating trigger on invoice insert,update to insert CustID and Invoice total into Accounts table I get part of it working INSERT INTO Account(CustomerID,Total) SELECT i.CustomerID,i.invoiceTotal FROM inserted AS i but before it does this I need to check to see if the CustID exists in the account table. If CustID exists Set Total = Account.Total+i.InvoiceTotal I'm new to transact sql and have tried ON dbo.Invoices FOR INSERT AS SELECT CustomerID FROM Account if Account.CustomerID = i.CustomerID begin UPDATE Account SET Account.Total = Account.Total + i.invoiceTotal FROM Account INNER JOIN Invoices ON Account.CustomerID = Invoices.CustomerID SELECT i.invoice ...Show All

• Visual Studio 2008 (Pre-release) Error : The default entity container name 'HRISBusinessModel.HRISBusiness' is invalid.

  Hi, I've created my first test application and I got the following message : The default entity container name 'HRISBusinessModel.HRISBusiness' is invalid... I'm unable to find a reason, so if someone can help me to solve this Message : The default entity container name 'HRISBusinessModel.HRISBusiness' is invalid. The required mapping and metadata information could not be found. Parameter name: defaultContainerName The inner exception message is : The Entity Container Type 'HRISBusinessModel.HRISBusiness' for the CDM space does not exist in Metadata workspace. MSL: < xml version="1.0" encoding="utf-8" > <Mapping p1:Space="C-S" xmlns:p1="urn:schemas-microsoft-com:windows:storage:mapping:CS&quo ...Show All

• SQL Server Selecting varchar(MAX)

  Hi, Hope I'm in the right forum. Is there some sort of trick to being able to see all the data in a varchar(MAX) column I'm inserting some lengthy data into varchar(MAX) columns. Running the profiler, I can see that long strings are being passed in. But, when I query (to grid, text or file), I only see the very first character. In addition, when I do a SELECT LEN(myVarcharMaxColumn), it returns 1. What am I missing here Thanks, Mike oh, I should say that I have four varchar(MAX) columns. They are defined as varchar(MAX) when I right click the table and chose Modify. When I do sp_help myTableName the length of the varchar(MAX) colums shows as -1. Mike ...Show All

• Visual C++ Dialog with a toolbar with tooltips failing

  I have a dll, the dll calls up a dialog which has a toolbar in it. The toolbar buttons all work fine, the dialog works fine but for some reason I cannot get the tooltips to show I have tried a pretranslating the message, added 3 different methods of getting them to work and nothing has worked.. This is a dll called by a program and the main call the the dialog is below: Also this dll is a MFC in a Shared DLL.. static void ModelessDlg() { int rc = 0; HWND hWndParent; AFX_MANAGE_STATE(AfxGetStaticModuleState()); //The call to the main app to get an handle to the main window hWndParent = main_GetWindowHandle(); CModelessDlg *pModelessDlg = new CModelessDlg; pModelessDlg->Create(IDD_MODELESS, CWnd::FromHandle(hWndPar ...Show All

• Visual Basic Sql Server project stuff...

  Dear folks, I’ve created a Sql Server Project from my Visual Studio 2005 with Visual Basic. When I try to add GetCommand it doesn’t appear at all, intelligense doesn’t show me that method. Why I don’t get the point. What else/assembly is needed Dim oCommand As New SqlCommand Dim oPipe As New SqlPipe oCommand = SqlContext. Thanks in advance for your comments and thoughts, You're accessing the SqlContext class statically/shared. The intellesense you're listing is the correct intellesense for that class. http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.server.sqlcontext_members.aspx GetCommand is not a member of SqlContext. Is there a ...Show All

• Windows Forms is there a limit on Controls contained in VS 2005 .NET Form ? handle creation exception

  I get a Error creating a window handle upon trying to create the 9937'th control. The number of controls when the exception occurs is dependent upon the mixture of controls created, InkEdit controls produce the exception much earlier. I was attempting to reproduce the incosistent behavior of ToolTip in my "real" application which currently has 9,216 controls (previous post that has no solution yet!). This has the feeling of running out of memory OS: Windows XP professional (32bit), patches as of 9/12/2006 CPU: Dual Core Opteron, 2GB Ram Attached is the exception detail and the files that make up the VS 2005 test program. ================================================================== System.ComponentModel ...Show All

• Visual C# Struture within a Structure

  Hi, I have the following two structures public struct structBaseFile { public string Filename; public string Language; public string Encoding; public string Path; public string Platform; public string Filetype; public structLocalFile [] Loc_File; } public struct structLocalFile { public string Filename; public string Language; public string Encoding; public string RelativePath; } As you can see structBaseFile contains an array of structLocalFile - my problem is...HOW do I initialise this. I have something like this currently structBaseFile _basefile = new structBaseFile (); _basefile.Filename = "file&q ...Show All