Hi,

i use this :-

select @load_source = "'c:\temp\FlexKIDS'"

select @sqlstring = "RESTORE FILELISTONLY FROM DISK=" + @load_source

insert into #list_file exec (@sqlstring)

HTH

Paul

the error indicates database corruption.

see error 605 in BOL .

HTH

Paul

fooled me too !

hi, glad to be of help, I use things like this quite frequently, well worth remembering.

Paul

hi,

i think this will do the job :-

create table cust_names

(cust_id int, surname varchar(20), forename varchar(20))

insert into cust_names values(1,"Smith", "Brian")

insert into cust_names values (2, "Smith", "John")

insert into cust_names values (3,...

hi,

the range for smalldatetime is January 1, 1900 through June 6, 2079. if your dates are out of this range then this may be what is causing...

i too have tried to re-install and i still have the same problem. there doesn't seem to be a pattern to it at all, and it's very annoying !

datediff returns and integer , regardless of which datepart selected. This is why avg works. This is much neater than extracting it from a string !

Paul

hi,

what you need to do is to use substring and charindex to get values for hours, minutes and seconds, and convert the value into a total of seconds,...

hi,

is that hh:mm:ss ? or something different ?

Paul

hi,

does the varchar(20) field contain a datetime ? or is the difference measured in seconds or minutes or days etc?

Paul

thanks for that frank. something i'd missed.

at least I've learned something today, so the day hasn't been wasted 🙂

Paul

hi,

syslockinfo is not a 'fake' table. see syslockinfo in BOL

Paul

hi,

are there any triggers on the table ?

Paul

i think you need to have a time with all datetime fields. the only thing i can think of is to set the time to the same for each row...