A1Programmer's Q&A profile

• SQL Server insert only time in sql server database

  hi, i want to insert only time in my sql server database.but when m try to insert time in database it takes time+default date. i want to eliminate this default date. plz any one know this then tell me. Regards, shruti. Can't be done Huh. I was seaching for the answer to this today. Alright, I can deal with having the default date in there. But what really confuses me now is that all of the existing values in this column in this database are only the time value. Existing asp pages (which both create and update these records) seem to have no problem just putting the time in there. No acrobatics. Now, I'm using an UPDATE query, and they're using an ADODB.Recordset object. I guess that makes a difference 1 ...Show All

• Visual Studio Tools for Office I can't debug

  I am in a strange situation that i'll try to explain. I have prepared a Virtual Machine where i have installed this: Framework 1.1 (vs.net 2003) Office 2007 My old VSTO Excel solution (implenting ISmartDocument interface) My old solution run ok but i can't debug it. Anyone have some idea how to solve this problem i have tried in 2 ways: start debugging from Visual Studio 2003 (F5) by set Option Debuggin "Start External Program" (in my case Excel). Excel start but when i open my smart document it exit without informations first i start my smart docuement, task pane load ok and i run. Then in Visual Studio i select "Attach to process", select "Excel", but it say: "Unable to att ...Show All

• SQL Server Conditional Split Question

  I have a package which has a conditional task which directs rows to its respective OLEDB command. The records are sorted from the source system in chronological order. The problem I am experiencing is that some of the operations do not seem to be occurring in the same order. An example of this would be someone inserts a record, deletes the record and reinserts in the record in that order. When we run the package we can see the records are coming down in chronological order but the delete from the split seems to occur after the inserts. Has anyone else experienced this Is there anything I might be missing to ensure things happen in the order they should Any advice would be greatly appreciated. Thank you. Bagles1 wrote: Thank you ...Show All

• Visual C++ Help needed for Windows Hooks ( Global Mouse Hooks )

  I have two addins installed in my Outlook 2003, both have their specific functionality, I would like to integrate the functionality of both thru global mouse hooks, here is my senerio 1) Lets say there is a button "abc" on toolbar "A" in outlook mail composing window 2) and there is a button "xyz" on toolbar "X" in the same mail composing window 3) on click of button "abc", I would like to generate click of button "xyz" first 4) and then resume back to the process of button "abc" I am thinking of developing application using VC++ and creating global mouse hooks (may be there is some better approach), I know I can capture the mouse click but my questions are 1) h ...Show All

• SQL Server VFP Linked Server problems

  We're using SQL Server for the majority of our applications, but our accounting package is still in VFP 8.0.  I need to make some costing adjustements from our inventory program.  I have linked the VFP database to SQL Server just fine and, using OPENQUERY, I can SELECT data without a hitch.  Performing an UPDATE or INSERT, however, is a different story.  I get the following error: "Server: Msg 7301, Level 16, State 2, Line 1 Could not obtain a required interface from OLE DB provider 'VFPOLEDB'." Scouring the internet wasn't very helpful on this.  Can anyone offer me any suggestions I am having this same issue running update queries on a VFP file via SQL Server express. I'd like ...Show All

• Visual Studio Embedded Code

  I have written a function in the 'Embedded Code' section under 'Report Properties' ... but when I try to call the function in an expression, it is not available. Code: Public Function FindStatus(ByVal Val As Integer) As String Dim rStr As String = String.Empty Select Case Val Case 0: rStr = "BLANK" Case 1: rStr = "MUD" Case 2: rStr = "TIME" End Select Return rStr End Function Any Ideas Do you mean that the Expression Editor does not seem to know about your function If so this is a known limitation of the Expression Editor. Your function is available; just ignore the red squiggles. ...Show All

