Thanks for all the replier! Unfortunately have still been unable to resolve the issue. Google searches come up with solutions such as restarting the SQL Agent, SQL or the Server...

I can change the user andit runs. The real question is why SQL does not recoognise the login I used to access the server in the first place.

"The owner [ login name] of Job Back Up.Subplan_1 does not have server access".

Please note that I am already logged onto the server with that login.

Yes SQL has access to...

Hi,

Extended the code - which I run in QA for testing, as follows. The final SELECT shows a 0 so the error code is being returned is being returned. Does...

Hi,

Yes, have tried the following and it returns 0 even though the Emai addresss is incorrect. No warning Email received.

DECLARE @Retval int

EXEC @Retval = MASTER..XP_SENDMAIL

@RECIPIENTS = 'colllin.betteley@aecom.com',

@SUBJECT = 'Error Testing',

@MESSAGE...

Aplogies for delay.

It is indeed a comma delimited string. Which I am taking from a view which combines data in 2 tables, in different formats. Don't ask! 😉

I want to=o...

Now for the question! ;-(

I want to show the address as

The Street

Any Town

County

Post Code

I have seen this done by using COALESCE, but cannot find the code anywhere. Has anybody...

Gail,

Thank you for your response,very helpful.

Do you know the relationship between the LSN for back Up and Transaction log files? For Example

Type ...

We have several other Databases on the server and those applications all work well.

It is a straight migration between servers keeping SQL 2000

Changing the initial application login to a...

Yes, it has the correct default Database.

It cannot be an orphan as the login has been deleted and recreated on the server and in the Database.

The login cannot access tthe...

Thanks,

Nothing returned.

I have run a script, I found on the web, to identify orphan users. But nothing was returned there either.

Colin

Thanks all. Your comments have pointed me in the right direction and I have now achieved the desired result. with all the other issues required by this report it has...

Sure is.

They are not connected, hence my wish to separate the se sections by a comma in my query result

The column ITEM represents companies which are carrying out various functions. These...

Thanks, that is what I thought.

However, we recently moved aa databasse to a new server and the application failed. We added a guest login to the database, but did NOT...