Re: Insert Date and Time in SQL Server 2000 using ASP

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 06:50:54 -0500

Robin Lawrie wrote:
> Thanks again for your help Bob, it is very much appreciated!
>
> I'm new to SQL Server and am trying to develop a web application. I
> don't know if my hosting company allows stored procedures to be
> created on their shared SQL Server hosting plan but I will ask. If
> so, I'll look into using stored procedures if the hosting company
> offers it (and if they do offer it you can be sure of new posts to
> this newsgroup!)
Here is my canned reply for running stored procedures from ASP:
http://tinyurl.com/jyy0

Bob Barrows 

-- 
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Relevant Pages

  • Re: Insert Date and Time in SQL Server 2000 using ASP
    ... > Thanks again for your help Bob, ... > I'm new to SQL Server and am trying to develop a web application. ... I'll look into using stored procedures if the hosting company ...
    (microsoft.public.inetserver.asp.db)
  • Re: Insert Date and Time in SQL Server 2000 using ASP
    ... Thanks again for your help Bob, ... I'm new to SQL Server and am trying to develop a web application. ... stored procedures if the hosting company offers it (and if they do offer it ... > cn.proc_name cmdLoginDate, cmdLoginTime, cmdUsername ...
    (microsoft.public.inetserver.asp.db)
  • Re: Insert Date and Time in SQL Server 2000 using ASP
    ... Thanks again for your help Bob, ... I'm new to SQL Server and am trying to develop a web application. ... stored procedures if the hosting company offers it (and if they do offer it ... > cn.proc_name cmdLoginDate, cmdLoginTime, cmdUsername ...
    (microsoft.public.inetserver.asp.general)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Securing Stored Procedures from being seen
    ... username, but in SQL Server, there are too many users to map an individuals ... granting the group execute permissions. ... but I would have to know what groups the user belongs ... see the names of any stored procedures to which he has no rights. ...
    (microsoft.public.sqlserver.security)