sounds like yet another outsourcing to India to save money

i typically use a char(1) with a check constraint to allow only two values:

ie ALTER TABLE BLAH ADD GENDER CHAR(1) NULL CHECK (GENDER='M' OR GENDER='F')

I've seen this error in ADO when you stick a string into a varchar that is smaller than the string...ie sticka  30 character string into a varchar(20), and the ADO...

The magic tables are the virtual tables available in a trigger:

ie the [INSERTED] and [DELETED] tables, which can be referenced within a trigger so that you can add additional logic...

i would do this with three tables: as new/differet items are added, if they cannot use an existing attribute to describe them, it is added to the lookup table.

A similar...

could you have an uncommitted transaction that was created during testing, but never committed or rolled back?

in a nutshell, yes; you can change anything dynamically.

see sp_dboption in the BOL; also look in master and look at any of the stored frocs that start with sp_db or...

while the table definition doesn't allow variables, the DBCC command to change the starting value does:

declare @C1 int

set @c1=99

create table #sometable(id1 int IDENTITY(1, 1))

DBCC CHECKIDENT( [#sometable],RESEED,@c1)

this might help: i believe that error  Operating system error 21(The device is not ready.) encountered. means that the path to the device(in this case a log file) does not...

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...