SQLServerCentral / SQL Server 2005 / SQL Server 2005 Compact Edition

Notification Services missing

harcaype_rollers — Thu, 15 May 2008 09:42:59 GMT

Hi. Can anyone tell me how to include Notification Services?? I am trying to create a publication but I can't seem to find Notification Services node. I need to start the SQL Server Agent.

Instalation error

jorge.garmilla — Mon, 12 May 2008 15:54:00 GMT

I have a problem.Install the SQL Server CE (v3.1). It does not give mistake, but I can not add a reference to SQLServerCE because it does not appear on the list of references. Net. (I have previously installed SQL Server 2005). I refer to the hand and not let me.Any help?

how i can generate sequence number in sql server

kaushalkumar.thakur — Fri, 09 May 2008 04:36:53 GMT

suppose i hav employee name i want the sql command automatically genertae the distinct emp id....plz can any one help me ,wat will be the query for that

How to access sql database from sql mobile database?

ramesh — Mon, 05 May 2008 13:07:58 GMT

I have a sql-server database table and I have a sql mobile database with a .SDF extension, I want them to speak to each other by being able to write queries form the mobile database to access sql data and insert it into the mobile database, how do I do it?Please advise.Ramesh

Server Type in SQL Management Studio

arjun.marwaha — Thu, 01 May 2008 11:17:32 GMT

Hello,I have installed all the required installations for SQl Server CE, however when I open SQL Management Studio, the server type option is greyed out and I do not have the option to select SQL CE server type.I have installed SQl Management Studio Express edition (if that helps.).Please suggest.Regards,Arjun

Header information is either or corrupted...

abdurrahmanoguz — Thu, 01 May 2008 05:55:56 GMT

I have an application running at "Win CE Emulator" developed by Visual Studio .NET 2003. I am using SQL Server at my development computer where IIS is running. I have configured and created the virtual directory according to the steps available in the MSDN. I create publications as mentioned in MSDN. Seemingly, no problem was found. Now i have sqlcesa30.dll in my virtual directory and i can access it using [i][u]http://192.168.0.101/Term01/sqlcesa30.dll[/u][/i].I tried to create an RDA object and when i call its SubmitSQL method using the above mentioned URL, it generates an error "[b]Header information is either or corrupted[/b]."What am i missing? Please let me know what to do with it?

total time difference between more than two dates

meenu.monu — Sat, 12 Apr 2008 04:10:02 GMT

advance thanks to all...can anybody helpme soon...........i am using sql server 2005........i want to find out time difference between more than two dates in HH,MM,SS format.and i want to find out total time difference of all timeeg first i want the time difference of these two dates02/Nov/06 9:14:21 AM19/Apr/07 11:52:31 AM second i want the time difference of these two dates02/dec/07 12:14:21 AM19/jan/08 5:52:31 AM 3rd i want to find out the total time difference now i am using this calculation in my procedure is as follows...but i think this is wrong...if we will seperatly calculate like this wrong i am gettingset @totaltravelHr=datediff(HH,@datediff1,@datediff2)set @totaltravelMI=datediff(MI,@datediff1,@datediff2)set @totaltravelSE=datediff(SS,@datediff1,@datediff2) can anybody help me soon??????????regards

Is the Synatx correct??

niki — Wed, 12 Mar 2008 03:36:11 GMT

hi !!Im in a need of guidance in solving a query.[b]vw_ApplicationsReceived [/b] is aview from which i want to retrieve some Specified fields.the query is tofind the candidate details from the view where candidateApplicationId(Fk n PK) in CandidateApplicationinFolder table=candidateApplicationId in [b]vw_ApplicationsReceived [/b]& FolderId is the Parameter in stored proc. which is FK in CandidateApplicationinFolder table.Iwant to know whether the logic is correct??ALTER PROCEDURE dbo.GetDetailOfFolder ( @FolderId int )AS SET NOCOUNT ON; SELECT CandidateId, VacancyId, DateOfApplication, ReceivedThrough, CityId, DateOfBirth, Education, Experience, ContactNo1, EmailId,CityName, ContactNo2, StateId, VacancyCode, Title, FirstName, DesignationId, LastName, MiddleName, InsertedByCandidate, MediaId,ExpectedSalary, (SELECT CandidateApplicationId FROM Recruitment_CandidateApplicationInFolder WHERE (CandidateApplicationId=V.CandidateApplicationId)AND FolderId=@FolderId) FROM vw_ApplicationsReceived AS V RETURN

How can we Update Image in SqlServer Ce???

sivak42 — Fri, 04 Apr 2008 03:56:02 GMT

