I didn't believe there was any reference to the source server in a job?

I have tested by scripting out a job from one of our dev servers and the only reference...

Try the sp_helprotect command against the master database.

Have a look at the command on BOL.  I think there are switches that you can use to specify a given logins permissions.

regards

Carl

I have just done a search on BOL and it gave the following info:

Error 823

Severity Level 24

Message Text

I/O error %ls detected during %S_MSG at offset...

Are you getting these results when you monitor the physical disk/%disk time counter on its own?

Hello Phil.

How are you doing?

Spotted you where browsing this forum.

Carl

I have found a solution although I am not entirely happy.

When the sql script is created the date is of the format yyyy-mm-dd (2005-11-02) so I have to set dateformat...

I had a quick look on BOL for the sp_trace_create command and saw that error code 14 was due to an 'Invalid stop time. Returned when the stop time...

That was going to be my next test.

Thanks

Carl

Glad you found out what the problem was.

Regards

Carl

 Just to confuse you further :o)

Did you do move the master database first and then bring online and unattach the model and reattach seperately?

If you unattached and re-attached the master...

Sorry you will find the location of the log file in the sysaltfiles table in the master database.  This also points to the data file location

Regards

Carl

Just a thought.

Have you checked the sysdatabases table in the master database to see where the data and log files for the model database are pointing to?

If the location is...

If you are deleting all rows from the table you need to use the truncate table statement rather than the delete from table statement as the truncate table statement is a...

As long as you have enough space to autogrow by 20% which works out at 274 MB free space on the drive that .mdf file sits on the database should...

Thanks Brian.

I moved my system dbs from the default folders when I initially installed SQL Server.  Will I need to set up my system dbs the same way.  Even though...