Answer Questions

• co?kun MySQL

  Is SQL Server Express the same as MySQL MySQL is a totally different product and it's not even from Microsoft. A simple Google search could have told you this too tbh. ...Show All

• Josh K Remote Connection

  Could someone tell me how to remote connect to other server . Everytime when I try to connect to other server, I get an error message . Eventhough I have opened the 1433 port, allow the remote connection using both TCP/IP and named pipes, and open the firewall for connection. "An error has occurred while establishing a connection to the server. When connection to SQL Server 2005, this failure may be caused by the fact that under ...Show All

• AngelManzano Using connection manager connections inside a script component

  Within a data flow I have a script component that I want to perform some data calls from. I want to execute SQL commands to connections already defined in the package's connection manager. Is there a way to set my script's connection variable to the connection manager connection Or, can I use the connection manager connections directly from within the script I figured out my problem. Duh, there's a ...Show All

• Binny SMO Method Performance

  I've run a series of performance tests on a test app that uses smo for creating sql server tables (including columns, indexes, triggers, and foreign keys) and stored procedures (including parameters). On a 2.7GHz machine with 512MB ram (both app and Sql Server running locally), the series of tests yielded the following results: Table.Create() 0.3 ==> 0.6 seconds PrimaryKeyIndex.Create() 0.7 ==> 0.9 seconds Trigger.Create() ~0.0 ...Show All

• Alexiel Transfer Object and Click Once

  I have an application which uses SMO to perform various database tasks. When deployed using ClickOnce from a Website and set as a FullTrust application the application has the following behaviour when attempting to transfer database\data: ... transferObject.TransferData ... Error: 'HRESULT: 0xC0011008', ie DTS_E_LOADFROMXML error All other database connections\functionality within the application, which connects to MSDE and SQL Server E ...Show All

• qifeng Keep getting Virtual Memory errors

  Hello, I am wondering if there is a way to solve a virtual memory error We randomly get the following error when trying to run sycn over the http websync. Some clients have 512 MB running sql express, others are full instances that have 1.5 GB. The merge process could not allocate memory for an operation; your system may be running low on virtual memory. Restart the Merge Agent. Can you tell us abou ...Show All

• BozUK sql 2005 SP1 Setup Failed

  Hello I have installed Visual Web Developer 2005 Express, as well as Visual studio 2005 Standard edtion. I installed SQL 2005 express edition after installing Visual Web developer 2005 Express Edition! at least I thought I did. I most recently tried to install the SP1 of SQL 2005 express edi... and I seem to have gotten a failure to install message with (sa) in the message(I remember it from the first install but it had gone away on 2nd attempt) ...Show All

• exceldude2001 sql server 2005 trial version

  where is the import and export data function in sql server 2005 express i have a data in ms access which i want to import to sql server 2005 express.. thank you   erd wrote: do you have to uninstall the existing sql server 2000 enterprise edition to install the sql server 2005 trial version does it have to be clean install Hi erd, you don't necessary have to. However to do an 'upgrade' you have ...Show All

• Wprogram Error level and expressions

  In a report, I have the expression : =iif(Sum( Fields!X_A_1.Value)<>0,(Sum( Fields!X_A.Value)-Sum( Fields!X_A_1.Value))/Sum( Fields!X_A_1.Value),"NA") This expression product the error "The value expression for the textbox ‘textbox12’ contains an error: Attempted to divide by zero." I think it's because reporting execute the expression (Sum( Fields!X_A.Value)-Sum( Fields!X_A_1.Value))/Sum( Fields!X_A_1.Valu ...Show All

• zgierski Cannot complete Install of Express

  Product: Microsoft SQL Server Native Client -- Error 1706. An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'. Logged as MsiInstaller in App Log. The install fails with this and two other items in the bos that shows successful install items SQL Server Database Services Workstation Components, Books Online, Development ...Show All

• TFink Reporting Services viewed print layout is NOT the Printed output

  I have setup my report to be landscape ( 11in by 8.5IN ) and when the report is run it shows 4 list box elements per page when viewing the report in the browser HOWEVER when you click on the print button to print say page 182 - 185 the physical print ( also landscape mode ) is only allowing 2 elements per page and the page count is now doubled Some how the viewed page should be the same and the printed page... Never had a problem like this b ...Show All

• WallStreetVH ForEach Loop utilisation

  Hello, ForEach Loop Item allow to make operations row per row. How can i do operations 10 rows per 10 rows or 100 rows per 100 rows Thanks ! Your english is good, don't worry about that :) You can read your list of quotes into an Object variable using 1 of 2 methods: 1) Use the Execute SQL Task or 2) Use a data-flow with a Recordset destination component. Once there you can loop over it using the Foreach Loop's "Foreac ...Show All

• paddyprash How To Avoid Table Scan

  Hello All, Is their any way I can avoid a Table Scan by modifying the follow WHERE clause WHERE tbl_mis_Dashboard.loan_active_flg = 1 AND [tbl_mis_Dashboard].[loan_create_dt] between DATEADD(dd, DATEDIFF(dd,0,dateadd(mm,-13,getdate())), 0) And getdate() The field loan_create_dt is indexed on the table tbl_mis_Dashboard. The query returns approximately 256K records which is appropriate and necessary. Thanks all, Orlanzo It's ...Show All

• Supes Retrieve Data from Web Services Using DTS (SQL Server 2000)

  The project I'm currently working on involves combining data from one SQL Server 2000 databases and XML returned from a web service into a 3rd SQL Server 2000 database. This process must be scheduled to happen once a day. If it weren't for the Web Service, I'd say that this is a no-brainer and I'd use DTS. However, I'm not sure if I can even access a Web Service with DTS. Has anyone done this or have any tips Id try the microsoft.pu ...Show All

• Chris_S Basing Report on a Procedure with Cursor

  I need some advice on how to design a report using cursors. Is it possible to base a report on a cursor I would think that I would have to put the cursor into a stored procedure and call that procedure. But if I do use the cursor in the procedure, will the looped variables automatically populate the report or will I need to insert them into a table that populates the report Thanks, cj This should ...Show All