Hi guys, I would lilke know.I have a column called Image in the database. The type of of the column is Image. I want to upade it. I have an jpg file. How can do that????Lets say I can retrieve an image file from url,then save it into the sql server ce.....not insert ...i want to update...Thank you

Convert Oracle Select to SQL CE Select.

gagan rastogi — Mon, 07 Apr 2008 07:46:49 GMT

ORACLE:SELECT * FROM L_RPT_INV_PERSON_INFO WHERE (RPT_INV_ID,RPT_INV_TP) IN (SELECT RPT_INV_ID,RPT_INV_TP FROM L_RPT_INV_INFO where INFORMATION_CHANGED_FLAG='Y')What is the equivalent of above query for SQLCE.Urgent help Needed.Best Regards.

Transfer data from SQL server database to DBISAM

hisham2778 — Mon, 31 Mar 2008 00:17:41 GMT

Hi,I have two software systems as the following:1) Main software, Building on Sql Server 2005.2) Second Software, Building on DBISAM version 4.1On main software (SQL server), I have table including the name of staff, sex, nationality, age ... etc, and I want to transfer any change on this table (insert\update\delete) to same table was built on second software (DBISAM). I mean that I need online transfer.How can I do that?I am new in SQL server and I need your help.RegardsHesham

IDENTITY_INSERT Fails - Why?

cecil_a_galbraith — Thu, 28 Feb 2008 06:26:07 GMT

Can anyone tell me why the following fails? It works fine on SQL Server Express 2005 but not on CE. The issue is the second part of the query.create table MyTable (id integer identity(1,1), name nChar(50))goset identity_insert MyTable ongoinsert into MyTable(id,name) values(2,'test')goMajor Error 0x80040E14, Minor Error 25501> set identity_insert MyTable onThere was an error parsing the query. [ Token line number = 1,Token line offset = 5,Token in error = identity_insert ]Major Error 0x80004005, Minor Error 25004> insert into MyTable(id,name) values(2,'test')The column cannot be modified. [ Column name = id ]

t-mobile Wing

Bert Carles — Fri, 14 Mar 2008 11:57:59 GMT

Is anyone aware of the processor type you should select when installing to a T-Mobile Wing smartphone?

CE 3.0 replicated database just growing and growing and growing

hevansmailbox-sqlservercentral — Thu, 28 Feb 2008 08:06:07 GMT

Hello,I have a CE 3.0 based handheld (mobile device) that is replicated from a SQL Server 2005 server-side installation (sqlce30.repl.wce5.armv4i.CAB and sqlce30.wce5.armv4i.CAB). Everything is fine until an intermittent problem arises. The CE database on the handheld just keeps growing and growing and growing until the device runs out of memory.I thought it was a delete issue with deletes being replicated down to the handheld which were not being deleted. However, deletes on the CE mark rows as deleted which can be reused by the handheld's database. Therefore, if the db was growing out of control in this case, we would see it grow and then not grow for a period of time (when the deleted rows are reused, assuming there are a lot of deletes) and then grow again. However, I am seeing it just start to grow out of control and it keeps growing until no memory is left, there are no non-growth pauses.I've read online that it may be an issue with left joins causing tempdb to grow out of control, but our CE code doesn't use any left joins (just inner joins).A temporary fix of compacting the database has been suggested to reclaim any deleted rows; however, that is not a long term solution. It just means a device would take longer to crash. I need to find out what the underlying issue is and fix it.Has anybody seen similar behaviour?Perhaps it is a bug in the replication drivers for 3.0?Any help would be great.

How can i determine if a table exists in SqlCE?

noname — Mon, 12 Nov 2007 03:51:26 GMT

i want to check if there is a table named 'Table1' in SqlCE file on my device.how can i check it?thanx...

TOP 10 Distinct rows

jacobneroth — Wed, 05 Dec 2007 08:01:30 GMT

Hi guys,So here is my problem I have a view which has two columns named CNO and SNOit goes likeCNO | SNO63 163 163 263 263 3... ...46 11... ...56 2063 21Now basically what i want to do is that i need to get the top 10 distinct CNO numbers from this view.I am a novice to T-sql so i am not sure how to do this. Could anyone help me out on the same.ThanksJacob

RDA SSL Error

gsquaredcc — Wed, 13 Feb 2008 06:43:07 GMT

We are developing an application and on RDA pulls that exceed approximately 500KB or more we receive the (A Secure Sockets Layer (SSL) connection is required to access this site.) error. Why is this error occuring and why only on larger files sizes? I have read that transitioning to SSL will correct this problem, but that creates a problem for me. We do not wish to have a DNS entry for this site and the application communicates via IP address and a specific port. Since VeriSign will not issue a certificate to an IP based solution and requires a domain; what is my work-around?Is it IIS throwing the error or is it the local SQL mobile? Is there a solid work-around or fix for this problem?Any assistance is greatly appreciated.

