Answer Questions

• Karloff Possiblity / Instructions on how to install Report Builder locally without hitting report server

  We have a remote business client who has a proxy server setup and this translates into receiving a 407 proxy authentication blocking error when attempting to download the report builder application for deployment off the report server which is housed locally with us. The proxy server does not allow them to download application type files off another site. At the moment, they would not like to disable the proxy for these users to allow them to deploy the application on their client or add the report server as a trusted site. Is there a method by which Report Builder can be locally installed on the client pc instead of online only with it knowing the correct report server to access and then still launch correctly when the report builder but ...Show All

• Yulia Exporting to Power Point

  How to Export SQL Report to Power Point. There is no way to do this. There might be a third party product out there, but never heard of that. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• kopo SUM returns incorrect value in SQL Server Mobile Query ... Bug??

  Hi all, I am a newcomer to Microsoft Database Technology and have appeared to come across an issue with the SUM function in SQL Server Mobile Edition. I am running Visual Studio 2005 and have created 2 tables: Orders and OrderLines which are set up in master detail fashion. The SQL Statement I create in the Query Builder is as follows: SELECT     Orders.OrderNo, Orders.OrderDate, Orders.Priority, Orders.Address, SUM(OrderLines.Quantity * OrderLines.QualityReference) AS Total FROM         Orders, OrderLines WHERE     Orders.OrderNo = OrderLines.OrderNo GROUP BY Orders.OrderNo, Orders.OrderDate, Orders.Priority, Orders.Address Now, the SUM ...Show All

• Tigers21 mining association rules using SQL

  Hello everybody, I am interested in mining association rules field I have found some posted statements but I didn't undertand them. I need your help badly. Just tell from where should I start Thanks alot There is a tutorial using association rules for market basket analysis at http://msdn2.microsoft.com/en-us/library/ms345326.aspx This is a good place to start. ...Show All

• NickUk what components rely on SQL Authentication??

  If I have a Mixed Mode Authentication - Can I remove it from my existing product while upgrading to SQL Server 2005 What is the impact to the installations what components rely on SQL Authentication No components per se rely on SQL Server authentication. You can switch on only Windows Authentication if you want to. To see, if you still have a connection using SQL Server Authentication, use the profiler for monitoring or the event log with auditing all logon events. The hard way would be to just switch to Windows Auth. only and wait for any incoming error messages of the users. HTH, jens SUessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Kamii47 MDX - monthly values to days

  Hi, This is an odd situation, but ... We have a fact table that contains monthly actuals (120 widgets produced in June for example). However, our users however want to be able to drill down to the daily level and see daily values for the previous month - the daily values being computed from the months actuals / num of days (4 widgets a day in June for example). How would I do that in MDX and get the results down from the Month level to the Day level, so that our users can see daily values in a Pivot Table. Thanks, --Phil In your Time dimension define key being Day, and Month as related attribute to it. In the measure group, however, choose the measure group granularity attribute to be M ...Show All

• daniel666 Copy Database with Microsoft.SqlServer.Management.Smo.Transfer breaks identity columns

   Hello I have a task to copy at runtime "etalon" database inside one same SQL 2005 server. Everythings ok except identity fields: identity breaks in new database. I use such code:                     Transfer xfr = new Transfer(db);                     xfr.CopyAllObjects = true;                     xfr.Options.ContinueScriptingOnError = true;                     ...Show All

• MielieSpoor Web Sync Snapshots eat up disk space

  Hi Heads up on TEMP files I've been running web Synchronisation for over a month. Just today some subscribers received a message warning of an "OS Error" could not retrieve file "dynsnapshotvalidation.tok". Sometimes they also got an error regarding low or no virtual memory. After much investigation it seems that the Web Server hosting the web sync IIS had literally no space left on the system c: drive. It also turns out that the \\Windows\TEMP folder contained over 9GB of snapshot files. It seems that when the Web server collects snapshot files from Data Server to deliver to the subscriber it creates a Temp copy on it's own local system. Unfortunately this temp data is not cleaned up and over time has jammed up the sy ...Show All

