if you're confident about the state of the data, I'd test without indexes in the destination table. applying indexes to each insert/delete row adds overhead to the process. then have...

users typically only submit m/d/yyyy. SQL Server stores time as well. So, i create the date string equalizing the time then query

Create Proc p_Orders_GetByDateRange

(

    @StartDate DATETIME

   ,@EndDate DATETIME)

AS

DECLARE @NewStartDate DATETIME

DECLARE @NewEndDate...

It looks as though Remi's answer may be correct. ASP is late bound and dosen't know about the ADO constants unless you are including adovbs.inc OR added the ADO typlibe...

use Request.Cookies("CaseSensaTiveCookieName") to read it in.

use Response.Cookies("CaseSensativeCookieName") to write it back out after a successfull login.

--In SQL

open the table in design view and change the collation for the password collumn...

it was setup when the connection was first defined. When EM was first registering it's connection to SQL Server, it was defined then. It's at that time that you could...

see the 'sp_OACREATE()' system stored procedure. this allows you to call COM api's.

There are also 2 techniques:

1.  either you register it with COM(regsvr32)

2. or you install it in...

the docs at MS are wrong. You CAN'T install MSDE as a default instance...

does xp_sendmail require admin privaledges?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_6hbg.asp

(watch for wrapping)