Answer Questions

• Martin.de New Query button -- always prompts for authentication

  Every time I click the "New Query" button, or drag a file into the editor, the system prompts me for authentication. This time and time again leads to executing commands on the wrong database, and the only workaround is basically to accept the necessity to hit the enter key when prompted for auth, and to always double-check which database you're about to execute your query against. If the user account you are authenticating as has acce ...Show All

• stupidStan DSV and Cube do not match - generates Key Errors

  Hi All, This is strange behaviour, hopefully I can resolve it without rebuilding the cube and all the dimensions from scratch. I have a cube with a fact table, and a number of dimensions, including an EventType and Event Date.  (Event Type is "Sale", "Return", etc.etc, Event Date is the date it occurred) When I created the DSV for this I accidently joined the fact table EventTypeID field to the EventTimeID on the Event Date di ...Show All

• Zwheeler Querying Data from Report History

  Can we query data in the report histories So that trend analysis reports can be created. Consider there exists a report, “Shelf Position Product Wise” and it’s scheduled to be generated each day. Now we want to create another report querying the data from the history/snapshots of that report for Product Wise Shelf Position Trend. See this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=376677& ...Show All

• vb2005Coder Using Unicode in SQL Server

  Hi I'm have big problems trying to save Unicode information into my MS SQL Server 2000 Desktop Engine. Alright, so the problem I'm having now is I'm working with MS SQL 7.0 and PHP5. I've trying to get information to save into MS SQL, however it is storing it all weird. When I save the information and try to view it in Enterprise Manager it shows it has random characters but for some weird reason I can output that information on the page ...Show All

• SirAndre007 SQL Server 2005 changes for selecting multiple tables

  I have to execute quick tasks (like I did in SQL Server 2000) where I want to either delete several tables or script several tables. Is there anyway to actually select multiple tables easily by right clicking the tables in SQL Server Management Studio like you did in Enterprise Manager Thanks. Thanks....this stip saved me a lot of banging on the keyboard..... Yeah, this makes no sense. Why did you have ...Show All

• Gajanan Didore Foreach Loop Container in SSIS

  Could someone send me any links or information on how to loop through an ADO.NET dataset in SSIS I need step by step information please. Thank you, Shiva Thanks Jamie for giving a couple of answers for this problem. Yosunu, can you give us more details on the scenario you are trying to accomplish. What are you going to do with each row from the ADO.Net recordset This will help us as we plan future ...Show All

• John Doyle Reporting Services Hardware Requirements

  Does any person know if this is acceptable I have reporting services on a virtual server.  On this virtual server I also have running, SQL 2005 and Analysis Services 2005.  I have about 45 GB or HD 21 GB of the 45GB free and I have 1 GB of memory. Is this good Hi All, Can any body help me in sizing the Hardware Capacity Planning for MS Reporting Service 2005. I need to know the exact H/W & S/W requirement to start this ...Show All

• whytepaul small scale (light weight) SQL search engine (basically a stored procedure) to search through Products Table

  Hi, I am attempting to build a small scale (light weight) SQL search engine (basically a stored procedure) to search through Products Table. I am passing a search string, which i break up by the ' ' (space) delimiter. next for each [value] (after breaking up) in the search string I want to be able to count the number of occurences of each [value] in the [ProductName] [ProductDescription] fields of the [Products] table. However I am confused as i ...Show All

• Sabroni Task Expression Evalutation Time

  I have designed a package whose first step initializes several variables .  Other steps in the package have expressions based on those variables. Example Expression for MyTask:    PropertyName = "Disable"    Expression = "@DoMyTask" Given this example MyTask will be enabled/disabled solely based on the value of @DoMyTask at the time the package execution begins.  Changing the value of @DoMyT ...Show All

• Benzi Installation Stalls at "Detecting Installed IIS"

  I try to install but once it gets to Installation Status window it freezes at Detecting Installed IIS. What do I do to get past this wonderful step And who tested this installation process Better yet, who let it be releases with so many bugs Thank youl. I finally had success. Seems like turning it off (Symantec Antivirus) was not a guarantee for success -- I did turn it off before with no success; uninstalling all might have helped to ...Show All

• Lugaid Backup database failure is not firing

  I created a transaction log backup database maintenance task which then flows to a notification task if a failure occurs. If I set the backup path to a path that does not exist on databases that are set to simple (which should also cause it to fail I would expect, since you can not backup transaction logs on a simple recovery model database) it just succeeds and does not go to the notification task. Why ...Show All

• GDK-Dev Strange behavior of the MSDE

  Hi, I have an application running with MSDE database, but since a couple of weeks 100% of memory is being allocated for MSDE instance. Even if I restart MDSE Service, some minutes later memory allocation increases again quickly. The CPU usage is not normal, between 40% and 60%, going to 100% while any query is done. Could be any variation of Slammer affecting the system But I had SP3 installed and Slammer fix tool too. Could someone help m ...Show All

• Paul Stovell How do I create a new db in sql 2005 express

  How do I create a new db in sql 2005 express useing manager express I'm used to mySql front and this is my first try at sql. Also, does anyone know of a link(s) on the vast msdn website that explains how to use this software All I've found so far, are a lot of pages telling what it can do not how to do it. I'd appreceate any help, I want to get started on this . Never mind I did it I see you have to do a lot of right clicking. ...Show All

• Andreas Kranister Server Man Studio Express Connect error on server but works locally . help??

  Hi there, Can anybody help me I installed Server Management Studio Express and it works great on my local server but when trying to connect to a server i have on the lan it gives me a connect error. I use the correct format i.e.  machine_name\SQLEXPRESS I have also enabled Protocols, via, tcpip, and named pipes... and restarted sql server express on the server. I do have a standard Windows 2003 firewall installed maybe I have to open a por ...Show All

• Pat_ON OLAP substring

  how to split account dimension into three different dimensions for example account dimension member = 11111200900 account_num.member = 11111 item_num.member = 200 sub_tem.member =900 Using Analysis Services 2005, the easiest way to do this is to create named columns in the table in the DSV which split out the portions of the accout. Then you will probably want to create seperate attributes within the same dimension for each of these ...Show All