Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4

SQL Server Compact Edition

Index ‹ SQL Server

- Previous
  - 1
    - Search Stored Proc That's what I tried, it didn't pickup the sproc. I even changed it to a known good sproc name. Hmm ... so close Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 2
    - How to query SQL CE database schema What are some basic commands to query information about a CE database schema. I'd like to see my foreign keys etc. Where can I find this information in BOL Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 3
    - Compare 2000 with 2005 Performance - 32/64 Decide to buy? FYI I have a few 2005 (SS2k5 x64) installs and many 2000 (SS2K x32) installs. Last evening a developer emailed and said her select was taking to long to run, 22 minutes on the SS2K x32. I cut\pasted her select and executed it on a new X64 Sql Server 2005 SP2 (3050). The databases are identical as the X64 will be her new Sql server. The sql ran in 36 seconds. I look good Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 4
    - Table Column Comparison Transform I want to be able to compare column values between the two different tables. These tables will have the same primary key but the column names and number of columns will be different. I will have a mapping table that lists which columns are to be compared. Table A, compare column 3 to Table B column 5, and Table A (column 6) to Table B (column 34), etc ... thanks Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 5
    - upload to a text file I have an Ntext column with some XML content. I wanted to upload that content in to a text file EX: "c:\ncolumn.txt". Any help on this is highly appreciated.. Thanks! Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 6
    - When you create a cube, does it have constant connection to the DB after the cube is created I agree with what Chris posted and I would have done the same thing. Your question is a fundamental question and that's what you need to learn. Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 7
    - Reporting Services Configuring Default Error Messages There has got to be a way to modify the underlying message returned from SOAP, modifying something in the reporting database messages, or modify some type of htm file. The error page is being rendered somehow. I am going to edit this post and supply a URL to give you an example of what I found. However, this only discusses about doing something and not how to do it. Again, this discusses adding an icon and what I want to modify is the text. http://www.ssw.com.au/ssw/Standards/BetterSoftwareSuggestions/ReportingServices.aspx#IISService Search for Item # 61 "Make this error more friendly by making it visually consistent with the SQL Server Configuration Manager" Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 8
    - need to changes the default port address of apache server can any one guide me how to change the default port address of apache which is 80 to any other port number. coz the default port number is taken by iis also. Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 9
    - selecting top 20 and the rest Anand, Try a select into with the big processing sql and then a union select. Sort of like this: Select * into [temptable] from ( select Id, amount from ({ really big and long time consuming sql statement}) as temp select top 5 cast( id as varchar 255) as [ID], amount from [temptable] order by amount desc union select 'Rest' as [ID], (select sum(amount) from [temptable]) - (select sum(amount) from [temptable] where id in (select top 5 id from [temptable] order by amount desc) Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 10
    - how can I substract a SUM from a SUM? OK then, how about this Chris SELECT SUM ( CASE WHEN visit_items . item_code = 'DISCOUNT' THEN visit_items . item_price ELSE 0 END ), SUM ( CASE WHEN visit_items . item_code ! = 'DISCOUNT' THEN visit_items . item_price ELSE 0 END ) FROM visit_items INNER JOIN visits ON visit_items . visit_id = visits . visit_id WHERE ( visits . visit_is_open = 'Y' ) AND ( visits . visit_file_no = @file_no ) Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 11
    - Problem in Installing SQL Server 2000 Personal No Deepak... we all make mistake... we all are there for a common cause to its help each other and there by improve our knowledge... so pse do not take it as personal... Madhu Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 12
    - Deployment problem Help Hello all experts, I have tried to deploy my cube using an XML Script in dev box, modify connecting string by changing server name, run in QA box, and process cube, but always failed. Error massage: боProcess failed. Trace information is still being transferred. If you do not want to wait for all of the information to arrive press Stop.бп Any one had experience for this error Thanks in advance. Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 13
    - Reporting Services printer problem I have a windows NT service, which prints to a laser printer programmatically using MSRS 2K. It works fine with a HP printer however when I try printing to a Lexmark Printer it does not always print. Somebody help. Microsoft please release a latest patch for MSRS 2K, its been so long since we had one. Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 14
    - Month/Year comparison against a date Hi, Is there a way to get the last day of a month, given a date in a datetime variable I have a stored procedure that accepts a datetime parameter. I need to find the last day of the month for that parameter value. For example, if the stored procedure is passed the datetime value, '6/13/2007', I need to be able to get from that '6/30/2007.' Here's the bigger picture: The sp actually takes two datetime parameters (unfortunately, I don't have access to change the user interface). The sp needs to select records between the month/years of those dates, not including the first but including the second. For example, if the user specifies the following dates: 6/7/2006 7/15/2007 the sp needs to select all records that come after 6/30/2006 and on or before 7/31/2007. I've tried this: ("ReportDate" is the name of the datetime field in a table in the sp and "@StartDate" and "@EndDate" are the datetime parameters in the sp) Month(ReportDate) > Month(@StartDate) And Year(ReportDate) >= Year(@StartDate) And Month(ReportDate) <= Month(@EndDate) And Year(ReportDate) <= Year(@EndDate) But this returns fewer records than when I enter 6/30/2006 and 7/31/2007 as the parameters and just compare dates like this: ReportDate > @StartDate And ReportDate <= @EndDate Thank you. Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 15
    - VB6 RDO error Could you try adding qryStoredProc.Prepared = True Just before using the parameters Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 16
    - Transaction Question When I run the following in Query Analyzer: SET QUOTED_IDENTIFIER OFF -- allows double quotes (") used as wrapper for dynamic sql. DECLARE @E int BEGIN TRAN T1 PRINT 'Start...' EXEC ( " begin tran T2| raiserror( ' inside proc', 16, 11) PRINT STR(@@ERROR) rollback tran T2 PRINT STR(@@ERROR) return " ) SET @E = @@ERROR IF @E <> 0 BEGIN PRINT 'Error ' + LTRIM ( STR ( @E )) + ' out of here...' ROLLBACK TRAN T1 RETURN END PRINT 'Done.' COMMIT TRAN T1 I get the following output and error: Start... Msg 50000, Level 16, State 11, Line 3 inside proc 50000 Msg 6401, Level 16, State 1, Line 5 Cannot roll back T2. No transaction or savepoint of that name was found. 6401 Msg 266, Level 16, State 2, Line 7 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 2. Error 266 out of here... Anyone have an idea why I would get the 6401 and 266 error JD Waleska, GA MSBassSingerNO-SPAM@alltel.NO-SPAMnet (just remove the string NO-SPAM) Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
- Next
  - 1
    - Integrating SSRS with report viewer I'm Sorry Scott still I did not get it..I'm lil bit confused with words. How do I add reporting web serivce reference can I use ASP.NET configuration Where can I find ListChildren mothed & GetReportLink monthed How do I pass link to reportviewer just clicking the smart tag and specifying the report path Thanks Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 2
    - successful implementation of dataware house and data mining hi all i want an article on a company or organization that has successfully implemented dataware house and data mining, and by its help they have been able to increase their business or sale etc etc help will really be appreciated Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 3
    - Aggregation wizard I changed my data source tables to views which effectively reduced the number of rows being loaded into dimension to only those items that appear in the fact table. However, in the Aggregation Wizard, when I request a row count, it appears that the wizard is not looking at the view, but the original table. Is this possible Thanks, Sully Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 4
    - USING SSIS for scheduled import Mike Kim wrote: Hi msdn forum members, I need to import data from another server using Express edition every minute. So I ran the import wizard, and I saved the packaged on the hard drive. Then when I try to make a new job and new schedule for scheduling, I can't seem to find SQL server integration service option for the Type. does anybody have any idea why I can't see SSIS there or had the same problem Or is there another way of importing data every minuite other than this BTW my server is 2005 standard edition. Thanks in advance, Mike Kim SSIS is not included in Express Edition. Check the comparisons page: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx EDIT: Also, if you are using this on your standard edition server, you will need to make sure that you have installed integration services (it is different than the database engine and needs to be specifically installed) Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 5
    - Monitor network resources used by single database Hi, Is there any methord to monitor network utilization per database on single instance of SQLServer2005 or SQLServer2000. Please help Regards Mohd Sufian Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 6
    - Drop database on a different SQL Server. and can you please tell how to do that as i tols earlier, i am new to SQL Server Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 7
    - replicating UDT's to subscribers how many dba's does it take to change a light bulb stupid mistake. need to change it to true to convert data types like on all our other publications Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 8
    - XQUERY / XPATH versus nodes containing ":"-character Hi, all. I'm having problems using XPATH / XQUERY versus input containing ":" in the node names. Example: Code Snippet <MyData:Output xmlns:MyData=" www.myprovider .com"> <MyData:Provider> <MyData:Property MyData:Name="FirstName">Joe</MyData:Property> </MyData:Provider> </MyData:Output> T-SQL (breaks): Code Snippet SELECT XMLContents.query('/MyData:Output/MyData:Provider') FROM dbo.Some_Table __________________________________________________________ XQuery [dbo.Some_Table.XMLContents.query()]: The name "MyData" does not denote a namespace. However, if I remove all the "MyData:" references from code and data, it works fine. I don't have an option of getting the incoming data changed; is there a way to escape the character to get this code to work Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 9
    - SQL Server vs. XML Configurations I have 2 connections in the package. One is development.sa and the other is development.ssisconfigurations.sa. I have the configuration set to define the development.sa properties, which I want to use for a number of the packages i create. My guess is that I am just missing something obvious, but it does not seem like I am. Sam Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 10
    - converting to numeric (6,3) Hey guys, I am trying to achive the following: Truncate the values 1680.390000000000000000 to numeric (6,3) All works ok until i hit a value over 1000, (as above) The code i was using is: cos1 = 1680.390000000000000000000 CONVERT (NUMERIC(6 , 3), ROUND(COS1, 3)) I have tried a few others, but nothing seems to work.. I get the following error. "Arithmatic Overflow" Has anyone got any suggestions Thanks guys, Scotty Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 11
    - Datasource Views and Teradata I'm trying to to use SSAS 05 w/ our Teradata warehouse (VERSION 05.01.02.70 RELEASE V2R.05.01.02.40) and I'm having a problem creating datasource views. My issue is that the wizard returns every view and table in the warehouse (tens of thousands) which takes over 10 minutes . I can't seem to limit it to only the database I'm intersted in using. I've tried using the restrict schema option but then no objects are returned. Any ideas on how to do this Can you create the datasource views without the wizard Thanks. Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 12
    - Understanding code created by SSIS import/export Wizard I can't seem to find these options in any of the designer areas otherwise I would have done that. I assume the logic is in the transfer tasks or somewhere in the foreach loop but there aren't setting for these specific options. I can't tell where it's getting its list of tables to transfer for the export/import either.From what I can tell the settings for deleting or appending rows during the import and allowing identity insert are stored somewhere else. Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 13
    - SQL Server 2005 Service Pack 2 - RTM - WHEN??? Hi, Does anybody know how many CTPs will be provided before the RTM will be delivered Thanks Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 14
    - Parameterized Queries Just getting started using SSce and having a few problems What I want to do is something like this... Dim Code As Integer Dim Description As String = txtDescription.Text.Trim Dim conn As SqlCeConnection = ConnectToLocalDatabase() Dim ssql As New System.Text.StringBuilder ssql.AppendLine( "INSERT INTO T_Titles (Description)" ) ssql.AppendLine( "VALUES(@Description)" ) ssql.AppendLine( "SELECT @Code = @@IDENTITY" ) Dim cmd As New SqlCeCommand(ssql.ToString, conn) Dim sqlCode As New SqlCeParameter( "@Code" , 0) sqlCode.Direction = ParameterDirection.InputOutput cmd.Parameters.Add(sqlCode) cmd.Parameters.Add( New SqlCeParameter( "@Description" , Description)) cmd.ExecuteNonQuery() Code = CInt (sqlCode.Value) ********************************************************************** The above code doesnt work. Firstly I am not sure if I can execute the two statements in one go. Secondly, I am not sure if output parameters are supported. I have been working with SQL Server since 6.5 but have always used sprocs and am feeling a little lost here without them. Any help getting started would be greatly appreciated. Thanks Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 15
    - Users and Roles script In 2005, is there a way to automate this I'd like to be able to do this automatically periodically: 1) Script out the development users and their roles in my development database 2) Backup the production database and restore the it to the development database 3) Re-synch the existing users (sp_change_users_login), drop any obsolete users (sp_dropuser), and add any development users with roles back on Does anyone have a script that can help me achieve this Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4
  - 16
    - how to extract this text? I have options_field contains a lot of data.. here are examples: DTбдNBбдNMбдANI=80088080 39139662 ANI=80088080 36637576 бдDNIS=80088080бдDTбдNBбдNMбдUNIT ANI=80088080 39188390 бдANI=8008808017403125бдDNIS=80088080бдDTбдNBбдNMбдUNIT ANI=80088080 39653135 бдALIASбдDNIS=80088080бдDTбдNBбдNMбдUNIT ALIASбдANI=80088080 39169467 бдANI=8008808017326875бдUNITбдNMбдNBбдDTбдDNIS=80088080 DTбдNBбдNMбдDNIS=80088080бдANI=80088080 36331200 бдANI=80088080 39318646 I want to extract every 39 and 36 mobile numbers in the ANI. All numbers are 8digits as highlighted ad some records will have more than mobile number while some won't have any mobile number listed. so the result should be 39139662 36637576 39188390 39653135 39169467 36331200 - 39318646 Tag: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4

Plane

Hi,

I have installed "SQL Server 2000 SP 4" to SQL server and it is running fine.

But when i install the "SQL Server CE version 2.0 Update for use with IIS and SQL Server 2000 SP4", i get below error:

"SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.
When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."

I have go thougth few articles in the forum, try to open the sqlce20sql2ksp4.exe file and then run only the MSI, but still fail.

By the way, i found that the sqlce20sql2ksp4.exe does not include any MSI, it is a direct executable file.

Appreciate if anyone tell me the solution.

Thanks in advance.

Best regards,

Plane.

Re: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4

ErikEJ

Are you 100% sure SP4 is installed (SELECT @@VERSION)

Have you downloaded the lastest version of this file: http://www.microsoft.com/downloads/details.aspx familyid=79071E22-52F5-4189-998E-FD03648FD3F4&displaylang=en

Re: Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4

Plane

Hi ErikEJ,

Thanks for the infor.

I'm sure the SP4 is there because the SQL Server Enterprise Manager show me "8.00.2039(SP4)".

The installer that i using right now is come from the link you mentioned.

Best regards,

Plane