Answer Questions

• deanhully WebParts not found for Reporting Services

  I created my first Webpart .aspx page in SharePoint 2003. I created a new Document Library and assigned my webpart page to that library. Now when I go to Document Libraries, click on that webpart, I get the page but I no longer see the buckets for the layout..nor do I see the Explorer to allow me to try to add webparts. How do I get to this screen again that allows you to drag and drop items into my page It's just a blank page with a header righ ...Show All

• Jaans SQL Agent Job fail

  Hi, i've setup a sql agent job using a maintenance plan. As far as I know e.g. the database backup jobs are created as integration service packages. When I try to execute this sql job, an error message appears: SQL Server Scheduled Job 'BackupSSO' (0xDDC8AE8E9B2EF940919967FEBE70B85A) - Status: Failed - Invoked on: 2005-09-15 10:05:06 - Message: The job failed.  The Job was invoked by User WW001\claus.  The last step to run was step 1 ...Show All

• Deken SCD (Slowly Changing Dim) DTS vs SSIS Best Practice

  Hi there,   Is the best practice of managing change with Type II SCD used in DTS still valid on SSIS, or should we use the SCD transformer provided out of the box   Thanks. -w For updating dimension tables with thousands (or more) of records, it seems like the Lookup and SCD tasks are inefficient compared with building those lookups using joins built into the query that ...Show All

• larsw Problem connecting to SQL Server 2005 database instance

  I have an old ASP app that I have had to migrate to use SQL Server 2005. I have two pages that are virtually identical (one is edit only the other makes provision for adding new records - I didn't write these apps but I am responsible for making them work now). One page connect successfully to the SQL Server Instance and the other does not. They are using EXACTLY the same connect string. The only weird thing that has transpired is that we mig ...Show All

• Squeaker granting select permission

  Hi, How to grant select permission on table of another database from current database. Ex: I am in database asddb I want to grant select permission on table "test" which is in database bsddb. Can anyone please help me in resolving this problem. Please take a look at the GRANT statement in Books Online. You need to switch to the database using USE and run the GRANT statement. ...Show All

• Nathan Booth Report Builder Color Pallette

  The default pallette of the report builder seems to the light blue-based colors. How do you change the default pallette to say be my company's colors I would think that is would be an extremely common request as almost companies like reports to be branded with their companies colors. Besides setting the default pallette when you say create a table or chart. The color picker for all color customization only seem to have a fixed set of colors ...Show All

• snandan How to Turn ON the Log

  My users have created reports using Report Builder. I as an administrator would want to see the queries which was generated. Please could some body tell me how I could turn ON the log. Thank you, You have a couple of options: 1. use sql profiler on the database server instance 2. change the logging level for the SemanticQuery component within the ReportServer instance - Program Files\Microsoft SQL Server 2005\instance\ ...Show All

• MarkV importing a SQL 2000 database

  I installed SQL 2005 Express and Server Management Studio Express (CTP) but now what's the easiest way to import a database from a SQL2000 server Steve I've been using backup (from 2000) and restore (to 2005) with zero issues....   ...Show All

• Rouretain Real Time ROLAP different then ROLAP

  What is the benefit of setting the proactive cache to Real Time ROLAP. Wouldn't this be the same as ROLAP. Confused on why there is such an option. Books online doesn't seem to answer it clearly. Hi Deepak Could you please send me some code sample and "how to " for send client notification to Analysis Server Thanks alot. Regards; Rakesh   ...Show All

• TimothyB error creating a new pull subscription

  Hi Using RMO, VB.net 2005 and SQL 2005 Trying to create a new pull subscription programatically - merge HTTPS ovfr the internet Works fine when within out internal network - but when externally there is a problem.... I'm using the code from BOL - using their values - but pretty much cut and pasted. ' Define the Publisher, publication, and databases. Dim publicationName As String = "AdvWorksSalesOrdersMerge" Dim publisherName As String = instance ...Show All

• FM52 How to recover Database from .MDF

  Hi there,   I lost my .LDF file. Is there a possibility to recover Database from the MDF file with all data and Stored procedures Im using SQL Server 2000.   Please help....and sry if this is the wrong Forum for it...   Thx T. Gnewuch   Try to use sp_attach_single_file_db, it can recreate the logfile if the database is not corrupt. HTH, Jens Suessmeyer. --- http://w ...Show All

• Robert Sanchez Log shipping: How to failback after a failover log shipping?

  Hi, I 'm sure I am missing something obvious, hopefully someone could point it out. After a failover log shipping, I want to fail back to my inital Primary server database; however, my database is marked as loading. How can I mark it as normal I did the failover as follow: I did a failover log shipping from the 2 server Sv1 (Primary) and Sv2 (Secondary) by doing the following 1) Stop the primary database by using sp_change_primary_ro ...Show All

• Sudheesh Suresh Remove "top of report" when published via ASP call

  Sorry the subject is a little vague! I am issuing reports via ASP pages. I inherited this setup from my predecessor, who has a cycling "Sales Board" that calls reporting services pages from a script. All other pages do not have the light colored band across the top in which you can add parameters, click the "View Report" button etc. I have now created a new report and this band is there - can anyone please tell me how I ca ...Show All

• CCalhoun ErrorCode and ErrorColumn in Excel Destination

  I am exporting records with errors to Excel using the Excel Destination tool. The ErrorColumn is a numeric. How do I find out which column it is Hi Rob I want to do something similar but write out the column name to a table along with the data when rejected.  Did you ever figure out how to do this Thanks Marcus If you want to do this manually (i.e. not programmatically), ...Show All

• Alcor Trigger Problem

  I Have problem in creating after insert trigger. Actually my requirement is when i try to insert a record in transactions, trigger should get td_value from control table and update the same value in the transactions tablee, then increment the id_value by 1. I wrote trigger as below, but it is giving error in update transaction set..... statement can some on help in this regards. create trigger update_transID on transactions after insert as de ...Show All