Answer Questions

• hmayer positive and negative signs

  i have account_entries table which has the following fields: debit_or_credit entry_amount and I want when inserting every field to check if the inserted row was assigned to (D)ebit and (C)redit it should change the entry_amount accoridanly. maybe something like trigger plz help... i have one more non-IT question plz.. I have assigned the visit fees as expense, visit payment as income what about the discount will be positive or negative income or expense I'm hoping I've answered your question correctly - I'm not entirely sure of the situation. Here I'm assuming you have revenue which is paid to you, but some people may have a discount, which reduces how much you ch ...Show All

• bensterdev Wrong values stored in a field of Datatype Float

  Hi, When i try to insert a value in to a field of datatype float(8), it is storing the wrong values(approximate values). For example, if i try to insert 2.62 , it takes it as 2.6200000000000001 But i can see the correct values displayed in the frontend. Heard that there is a fix available for this issue. Could any of you help me in getting the details about that fix Thanks in advance. ~ Chaitanya No, this is by design. FLoat(8) will display the exact values for 8 digits: 2.6200000 000000001 HTH, Jens SUessmeyer. --- http://www.sqlserver2005.de --- In addition to what Jens said, read here about the float datatype: http://msdn2.mic ...Show All

• NoSTaBoNN How can I Remove the Screwed-up AdventureWorksDB in SQL Server Management Studio Express?

  Hi all, I downloaded AdventureWorksDB.msi Microsoft and struggled to install it in my SQL Server Management Studio Express 8 months ago. I forgot the AdventureWorks examples and other stuff were in my C:\ drive. Recently, I downloaded a new AdventureWork.msi and executed it to install without removing the old stuff from the "Add and Remove" of Control Panel. Now my AdventureWorks database is screwed-up in my termical PC that is linked with Microsoft NT 4 LAN System!!! Please kindly help and tell me how I can revome the scewed-up AdventureWorksDB in my terminal PC. Thanks in advance, Scott Chang Hi Buck, Thanks for your response. I following your instructions and I got the following: Database to detach: ...Show All

