Answer Questions

• AndyCourtenay How to set an action?

  Hi,   I want to link to a website (like www.google.com ) when user click any cell in cube browser.   Then I set an action, the setting detail as following:     Target Type: Cells     Target Object: All Cells     Action Content Type: URL     Action expression: www.google.com   But it's not work fine. When I click any cell in cube browse there is an error message.   Is any prob ...Show All

• puresmile "product level is insufficient" message during flat file import

  I'm using the import wizard to create a new table from a flat file source.  The table gets created but no data gets copied.  What's wrong   Here's the report: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error)    &nbs ...Show All

• smarwha dynamic sql help

  I have a search procedure tied to my .net GUI. One value is required out of the 3 parameters I send it. The other 2 could be null, not null etc or any combination The problem is the parameters are placed into the where clause. Is there a way to do an if statement of sorts in the where clause so that only the values that are not null end up in that part of the statement I want to handle this in the sproc instead of reverting to a dynamically c ...Show All

• dandesro Deployment of system

  I am about to start developing a system using VB 2003 and SQL Server 2000. On my development computer, I am going to use MSDE for the database, which I guess I will later be able to export to my client's SQL server 2000. Now, I am a bit worried. In my local computer, I can develop a system which runs locally very well. So, I am very sure I will be able to develop one for my client. But when I later deploy it to the client, it will have to run ...Show All

• skillpoint Unable to use Reporting Services

  Hi, After installing Sql server 2005 CTP09, we can neither connect to reporting services trought Management Studio nore to reportserver. Using Management Studion we are getting this message: TITLE: Connect to Server ------------------------------ Cannot connect to XXXXXX. ------------------------------ ADDITIONAL INFORMATION: The underlying connection was closed: An unexpected error occurred on a receive. (Microsoft.SqlServer.Man ...Show All

• David Olix - MSFT How can I use a Date Picker in a report

  I have a parametrized report which actually uses a combo with dates to render the report. And I want to change it for a Date picker. Can I do it Thanks in advance. VectorR3, You can do this ins Reporting Services 2005, not in Reporting Services 2000.  Go to "Reports", "Report Parameters".  In here change the type on your field to a datetime field.  Then when you select preview report you will s ...Show All

• polonius Unable to use Books Online search function

  I am unable to use the search feature in Books Online.  Every time I click the "Search" button, I get this error message: Package "Visual Studio Common IDE Package" failed to load Anyone have any ideas on what might be causing this error Okay. I'm checking with the Visual Studio team for further assistance. In the meantime, it would be helpful to know which CTP version you installed. Thanks, Can yo ...Show All

• RCN Multiple MDF in SQL Express?

  Dear all, I have the following questions about SQL Express: 1) Is it possible to use multiple MDF files simultaneously 2) If 1 above is yes, the limit of 4GB of data storage is limited to each file Or the limitation if apply to the SQL Express as a whole 3) Can I have different locale for each MDF files (say, one in Chinese, one in Korean and one in Japanese) Thanks in advance Raymond Understood...many thanks ...Show All

• Jesper Lund Stocholm YTD calculations performance

  Hi, I'm having problems with a calculated measure which is being used for returning year to date sales from the product dimension. The problem is that the performance is incredibly slow even on a very small subset of the data, and I haven't actually managed to have the sample query (below) return as of yet (I've had it running for 45+ minutes). The measure is very simple: CREATE MEMBER CURRENTCUBE.[MEASURES].[Sales YTD] AS Aggregate(PeriodsT ...Show All

• praveendm Deployment Error for Report Model

  I am trying to deploy a Report Model for the first time using the classic Adventure Works sample found commonly on the net. But while deploying the Report Model, i get the following error: "permissions granted to user 'myDomain\MyuserId' are insufficient for performing this operation" and the file mentioned is "Adventure Works.smdl". Kindly advice if there are any permissions to be set up for deploying Report Mode ...Show All

• Sandeepn75 Forcing a package to run as 32 bit on a x64 machine using SQL Server Agent?

  I have a need to force a package to run using the 32-bit runtime from the SQL Server Agent. The machine is a x64 unit. I'm having to use an ODBC driver to extract data from our ERP package that will only run in 32 bit. Any help would be appreciated. Thanks, Donald. That worked like a charm. Hi. Here is another suggestion: run distributed queries through SqlExpress/32. Here ...Show All

• kmermel SQL Server 2005 Express - Upgrading will Lose Data?

  Hi - quick question. I wanted to upgrade pre-release version of SQL Express to the latest version, and wanted to make sure that none of the database information would be lost. The thing that concerns me is that it states to uninstall previous versions of SQL Server 2005 Express before installing the latest version. I threw the database tables into a backup directory, and I think this should be fine, but I want to be sure. Let me know. Thanks! ...Show All

• bruce_heath Business Intelligence Project?

  I installed the VS 2005 Beta and didn't see the business intelligence project type.  How do I get that project type in my list   Do I need SQL 2005 installed on the same machine In VS2003, you just needed to install the SQL Server client tools to access the Business Intelligence project type.  I'm not sure if there's an option in the current SQL Server 2005 install to just install the client pie ...Show All

• Petr Svoboda Hiding Parameters

  Is it easy to hide the parameters of a report Im using the ReportViewer tag in asp.net and I have my own parameters that I am passing into my report. But when the report renders, it shows the default parameters that look terrible in my application. I was wondering if there was a way to only have my own parameters showing Thanks in advance everyone man, just after I posted this I found the exact thing I wante ...Show All

• Fredo can i use SQL server 2005 standard to create and host db for website?

  Hi guys,    I am just wondering what's the difference of sql server 2005 standard and enterprise editions. can I use SQL server 2005 to host a database for a website     Thanks!   Daren   You can find an overview of the features on the Microsoft website ( here ). Hosting a database for a website on a Standard Edition is perfectly possible.  Enterprise Editio ...Show All