see http://www.sqlservercentral.com/scripts/contributions/610.asp for the stored procs:

create table ExampleTbl(Operator int , Password varchar(40) , AR varchar(40) )

insert into ExampleTbl(operator,password,ar) values (1,dbo.RC4('realpass','seedstring'),'x')

select Operator,dbo.RC4(password,'seedstring'),ar from ExampleTbl where Operator=1

select Operator,dbo.RC4(password,'wrongstring'),ar from ExampleTbl where...

i'd like to see the code of the job step, but i bet this will get you going in the right direction:

Perform an action when a file exisits

That's the...

either access the page via http://localhost to see the real .NET error, or do exactly what the error message tells you to do...change web.config to have customErrors mode="Off"

when customErrors...

cant you just check for the existance of the file, or that the filesize is > 8 bytes or something before PKZIP is called?

if the file doesn't exist or meet...

i believe the extended property in question is getting CONVERTed into a varchar field with no definition.

if you cast/convert something as a varchar without a size, it defaults to a...

i would have a separate table that has a reference to the InventoryMaster Table and the Category table; I'm awful sure going down the road, you will have multiple items...

Wherever possible, the backup should have all the data required; ie all lookup tables for static drop down lists such as "status" and "state" and whatnot are in the backup.

I...

yes; a SQL Server backup is the equivilent of a dump file; the differences are it restores much faster than a dump, and it is really binary in nature; opening...

the best answer is to create a backup of the database, and restore the database, instead of trying to script it out.

I don't think you can script out a TEXT,...

if you pass zero to a date time field, it is a valid date. that date is 1900-01-01 00:00:00.000 of course, so i think your foxpro database has zeros for...

use this script from the contributions, and change the where xtype='U'

to be where xtype in('U' ,'V')

http://www.sqlservercentral.com/scripts/contributions/759.asp

that will give you tables and views in dependancy order, which is the...

which user did you create? rep_process or rep_user?

did you create only one but both need to exist?

if it's a test database, you should be able to get another copy from production, right? you do have access to backups, right?

if not, your only hope is that you...

someone recently had trouble with FT where a very vanilla statement no loner worked, but worked on other servers with same data/config.

reinstalling all the patches did the trick;

at a minimum,...

i was wondering how this new guy was beeting Remi to the punch/post; must be that Remi-bot we heard so much about.

Seriosuly, thanks...