Answer Questions

• Dave512 where to place articles

  I have a design that includes articles that will be searched. Obviously its too slow to put them into fields, and impossible because some have photos or are otherwise html documents. So I want to put pointers to their location. Two questions. For each deployment, both desktop and web, where is the best place to put the articles. In any folder, or only in an iis virtual folder dennist685 I personally would ...Show All

• Tayfun Kocak Making SQL Keywords All Caps

  Is there a way to make keywords such as SELECT, FROM, WHERE, HAVING, AND, ON etc. always appear in all caps when typing queries n the SQL Query Editor I have looked in the Options under Fonts and Colors but I dont see a way to make these keywords all caps. Any advice is appreciated. Regards, Randy J Hi Randy, holding the Shift Key during the typing of the keywords :-) Just kidding :-) I don’t think th ...Show All

• VS2005_evaluator How to add the total balances of previous year into the next year?

  I'm working with a table called SALFLDGAMS where it has two columns that I need to work with. One of the columns is Period which has years from 2000 to 2005 and the other column is called amount which has the balance for that year. Let me explain in a little more detail. There are account codes associated with the years as well so there will be many places where for example the year 2000 will show up with a given value. What I'm trying to do is ...Show All

• DearDearDear Another question about Login failed, but with Windows NT Integrated security for SQL 2005

  Hi, Happy New Year!   I have been struggling with this problem for a while with SQL 2005.   I have never had such login problem with SQL 2000. Here is the scenario:   I have installed SQL2005 standard version on a XP Pro box and I am trying to access it from another XP Pro machine.   I can access it using a SQL user name and password that I set up on the server, but I have not had luck with using Wind ...Show All

• Meda Pandu Report Model

  Can you have more than one data source view in one report model I have data from multiple sql databases that I want to combine into a single report model for the users. Lev is right. If you want to create a model over a set of databases you need to do some manual work with your DSV. In model designer start with generating DSV for primary database (the one containing more data). Then manually add named queri ...Show All

• Klimov Vova SQL Browser service won't start

  I tried the instructions in sqlexpress's WebLog to connect to a remote database. Using SQL Server Configuration Manager I enabled TCP/IP and then tried to start the browser service. When I right clicked the icon, all the options (Start,Stop,etc) are grayed out. Can anyone help me with this, please Thank you Oops, sorry, I'm an idiot. Properties, Service, Start Mode to Automatic Thanks ...Show All

• joost g. Error in File System Task

  Hi, I am trying to transfer all the data from Excel to SQL Server using the Script Task (since I got some issue with the Data Flow -- that is a different story, let us come to this error), and after it got transferred I am deleting the source file using File System Task . [File System Task] Error: An error occurred with the following error message: "The process cannot access the file 'C:\Prakash\TestFiles\Names.xls' because it is be ...Show All

• GPK2005 Error generating symmetric key

  Hi, After installing SQL Reporting Services 2005 and starting the Reporting Services Configuration tool the reporting server is reported as uninitialized. The cause seems to be the creation of the symmetric key. Below I attach the relevant part from the log file: ReportingServicesService!crypto!8!1/4/2006-11:20:55:: i INFO: Exporting public key ReportingServicesService!crypto!8!1/4/2006-11:20:55:: i INFO: NT Service self activating Rep ...Show All

• Martin Taylor http protocol violation when webrequest in sqlfunction, thanks

  when I use webrequest to call a url, I got "The server committed a protocol violation", I found out this is because the url returns something 2.0 think is not standard, the solution is turn on useUnsafeHeaderParsing, so I add the below to my machine.config <system.net> <settings> <httpWebRequest useUnsafeHeaderParsing = "true" /> </settings> </system.net> but after I add that, I got different error when I call the ...Show All

• Nate Block to get the latest price value

  hello all.. having been search around for days but no clue.. Hope some MVP can help.. typically from transaction, there are TIME dimension, PRODUCT dimension, and there is PRICE value measure.  normally, OLAP returns is the sum aggregation of the PRICE value when cross joining the TIME and PRODUCT.  However, I would like to retreive only the LATEST PRICE of a product.. return result should be:     & ...Show All

• Chenxia Subscriptions Help - MonthlyRecurrence.Days Property

  When creating a subscription, we don't know what value to give the MonthlyRecurrence.Days property.  It wants a string value, but what   Does anyone know what string value to give this property to indicate the first day of every month   It takes an integer range similar to what is used when printing: "1-4,7,9" Check out this page http://msdn.microsoft.com/library/default.asp url=/library/ ...Show All

• Patrice Calve Decode funktion

  Hi! I have a question about the "Decode" funktion. is it only avaiable in Oracle The reason for my question is that I need to SELECT a colum in a table based on a int value. So if the uservalue is lower then that take that colum, lower then that take colum...etc. Can I use decode or/and is there better funktion (I'm using MS SQL 2005) Thanks in advance Mark MSSQL does not have a DECOD ...Show All

• Absolute Beginner SQL 2005 release date?

  We are looking to do some software upgrades in our shop so we were wonder what the release date of SQL 2005 will be Thanks Hi, Nov 7th 2005 it is. Here is the official PressPass from Microsoft on this: http://www.microsoft.com/presspass/press/2005/jun05/TechEd2005Day2PR.mspx Regards, Vikram SQL Server 2005 (along with Visual Studio 2005) will be released in the week of November 7. See here for m ...Show All

• Shyam Vaidya Why？

  1.SELECT          year, month, day, yearweek    FROM         ELP.dbo.[T_Mcalendar]                        WHERE           date>='2005/07/01' and date<='2005/07/31' 2.SELECT  ...Show All

• Baq SQL Server 2005 Analysis Services XMLA

  Is there any link to simple C# Application to check the correct configuration of XMLA on IIS. Also, is this version of XMLA is only compatible with Windows 2003 Not sure what the question is about. Are you reffering to the enabling HTTP connectivity to Analysis Services Something like you see in http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx Edward. -- This posting is provided & ...Show All