Answer Questions

• XGamerX SQL Server 2005 June CTP Install Issue

  When trying to install SQL 2005 June CTP to a Windows Vista Beta 1 install I am receiving the following error during the configuration portion of the installation: TITLE: Microsoft SQL Server 2005 CTP Setup ------------------------------ SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Connection was terminated [1236].  Refer to server ...Show All

• Sahil Jain Current User Roles List seems Incorrect

  Our app uses the ROLES column of the CATALOGS rowset from the schema, and I seem to be seeing what I think are incorrect results. The documenation says "Username is appended to ROLES if one of the roles uses dynamic security". OK. But I often get the username even when there are no MDX expressions used for dimension or cell access. For example, every Foodmart 2000 cube I have migrated shows the username in the role list. What ...Show All

• Kurt4949 CommandText Size Limit?

  Hello, some of our users have some "canned" reports they want to run without the hassle of searching for members throughout a myriad of hierarchies in our OLAP cubes. Tools like ProClarity and Novaview are great for analysis, but when needing long lists of unrelated low lying members of a dimension, they're quite cumbersome. We decided to use Reporting Services to save the reports' static layouts and pass the MDX strings programatic ...Show All

• Pamb readxml doesnt work :(

  hello! i'm working on a project for pocket pc, which is an app that registers customers, suppliers, stocks and orders. all this is stored in the ppc itself using the SQL CE server. i'm programming with VS2005, which is great, the tableadapters make the work lot easier. i'm just having some problems importing and exporting data from the sql tables to files. the export function works quiet well, i just load the data from the tabl ...Show All

• Dave S. Anderson Noob questions about Reporting Services

  Sorry for the noobish questions, but I just loaded Reporting Services and am trying to learn about it. 1. Is there a way to manipulate the tool bar that appears with the report   The one that has the pages, percent view, find/next, format/export and refresh.  I can't seem to find any properties to set for it.  For example, when I created reports with the evaluation copy, a print button would be on the toolbar, but with the full ve ...Show All

• PaulSomers SQL 2005 Developer Edition beta error message

  Hi When I install the latest CTP, I get this message when I ask for Analysis Services to be installed - deselecting that option, enables me to do the main install.   The message is: Setup failed because Service MSSQLServerOLAPService is disabled for the current hardware profile.   Services must be set with the current Hardware Profile logon property profile enabled.   For more information on how to enable the hardw ...Show All

• joru creating a database, tables, records, and fields in a Sql server 2005 express

  I am at my wits end as to how to do this. I have downloaded Sql server management Studio and tried to create a database but I can't figure it out. There is an almost nonexistant help file so I am lost as to how to start. I have succeeded in looking at some system databases but that is about the extent of it. Can someone show me the proper procedure Am I using the wrong tool Thanks, Paul Hi Paul, there is no ne ...Show All

• Robert Wishlaw sql server management studio nov ctp

  I have vs2005 prof. installed along with sql express RTM I installed management studio nov ctp when I try to launch it, nothing happens any Ideas Thanks deleting the key worked for me too Thanks Microsoft SQL Server 2005 Books Online set this entry. I've deleted the "shell" key and the books online stop working. After this I reinstalled the BOL and Management Studio stopped working. Interesting. :) Deleting the following key: ...Show All

• PekChan OK button not working...

  I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK. I have installed the app, SP2, and a hotfix that is on the website. Help.... I've run aspnet_regi ...Show All

• TANWare Empty Address Lines

  What is an easy way to squeeze the lines of an address when anyone one of the address lines might be empty Example: Customer Name AddressLine1 AddressLine2 AddressLine3 City, ST, ZIP I have not tried this but you can try using a formula for the LINE HEIGHT property of the the address lines - Under Properties/Format =iif(Fields!AddressLine2.Value= "" , "0pt" , "9pt" ) This hopeful will set it's line height ...Show All

• Ted Herrman AdomdConnection via a UDL file

  To connect to a database engine by using types such as OleDbConnection , I can create a UDL file to connect to the database, then just use that UDL file by a connection string like " File Name = \\My Documents\\my.udl". It seems that I cannot use this way to connect to SSAS. I can create a UDL file to connect to a local SSAS without any problem. However, when I use connection string like " File Name = \\My Documents\\myssas ...Show All

• AndyB90 Upgrade Express to 2005 CTP

  Is there a way to upgrade SQL express 2005 to SQL Server 2005 CTP Upgrades via Setup are not yet supported. You will need to uninstall Express, install the full CTP, and then attach your databases. Note: Uninstalling Express will not delete your databases. However, it will remove any users, jobs, etc you created. Dan ...Show All

• LFerg VS2005 / NonExecuteQuery / SQLDataSource

  Please help me before I split my head open on my desk! I'm new to .net, I'm having to learn it for my new job - so they've gotten me started on VS2005 and SQL Server 2005. I have a SQLDataSource that executes a Stored Procedure. What I want to do is get a value back from my stored procedure so I can run a script only if successful.  It seems like the "NonExecuteQuery" function is what I'm looking for, but I can't find any examples of ...Show All

• Frog Prince newbie helps - but I can not find Management Studio now.

  just finished installing SQL Express, and now, dont know what to do next :) - I have installed FULL. Does it have any GUI tool for me to create a database - how can I login into system - how can I restore a backup file I have a backup file from SQL 2005 standard - how can I create backup for databases thanks Use the SQL Server Management Studio Express Edition I am also new ...Show All

• Aneo SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All