• technoTABLET How can i make an updatable view???

  Please read this example: I got 2 datatables PersonName: wich contains IdPersonName, Name and IdPersonLastName PersonLastName: wich contains IdPersonLastName and LastName I know that i need to make a relation between Person and PersonLastName I want to make a view named Person: wich contains PersonName/Name and PersonLastName/LastName and i want to make updates to the two datatables when i insert data in the PersonView I hope someone can Help Me This should do. ALTER Trigger Trigger1 ON dbo.PersonComplete INSTEAD OF INSERT AS BEGIN SET NOCOUNT ON INSERT INTO PersonLastName SELECT LastName FROM inserted i WHERE not exists(SELECT 1 FROM PersonLastName pln WHERE pln.L ...Show All

• HSBF Lewe ---PULL replication with SQL Server Express, it is possible whether or not?---

  Hello! Question of such plan, to documentation to Microsoft SQL Server 2005 Express Edition it is written, that the given product supports only PUSH replication, however in his{its} structure there is an agent replmerg.exe which description says: replication merge. Synchronization means, that the agent of merge transfers changes from the subscriber to the publisher, and then transfers changes from the publisher on the subscriber … And so the question if this agent is present at this edition, whether that is possible to adjust manually his{its} call, or through Windows the agent, for realization PULL replication or it is impossible and for what reasons Thanks. I do not understand your q ...Show All

• tonalt Mobile replication

  I have the following setup Server 1: Windows 2003 inc IIS. Also on this server is SQL Server Web sync web service and it has an external IP address for internet connectivity Server 2: Windows 2003 inc SQL Server 2005. This server has a database setup with replication so the a Window Mobile 5 device can do a merge replication. My problem is that the replication fails when trying to send the snap shot from Server 2 to the mobile device. The device seems to get through to the replication agent, as entries in the Replication monitor are logged (see below). I have checked all the permissions on the relevant shares required for replication (basically set "Everyone" with full access). My initial question would be. ...Show All

• kforrey How to fail when ForEach File Enumerator doesn't see files

  I have a ForEach file enumerator that executes a data flow for every source file in a specified directory. If there are no files in the directory, the package executes with a result code of 0. I need the package to fail if there aren't any files found in the specified load directory. Is there a simple way to do this with the SSIS component, or will I have to script the entire file enumeration process inside script tasks to handle this requirement Thanks in advance for any assistance with this question. Please post replies to this forum. -Doug Yes, we need to fail it because the job scheduler we use will provide the appropriate notification or take appropriate action to try and resolve the situa ...Show All

• Narayan19 SQL Server next generation product family

  Is there any documentation available on sql server product family after SQl Server 2005. If so what new enhancements are planned. We are planning to release a product in 2010 and would like to get an idea on what new features we could take advantage of in next versions and compatibity issues. TIA We are still not public on much of this information. You will definitely start seeing some more details in the next six months. Is that OK Feel free to contact me offline, I work for product group, mark.souza@microsoft.com I believe you have to refer through the http://www.microsoft.com/sql website where relevant links are availble for the third party vendors , if not you can contact your local ...Show All

• ltca Where (what file) are job history logs stored?

  I need to perform a backup of the file(s) that hold the job history for a scheduled job. Where are these files kept Names Can anyone help I've looked in EM and while I can set the size of them, I cannot seem to find any indication of where they are kept, called, etc. tx Thanks !! hi, are you looking for the sysjobhistory in the msdb table   try this use msdb select * from sysjobhistory regards, joey   ...Show All

• Stan B The Problem 800a0ea9 absolute recipe what ?

  Windows X64 - IIS6 The Problem 800a0ea9 absolute recipe what conn.asp <% set Bag = Server.CreateObject("adodb.connection") strConn = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & Server.MapPath("db/vt.mdb") & ";" bag.open strConn %> ADODB.Connection error '800a0ea9' Provider is not specified and there is no designated default provider. /test/ vt. .asp , line 16 http://support.microsoft.com/kb/278604 Also, be sure the website identity account (IUSR_xxx) have read/write to the subdirectory. You need to grant full permission and restart the website/IIS to take effect. http://blogs.msdn.com/david.wang/archive/2005/09/23/HOWTO_Dia ...Show All

• kawano1h Parse dataset in report

  I am using a "jump to report" that accepts multivalue parameters for fiscal periods. It works fine, returning the correct data. However, I want to add the chosen fiscal periods to the report header in a textbox. When I use =Join(Parameters!DATEfiscalperiod.Value, ", " ) the results in the textbox show as: [DATE].[fiscal_period].&[5], [DATE].[fiscal_period].& When using:: =Parameters!DATEfiscalperiod.Value results in [ rsInvalidExpressionDataType] The Value expression used in textbox ‘textbox5’ returned a data type that is not valid. Is there a way to parse the dataset to only return "5, 6" in a string TIA ...Show All

• James_Z SQL Server General Network error.

  Hi, I am using .Net framework v 1.1 and SQL server 2000. I got the following output on firing "SELECT @@version" in my sql server. ---- Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) I am getting the General Network error when i try to select, update or insert data from / into sql server. This error is randomly generated and some times just disappears. But i am sure that there must be some problem bcoz, now or then the same error is thrown. I am firing these queries from a windows service. Since it would be automatically working in background i want that a sure shot solution be imple ...Show All

• kesim Can aggregate functions be used in a check-constraint or a computed-column?

  Hi, Can aggregate functions (e.g. Sum, Avg) be used in a check contraint or in a table's computed column Thanks! Thanks for the suggestion to use a function. Tried it and it works well! Green: I don't think you can use subqueries for either circumstance; therefore, I am not sure that you can apply either one to a table. I think that the best you can do for a function is a scalar function. Can somebody else verify this Dave You cannot do it directly, but as Dave suggested, you can do it by creating a function. Here's a simple example create function SumTestOne() returns int as begin declare @retVal int select @ret ...Show All

• TomTom2000 Javascript Error on Report Manager

  Using SRS 2005 w/ forms security enabled, I have come across a persistent error that I am unable to resolve. It appears that the report manager is failing to reference a javascript file [ Scripts.ReportViewer.js] that is served through an .axd file [ Reserved.ReportViewerWebControl.axd ] that is apparently dynamically created by SRS. The symptoms of this are: OK buttons do not function, the layout on Report.aspx is degraded, images do not load, and I get a multitude of javascript errors. I have verified that the .axd extension and wildcard mappings in IIS are correct and that the "Verify file exists" are unchecked. Others have apparently experienced this issue, but there is no KB article regarding this issue. [here are s ...Show All

• Caolan ODomhnaill ConnectionManagerOleDb usage in a Script Component

  Hi, I have a need to use a shared connection manager of type OLEDB inside a Script Component. I guess that the right way to get the OLEDB connection is to override the AcquireConnections method, case the shared connection manager to the ConnectionManagerOleDb interface and call the AcquireConnection method. The problem is in the return value of the AcquireConnection method (it’s Object). My assumption is that in case of OLEDB connection usage, the AcquireConnection method returns some OLE DB COM interface. Does some of you tried to cast it to some interface/class exposed by DTS (or some standard COM interface from MDAC) PS I’m aware about the possibility to use ADO.NET connection managers, however it’s n ...Show All