You're not alone... same thing happens to me. In fact, I wanted to post a question regarding it but obviously couldn't! I didn't know about the "no WYSIWYG"...

Depending on what type of admin access you have to the web server and accompanying hardware, this is probably easier done by using a router access control list or by...

Just FYI... the latest issue of Consumer Reports has a good review of cell phone devices and services.  Me, I'm still using my cheapo Audiovox from 2000 with my Sprint...

Not sure what the limits of your requirements are, but if it could possibly pertain to your situation, don't forget to take URLs starting with "https://" into account...

I am certainly no Agent or job expert, but you might want to check out modifying the job using SQL-DMO and the job-related objects.  You should be able to create...

You will need to upload the Excel file to the server before processing it.  Web browser security will most likely prevent you from accessing a file on the client thru...

If the logic of determining the agents/subagents gets too complicated for the actual stored procedure, consider packaging it in a user-defined function which takes in a master agent ID and...

OK, I definitely follow.  I guess I just got wrapped around the fact that my apps rarely use user-entered data for queries like this.  When I do INSERTs, UPDATEs, DELETEs,...

OK, how about this...

Dim cmd as New ADODB.Command

Dim rs as ADODB.Recordset

With cmd

     .ActiveConnection = WScnn

     .CommandType = adCmdStoredProc

     .CommandText = "usp_Test"

     .Parameters("@UserID") = valueForParam

     Set rs = .Execute

End With

valOfParam =...

I've been using SS2K for a while now as a document repository with no problems.  One DB has 1800 documents (PDF, Word, etc) totaling 4.5GB and another is storing 52,000...

Maybe I'm missing something here, but shouldn't it be a lot easier than this?  If the SP truly has one parameter and returns a single row with a single column,...

Keep in mind that the ASP Session ID isn't a unique value.  When the web server gets restarted, the session IDs reset.  Using this val for auditing purposes probably isn't...

Rather than "SELECT *" I would think you'd want to limit this to only what you need, something like "SELECT BarCode..." since, if I'm not mistaken, "SELECT *" adds overhead.  UNION...

Why not add "language" to your PK?  Table could be like:

FLD (PK): ID

FLD (PK): Language

FLD:  TextValue

Then you'd have records like

A - English - English Text A

A - French - French...

Here's how I do it...

Table structure:

FileID         uniqueidentifier

FileNM         varchar(255)

SizeDM         bigint

ContentTypeID  varchar(100)

UploadDT       smalldatetime 4 0

ContentBD      image     -- FYI, BD stands for binary data

ExtensionCD    varchar(10)  --> computed column, formula is ([dbo].[fnFileExtension]([FileNM]))

Stored procedures:

CREATE PROCEDURE dbo.procFile_ADD

  ...