Answer Questions

• QuantumMischief Alternative to Merge Replication

  I am involved in a development project of an enterprise level hosted application. The main product is a smart client application, and will soon have an embedded sql express option. At the moment I am building the WM 5.0 mobile application and have been advised against using merge replication to syncronize the databases. The reasons have been that our main SQL 2005 database is on a hosted server that would have to open ports directly to the internet for the merge replication to do its thing. So far I have built some realy pain in the *** manual synchronization that loops through every table it needs to sync looking for a last modified time... pushing and pulling this way. This way it can pass DataSets through a web service just like ...Show All

• SDruelinger ssis in sql server express edition

  hi, can anybody tel me how i can install (any component to be instakked) ssis in sql server 2005 express edition it's lok like this edition doesn't support ssis! is' it true Thanks Sandipan Hi Carlin, The security model did not change in SQL Server 2005. We did change the Service Account used by SQL Express from that used by MSDE, but the model is exactly the same. There is a set of DTS Design Components also available on the feature pack page, I've never installed these, but the description indicates they provided design functionality for DTS 2000 packages in SQL 2005. You are correct, you can not generate a canned SSIS package and then run it in Express. You must have the SSIS engine to run SSIS packages, SQL Expre ...Show All

• RyanB88 Slowly Changing Dimension Historical Attribute causeing same row to be reinserted

  I have a Slowly changing dimension that I am using to populate a dimension table. My problem is this when I run the package and any of the fields are marked as Historical Attributes it will add an additional row regardless of the fact that the incoming data and the data in the warehouse match exactly. I've tried several things to fix this problem but so far none of them have worked. Some of the things I have tried that haven’t worked are to match all the data types (which I have to do anyways) I've tried trimming the strings, I've also tried adding just one column I am using a data conversion to convert them from varchar (the source datatype) to nvarchar(the warehouse datatype) I'm at a dead end here and don't know ...Show All

• Peter Aspect Search for data inside a Recordset Destination

  Hi there, I need to develop a module and wondering what would be the best implementation... I get a list of files from a text file and store it in a Recordset Destination (object variable "CUST_INV_LIST"). I need to check that all the files in a directory are in the list. I can loop through the files in the directory using a ForEach container, but how do I check if it is in the CUST_INV_LIST recordset I thought about using another ForEach container to loop through the recordset, check if the physical file is equal to that row, if so set a flag, ... but it's neither elegant nor effective. Another option would be to use a Script Task to search for the physical file name in the recordset. I tried with the Data.OleDb.O ...Show All

• yeos_lee Index on query with both where clause and order by

  What is best index for this query Select * from Table1 whete Table1.C1 >100 and Table1.C2=23 order by Table1.C3 How many index do I need and what column order I would appreciate if some body can put link to complex query index guideline Thanks for help. It's difficult to give an optimal answer without first gaining an understanding of the distribution and volume of your data. For instance if your table contains only one row then a full table scan will be the most efficient way of returning the results . If your table contains millions of rows, yet 99% of the rows satisfy the criteria (Table1.C1 > 100 AND Table1.C2 = 23) then a table scan is still likely to be the most effi ...Show All

• ajay_dekavadiya Different file save location when used as a scheduled job than in VS2005

  I have an SSIS package that I created that looks like the following: Execute SQL Task [Determines the file name] Data Flow Task Source - Query [Grabs the data] Destination [Saves data to file on network drive] Send Mail Task [Tells user to get file from network] When I run this package inside Microsoft Visual Studio I get the results I want. It sends the file to the network drive and because there are SSN's in the file, it doesn't actually e-mail the file but puts it in a secure location for the person to get the file. When I schedule this in SQL Server 2005 I get the file saved to: c:\windows\system32\dynamicfilename.csv So somehow it is still able to determine what the file name should be, but instead of sending the f ...Show All

• Alexander Petukhov Problem during deployment

  Case description: I follow the instructions in the installation manual of MS on: http :// www . microsoft . com / technet / prodtechnol / sql /2000/ deploy / rsdepgd . mspx customized for the Enterprise Edition, but, despite of what is described in the manual, during the installation Inever get a prompt asking me to define the Virtual Directory in IIS, or set the Service Account for the ReportServer, etc. The installation finishes (on screen msg: installation was successful). After the installation is through, I can’t see the ReportServer within the Services, neither the Report Site is up (it’s not even configured). The only difference between the configuration’s prerequisites and my server is that it has SP4 on SQL Server ...Show All

