.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

How does sql server store passwords?

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
 
I was asked today about how sql server stores pswds, which algorithm it uses & so on (i found its hashed & so on in syslogins). I could not find much from BOL. I would appreciate if someone has BOL / other links for sql 2008/5/0.


View Complete Post


More Related Resource Links

SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices

  

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


Store Null Data In image datatype in sql server 2005

  

hi

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.


regards


VB.NET - store HTML code in SQL Server

  

Hey guys/gals!!

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? 


Thanks everyone!


How to store Marathi Character in SQL server?

  

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?

 


How to store only date and only time into sql server 2008 from C# asp.net 3.5

  

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,

Arvind Pathak


Decrypt the encrypted store procedure through the T-SQL programming in SQL Server 2005

  

HI ,

 

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  in advance.


" Education is the beginning of transformation. Dedicate yourself to daily learning via Blogs/Forums/books and coaching "
Click here to read my blog

Unable to set up a new Secure Store Service Application in a single-server installation

  

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 2005

  

Hi all,

 

how to store query string in sql server 20005 


SQL Server 2005 store procedure performance issue

  

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!!!

 

 

 


How to store binary (file) in SQL server using Entity Framework?

  

Hi,

 

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#?

 

Thanks,

G


I'm not a development! I'm an infrastructure engineer! Please be patient on the development forums! :)

How to store binary (file) in SQL server using Entity Framework?

  

Hi,

 

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#?

 

Thanks,

G


I'm not a development! I'm an infrastructure engineer! Please be patient on the development forums! :)

In what certificate store should we put server's certificates?

  
hi

 

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

Hijri Date Time store in SQL server DB

  

Hello

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.

Thanx,,

: )

 


Store Procedure conversion to sql server 2000

  

Hi all,

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 Cry

thanks in advance


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


ALTER 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
------------------------------------------------------------------------------
AS
BEGIN

declare @SRO int

print @SROLogin

select @SRO= srocode
from sromaster
where ShortNameE=@SROLogin

print @SRO

SQL Server 2005 - How to Call One Store Proc from Other Store Proc ?

  

Hi ,

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 ?

 

Thanks.


Storage system for SSIS packages(SQL Server , File System, SSIS package store)

  

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?


Happy to help! Thanks. Regards and good Wishes, Deepak.

How to upload a file to web server in asp.net and store file path into database table?

  
This article describe how to upload a file into web server folder using asp.net file upload control and store the file information into sql server database.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend