Answer Questions

• OliSchwarz Removing Publication from Monitoring Tool

  Hi: I removed the publication from the database but it is still showing in the monitoring tool. Does anyone know how to remove it from there Thanks did you try refreshing disconnect-reconnect If replication is removed forcefully in publishing db, and distribution db is not accessible, it is possible to leave orphaned entries in some of the metadata tables at the distributor. if this is ...Show All

• mepurathu Bar Chart Static width

  I have developed a subreport with a bar chart that is the width of a lanscaped page. When presenting a series of bars, the width of each bar changes depending on the number of data points presented. My objective is to present each bar with the same width regardless of the number of data points. Can anyone help me -- please Depending what you are trying to do there are often many ways to achieve the desired eff ...Show All

• Siv SA password

  Hi expert, I just install SQL server express. Very smooth installation and allow me login into the server by using window authentication. How i want to login as sa. if I using sa as login and SQL Server authentication. I cannot login to ther server. Thanks. It's also worth mentioning that you can change this setting from Management Studio Express; right-click on the server and open the Properties dialog. Th ...Show All

• Mike VB Data Transformation Services

  How can I make a DTS in MSSQL Server Management Studio Express I know how to do that in SQL Server Enterprise Manager. Is this restricted in the express Thanks. SSIS (aka, DTS) is only available with SQL Server 2005 Standard Edition and above. With Standard Edition, you can use Business Intelligence Studio to make SSIS packages. http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx I'm not fully certain ...Show All

• BillH CellSet.get_Item peformance degradation

  Hi, I am observing a degradation in the CellSet.get_Item function times as I traverse through the Cellset return in response to a MDX query. The .NET (C#) application fires an MDX queries and traverses each Cell in the returned CellSet. The traversal is sequntial and in the order of the Cells Ordinal number. What I observe is that the CellSet.get_item function time increase as the traversal progresses. For the first 2000 cells the time taken ...Show All

• Moldavia Matrix Subtotal

  Hi, I have a matrix with 3 row groups:  Location, Company, Country.  I want to add a subtotal of "Company" that will breakdown into "Country" as well. e.g. right now if i add subtotal to "Company", it will give me: New York Company A CAN                     100 USA           &nb ...Show All

• amza Access denied when connecting remotely via SSMS

  Hello, Only the server administrator user can connect to SSIS from remote workstations.  All other users encounter "Access denied".  What security settings are necessary to permit regular user access to SSIS   Firewalling is not an issue.  SSIS is running and works fully for the server administrator user.  All users can manage the Database with SSMS just fine; only SSIS cannot be accessed by regular users.   ...Show All

• Conradical Datafields in report header

  Hi. I want some information stored in the database to be shown on the top of each page in my report. But in the report designer I get an error message if I try to drop a table in the header, and if I try to assign the value of a textbox in the header to e.g. "First(Fields!sometable.Value)", I get a runtime-error in the preview that says "... Fields cannot be used in page headers or footers". How can I do this Regards, Tomsi ...Show All

• Joy2u Where is the SQL Server 2005 Express Manager Sep CTP?

  Microsoft has posted a September CTP of SQL Server 2005 Express, details at http://www.microsoft.com/downloads/details.aspx familyid=6E4AAC3A-9D85-4734-B1FD-318FB83B0D29&displaylang=en . But no September version of Express Manager can be found, and we are unable to install the June CTP of Express Manager because of an installation problem that it reports: "This computer must have at least Windows 200 SP4 and the user must have administrator ...Show All

• DamianH [264] An attempt was made to send an email when no email session has been established

  Hi I have go an integration service package which sends email on completion of the package. It is not a notification email. The email is being sent from the integartion service package. The package is being scheduled using SQL Agent Job scheduler. It has few steps each and every step sends a mail on completion and then it moves to the next step. If i run each step seperately. It completes the job and fails when sending the email. Giving ...Show All

• Dilmer SSIS Diagramming

  Hi, I just want to ask, is there a tool that can create a diagram supporting the SSIS package I have created I would like to know if there is any available tool that can do this task so that I can support my SSIS package documentation. For example, I have created a Data Flow task that transfer data from a source database to SQL server 2005 destination. I would like to create a diagram that summarizes the task it perform fr ...Show All

• Froggyman3210 BI/SSIS Developer environment?

  Which sql components are needed to develop/execute packages within BIStudio considering that SSIS is centralized in one sql server Is Source Safe 2005 integration within BI has the ability to add/update packages to a SQL server location instead of a system file Thanks, Greg. I can only answer your first question. When you install Business Intelligence Development Studio from the Client Tools node in SQL Server setup, the components necess ...Show All

• BSautner Dynamic Scripts

  I've found that SSIS does not work well with running small dynamic scripts ... For example, I have scripts that need be created via dynamic SQL. I want the dynamic SQL to be created using variables in SSIS. The ways around this are to create small temporary stored procedures that I can create in the SSIS package at run time that have dynamic SQL in it - and execute it with the variables as my parameters. Does anybody else do this, or ha ...Show All

• 天秀软件 cant connect

  i am devleoping an ASP.Net website now. i got a problem on connecting. when i try to connect (i manually made thew connection), it wont connect. the error is this: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Login failed for user 'MANEC\Batman'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) I have other other webpage that us ...Show All

• slickj MDX Linked time question

  Hello, I am new to Analysis services but I have a quick question on a capability. I am trying to calculate a measure both in an mdx select statement and later turn this into a calculated measure. Here is the scenario: Currently I have a fact table with links to 3 dimensions with one of them being an asset dimension, one being a time dimension, and metric dimension. In the time dimension I have day, year, hour, day of week, day of mon ...Show All