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

varuna70 if thats what your database is called

it depends on how the relationship is enforced - but in essence

table a foreign key relates to table b primary key

table a field that relates cannot have any value that...

when you say you've run out of space - what do you mean ?? the drive is full?

he's helpfully commented out an example proc call at the end

-- #sp_shrinkdata @updateusage = 1, @freed_space = 100 , @Msg_rtn_intv = 10

just remove the --

can you post the results of the query

exec sp_helpdb varuna

doing a bit of research - MERGE has been included with SSIS but not as part of the T-SQL after Beta2

you can run the nice shiny merge command using SSIS...

you may be able to get it from the connection string in the apps - depends on your app

lesson learnt - never use SA account for your apps or reporting

I don't think there will be many DBAs telling you how to hack the 'sa' password on their boxes.

if you're the DBA and you've forgotten the sa then i'm sure...

unfortunatley microsoft removed it from 2005

i've seen talk that if you buy visual studio 2005 there is an sql developer/debugger in there - but that's a lot of money

rcovery model is down to what recovery options you need.

there are 2 basic modes in sql 2000/7

simple mode (or in sql 7 truncate log on checkpoint on)

in this mode you...

if only 100mb of the 1.3gb is used you don't need to truncate the log - you need to shrink it.....

trunctate log means to remove the inactive entries from within...