Answer Questions

• jonzim Multi-column report not working for me

  My organization is making the switch to Reporting Services and I am tasked with reproducing a number of reports which are currently done in Access.  One report in particular has the result dataset snake across two column.  I modified the layout of my report to be two column but I can't seem to get my table of data to snake into the second column. I am sure that I am just missing a check box or something, but I am at a loss. Gordon ...Show All

• Coolnet1savvy Visual studio interface EXTREMELY slow

  Hi folks, I'm working within VS2005/Business Intel studio environment. I've got one master package, which loads about 18 sub-packages as tasks. After openin the master package (and waiting 5-10 minutes for the packages to open and validate), maneuvering within the IDE is nearly impossible, it is so slow. Context menus can take 30 seconds to open. Certian operations, like closing a window, seem to hang the environment. Does anyo ...Show All

• Dillon sysxlogins table and null names

  Hi all, running sql server 2000 sp4, viewing the sysxlogins table data, and am wondering about the three items listed with a <NULL> in the name column, all xstatus = 192, each has a unique srvid value of 0, 2 or 3. Looking in the MS tables reference book did not help they don't cover sysxlogins, googled around but no luck, searched this forum also. What are these entries Thx Copying the answe ...Show All

• ISV Royalty Program Schema changes after Replication

  I see from help books that table changes are not allowed using Enterprise Mgr. after a publication exists. The only way to make db changes is to use T-SQL. I found the correct sp to make changes below. I am using sp_repladdcolumn <tablename>,<columnname>,<datatype(25)> sp_repladdcolumn does not allow datatype length to be supplied. Result defaults to 1 and sets to NULL. I need a variable length on my datatype. Is th ...Show All

• DBA Tool Upgrade from June CTP to Sept CTP - BKM

  I am upgrading to Sept CTP from June CTO. Should I completely uninstall the June version before proceeding towards the new version Any experiences Pls share. Yes, you need to completely uninstall June CTP components. Read the READMEs carefully about uninstall order for your circumstances. Andrew Watt MVP - InfoPath wrote in message news:378426eb-8533-43f6-9f9f-a37719c91585@discussions.microsoft.com. ...Show All

• Marcelo - MSFT MOVING DATA BETWEEN SERVERS

  I got a dts package to move data from one server to another. It ends up in a results table. I am tryin gto truncate a 4 field table and then repopulate it from this results table (same 4 fields) Seems easy but for some reason it is beyond me LOL. Can someone please tell me what the syntax should be after truncating the table that is to get the information. Or should I drop it and do insert into Well, if yo ...Show All

• slabanum Synchronizing sql 2000 and sql 2005

  Im working on a project. This program will run off of a sql 2005 database. The company that we are selling this too uses sql 2000. They will end up using both. They will enter their data as usual, into the sql 2000, and then I need to get that data from 2000 to the 2005 database, anytime a transaction occurs, I need that transaction to also occur in the 2005 database. The 2000 DB has 4 tables. These 4 tables are split up into different ones in 2 ...Show All

• Ben805 Error when calling a Java (ws4ee) web service

  Hello,   I try to call a web service written in Java Jboss (ws4ee)   I can download the wsdl file.   At design time, the wsdl file is well recognised by the web service task. I can select the method in the wizard.   But, at run time, I have a problem. I receive the following error. When I use a network analyzer, I have no traffic with the server.   Error: 0xC002F30 ...Show All

• johncart ~* displaying report in print preview mode *~

  Hi, Is there any way to display the report in browser in print preview mode... Thanks in advance.. Cheers Chakri. ...Show All

• CHTHONIC Page break after X items

  Is it possible to force a page break after a specified number of items in a table For instance, I have a name badge report but I'm running into a problem where some badges are sliced down the middle at page breaks when exporting to pdf or tiff.  If I could force a page break after every 2nd or 3rd badge it would alleviate that problem. Thanks in advance. hi, I hope someone can help me! I don't understand w ...Show All

• VincentCroft How to suppress the subreport when there is no data in it?

  Since there is no way to pass value from subreport to the main report, how to suppress the subreport when it is blank Thanks. In one sense I have the opposite problem. My subreport is hiding itself because it has no data. However it contians static text that I need to have showing. Is there a way to force the subreport to stay visible Thanks, Jonathan Can you explain ...Show All

• Azita Mangoli SQL 2005 Sept. CTP setting up Source Control

  I am attempting to set up source code control using the SSMS. Following the directions in BOL, I go to Tools | Options | Source Control. The documentation now states that I should see an Environment page. However, the only option listed on my system is Plug-in Selection. On that page, there is a drop-down list for adding plug-ins. However, the only item listed is 'none'. Any ideas on how to proceed I am trying to access our VSS 6.0 database ...Show All

• Kinns SPIDs blocking itself

  Running sp_who2 on our SQL Servers during peak time (where more data come in), that the same spid is displayed multiple times and some of them blocking itself. DISKIO and Lastbatch on all these will the same, while the CPUTime are different. This is how the result of sp_who2 looks: SPID        Status         BlkBy      Command  ...Show All

• Andres Ponce de Leon Need Bulk Insert help

  Hi all, I am not sure I post this in the correct forum or not, if not please reguide me to the correct forum. I have data files created from streamwriter using tab for field terminator and line break from streamwriter. Then I try to use Bulk Insert to load the data file into a table with format file using bcp command. Then I received the following error: Msg 4863, Level 16, State 4, Line 1 Bulk load data conversion error (truncatio ...Show All

• Ben Zamora not able to login in other computers!

  I'm developing with Visual Studio 2005 Standard Edition and SQL Server 2005 Express Edition, my problem is that as default SQL Server Express uses windows authentication. Since I develop in my own PC and install the software in another PC, my SQL Server Database is useless cause it still tries to log in wih my computer name and windows user. I'm using a conventional intallation project in which I include all the files (fonts, project output) ...Show All