assuming you are using asp and not .net, because you were referencing Request.Form, i think you could use something like this to get your recordset of values.

you still have to...

for those of you who are too cheap to buy and register winzip(command line winzip is not free, i beleive)

you can use PKZIP25.exe, which is the last free command line...

I've done something very similar; the difference in mine is that it assumes  specific paths, which you would have to change or paramiterize (sp?);

it is adapted from a backup...

I think i see where the question resides.

the interface for RS IS web pages....there is no .exe program like sqlserver.exe to call. There is no client side application to install.

i...

you could also use the SPLIT function off of this web site; it returns a @table of data,; for example

select * from dbo.split('x10\210\63\1\10\J-type\4/...','\')

returns:

strval                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           ------

x10

210

63

1

10

J-type

4/...

i would imagine from there you...

Reporting Services requires IIS, because all access to the reports are web based;  any of the drill down reports are web pages that link to the detail views, so with...

Can i ask what was your source for the ZIP+4 database? I've only found ZIP databases, or items like the PLACENAME database with zipcodes from the census, but cannot seem...

all error messages are in master.dbo.sysmessages i believe;

so you'd select @err=@@error in your proc, then

select description from master.dbo.sysmessages where error=@err

if the severity was such that a run time...

Sara thanks for the input;

your suggestions showed me that in my real world sample database, your script found ten more tables, and their table counts, than mine did;

i just...

this is from the middle of a loop which joined sysobjects and syscolumns....

i've basically done what you are doing now...scripting out the table definition, complete with defaults, contraints etc.

I stick...

For a .NET application, you can start with some of the built in encryption methods from the framework;

http://www.codeproject.com/dotnet/SimpleEncryption.asp

has a handful of examples using it, as well as comments as...

I've done this for several different reasons... but it is basically the same...munge existing data to be unreleated to real client data.

i've got a database of animal names, colors, and...

for reference, I like to put a check constraint for a datetime which sets a minimum value...the reason is a date of zero is a valid date (01/01/1900 00:00:00)

for example...

someone's contribution to the site, almost identical to Frnaks suggestion, but i probably renamed it to be convenient to my naming convention:

create procedure sp__CountTableRows

as

begin

 SELECT sysobjects.name, sysindexes.[rows]

 FROM sysobjects 

  INNER JOIN

  sysindexes 

 ON  sysobjects.id =...

Our office does the same...we have a vb dll for older apps and a vb.net dll for the web and winforms to use, both of which have a variety of...