problem in installing sql server 2005

sweetgunjan333 — Fri, 08 Feb 2008 03:20:59 GMT

hi.im facing this problem when im installing sql server 2005...i dnt know what to do..so please help me if u know...problem is---"the drop location is missing file that allow setup to determine how a multi instance product should be installed.setup cannot continue please repair the drop and try again"when these lines comes the whole installation process ends automatically...

stored procedure Date/Time last accessed

Kurt W. Zimmerman — Tue, 27 Nov 2007 11:22:24 GMT

Greetings all and thanks for reading my post. I am trying to find a way to determine when the last date/time a stored procedure has been executed. I am dealing with a VLD and really can't afford to have profiler constantly running.Is there a table that I can query that would provide me this information?Thanks in advance.Kurt W. ZimmermanDBARHWI, Inc.Poughkeepsie, NY

loading data from Oracle

Chander — Thu, 29 Nov 2007 05:03:33 GMT

Hi,I'm trying to automate the data loading process in sqlserver. The source database is Oracle(9.2) where EPOCH time is being used. The target database (host) is SQLServer(7). The data is loaded through DTS package which is run manually once a week. The 'data to be loaded' is filtered in the where clause in the DTS package where the date range is manually changed before each run.Script in the DTS Package(in SQLServer) to extract the data from Oracle:[i][font="Arial"]SELECT "Username", "Company Name", "Assigned to", "Case ID", "Case Type", "Create Date", "Status", "Submitter", "Product Group", "Product Type", "DSL Phone number" , "Priority","ASAM Port"FROM "CO:Helpdesk" CO_HelpdeskWHERE ("Create Date" > {ts '2007-11-20 22:15:22.000'})[/font][/i]My Objective is to automate this process by fixing the option manually changing the date range. To do this I'm not able to fetch the "EPOCH" version of "SYSDATE" in oracle.I tried number of option like below but its failing at the parse stage:[i]WHERE ("Create Date" = CURRENT_TIMESTAMP)[/i]Please help me out on this.(Its the remedy database in Oracle)regardsChander

Load Sql Server ?

titmael — Sat, 02 Feb 2008 04:49:47 GMT

hello everybody,my probleme is easy. i have a pocket pc and i downloaded sql serveur 2005 compact edition on the site of microsoft.i was installing the three cab Microsoft SQL Server 2005\Device\Mobile\v3.0\wce400\armv4the pocket Pc is a Win Mobile 2005. the query analyser works. i was download a jdbc for sql serveur but i dont resolve how use it. my error is The TCP/IP connection to the host has failed (etc)please help methanks, a french geek! :hehe:

CLSID for SQL SERVER CE 3.5?

MexiCano — Fri, 23 Nov 2007 17:01:19 GMT

Hello all i need helpi have the CLSID for SQL CE 2.0 and SQL CE 3.0, now i want test the SQL CE 3.5 but i need the CLSID CLSID_SQLSERVERCE_2_0 = {0x76A85B2E,0x9DE0,0x4ded,{0x8E,0x69,0x4D,0xEF,0xDB,0x9C,0x09,0x17}}; CLSID_SQLSERVERCE_3_0 = {0x32ce2952, 0x2585, 0x49a6, {0xae, 0xff, 0x17, 0x32, 0x7, 0x6c, 0x29, 0x45}}; CLSID_SQLSERVERCE_3_5 = ?????? thanks

to create ldf file from an mdf file

megha.chauhan — Fri, 07 Dec 2007 03:58:51 GMT

in a sqlserver database 2005 suppose we dnt have or we lost an ldf file then how to create an ldf file i.e. log file from an existing .mdf file .

Compare tables

joe joe — Wed, 07 Nov 2007 04:02:12 GMT

Hi There, I am using Except to compare two tables with the same structure like this,Select * From TableAExceptSelect * From TableBThis gives me all the distinct rows from tableA not in tableB. But now I want to know exactly what the difference is? For exampleTableA has a row like this,StreetNo HouseNumberFrom HouseNumberTo EqualUnequal TimeStamp DistrictNo DistrictName 5989 075 7 U 2005-01-02 14:18:00.000 89 Downtown WestWhich is not in TableB, but TableB has "allmost" the same record, besides a new timestamp and a new DistrictName (for ex. Downtown W.)How do I put together a PrimaryKey consisting of all variables (including a TimeStamp)? And can I use Except to make a Query listing the exact changes with this PrimaryKey?My primary goal is to find the changes between the two tables. The tables are identical tables, TableB is just one month older than TableA. If there is no changes in a row, then the row keeps the original timestamp. I need both small changes (new districtname) and bigger changes like completely new rows or rows not exsisting any more.Regards Joejoe