• MLyons10 YTD, MTD etc for Current Point In Time

  I've set up time intelligence on my cube.  This works fine.  I can get to: YTD YTD Prior Year YTD Index Jun 2006 Qtr 502962 467145 107.6672125 Sep 2006 Qtr 733396 916144 80.05248083 Dec 2006 Qtr 733396 1440868 50.89959663 Mar 2007 Qtr 733396 1850595 39.63028107 with the following MDX. SELECT { [Time Calculations].[YTD], [Time Calculations].[YTD Prior Year], [Time Calculations].[YTD Index] } ON COLUMNS , { [Time].[Fiscal Hierarchy].[Fiscal Year].&[2007].CHILDREN } ON ROWS FROM [mycube] WHERE ( [Measures].[Order Quantity] ) This works fine if I have time series on rows and time calculations as colum ...Show All

• Nordy SQL Server Management Studio Express

  I am getting this famous error message: Connect to Server Additional information: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (Provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server) (Microsoft SQL Server, error:2) The above error message appeared either way - Windows Authentication or SQL Server Authentication. I am not trying to connect any remote Server or Database, everything is installed on the local computer. the server name is my local computer name. SQL Browser is disabled. I can run SQLCMD -S \SQLEXPRESS ...Show All

• narend SQL Server 2000 Connects to Remote DB but not Local DB. Why?

  I am using MS SQL Server 2000, installed on my local machine. I use JCreator 3.50 as my development IDE for Java. I have Norton Internet Security, but it does not block port 1433, which I use for SQL Server. Windows Firewall is turned OFF. My hard drive died, and my backup died then as well (it had been fine 1 week before). I had to start from scratch. I installed Windows XP SE2, JDK version 5 (version 1.5.0_06, I had previously used 1.40) and SQL Server 2000 with SP 2 as well. When it didn't work, I uninstalled SQL Server 2000 and did a clean install of SQL Server 2000. Instead of the default instance, I gave the instance a specific name, so I would know what to put in the Java code. I can connect with a remote DB using the standard URL a ...Show All

• MrJP Problem With SP2 for SQL Server 2005

  I have a windows application that uses “ReportService2005” and “ReportExecution2005” web services to render to PDF a Reporting Services report in a loop (around 700 reports) and it was working fine before installing SP2 but now it works properly for a couple of minutes and then it returns the exception below:   - ex       {"System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportPro ...Show All

• Thibaut Barrère move database from development to production

  What's the best way to move database from development to production environment SSIS usage of databases or databases in general If you want databases in general the Database Engine is a better forums for this question. Thanks, Ovidiu Burlacu ...Show All

• Henrik Goldman sp4 on dev edition 2k

  I'm running SQL Server 2000 (Developer Edition) on an XP machine. I'm trying to apply Service Pack 4, which, though I haven't service packed SQL Server 2000 in a couple years (most recently working more in 2005), I have installed SPs against SQL Server without difficulty in the past. I've downloaded the x86 SP4 exe. I extact the package ... but when I got to run setupsql.exe from a command prompt, I get nothing -- no dialog, no apparent install. silent switch is NOT specified. Hi, I donot remember the threads but earlier i see the threads asking how to remove / delete registry information which is still their after Uninstallation , so i would suggest you to refer below links for Manual Install & ...Show All

• Mitali Deshpande Null datetime value problem in sproc

  Hi. I wrote a sproc to insert values from a tab-delimited text file into SQL 2005. There is a column in the text file that contains datetime values. Some of the values may be null. I have defined my sproc as: [CODE] createproc [dbo].[spInsertTransactionData] @LoadTransactionCode tinyint, @AccountNumber char(19), @PostingDate char(8) = '01011900' as insert into table1 ( LoadTransactionCode, AccountNumber, PostingDate ) values ( @LoadTransactionCode, @AccountNumber, cast(stuff(stuff(@PostingDate, 3, 0, '/'), 6, 0, '/') as datetime) ) [/CODE] I am getting the error: "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value." When I step into the sproc, I see t ...Show All

• MMEZIL cannot allocate more connection.connect pool is at maximum increase max pool size

  hi i'm having this error on my application"cannot allocate more connection.connect pool is at maximum increase max pool size" the proble is when i do testing this error does not apply it only Appears when the application is been used by many people How can I resolve this Thanks If you use connection pooling you will have to implement a custom logic to either wait for a released connection or throw a customized error like "Come back later". Also make sure that you release the connections to the pool after using them by the users. If you did not define the connection pool size yet, you should consider if your environment can afford / take more conenctions. HTH, Jens K. Suess ...Show All