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] ...

Error

Duplicate post

All replies to this thread http://www.sqlservercentral.com/Forums/Topic1734147-3411-1.aspx

You can run xp_logininfo against all the groups in on the server and note which groups the user is in

exec xp_logininfo 'DOMAIN\Group','members'

Service accounts should be changed via config manager not services.msc.

Open up config manager switch the account back to the original account, then switch it back to domain account. This...