Answer Questions

• bigdavelamb Trigger

  hello team: i have two tables order and orderdetial, i want from the orderdetail the sum of the quantity of products  for each order and then insert this sum in order table infront of each order this is the first part: declare @s decimal select @s=sum(f.quantity) from orderdetails as f inner join orders as a on a.orders= f.orders group by f.orderdetails any one have advise, thanks lot Thank you very much the view is accuret Thanks lot about the trigger i hava a question what is 'set orderTotal = orderTotal.orderAmount ' <-- i couldnt understand it Thank you ver much Hassano, It is considered a very bad idea to store data that can be calculated from other data. It becomes 'ea ...Show All

• Quinn01 Connections in Pool Not Being Reused

  I have a form that has a number of database calls. It does these sequentially. In some cases it's not possible (due to archetecture more than anything) to make these calls all on the same connection. However it does open then close the connection. (all connections created are in using statements) What I'm seeing is that we're getting a timeout when the 100 connection limit is hit. Looking at Activity Monitor I can see these connections growing and growing over time in the activity monitor the more windows you open and close even though these connections are closed. (and they all use exactly the same connection string) I read that it might be because of SQL Debugging being turned on in vs.net, but that is not enabled in either debug o ...Show All

• Alex Yakhnin - MSFT Processing after new data

  I'm trying to build a cube in the "real world" for the first time. I had my fact table populated with one day's worth of data, set up my time dimension using named calculations based on a datetime within the DS View of the fact table (a la the Larsen book), then built and deployed and everything worked great. However, when I added the next day's worth of data into the fact table and tried to get it to process incrementally (and then fully), the processing fails and it looks like it's complaining about those named calculations that worked so well on day one. Any thoughts on what I might be missing here Thanks Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fact_ALI, Column: YearOfBid, Value: ...Show All

• emailAtul SQL Question

  Hi there, I have these tables: Students student_id (PK) student_name Courses course_id (PK) course_name StudentCourse student_id (PK) course_id (PK) If I want to select a student that has 'course1' and 'course2', how do I write this statement This didn't work: SELECT DISTINCT Students.* FROM Courses INNER JOIN (Students INNER JOIN StudentCourse ON Students.student_id = StudentCourse .student_id) ON Courses.course_id = StudentCourse .course_id WHERE Courses.course_name LIKE '%course1%' AND Courses.course_name LIKE '%course2%' The problem is 'AND'. it concate the two course_name(s) to be like this condition: WHERE Courses.course_name LIKE '%course1course2%' Any idea Thanks Rob gave the right ...Show All

• DavidDo Install programming is terrible

  I use SQL server 2005 for a year now at work and home. The intsall process and logic is TERRIBLE compared to previuos versions. The most common problem I get on developers machines is when they are using EXpress and then upgrade to the Developer or Enterprise edition. Sql Server 2005 Express database instances get left in the registry or somewhere, and the next install sees it and refuses to install its instance. The ARPWrapper.exe. tool in the boot strap can be run and you can see the instance there, but they is NO POSSIBLE WAY to remove it.. I have been woring on this for 2 days and really hoping someone has a fix for this. I have tried the variosu registry HACS out there on the net, but no luck still. I noticed that a huge proportion o ...Show All

• Martin Johannesson OleDb Source Error - Connecting to Oracle 9i

  Hi, I have my datasource in Oracle9i and destination is Sql2005. I am connecting to Oracle 9i through OLEDb provider and when I connect to my DataSource using OLE DB Data Source, I get the following error: Warning at "guid code": Cannot retreive the column code page info from the oledb provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale Id will be used. Could anyone please help me trouble shoot this problem. Regards, Sudhakara.T.P. sudhakaratp@hotmail.com ...Show All

• DataConversions oracle oledb provider not registered in local machine

  Hi, I am trying to establish a connection to an Oracle database using the following code in a script task: Dim oOleDbConnection As OleDbConnection Dim sConnString As String = _ "Provider=OraOLEDB.Oracle;" & _ "Data Source=DBxxx;" & _ "User ID=Userxxx;" & _ "Password=Passxxx" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() When I execute the script task, I receive the following error: The 'OraOLEDB.Oracle' provider is not registered on the local machine. Am using the correct provider I do not know how to resolve the said error. Here are some facts: Oracle 8i is installed. Tnsnames.ora is updated. I have successfully ...Show All

• F. Gsell Tape not available as Backup Device

  I've got a new HP ML370 G4 Server 2003 SP1 with a fresh install of SQL 2005 SP1. I'm trying to create a backup device for the internal HP DAT 40 and tape is greyed out as an option. I have the newest HP software drivers and firmware. The tape drive is seen by Server 2003 device manager and by NTBACKUP. I can backup using that program. Why doesn't SQL 2005 see it I tried a new HP Ultrium tape drive with the same results. Anyone else see this and can recommend a fix TIA Hello, I am having the same problem. I only use Windows server 2003 x64 standard and SQL 2005 x64 standard. The tape drive i am using is a Sony AIT4 tape drive. Please advise Hi, I have the sam ...Show All

