The job has been running successfully in the past, could it still be a permission issue, it is owned by 'sa' so do I check for this in the security...

Thanks

Hi, thanks for the reply, the database am using has a job that backs up the transaction log every day, so I guess there will be loads of log files.

What...

Hi guys, Yes its sql server 2005 developer edition, sorry I did not know this was a sql server 7/2000 forum, so I guess I have all the prerequisites then.

Hi All,

Silly me, the script was supposed to save to a path pointing to D:\ and when I

check inside the script I discovered this, so the job was able...

Am logged into sql server via my domain account, I have a domain, the C:\drive is for my workstation as you suggested, am creating the jobs using a window user...

Now fixed, we used the Stored Procedures below, executed them separately in query analyzer:

**//Make sure you execute these scripts separately

--1)

sp_configure 'allow update', '1'

RECONFIGURE WITH OVERRIDE

--2)

update sysfulltextcatalogs set path='S:\Text'

--3)

sp_configure 'allow update',...