View Complete Post
Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, synchronization, and connectivity issues, are discussed in this article. Topics such as making your data public, choosing the right type of replication, and handling errors are also covered.
Paul Yao and David Durant
MSDN Magazine June 2001
i wanted to store image in sqlserver database image field and i did. But now in some cases i want to store null value in that image field please let me know how to do this using file uploader.please give complete sample code.
Quick question - I want to allow someone to enter HTML markup in a control, and save the input exactly as entered.
I want people to put a minimum of 50 words, to maximum of 500, and be able to save the formatting of their text in SQL 2005 server database.
Also, I understand this is two questions, but how do I save metadata of an image file in the sql database? I mean, I get the gist of it, but how do I do it?
I am going to design a application having front end with VB.Net and Back end with SQL SERVER in. And I want the complete interface of that
application in marathi language.
when I enter the marathi character in data base and execute it, it shows "????????" like this.
What I do to enter and store the marathi character in Database?
Hi 2 all,
can anyone help me how to store only date into sql server 2008 from C# asp.net 3.5.
I want to store only date(like 26/05/1986) and only time (like 04:45:40 AM) into sql server 2008 .
I am using C# asp.net 3.5 as front end.But i am not getting how to convert datetime into only date and only time from front end application.
It should not be as a string from front end.it should be as a date type / time type.
I can not see only date or only time data type in VS 2008.
so please help me how to store only date or only time into sql server 2008 having only date or only time as a data type.
Thanks and Regards,
I have a encrypted store procedure in my production server .Right now I do not have the script now I want do some modification.
Please any one can help me to decrypt the store procedure it will be a great help for me.
For any suggestion thanks
Problem: after initial SharePoint installation, I tried to add the Secure Store Service Application under "Manager Services Applications". The process screen returns something like "The time job created. But failed to start in one or more
servers in the farm." Further investigation found that in the SQL Server, the secure service account was not added under the Login user accounts. The Secure_Store_Service_DB has been created, but not under the name of secure store
service account. In another word, the database was created but the action seems to be incomplete.
Background: this is a single server farm installation on Windows Server 2008 R2, SQL Server 2008 R2, with AD CS and AD DS, DNS roles enabled on the same box. The configuration task was running with the farm admin account which is also a domain
admin, and has dbcreator, securityadmin, and sysadmin roles in the SQL server.
how to store query string in sql server 20005
We are calling store procedure from vb.net client following are the observation.
1) sqlserver 2005 takes huge amount of time (more than 1 hour) to execute procedure. The procedure has select statement using join statement. (Generally this procedure executes and populate data in 5 seconds when it is called from .net client.)
2) If same procedure is executed from sql server management studio, procedure executes and populate data in 5 seconds (works as per expectation)
3) If we recompile procedure (i.e. open procedure in alter mode in management studio and click on execute button) , the procedure executes and populate data as per expectation.
4) This is intermittent issue on production machine. Most of the time procedure is executed and populate data as per expectation when called from vb.net client. But it does not give expected outout in some scenario. The frequency for occurring the issue
is once in 15 days and there is no pattern in which the issue is occurring.
Can any one help to resolve the issue.
Thanks in advance!!!
Sorry for the newbie question. I want to store files in SQL server. I searche a lot but didn't found what I could use. I'd like to use Entity Framework and C# in Visual Studio 2010. Could somebody help me with a code snippet or pointing me to a good howTo
where I could find and understand how to store files in SQL using Entity Framework 4 and C#?
Assume system S
owns a certificate C . The following quote suggests that if
C is to be used by S's
service apps to authenticate themselves to clients, then C
should be stored in LCS . But if
C is to be used by S's
client apps to authenticate themselves to a service, then C
should be stored inside CUS
" • The local computer store (LCS). This contains the certificates accessed by machine processes, such as ASP.NET. Use this location to store certificates that authenticate the server to clients.
• The current user store (CUS). Interactive applications typically pl
I have a problem and I searched a lot without any benefits
How can I store hijri date in datetime field in SQL server 2005
Is SQL server db support this?
And how can I deal with this problem and generate crystal report with hijri dates.
this my sp for sql server 2005. this query wont work on sql server 2000 because it doesnt support the XML
nw i want to convert this to sql server 2000 compatible
plz help me out guys....itz on deadline
my boss will kill me
thanks in advance
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER procedure [dbo].[spIncometaxInformation]-- @amount int, @fromdate datetime, @todate datetime, @Fromamount int, @ToAmount int, @Opertype char, @SROLogin varchar(max)-------------------------------------------------------------------------------- SP Name:= spIncometaxInformation-- Created By:= Desai Madam-- Modified By := Kiran Ghadge-- Modifiaction Reason:= For calculating IT based on optios ------------------------------------------------------------------------------ASBEGINdeclare @SRO intprint @SROLoginselect @SRO= srocode from sromaster where ShortNameE=@SROLoginprint @SRO
I have a Requirment, How can I called One Store Procedure from Other Store Procedure ?
After Calling to Other Store Proc, How can i Store that other Store Proc Result Sets in the Temp Table, So i can process in the Current Store Proc Result Sets ?
Hello SSIS experts,
I just wanted to confirm the difference between SQL Server storage and SSIS Package store for packages. As seen from the BIDS, the SQL Server list packages from msdb(point
to note is the folder MSDB is not visible here) and SSIS Package store(MSDB folder is visible) and the authentication is defaulted to Windows (disabled) from both the file system and msdb?
Just wanted to know if there are any other differences to be noted or request to let me know if there are any corrections to be madein my views?