• Stonaltar Problem uninstalling SQL EXPRESS on Windows 2000

  I had a problem with the install so I planned to uninstall everything and reinstall SQL EXPRESS, instead I'm stuck. Pasted below is actual uninstall log. Thanks in advance Microsoft SQL Server 2005 Setup beginning at Thu Aug 17 21:44:16 2006 Process ID : 2336 D:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2006/7/17 21:44:16 Complete: LoadResourcesAction at: 2006/7/17 21:44:16, returned true Running: ParseBootstrapOptionsAction at: 2006/7/17 21:44:16 Loaded DLL:D:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\xmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2006/7/17 21:44:16, returned false Error: Action "ParseBootstr ...Show All

• barry sela problem using System.Data.Oledb.OleDbDataAdapter for importing Excel

  Hi All, I am facing this weird problem of partial data being fetched when using oledbadapter for fetching data from a Excel spreadsheet. A few cells containing text values are not being fetched..I get an empty string. When i replace this text value by an integer, the problem is no more a problem... Anyone having faced this problem or having knowledge about this..pls respond.. Thanks in advance I'll  recommend the use of DTS. then create an SP that triggers the DTS thru xp_cmdshell using dtsrun. call the SP from the application ...Show All

• pblecha 2005 SP1 install, another can't authenticate...

  win 2003 sp1 with sql 2005 enterprise. Tried SA.. Tried AD Admin, tried local administrator. Set up in mixed mode so i tried windows and sql authen... I can log in normally with SA and the password and the windows admin account. Nothing works, tried services off and on. Tried clearing everything Reinstalled completely... Only the SQL Server part fails because it requires authentication. All the other parts succeed. I don't get a log since it just thinks im typing things wrong. Just this 06/06/2006 21:24:59.641 Authenticating user using Windows Authentication 06/06/2006 21:24:59.641 SQL Service MSSQLServer was previously running, ready for authentication 06/06/2006 21:24:59.641 SQL Agent Service SQLSERVERAGENT was not prev ...Show All

• GDigrego Full-text Index Question

  Hello all, I just created a new Full-text index on a column, and I set Change Tracking to Auto. When I do this, do I still need to have an Incremental Population schedule, or does SQL Server handle the population in the background on a continuous basis when Change Tracking is set to Auto Thanks for your help, Jason I'm using SQL Server 2005 Management Studio to do everything; although, the database server that I'm doing the work against is SQL Server 2000 SP4. Jason See inline. EXEC dbo . sp_fulltext_table @tabname = '[dbo].[Log]' , @action = 'start_change_tracking' GO -- If you have timestamp column on the table, start_change_trac ...Show All

• rohit nagesh How do 'you' organize Reporting

  Hello, This is more a informational question. Until now we had over 50 reports ready in our system, we are almost ready to go into production and are starting to link all reports with eachohter. The first problem was that we had them all nicely grouped in different projects so that we could publish in a logical folder-tree. Problem is that we can't jump to reports that are nog in the same folder. Going by url changes the layout and parts of the report manager are gone. We then started to have a look at Sharepoint but i can't find books on the topic SharePoint & SSRS that describes the possible options. I've seen quite some documents and ways to publish reports but until now we prefer to mail the periodical reports to the users wi ...Show All

• yahu_Hugh How to guarantee unique of columns > 900 bytes

  We have an app that threads together emails coming out of Exchange, using their messageid. To ensure threading works correctly, we need to ensure uniqueness of messageid, which we do with a unique index (we also need to be able to lookup by messageid when a message comes in). We are currently porting the app from Oracle and PostgreSQL to SQL Server and are having problems with the 900 byte max length of an index. The problem is that the maximum size of a messageid (according to the Exchange docs) is 1877 bytes. How can we guarantee uniqueness   Umachandar Jayachandran - MS wrote: If you are using SQL Server 2005, you can use the hashbytes function to compute say MD5 hash on the string and p ...Show All

• Alexandre Defalque How to upload a file to a Server URL using Web Service Task?

  Hi, I have been trying to setup a web service task to use my http connection manager that connects to a server url. What I want to do is to upload a file to a web server... can this be done using web service task and what is the WSDL and what happens when my target server usis SSL so instead of http, it should use https I need help with this one... can't quite imagine how to get things rolling.. Thanks in advance! Kervy Hi Duane, yes I have 2.0 installed, I am using Sql server 2005 as well as VS 2005 in my development. Thanks for that info, I'll try to play around with it ... I'll come back with some news Kervy ...Show All