Answer Questions

• Kaiser28 How to scale down database diagram to fit into a page for SQL 2005?

  In sql 2000 enterprise manager, diagram, I can right click and get page setup where I can shrink the size of the diagram to fit page. In the SQL 2005 diagram, How can I adjust the size of the image printed on paper Did Microsoft take this useful feature away Thanks! That is excellent. -Andy I figured it out and wrote this doc for my development team. How To Use ...Show All

• FrozenFrog Migrating from 2005 to 2005 Mobile

  Hello All, I have a database created on SQL Server 2005 and now I would like to migrate the table structure to a SQL Server 2005 Mobile database. Generating the scripts and running them against the mobile database generates a lot of error that I suppose are caused by not supported features or keywords on the mobile engine. I would like to know what are the best procedure for doing such migration. Note that this has nothing to do with repli ...Show All

• rdrago SUM problem in SSRS 2005 report

  I don't know how best to explain this but will try. In my SSRS 2005 report, i have one group in my table.  In that group, I have a field that for each company record in my dataset, this field value is repeated for each record. This is a transactions table so you'd expect several records in the dataset for each company..that's not the problem. example data from dataset: TransID     CompanyID   &nbs ...Show All

• HonFui Pass through Authentication

  We have Reporting Services 2000 standard edition installed and everything works fine. You can log in and run reports and the Reporting Services security rolls work. The problem is when a user goes to the url of reporting services web server it prompts them for a login. They enter their Windows domain login and they get in. Is there a way to configure Reporting Services to use the user's Windows Domain login credentials (pass through) and not ...Show All

• Anthony Wong 6 How to use Excel to browse cube

  I have created a cube. Now when I open excel so that to browse the cube in the excel pivot table i am getting connection refused error I am using olap 9.0 to connect to my cube which is deployed on the sqlserver 2005 analysis server. server is up and running. Hi, I having the similar problem with you. But no sure whether your error message is same with me. Here i get the error message as below: ...Show All

• osmansays Why do all packages in the project open when running one in debug mode?

  Does anyone know why this happens When I run one of the packages in my project (by hitting the play button in the designer), all of the other packages in that project open before it starts running Thank you. Is this also true for all packages in all projects of a solution I have multiple projects for a SSIS solution, and when I debug one of the packages in one of the projects, all the packages in all of ...Show All

• JonyBGood2 error '800a03eb' Type mismatch

  Maintaining database website,its running ASP pages on windows 2003 server with SQL server 2000. I have upgraded SP2 for SQL server to SP4 in maintance process. The problem accur with some ASP pages are server_errors [server_Errors] GetErrorMessage [serverSERVER version 1.0.0] error '800a03eb' Type mismatch /server/asp/cmfls/errorconfirmation.asp , line There may be permission /security issues related with database.help me to tr ...Show All

• Edwin Castro Re Transactional Replication

  Hi All! Need help guys... I'm new to SQL Replication, though I successfully created a transactional replication testing on my machine using PUBS DB and a separate DB. I'm planning to establish/setup a Transactional Replication. There are two SQL Servers, one is being used by WebApp_1 and the other is being used by WebApp_2.  Both servers are maintain by different administrators and situated on different domain/location (both used ...Show All

• The PCman How to set empty a space from a derived column expression?

  hi, This field comes from a flat file and sometimes own zero and sometimes own a empty position (after 'EUR'): 2006053000499236000005307700108287457080200408287452006052953990000000010000EUR 2006053000499236004414989200101423426004400501423422006052953990000000010000EUR0 [Column 12] == "0" [Column 12] : TIA No. In the pipeline. If it is DT_STR then your expression will be: [Column 12] == "0" ...Show All

• Srinivas Lingineni Remote connection of SQL Express

  Good day! I'm trying to make remote connections to SQL Express and it seems that it is not working. Below are the steps that I did - TCP/IP enable in the "Protocols for SQLExpress" node - Since I'm not going to use SQL browser, I clear out the value for "TCP Dynamic Ports" and instead create my own TCP Port number - I add my windows authentication to the dbase that I want to try to connect remotely ...Show All

• jnariss time out expired error

  Hi all, I am so glad to find this discussion forums for SQL NS. I’m badly stuck and need help. Background: I am currently working on an VB.NET + ASP.NET + SQL 2000 + SQL Notification Services based application. I maintain / enhance it. The application uses Notification Services to send automated emails to the users. (Event based subscriptions only). My application has two notification services running, one of them started failing about a week b ...Show All

• Breck Carter Difficult Query

  Hello, I am new to Transact SQL and am not sure how to get the proper result set.  If there is OE 1 and only EP 1 for the same sysprojn (see 3000021), I only want to select the row with the OE 1.  If there are more EP rows for the same sysprojn (see 3000024) then the sum(bookd) of the EP rows equals the bookd of the OE.  In that case, I need to select all the EP rows and the OE row.  Any help would be ...Show All

• database_mentor xml modify 'replace value of' using sql:variable

  I need to be able to use sql:column in a xml modify/replace statement. Is this supposed to be possible Here is a simple scirpt that shows the problem I am having. I used sql:variable instead of sql:column for the sake of simplicity. declare @xml xml set @xml = '<root/>' select @xml declare @value varchar(10) set @value = 'val1' set @xml.modify('insert <item value="{sql:variable("@value")}" /> into (/root) ...Show All

• 7racer Export Issues

  This is regarding the export to web archive problem in SRS Report. We have a report which displays the photos in each sub report. Some Images are not getting loaded when the report is exported to Web archive. When I export the report again to web archive some other Images are not getting loaded. This behavior is random and it is not every time the same images not being loaded. But when the same report is exported to exce ...Show All

• Mike Jocher restricting the amount of data getting into a cube

  i have a cube with a lot of data. there is so much data that when a report is run on the cube it takes a substantial amount of time to build the report. the cube contains data for the past 5 years. i want to limit the amount of data in the cube to just the last 1 year, so that when i process the cube, it only pulls in the last year of data. how do i go about doing this Im using sql server 2000 database. Or if ...Show All