Answer Questions

• RonFarley Storage of packages: file system or Sql Server?

  HI, we are beginning a new project at my company and I was wondering where is the best place to save SSIS packages: file system or SqlServer. I have used other ETL products and they always create a repository on an RDBMS. Since SSIS offers us the choice of DB storage or file system, is there pros and cons of both approach Will the deployment of our application be simpler by using Sql Server since we would onky move metadata instead of files ...Show All

• JoseSP How to mimic replmerg.exe in vb.net

  Hello, On an existing Merge Pull Subscription (Subscriber: SQL Express) via websync how can we start replication via vb.net We can use the cmd line replmerge.exe and all works fine however we would like this to be cleaner as it's going to be on demand sync. I saw in BOL about the RMO and how to create pubs/subs but nothing telling me how to actually start the replication process. Is there a sample of how to start the replication process in vb ...Show All

• Cbless How to connect Oracle Data Source for Reporting Service

  I have the problem to connect Oracle data for my Report designer. 1st I used ODBC, it does not work, and my reference book "MS SQL server 2000 Reporting service step by step" tells me that I must select Oracle data provide instead of the generic ODBC. I created a new data source and after I enter the userId/pswd and click "Test Connection" button, it is OK. But when I click "run" icon to try, it gives me the f ...Show All

• wonny References in SQL Server Projects

  Hi, I'm using Visual Studio Beta 1 with SQL Server 2005 Beta 2 and have created a SQL Server Project. The first thing I tried was to add a reference to a C# class library project that contains many C# tools I like. Bad news, I get the following error message: "A reference to 'csharplibrary' could not be added. SQL Server projects can reference only other SQL Server projects ." My question is: is this behavior a limitation of any of the Betas, o ...Show All

• alex_g_73 Date picker not showing...

  I have report parameters configured to use date pickers...but they don't show up when I run the report.  I see the date picker controls when I preview the report in design mode, but they don't show when I open the report in a browser.  Any thoughts It could be unrelated, but the error I get when I try to run the report with text dates is: Collection was modified after the enumerator was instantiated. ...Show All

• Zhiqiang Feng Check if cube exists

  How can I check whether a cube exists and make the control flow dependend on that Thanks for help!! By using AMO in a script task   HTH Ovidiu I finally found the "References" node in the object explorer (seems kind of stupid I didn't saw it..) Could you give me a small example There is only little information available in the SQL Server help. ...Show All

• LccTom Subfolders

  I know you can create sub folders in report manager, and then move reports into them. Is this a good idea since report designer cannot deploy to sub folders, and then you are left with deleting and moving, which throws off your subscriptions. Am I missing something Thanks! On the project property pages you specify the TargetServerURL and the TargetReportFolder.... Moving through RM doesn't overwr ...Show All

• Jemmy Wang After Install of 2005 still 2000 Engine!

  I have installed the new SQL Server 2005, but I see my local database as version 8.9.193, means SQL Server 2000. I do not know why setup did not upgrade it. What do I need to do now  I think some new options are now working because of that... Hi I wonder now. Is it possible that SQL Express 2005 has been upgraded to full version, but the instance is still called SQLExpress, even it is full version SQL Server 2005 Pl ...Show All

• Ahmed Amin El-Morali Creating an Offline or Local Cube

  Hi, I want to create an offline cube (Local cube) and insert data into it from an existing cube in SQL Server Analysis Services 2005. Can anyone please help me on this issue. Thanks and Regards, Gautham. I am having the same problem.. any luck.. pelase email me.. chandran.gangadharan.b@bayer.com i have never understood.. how do ue xecute an mdx query.. like we use sqlplus for an oracle sql statement.. iw ...Show All

• Quintin Willison Default TCP/IP Settings

  I am trying to do a SQL Express Unmanned installation and I have been having trouble with the TCP/IP settings. I have tried both disablenetworkprotocols=0 and =2 and after the installation is complete I open the configuration manager to check the settings. It says TCP/IP is enabled but when i check the properties it says both IP1 (my ip address) and IP2 (localhost 127.0.0.1) are both disabled. To me this doesnt make any sence. I can enable TCP ...Show All

• Elyasse - MSFT AS2005 September CTP Memory Error

  I get "Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed." while executing query set with cube browser in SQL Server BI Dev Studio. The same error I get while executing query with VB code (via ADOMD). The source of the error is AS2005 OLEDB Provider. One important information: I have installed Sept CTP on clean Windows XP Pro, there were no previous ...Show All

• Tasnim MCTS Exam 70-431 Database Administration Study Documementation and Samples ?

  Hi, I am looking for good documentation and examples to use to 'study' for Microsoft exam 70-431. This has everything to do with nuts-and-bolts Database Administration of SQL Server 2005. The December BOL examples, do not cover enough topics. The topics that are covered are not in enough detail. The 70-431 exam requirements are very detailed. This seems to be a nuts-and-bolts test. I am looking for nuts-and-bolts study material. No b ...Show All

• JoeWood An incorrect or unsupported HTTP function call was made error

  Hi All, I've got this error " An incorrect or unsupported HTTP function call was made " I can't browse SQL CE Agent using IE also. How to solve this error TQ 1) Make sure that http://IISBoxName/VirtualDirName/sqlcesa30.dll diag show GREEN SUCCESS for SQL Server Reconciler either 9.0 or 8.0 depending on your environment and SQL Server version. 2) Check whether replrec.dll, msgprox.dll, ...Show All

• Smacker Reporting Services

  About a month ago I was able to download the Reporting Services for free to use with SQLExpress. Now I am unable to locate the download. I upgraded my PC so need to reinstall everything. Anybody know where the download is. Thanks You are looking for SQL Server Express Edition with Advanced Services. Download link: http://www.microsoft.com/downloads/details.aspx familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48 ...Show All

• Josep Maria Roy SQL Server Management Studio 2005 Licensing

  I handle all licensing for our companies. I am trying to completely understand the licensing and want to insure if I approve the installation of Mgmt Studio 2005, that it is covered by SQL Developer licenses THANK YOU! Hi, here is a page that discussed licensing in general and there is a phone# you can call for more information. http://www.microsoft.com/sql/howtobuy/default.mspx#EMF Hope that helps ...Show All