Originally posted by fraze
Ahhh - at last a result - some cunning b*****d had created a logon trigger that switched the schema if a user had a certain role (which my user does).
Oh dear thats funny, I hate it turns out to be something daft like that......what a bugger. at least it made me laugh on this cold Wednesday morning.