• bryanedds SQL Express

  Hi: I'm trying to replace MSDE with SQL Express 2005, I would like to know if Window XP Pro SP1 is OK to use Can I write code with VB6 with SQL 2005 Express Any Step by Step Installation of SQL Express 2005 Thanks and regards Hi, you will need Windows XP SP2 for SQL Server Express: http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/RequirementsSQLEXP2005.htm The database engine can be called like the MSDE database engine. using ODBC you can use the SNAC client in order to connect. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Use SNAC if you want to use the advanced SQL Server 2005 features. HTH, Jens K. Suessmeyer. --- http://www.sqlse ...Show All

• Haneli Installing SQL server 2005 evaluation

  After unzipping the download I have run the splash.hta file. I then chose run the sql native client installation wizard. I then receive the installation package is not supported by this processor type. Contact your product vendor. I am installing this for a class I am taking on a test station. It is a PIII 863 with 512 MB or Ram, running windows 2003 enterprise server SP1. I have looked at the hardware guidelines and it seems this is enough to run it. Any ideas That really does sound like the message displayed when you run a 64-bit application on a 32-bit operating system. Can you try to double click on setup.exe and see if it displays a similar message If so, it would be displayed even before you see t ...Show All

• loopool SUM returns incorrect value in SQL Server Mobile Query ... Bug??

  Hi all, I am a newcomer to Microsoft Database Technology and have appeared to come across an issue with the SUM function in SQL Server Mobile Edition. I am running Visual Studio 2005 and have created 2 tables: Orders and OrderLines which are set up in master detail fashion. The SQL Statement I create in the Query Builder is as follows: SELECT     Orders.OrderNo, Orders.OrderDate, Orders.Priority, Orders.Address, SUM(OrderLines.Quantity * OrderLines.QualityReference) AS Total FROM         Orders, OrderLines WHERE     Orders.OrderNo = OrderLines.OrderNo GROUP BY Orders.OrderNo, Orders.OrderDate, Orders.Priority, Orders.Address Now, the SUM ...Show All

• Sir Code Alot If statment within Where clause

  Im using Business Intelligence with SQL 2005 to build reports Could one use a If Statement in a WHERE Clause My parameter contains: All 1 2 3 (In a dropdown) When the user selects '1', the WHERE clause should include the variable, but when 'All' is selected '1', '2' and '3' should be included SELECT CustomerName, CustomerTel FROM tbl_Customer WHERE ((IF @Varialbe <> 'All') (CustomerCode IN (@Variable)) END) can this be done Adam Thank you for the help. The solution you proposed works as expected, albeit extremley slower than it should. Thanks again for the easily understandable and flexable answer and also for the fast responce. Gerhard Davids There many ways to achieve this. E.g. ...Show All

• TDays what else to Tune

  there is a third party appliaction running in the company where i work. Recently they have been gettig lots of sql timeout messages. I ran SQL Profiler trace and found a couple of queries that took between 5secs to 10 minutes to complete in the profiler. But when i run those queries from my PC they complete in seconds. I have update the indexes, updated the statistics. But the performance is still not better from the clients side. what else should i do or check for to performane tune Here is an excellent whitepaper on sql2k5 perf. http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx ...Show All

• davehomebrew Textbox color expression referring to textbox value

  Is there a way to have the Color expression for a textbox refer to the value in the textbox without having to explicitly provide the name of the textbox For instance, if I have a textbox that is named textbox10 that is displaying the value Fields!ItemProfit.Value and I want non-negative values to be Black and negative values to be Red, I would code the Color expression as: =iif(Fields!ItemProfit.Value >= 0, "Black", "Red") Is there a pronoun or other identifier I can use instead of Fields.ItemProfit.Value For instance, something like =iif(This.Value >= 0, "Black","Red"). If I have alot of fields in my report that I want to have this kind of conditional color formatting on, then I'm ha ...Show All

• Bradley Reynolds create view using data in seperate severs

  Hello: I'd like to create a view on server x which references tables on an entirely seperate server. Is this possible Is seems strange to have to copy the tables over just to create a view. In the view wizard I can't seem to 'browse' to the tables on the other server. The code I'm working with would conceptually be something like this: select server name.database instance.owner.table.field from server name.database instance.owner.table where <field name> like 'xxxx%' or something along those lines. Any help would be appreciated! Thanks. Hi, select servername.databaseinstance.owner.table.fieldname from servername.databaseinstance.owner.table where field = 'xx ...Show All