SQL Server Paging / Alert Call To A Mobile Phone
Dec 13, 2000Hi
I am trying to setup alert msg. on my mobile phone when sql task fails
Has any body done this before????? Any sugessitions????
Thanks
Vijay
ADVERTISEMENT
Sms To Mobile Phone Using SQL Server
Apr 25, 2007hello every one
any body please help me how to send SMS through SQL SERVER to mobile phone and how to schedule using sql to send automatically.
Sms To Mobile Phone
Apr 26, 2007hai,
how can i send sms through web page(without using web service) to mobile phone using SQL server 2005
Developing Database For Mobile Phone
Mar 9, 2008Hi,
I am developing a Translator for a mobile phone and I am using MS SQL server 2005 for creating my database.. I am having a problem in creating a relationship between my tables.. I have the following tables:
English(engcode,engword) - engcode is primary key
Esperanto (espcode, espword) - espcode is promary key
EngEsp (engcode,espcode)..
The problem is that the icon "relationship" is disable in sql 2005 and i am nt able 2 create the relationship..
Any Suggestions??? Please help me..
CASE Function Home Phone Work Phone Cell Phone
May 8, 2008
Hi,
I'm trying to create a case function for home phone ,work phone and cell phone. The thing is some of the home phone numbers either null, zero or less than 10 digits then i'd like to get either cell phone or work phone if they are not null, zero or less than 10 digits.
I'd appreciate it if you could help me on this?
Thanks in advance.
SQLce / WM5 Phone Edition (T-Mobile MDA) / Storage Card
Jul 29, 2007I have built an application for storing my flight times on my phone after each leg of a trip... I am using C# and Sql CE as the storage system for later export to a larger desktop version (in the works). My question is related to storing the sdf file on the storage card. Can it be done and what would the connection string look like since I have tried and got a error stating it can't find the sdf file in question. I have it setup right where if I were to do a fresh install it would ask for the install directory main memory or storage card. If I select storage card it installs just fine but when I run the app it does fail with the aforementioned error..
Storage Card is 2 gigs..
Thanks
Morgan Vermef
A Call To SQL Server Reconciler Failed. Sql Mobile, BusinessLogicModule
Jun 16, 2006I got a merge replication published by my SQL Server 2005 and subscribed by my Pocket PC emulator having SQL Mobile. This works fine.
I've now developed my own class to handle my business logic according to MS specifications. Inherits from BusinessLogicModule in Microsoft.SqlServer.Replication.BusinessLogicSupport.
I had by using the sp_registercustomresolver and sp_changemergearticle.
When I now try to synchronize from the emulator I get the error
Message: "A call to SQL Server Reconciler failed."
Native Error: 29006
Source: Microsoft SQL Server 2005 Mobile Edition
Any ideas what has happened?
I also tryed to run the class in debug with my mobile app but same thing happens and it happens before any of my code runs.
SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call
Sep 5, 2005Hi All,
View 14 Replies View RelatedA Call To SQL Server Reconciler Failed. SQL Server 2005, SQL Server Mobile Merge Replication
Oct 2, 2005Hi,
View 36 Replies View RelatedSQL Server Mobile Merge Replication Walkthrough, Cant Find The .NET Framework Data Provider For SQL Server Mobile Edition.
Sep 9, 2005Hi,
View 3 Replies View RelatedSQL Server Mobile 2005 Merge Replication Problem On Windows Mobile 5.0
Aug 8, 2006
Dear ppl,
I am writing an application for a device (MDA Pro T-Mobile) having Windows Mobile 5.0 using
-MS .NET Compact Framework 2.0 SP-1
-SQL Mobile 2005.
-VS 2005 .NET
The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.
"SQL Server Mobile encountered problems when opening the database."
repl.AddSubscription(AddOption.CreateDatabase);
repl.Synchronize();
I don't understand why I am having this error. It does create the database on AddSubscription() method but it is failing opening the database on Synchronise(). I have also tried uninstalling and then reinstalling all the SQL Mobile components in the following order.
-sqlce30.wce5.armv4i.cab
-sqlce30.repl.wce5.armv4i.cab
-sqlce30.dev.ENU.wce5.armv4i.cab
However, when i run this application on a device(Dell X50 AXIM) with Pocket PC 2003, it runs fine creating the database and sysnchronising it.
The target platform for the project is Windows Mobile 5.0 Pocket PC SDK.
Does any one have any clue what could be the problem ?
Regards
Nabeel
Problem Using SQL Server Mobile 2005 With Windows Mobile 5 Application
Mar 23, 2006Hello,
I am developping a non-managed C++ application for PocketPC using a SQL Server mobile database.
The application is compiled for PocketPC 2003 and uses SQL Server Mobile v2. I use Visual Studio 2005. But I need to compile the application for Windows Mobile 5.0 devices. So I installed the WM5 SDK and had the WM5 into my project configuration.
The "ssceoledb.h" which I include incluses the "transact.h" file. But my problem is that this file is only provided with the PocketPC 2003 SDK and not in the WM5 SDK.
So I cannot use the WM5 configuration project with SQL Server. I also tried with the last SQL Server Mobile 2005 (ie v3.0) and the "ssceoledb30.h" also includes "transact.h".
Did I miss something to install ?
Do you know how I can resolve the problem ?
By advance, thank you for any answer.
--
Gregoire
Cannot Build SQL Server Mobile Solution For Windows Mobile 5
May 18, 2006Using MS VS 2005 (incl SQL Server Mobile)
MS Pocket PC 2005 SDK
I am working on a project that builds for Pocket PC on both Mobile 2003 and Mobile 5. The project uses/will use SQL Server Mobile to store local data.
Project created from new with support for both platforms. I include required header files ssceerr30.h and ssceoledb30.h.
Project builds fine in WM2003 configuration, release and debug.
When I build for WM5 the compiler cannot find the header file transact.h. This is included from within ssceoledb30.h. Same as under WM2003.
In WM2003 configuration if I highlight the ssceoledb30.h include in Visual Studio and open the header, it takes me to <Visual Studio dir>SmartDevicesSDKSQL ServerMobilev3.0. I then locate the include for transact.h and do the same, which takes me <Visual Studio dir>SDKPocketPC2003include. The file exists.
If I repeat the above 'browsing' under the WM5 configuration, ssceoledb30.h takes me to a different copy in the WM5 SDK directory. There is no diff between the file here and the other copy used by WM2003. If I attempt to open transact.h - file does not exist.
Fix (which I'm not too sure about, i.e. is it OK?) - If I copy transact.h to the WM5 SDK directory, the project builds.
Why has transact.h disappeared from WM5 SDK?
I can find no ref's to this problem anywhere. Is my installation of the WM5 SDK corrupt? What else could I be missing?
Is there a sample for SQL Server mobile (like the NorthwindOLEDB sample) that comes configured to build for WM5?
SQL Server Mobile Tutorial And Getting Proper Mobile DB Installation
Apr 24, 2006Hi folks, I'm new to Windows Mobile progamming, and new to this forum. Apologies in advance if I'm asking a boneheaded question, but I've done searches and can't find anything directly applicable to my problem.
I'm currently walking through the published MS tutorial in setting up an SQL Server 2005 Mobile application that subscribes to a publication on SQL Server 2005 to exchange information.
I've gotten almost all the way through... successfully set up the server components, creating the publication, etc. On the mobile side, I've been able run the cab files to install the SQL Mobile components and to create the project, add the reference to the dll, and instantiate an engine object. It compiles.
The step in the tutorial after that, though, where you specify the data source from the "data" menu, I've got a problem. When I try to use the "new connection" dialog from choosing the data connection, "MS SQL Server Mobile Edition" doesn't show up as a choice. I've tried choosing any of the other combinations, and in teh subsequent "Connection properties" section my database, SQLMobile (as in their sample) is available, but I get an error when I choose it and click OK. Clicking on "Test Connection" gives me a connection successful message.
My guess is that something about the Mobile server side components is not installed correctly on my development machine, but honestly I have no idea how to begin to fix it. Has anyone seen this problem before and know how to resolve it?
Your time and any knowledge sharing is greatly appreciated.
Thank you,
-Dana
SQL Server 2005 Mobile Edition ANd SQL Server CE - SHould I Have Uninstalled Mobile First ?
Sep 16, 2007
Hi:
When I try and connecto to SQL CE I always get an invalid operation exception. I"m afraid that I did not follow the proper install for Orcas Beta 2. I can't remember if I was supposed to uninstall SQL Mobile 2005 first or not.
All I know is when I try and use my SQL CE I can't connecto to a DB / sdf file ?
Any help would be appreciated I"m just starting to use SQL CE.
thanks
mark
Creating A Mobile Application With SQL Server Mobile - FIX
Jul 21, 2006This is a great tutorial and it's a shame one of the more important steps was missed.
In the €œCreate the snapshot user€? section you you find the steps to create the snapshot_agent account. Then in the €œCreate the snapshot folder€? section you find the share and folder permissions. However, at no point do the instructions advise you about adding the snapshot_agent to the SQL Server Logins. The result is that agent cannot perform the initial snapshot but you won't find this out until 50 steps later after Step 10 in the section €œCreate a new subscription".
To get back on track, openthe Object Explorer's Security section and add the snapshot_agent to your logins. Then using the "User Mappings", set an appropriate level for the SQLMobile database role. Once completed you then need to run the agent.
Right-click the SQLMobile publication you created and select "View Snapshot Agent status". From that dialog you can select "Start" to run the agent. When it completes, you can return to the tutorial section "Create a new subscription" and continue with the tutorial.
Creating A Mobile Application With SQL Server Mobile
Nov 3, 2007I am studying the tutorial in SQL Server 2005 Mobile Edition Books Online, and the topic is Creating a Mobile Application with SQL Server Mobile. I have got a problem when creating a new subscription after created a new SQL Server Mobile database. And the problem is shown below:
New Subscription Wizard
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
* 無法完æˆ?作æ¥ã€‚
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
Before I have met this problem, I have finished all the task. And I can browse the localhost web site by using anonymous account even I use internet explorer or browse the directly in IIS.
Does anyone can solve it?? Thank you very much~~~
SQL Server 2014 :: How To Split Phone Number Based On Symbol Dynamically
Jul 16, 2015I would like to know how to split the phone number into two columns based on - symbol Dynamically.
for example
Phone Number
123-12323
1234-1222
so output should be
code number
123 12323
1234 1222
Paging In SQL Server
Aug 23, 2007
Hiii all
SQL Server 2000 or 2005 dose not support the LIMIT statement like mySQL. So plz can anyone tell me tht how to do paging in SQL Server?? Without using CLR Integration...
Paging - Sql Server CE
Mar 14, 2007Since Row_Number() is not available to SQL Server 2005 CE, are there any other alternatives for paging when querying the database?
Thanks.
CPU Utilization Alert Through WMI Alert
Aug 13, 2015Can you use the below query to get CPU high utilisation alert purposes for both named and default instance? or, do I need to make any changes here (@wmi_namespace=N'.ROOTCIMV2' ) ?
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @name=N'CPU_WM_Utilization_Check',
@message_id=0,
@severity=0,
[code]....
SQL Server Alert
May 11, 2004Hi folks! I have an alert that fires on error 208(Invalid object name '%.*ls'.)
Can i customize it to get some thing like in the Net-Send command:
(invalid object name '%.*ls'. executed by %user from %computername)
What my concern here is to customize the messages. The description option in the alert allows only static info to be added.
Howdy!
Paging Files For SQL Server 7
Mar 13, 2001Is it necessary (or perhaps just beneficial, if not necessary) to create a paging file on the drive where SQL Server is installed along with the paging file on the OS drive. For example, Windows NT 4 is installed on the C drive, and SQL Server is installed on the D drive. Should I have a paging file on both drives. Someone mentioned to me that you should have a paging file for both drives, but I had never heard of that before.
Tony
Sql Server 2000 Alert ..
Mar 18, 2002Hello Everyone,
Please help Newbie !!
I have a server where I have been getting
"SQL Alert Sev 24 : Fatal Error : Hardware Failure" for
the past week.
Occurence : We disconnected the workstation (which we are
using as SQL Server) from one floor and connected it to
another floor. No Configurations changed. No hardware
failures reported so far on the win 2000 box.
We are very well able to do the SQL development on that
box. Everything seems normal except I get this error sent
atleast once a day in the morning.
Regards,
Kurt
Follow are the Erros/Warnings in the Event log.
1)
The SNMP service is ignoring extension agent key
SOFTWAREMicrosoftDHCPMibAgentCurrentVersion
SOFTWAREMicrosoftWINSMibAgentCurrentVersion
SOFTWAREMicrosoftIASAgentCurrentVersion
SOFTWAREMicrosoftACSAgentCurrentVersion
because it is missing or misconfigured.
2)
Application popup. Service Control Manager : At least one
service or driver failed during
system startup. Use event viewer to examine the event log
for details.
3)
The site server ILS service service dependsd on the IIS
Admin Service which failed to start becasue of the
following error: The service cannot be started either
because it is disable or because it has no enabled devices
associated with it.
4)
The remote access connection manager service depends ont
eh Telephone service which failed to start because of the
following error: The service cannot be started, either
because it is disabled or because it has no enabled
devices associated with it.
5) Network Problem. The time service has not been able to synchronize with domain controller for a long time.
..
Sql Server Paging Script And Cursor?
Jun 22, 2005suppose from my code behind i will pass my sql query to sql server store procedure and i want that scriptwill be written in such a way that my store procedure will execute my query and populate cursor and then cursor will be return from my store procedure to code behind.so i want to know is it possible in sql server if so pls give me a sample sql server store procedure code.
View 1 Replies View RelatedDB Engine :: How Server Memory Paging Out
Nov 23, 2015Is there any easy way to detect SQL Server memory is getting paged out? Any DMV query or tips to confirm it is paging out.
My SQL Server Version is: Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64)
SQL Server Admin 2014 :: No Objects Listed For Server Performance Condition Alert
Jan 25, 2015We are trying to create some alerts in our SQL Server 2014 BI edition.Issue is that, after I chose "Type" as "SQL Server performance condition alert" nothing is listed in the "Object" list box.SQL Server event alerts are working. Issue is only with "SQL Server performance condition alert".
View 3 Replies View RelatedSQL Server Admin 2014 :: Database Mail Fails At Email Server Alert
Apr 23, 2015We recently had a problem with DB Mail. SQL jobs that sends an email succeeded but the email in the job fail to sent. There was a problem with the email server. The error is included. We fixed the problem with the email server. How can I get an alert when a DB Mail email fails send?
Date4/23/2015 10:01:06 AM
LogDatabase Mail (Database Mail Log)
Log ID5907
Process ID13204
Mail Item ID5702
Last Modified4/23/2015 10:01:06 AM
Last Modified Bysa
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-04-23T10:01:06). Exception Message: Cannot send mails to mail server. (Insufficient system storage. The server response was: 4.3.1 Unable to accept message because the server is out of disk space.).
)
SQL Mobile 2005 Replication - SQL Mobile DLL Could Not Be Loaded - Error 28559
Jun 15, 2006I am migrating a pocket PC application from VS 2003 to VS 2005 and a few weeks ago I hit the following problem when replicating
A SQL Mobile DLL could not be loaded. Reinstall SQL Mobile. [ DLL Name=sqlceca30.dll]
Scanning forums for help I saw that other people had had this problem and one
http://www.eggheadcafe.com/aspnet_answers/NETFrameworkCompactFramework/Feb2006/post25814466.asp
suggested that this problem could be circumvented by getting the replication object early and then continuously using the same object for subsequent replications.
I did this and it works a lot better now but ever so often I get another error which is
Native Error 28559 SQL Mobile encountered problems when opening the database
My only option at this point is to stop and start the application which cures the problem.
Need To Alert All Users To Exit Sql Server
Aug 2, 2001How do I configure the database so that it will send an alert to all users who are logged in and using SQL*Server, when I need them all to get out of the database ??? Or, what do I need to look up in the documentation ??? I have looked under SQL*Mail, but that doesn't look like it will work for what I am trying to do.
Any help you can give me will be greatly appreciated.
Thanks,
Nancy
Email Alert In SQL Server 2000
Mar 28, 2008It seems that in order to get an email alert from SQL Server 2000 I need Microsoft Outlook orMicrosoft Exchange client installed. Is there any other way to get an email alert (not net send) when a back up is finished? for example using a @hotmail.com account?
thanks
Paging Records On SQL Server Using Derived Tables
Jan 24, 2007I am using derived tables to Page data on the SQL Server side.I used this link as my mentor for doing paging on the SQLServerhttp://msdn2.microsoft.com/en-us/library/ms979197.aspxI wanted to use USER PAGING, thus I used the following code:CREATE PROCEDURE UserPaging(@currentPage int = 1, @pageSize int =1000)ASDECLARE @Out int, @rowsToRetrieve int, @SQLSTRING nvarchar(1000)SET @rowsToRetrieve = (@pageSize * @currentPage)SET NOCOUNT ONSET @SQLSTRING = N'selectCustomerID,CompanyName,ContactName,ContactTitle from( SELECT TOP '+ CAST(@pageSize as varchar(10)) +'CustomerId,CompanyName,ContactName,ContactTitle from( SELECT TOP ' + CAST(@rowsToRetrieve as varchar(10)) +'CustomerID,CompanyName,ContactName,ContactTitle FROM( SELECT TOP ' + CAST(@rowsToRetrieve as varchar(10)) +'CustomerID,CompanyName,ContactName,ContactTitle FROM Customers as T1ORDER BY contactname) AS T2 ORDER BY contactname DESC ) AS T3)As T4 ORDER BY contactname ASC'EXEC(@SQLSTRING)RETURNGOWhen I use this. Assume that the Total records returned by the SQLquery is 1198.Thus when I am on Page1 the above Stored Proc (SP) willreturn the first 1000 records.This works absolutely fine.Now I am on Page2, now I need to retrieve only the remaining 198records.But if I use the above SP, it will return the last 1000records.So to tweak this I used the following logic to set the@pagesize variable:Declare @PageCount intselect @PageCount = @TotalRows/@PageSizeif @currentPage @PageCount SET @PageSize = @TotalRows%@PageSizeSince I am on Page2 the above logic will set the PageSize to 198 andnot 1000.But when I use this logic, it takes forever for the SP toreturn the 198 records in a resultset.However if the TotalRows were = 1800, and thus the PageSize=800 orgreater, this SP returns the resultset quickly enough.Thus to get over this problem I had to use the other logic i.e. usingApplication Paging (i.e. first storing the entire result set into aTemp table, then retrieving only the required records for the PAGE)Can anyone suggest what is wrong with my user paging logic?????TIA...
View 1 Replies View RelatedPaging Query In Sql Server Compact Edition
Jul 26, 2007Hi,
I want to write query to implement paging in sql server ce 3.0. But it seems it does not support TOP or LIMIT keyword.
Can someone suggest alternative way to write a custom paging query in sql server ce 3.0.
Thanks,
van_03