• SQL Server SQL parameter Syntax

  Guys, Wahts the right way to specify a parameter in an Execute SQL Task when the param is a varchar should I use apostrophe's around the or not I have two SQL tasks .. one where the query is specified like : WHERE FIA.BaseCurrency = Which SSIS likes and doesn't complain about...(the but then I have another query.. [below].. which SSIS complains about unless I have apostrophes around the So its like: AND FIA.BaseCurrency = ' ' So.. which should it be The problem for me here is that when I DO put the apostrophes around the I get no results back from the query... PJ The problem query: SELECT ForeignCurrency, RateFromFile AS YesterdaysRate --The ISNULL just protects us from situati ...Show All

• SQL Server Sending a report via email triggered from a trigger on a sql table

  My question is it possible to send a report developed in reporting services via email as either a attachment or imbedded in the email, from an insert trigger placed on a table in sql. If so could you please help with the string that would be need to achieve this. The report will need to have one or two parameters passed to it from the table. The report is built and working through reporting services already. I was impressed with the subscription services that reporting services has in place and would like to utilise the reports further by auto emailing out when a new record is placed in the table. To be sent out either as an attachment or imbedded in the email it self. Thanks for any assistance in advance David ...Show All

• SQL Server Eternal 'Enable Pending' on SQL2005

  Hi! I have this problem... im kinda new to sql2005, and im responsible for creating some notification services. Ive done a lot of tutorials, books and samples and every time, when i reach the step of enabling the instance, i get this... Generator-Enable Pending Distributor-Enable Pending Even doing the Microsoft's Notification Services Tutorial. Ive tried everything I could figure, registering the instance with a user with every permission there could be... doing this local or on a client... and ive been 2 weeks stuck here... Any tip or clue will be thankfull. M.Eng.Leandro Melendez Ouch! That's a pretty drastic step! Glad it worked and thanks for posting the solution. Haven't had that problem before (thank ...Show All

• Architecture How to best implement an Orchestration Layer?

  So after carefully divding and separating our middle tier into lously-coupled services, the need for an orchestration layer that sits on top of all the services became apparent. I'm curious to see how others are implementing this orchestration layer: using something like Biztalk or another code layer that plays the role. BizTalk seems great at managing a business workflow, but what if this orchestration layer needs to aggregate data from multiple services Is BizTalk still the right tool Also want to know is since some service calls need the orchestration layer's help and some don't (calling the services directly), is there a pattern for this In other words, does the presentation layer ALWAYS call the orchestration layer even if some ...Show All

• Windows Forms setting the richtextbos properties

  i have opened a text file in richtextbox now i want to make some words bold and change the color .how can i do it using c# can anyone help me You need to select that part of the text you want to apply font changes to, then you can make those changes: richText.Select(10, 20); // selects twenty characters starting from the 11th (0 based) richText.SelectionFont.Bold = true; You might need to check SelectionFont for null as it is not set, when the selection contains more than one font style. -- SvenC ...Show All

• Visual C++ make a dependatnt service

  hi all i had made a service that beeps after a specified time interval.now i want that this service should be depend upon the some other services like RPC so that user cannot turn it off. or like RPC service whose stop button does not work or is disabled. Thanks in advance. If you use the .NET ServiceBase class, set the CanStop property to false. If you do this native, remove the SERVICE_ACCEPT_STOP flag from the dwControlsAccepted member of the SERVICE_STATUS word. Be careful doing this, beeping tends to drive users nuts. ...Show All

• SQL Server Invalid object name 'dbo.sysmergesubscriptions'. error

  Hello, the Expired subscription clean up agent is failing. When I try and run the command via studio mgmt I get the following error. Any help would be greatly appreicated. We have 5 publishers and one distributor all on a sql2k5 sp1 box. Command run: EXEC sys.sp_expired_subscription_cleanup Error: Msg 208, Level 16, State 1, Procedure sp_MSdrop_expired_mergesubscription90, Line 21 Invalid object name 'dbo.sysmergesubscriptions'. I'm wondering if you have another database that's been published before, but not cleaned up properly Can you run this script and let me know how many databases are returned as well as which ones returned do not have table dbo.sysmergesubscriptions. SELECT DI ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. No news about XNA 2?

  It has been a long time (feeling instead of real time) since XNA 1 released. I've been waiting for news about the next big thing. But it seems it's rather quite; no early info is out. What will be the next exciting things I can only guess... 1) Maybe it's an XNA Game Studio Professional which works with VS Pro version. But I'd rather like an XNA SDK to work with any IDE. 2) Maybe it's great enhancement to the framework. Many more D3DX stuff come into XNA, lifting XNA to the same level as MDX/native DX in functionality. Hmm...I hope the functionalities are not dropped just because they're not supported on XBox. XNA GSE has only been out since 1/3 into December in 06. Version 1 isn't too old! Since C# is a . ...Show All

• SQL Server Problem with slowly delete many filtered rows in table.

  I use cursor for delete 20 milions rows from one table, but it's very slowly. I want use delete rows in a non-resource consuming manner. I don't need from transaction log, but don't know how turn off it. Please help me! 10x I use the cursore because i want remove filtered data from this table. I have relation with another table and result to deleted rows is round 21 milions records from 41 milions. The big table have 9 indexes. Is it a problem to slowly execute I probe to not use the cursor. Write where clause with operator IN, but this not solve the problem. Now delete indexes, but problem stay. For cursor i use option FORWARD_ONLY, and delete records with DECLARE abc CURSOR FORWARD_ONLY FO ...Show All