OK, over kill service accounts shouldn't be added to the admin groups, but whats done is done.

Please post screenshots of the error messages you are receiving, along with screenshots of...

Its not you / the admin that needs rights its the service account running SQL.

You can have all the rights you want/need, if SQL can't access the file you can't...

have you set the necessary permissions to the folders?

Generally no unless something is intercepting the command and appending the additional.

My first step would be to find the sproc in question and check that out. If that's clean...

Killer

No problem Scott, here you go

CREATE TABLE [dbo].[Cache](

[Availability] [tinyint] NOT NULL,

[BasePrice] [numeric](9, 2) NOT NULL,

[Bookable] [tinyint] NOT NULL,

[BookingFee] [numeric](9, 2) NOT NULL,

[BookingFeeIncluded] [bit] NOT NULL,

[BrandId] [int] NOT NULL,

[CancellationScheme] [numeric](9, 2)...

Sounds like the application is adding the extra characters to the input string.

NHS

extortionate

Zealous about security and they want you to use a local account? Guessing this account is a general account for everyone to use? How do they know which...

Bank

What information do you need?

Never run into that scenario before.

Have had the code page be different so a server the Infra team setup was a US keyboard rather then UK so " and @...

Not a problem.

Noticed that the XML encoding character got stripped out as the IF tag always plays silly beggers with XML encoding

Need (spaces removed)

& # x 0 D ;

Adding in...

Nice script Lowell, just modified a little to remove the cursor

IF OBJECT_ID('[tempdb].[dbo].[#TMP]') IS NOT NULL

DROP TABLE [dbo].[#TMP]

CREATE TABLE [dbo].[#TMP] (

[ACCOUNT NAME] ...