Thanks Steve.

Another question.

If we use multi-core processors on SQL 2000 or SQL 2005 do we need to set some settings in the queries we write to ensure the query will...

Thanks for the reply.

Regards

Carl

Steve,

It's been a while since I last tested moving the clock, but if my memory serves me right you cannot log into SQL Server via Windows Auth once the clock...

I would simply place the sproc in a job and set the retry interval to 10 minutes and the number of retrys to however many retries you wish.  This can...

Thanks David.

I think that script is the nearest we are going to get.

It still leaves Photoshop CS2 the same and doesn't put the CS2 in the version field, but I...

The name column is VARCHAR(255).

Guys,

I get the following error when running the following command:

RTRIM(LEFT([name],PATINDEX('% [0-9]%',[name])-1)) AS [name],

SUBSTRING([name],PATINDEX('% [0-9]%',[name]),255) AS [version],

Invalid length parameter passed to the substring function.

Regards

Carl

Phil,

I asked our Infrastructure guy to drop the share and recreate it and I have now been able to write my backups to the share

Hi Phil.

Hope things are well?

Thanks for your advice. I have checked and the premissions have been set to FULL Control on both tabs.

Regards

Carl

I have connected to Server 1 and ran the backup command via Query Analyser.  So the backup should be running with my permissions.  I am an Administrator on the destination...

All,

I am even more confused today!!

I have tried to backup up a database from Server 1 to a folder on Server 2 using the following command:

backup database to disk =...

Thanks again Phil.

That works a treat.

Carl

Cheers Phil,

I'll give that a try.

Hope things are going well?

Carl

Karl,

That code works a treat.  I understand what you mean about ignoring BOL.

I'll need to run this code as the first step in every job that we have.

I've got the...

Karl,

I'll give that a try.

Thanks for your reply.

Carl