can you post the structure of AHDPROD.call_req and the indexes that are on it

yes - something like

sp_configure 'allow updates',1

go

reconfigure with override

go

alter table mytable add column col3 char(1) NULL

go

update syscolumns set colorder=5 where name='col4' and id=object_id('mytable')

update syscolumns set colorder=3 where name='col3' and id=object_id('mytable')

update syscolumns...

last=

select top 1 * from mytable order by myfield desc

first=

select top 1 * from mytable order by myfield asc

??

C++ is one of the most efficient object orientated languages microsoft offer, however it's also proboably the most difficult of the languages MS offer, which means that developers have...

i assume you're looking for someting a little more complicated than

select * from family where id_ancestor_m=123456

you're looking for a complete chain of descendants rather than just the children??

are you...

do you have an identity on the tables ? if so you can't assume the sql will ignore this column

try the following

rather than

insert into tablex select a,b,c...

hi colin - wonder which company that was??? sounds like the one we've both contracted at ???

but why ? setting to simple and then back to full acheives nothing other than forcing you to take another backup to start a new LSN chain.

what does setting to...

i vote for pre-recorded...

the point of attenting one fo these sessions is to listen to the man making the speech.

the point of visual aids is to assiste the man making...

what on earth are you doing jdixon?

if you set recovery simple you risk breaking the LSN chain so that reverting back to recovery mode full will be useless

you don't need...

and to find the log file number do the following

use isalog

go

select * from sysfiles

look for the log file and replace the first number of the above command with teh file...

ok - so just running the following should free ip 14Gb of space

use isalog

go

dbcc shrinkfile (2,1,truncateonly)

assuming that the log file is file number 2

select convert(datetime,

left(convert(varchar(8),run_date),4)+'-'+substring(convert(varchar(8),run_date),5,2)+'-'+right(convert(varchar(8),run_date),2)+' '+

case len(run_time) when 6 then

left(convert(varchar(6),run_time),2)+':'+substring(convert(varchar(6),run_time) ,3,2)+':'+right(convert(varchar(6),run_time),2)

else

left('0'+convert(varchar(6),run_time) ,2)+':'+substring('0'+convert(varchar(6),run_time) ,3,2)+':'+right('0'+convert(varchar(6),run_time) ,2)

end

)

from sysjobhistory

i'm not sure why you're not just running dbcc shrinkfile or the shrink commands from enterprise manager.

have you checked the size of your log files - ???

if you can...

sounds like your sql service account does not have permissions for the file

C:\Arquivos de programas\Microsoft SQL Server\MSSQL\data\varuna70_Data.MDF