Answer Questions

• decipherOne SQL Server Setup failed to retrieve the SSL Certificate Name

    When I try to install SQL 2005 Developer September CTP on Windows XP Professional  it returns an error "SQL Server Setup failed to retrieve the SSL Certificate Name" . I was using a certificate from SelfSSL but removed it. Still no luck This appears to be an issue with SQL Reporting Services. If I don't install Reporting Services then I can install SQL 2005. I'm guessing that Reporting Services is now requiring a certificate a ...Show All

• MikeBC Framework 2.0 changes - TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.

  If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host."   This happens against both 2005 and 2000 servers.   If I re-run the query it works.   However, this happens in our VB.NET app as well for clients with Wireless conn ...Show All

• garak0410 Error saving package to msdb (IA64 - April CTP)

  When attempting to save a copy of my .dtsx package (from BI Dev Studio), I get the following error. Any one have any ideas - note: This is an IA64 machine running W2k3 Server (SP1). If I select * from msdb.dbo.sysdtspackages90 I get no rows. Thanks! ============================================= The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 ([DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.). Th ...Show All

• SmSm241 Export a report to Excel : Data in a column become several columns

  Export a report to Excel : Data in a column become several columns When i export a report to Excel, the problem is coming, the report data that is in a column become several columns in Excel. Why the problem happens How to solve it. Oh, Ya! Fang Wang As you say, it's because my report has a header, so the problem happend! But the header is required, what can i do Thanks! I have solved this problem! The solutio ...Show All

• Davin Eastley Thousand separators in AS 2005

  My problem is about measure formats in AS 2005. I would like to present the number ten thousand(10000) as 10.000,00 , with (.) as thousand separator(European/Swedish format for numbers and (,) for the decimal). I do not want(10,000.00) because this is a problem when third part clients export data to Excel. The above 10,000.00 can be translated as 10 after an export to Excel.. If I run Pivot Tables, directly against As 2005, in Excel 200 ...Show All

• adam.connelly How to use user defined function in stored procedure?

  Hello friends, I want to use my user defined function in a stored procedure. I have used it like , select statement where id = dbo.getid(1,1,'abc') //dbo.getid is a user defined function. procedure is created successfully but when i run it by exec procedurename parameter I get error that says "Cannot find either column "dbo" or the user-defined function or aggregate "dbo.getid", or the name is ...Show All

• KevinJC Schedule backup SQL Server 2000

  Hi all, How can I schedule backup in SQL Server 2000 for ALL databases With SQL Server 2005 I can create maintenance plan to do this, but in the 2000 version I don’t know. thanks!!!! Have you tried one of the many different online backup solutions for sql server there's one from 4backuponline.com that works with sql server and it has been working beatiful for me for that last couple of months. You set it up once and you can forget a ...Show All

• RandyHayes Error when trying to use checkpoint file

  I have a package with settings SaveCheckpoints=True and CheckpointUsage = Never.  After the package failed I fixed the cause of failure by setting a database column to allow nulls.  Then I went to our web app that we built to monitor package execution and clicked on the button to restart the package.  The web app loads the package and then sets the CheckpointUsage property of the package object to 'Always'.  Then it ...Show All

• Adrian Hains Using Unicode in SQL Server

  Hi I'm have big problems trying to save Unicode information into my MS SQL Server 2000 Desktop Engine. Alright, so the problem I'm having now is I'm working with MS SQL 7.0 and PHP5. I've trying to get information to save into MS SQL, however it is storing it all weird. When I save the information and try to view it in Enterprise Manager it shows it has random characters but for some weird reason I can output that information on the page ...Show All

• Imran Hameed Differente between WebServices ReportingService, ReportingServiceExecution and ReportingService 2005

  I see those asmx files on the reportserver virtual folder and 2 of them have the render method, which are the difference between them when should I use one or another ReportService.asmx -- The "old" endpoint for 2000. It combines both management and execution functions. In SQL Server 2005, we split the endpoints into a distinct "management" endpoint and "execution" endpoint. These are: ReportExec ...Show All

• Maxi_I store procedures creation on prepare statment

  Hi, Can I remove stored procedure creation(optimization) for prepareStatment execution (Something like 'prepare=false' parameter on connection string) Thanks The problem, is that we create the pstm every time we need it (withot cache using). So, it's create prepared statment also. (We use pstm for easy working with sql parameters.... :) ). Driver we used before (iNet) has parameter named 'stor ...Show All

• Paul Bates Extract only unique entries to destination as to avoid duplicates?

  Hello, I have several source tables.  Some have unique keys, some do not.  All the tutorials I've seen on the web involve importing the entire collection of data from one source to the other.  I simply want to import data that does not exist in the destination table. Can we start simple   Suppose the source and dest. tables both have unique keys...how do I configure the lookup transformation to do something of an equivalent ...Show All

• lzeca Push Merge snapshot fails with Data is Null message.

  Hi, I'm converting a replication script from SQL 2000 to SQL 2005. I am getting an error with push merge with no way to figure out what is wrong. I've configured replication on a single XP server in SQL 2005 RTM version. I have a push merge set up between A and B and between B and C. All 3 databases are 9.0 compatibility. The snapshot and merge jobs for the A to B run fine with no errors, and merge replicates ok. The snapshot f ...Show All

• ec Problems importing data from an ODBC source

  I'm having an odd issue importing data from an ODBC source using a DataReader Source. There's data in the source table, and if I use a non-SSIS tool to query the source, all the data is visible. However, if I use the SSIS DataReader source, It returns no rows, and throws no error. Any ideas for figuring this one out This is affecting about 10% of the tables from this data source, and it's our ERP application, so there's limits on what I ca ...Show All

• Chi Wong Cluster install fails on SQL Native client

  When I try to install SQL 2k5 Developer on a Windows 2003 SP1 cluster I keep getting an error popping up while trying to install. the error looks like this: 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' Can someone please tell me what is wrong. I figure out what the proble ...Show All