how can i login to my db via storedprocedure?

noname — Tue, 20 Nov 2007 03:10:52 GMT

hi all.i have a database on sql2005 and a login storedprocedure.i have a login form on my wince device. i use vs2005, vbnet.i want to check the user with stored proc.sp has 2 parameters, uname and upwd. it returns a record if login succeds.how can i use my strored procedure from winCE device? should i first use Pull method from SQL2005 then, write SELECT query on my device?please write some code in vbnet...thanx...

is there any way to get results from SQLServer to SqlCE?

noname — Mon, 12 Nov 2007 04:04:44 GMT

I have a database on a sql2000, i want to get some records from sql2000 to my pocketpc device.i created a sqlce file on my device.i use rda in vb.NET language, i know Pull method to get data to my device.but i just want to get a record from sql2000 then my code will continue...sql is : "SELECT Count(id) FROM table1" or returning scalar result querys.how can i do it not using pull method?is there a way to get records from sql2000 without creating a pulled table on my device?thanx...

Temporary tables

sdjuricic — Fri, 02 Nov 2007 16:20:31 GMT

Hello,I have a java application that is running on Oracle and we would like to port it to sql server 2000.In oracle we are using global temporary tables with an option to delete all rows on commit. I saw that sql server has a similar concept of local temporary tables but it doesn't seem to have an option to delete on commit. The local temporary table is visible per connection but since we do not close connection, a connection can be associated with more than a single java session. The local temporary table in sql server gets dropped when the connection is closed. What is the best way for me to mimic Oracle's global temporary tables with delete on commit;Thank you

import table and data in compact edition

am — Tue, 26 Jun 2007 13:53:00 GMT

Guys,

Is there anyway we can import data into sql server 2005 compact edition.

Any inputs/suggestions would help

Thanks

Importing Data from Excel file to SQL Compact Edition Database

Jenson — Fri, 29 Jun 2007 01:53:00 GMT

Hi Guys,

I'm trying ways to import data from excel file into SDF database (SQL 2005 Compact Edition) and insert the data into respective table and column.

Any idea how should I achieve that? Has any of you done that before? Would appreciate any kind of helps offered.

Thanks.

Regards,
Jenson

How move tables and data from SQL 2005 Express to SQL 2005 CE

Clark Sann — Tue, 22 May 2007 06:34:00 GMT

Hello

I am not an experienced SQL Server user and I am struggling with transferring tables and data from SQL Express to SQL CE. So far I've succeeded in using Management Studio Express to create a script to export the structure of a table from Express. I've also succeeded in modifying the script so that I can run it and create the new table in CE. I had to modify the Constraints a lot. I hope the limitations of CE don't make my DB useless in CE. Anyway, the bigger problem at the moment is how do I get the data?

Should I try replication? Replication seems to require a web server, which I do not have. I have my SQL Express files and my SQL CE files on the same desktop.

I hope someone can give me some help. Thank you in advance.

Clark

sql server

pspuwar78 — Sun, 21 Oct 2007 15:56:24 GMT

I Want to practise SQL query At Home, I Want to download SQL server and whole on Windows Vista, i have tried to download from microsoft sql server home edition but was not able to work,query analyser never works on login, can you please tellme from where i should download SQL Server and Query Analyser AND HOW TO GET CONNECTIVITY Which is the biggest problem please help me.

.....Learning...SQL....Please help

El Masry — Wed, 22 Aug 2007 22:53:00 GMT

I would like to learn, but I know that the best way for me to master it, is to have the software with the book / manual infront of me, and keep practicing.

I can not afford to go to school, time wise and financialy

Is there a book tutorial with CD kind of thing to learn?

Your help is greatly appreciated.

SA Password - Stored Procedures

David Kilmartin — Thu, 23 Aug 2007 05:58:00 GMT

After installing Compact Edition - how can I change the sa password.

Also:

Is there a workaround for the fact that CE does not support stored procedures.

How How Can v Connect Pocket PC with Database other than SQLCE..

Mohamed — Mon, 25 Jun 2007 22:45:00 GMT

Hi....

