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

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?