Answer Questions

• BANG18 Sizing Columns

  I have a toggle enabled in a matrix report and I when the report opens all columns are collapsed.  I want to be able to hide or shink two of the columns until the one next to it is expanded.  Anyone know of a way to do this Edit the properties of the matrix group you want to be hidden and set the visibilty property to false. Set the toggle item to the textbox used to display the label of th ...Show All

• Sathish Kumar.R "A Drawing Error Occurred" when Exporting to PDF

  Hello, I have a report that I need to export to PDF, when I do so and re-open the report, I get a message stating "A Drawing Error Occurred". Plus when I have a textbox with a large amount of data, it always kicks to a different page, instead of print what it can fit on the previous page and the rest on the next page. Any help on this would greatly be appreciated. Thanks in advance. ...Show All

• PugV Export To PDF

  Hi, I have a table and a chart in my report .When i export it to PDF format the title of the report overlaps with the table and the chart spans 2 pages. Is there a remedy for this Hi, ok..Its like this.. i am generating a month wise report based on parameters supplied by an aspx page.This is being done dynamically by building the requisite RDL. In the RDL generated i have a table which ...Show All

• Bartosz Bien Custom Data Flow Transformation loosing CustomProperties

  I created a custom transform that has a custom interface and is a wizard that uses a web service. It creates custom properties and output columns on the fly. I set the dialog result to Ok and close at the end of the steps. The transform then has the custom fields and output columns I created in the wizard. I've verified this by right clicking on the transform and going to the advanced editor. If I then immediately run the package, the custom fi ...Show All

• Brian Pos Creating report based on parent-child dimension

  Hi I have a problem to create a report based on a parent child-dimension When I go to reporting services, and I create a new report based on a cube, I drag my parent-child dimension to my data-layout. Then the dimension is immediatily ragged down. Anyone an idea to solve this. hello, I have a similar problem in RS2005: In my report I see all levels in one column (How did  g4rc manage to see only top ...Show All

• JennyGMM SSIS debugging

  I've added some breakpoints to a script task. When I right click and execute the task the breakpoints are honored but there's nothing in the call stack, autos, or locals windows and I'm not able to add variables to the watch list. Is there something that I need to enable thanks Peter They are just not visible by default. After you hit the breakpoint you can go to the menu "Debug>>>Windows>>Locals" ...Show All

• HelpTheNewbie3893 How to create an object without being the owner of the schema

  Hi I have a schema called Accounts owned by fred User bob has create procedure permission as follows: grant create procedure to bob bob would like to create a procedure in schema Accounts . When he issues create proc Accounts.sp_proc .... it fails with: Msg 2760, Level 16, State 1, Procedure sp_proc, Line 3 The specified schema name "Accounts" either does not exist or you do not have permission to use it. What perm ...Show All

• el-neilios Exec Stored Procedure

  Hi, Hope someone can help me out here - I'm trying to design a data flow in SSIS which relies in part on a stored procedure as a data source - I'm running it through OLE DB. Sure Exec MystoredProc works fine on preview and on parsing, but it refuses to acknowledge any of the columns, when I go to Edit-->Columns everything is blank. Just out of interest - the reason I am using a stored procedure is because I dump the data into a temp ...Show All

• Cliff1234567 Transactional Replication failing - "The process could not bulk copy"

  Hello everybody, I'm trying to setup transaction replication between 2 servers. This is a one-way replication: Server A to Server B, not Server B to Server A. I am able to replicate all the tables except one. I added commands to the agent so that it would create an output file, possibly with more or better information. Here is a portion of the error causing the failure Agent message code 20037. The process could not bulk copy into table ' ...Show All

• Karen Kenworthy How do I get AdventureWorks to show in sql2005.

  How do you make the AdventureWorks sample show up (June ctp)   I already installed it using the msi file: "C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi" But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the database list (last step).  What's missing Right-click Database Engine , point to New , and then click Server Registration . The New Server Re ...Show All

• Jaroslaw Pekala Do I need DatePart or similar

  I have a function that uses the following statement in it SELECT src_terrier.Areacode, src_terrier.siteref, src_terrier.estatename, src_terrier.Securitised, src_terrier.unitref, src_terrier.unittype, src_terrier.unittype_count, src_terrier.tenantname, src_terrier.tenantstatus, src_terrier.tenantstatus_count, src_terrier.unitstatus, src_terrier.unitstatus_count, src_terrier.floortotal, src_terrier.floortotocc, src_terri ...Show All

• CarrieE.Wells Blank Error Messagebox Displayed at startup

  When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON.  Everything seems to be working after clicking OK though.  Anyone else experienced this.  Also...  Why is it that I can't repair the installation from Add and Uninstall   Do I have to uninstall it to repair it The SQL 2005 is the Developer Addition with a new install... Oddly enough, it has! I d ...Show All

• Joao Santa Barbara Problem with plug-in algorithm in SQL Server 2005

  Hi,all here, Could please anyone here help me for this problem My problem is: I have registered my plug-in algortihm with SQL Server 2005 analysis services, and I can see my plug-in algortihm added to the analysis service configuration file (msmdsrv.ini). But why I can not see my algorithm appearing in the list of algorithms when I tested it Really need help for that. Thanks a lot for any guidance and help. With best regards, You ...Show All

• Andy Boura sseutil usage

  Cool tool. How the heck do you use it I can do a sseutil -l from command line to see my databases. Then I do a sseutil -consolewnd to get a window up that allows me to put in SQL commands. But how do I point the thing at a particular database Hi Jim, Once you're in the console window you can run any T-SQL command just as you would when using SQLCmd. For your specific question about how to point it to a specific database, you would t ...Show All

• darkwitch Data Source Issues using DB2

  Has anyone used SSIS with DB2 as a data source. I am able to make it work with the OLE/db driver for DB2, but it is verrrrry slow and fails if it is not an extreamly small table (probably < 1000 rows). It runs much faster and seems to handle large tables if I do it with a script component using an ODBC DataReader. We would like to not have to write code for every table and I can't get a pre-defined data source to work with ODBC. The OLE driv ...Show All