I m software Developer, here by i had a doubt that how can v connect the pocket PC(C#.NET) with Database SQL SERVER other than SQLCE.. Is there any alternate way for connection...

ERROR - header information is either corrupted or missing

adamcrv — Sun, 22 Oct 2006 18:30:00 GMT

Hi,

This error plagued me for a while and i thought i would share my solution of how i fixed it. Googling doesnt bring up too much of a result for it so i thought this would be helpful.

the error is "header information is either corrupted or missing"

and it occurs (well for me anyway) when a program running in cf.net 1.1 is running and trying to connect to a SQLServer 2005 Database for replication (in my case merge).

I tried just installing the .net cf to 2.0 to the device and the sql ce replication components to 3.0 but to no avail.

The solution for me was to upgrade my project from CF.net 1.1 (1.05xxx) up to compact framework 2.0 . Which i did through Visual Studio 2005.

I think this is because the program when compiled in CF.net 1.1 is still trying to connect to a SQLce 2.0 dll etc and as such upgrading the project makes ur program upgraded to SQLCE 3.0 and communicate properly with the SQLCE 3.0 dll on your replication website..

I hope this helps any one else who might be having an issue with this..

Please feel free to comment or correct me if im wrong in my assumptions here.

Cheers

Adam

NChar and NVarChar data size and .Net

Chris Chilvers — Mon, 21 May 2007 10:25:00 GMT

I'm using Sql CE on the Pocket PC, and BOL says the maximum size for NChar and NVarChar is 4000 characters.

However, SqlCeParameter.Size appears to limit the size to 255. This causes the statment to error due to the data being truncated.

Setting the size to 0 makes this work, the database does handle the column correctly.

So is this a bug in .Net, or is there an update that fixes this behaviour?

SQL Compact problems

William Pedersen — Thu, 04 Jan 2007 02:11:00 GMT

Has anyone tried to use the new SQL Server Compact version?

I am considering using this in a new project, but during my testing I run into the weirdest errors.

I don't want to use the specialized SqlCeConnection,but OleDbConnection so the application supports any database (theoretically).

I cannot get it to work with datasets though. In my small testapp, I can create tables, insert data and get data with raw sql sentences and OleDbCommands. But when I try to use a Dataset with DataAdapters, then I receive weird errors like:

[CODE]
System.Data.OleDb.OleDbException was caught
Message="The given type name was unrecognized. [,,,,,]"
Source="Microsoft SQL Server 2005 Everywhere Edition OLE DB Provider"
ErrorCode=-2147217872
[/CODE]

[CODE]
"Multi-step OleDb operation generated errors. Check each OLE DB status value, if available. No work was done."
[/CODE]

Everything works perfectly with Access and SQL Server.

[Ask]how to set subscriber priority in merge replication

Aldrich Farrel Saputra — Fri, 16 Mar 2007 02:35:00 GMT

dear all,
anyone can help me pls, i need to set my subscription (in sql mobile) priority higher than the publisher (running on SQL Server 2000) in order to wins all the conflicts. so any update made by publisher will be replaced by subcriber.

how can i do that?

regards,
Aldrich

Problem in connecting SQL CE Database

Lillian Bose — Thu, 08 Mar 2007 05:14:00 GMT

Dear All,

Im new to SQL CE 2.0 DB.

We decided to go with MS SQL CE for the DB development for our Project which should work in the Hand Held Terminal devices.

We have developed our application using C++ in eVc++ environment ( CE 3.0) and from this application only we need to connect to the SQL CE DB and to manipulate the data.

So we need some guidance or some sample applications on how we could achieve the above mentioned. We searched in the Net and could not find any data.

We need to know how to establish a connection to the DB using the application.
Using that connection reference we need to access tables etc,
If you have any idea on this kindly share it with us.
Also while searching we obtained some links
We used the sample code available in the MSDN link

http://msdn2.microsoft.com/en-us/library/aa237914(SQL.80).aspx

But when we compiled we were able to compile without any errors after including the necessary header and library files.
When we tried to execute the program we were facing some problem with the following line
hr = CoCreateInstance( CLSID_SQLSERVERCE_2_0, 0, CLSCTX_INPROC_SERVER,IID_IDBDataSourceAdmin, (void**)& pIDBDataSourceAdmin);
In your posting we found that you were also facing the same problem at that time, so if you could help us in this regard , then it would be very useful fro us.

We are using SQL CE 2.0
EVC 3.0
PocketPC emulator

Breaking/Striping Password in a mobile SQL Server 2005 Database(SDF)

allan audi — Fri, 26 Jan 2007 02:33:00 GMT

I am currenlty using mobile server 2005 (sdf) and a Dot Net framework front end on my PDA. SDF file has a password which i cant remember. I would therefore request anybody out there who can help break/strip the password. My whole months data is stuck in the database and i need to download it. thanks.