Ok so playing around it looks like ..

If you use a AD Groups for users. When they create a table with any rights less than SysAdmin (ill say what ive...

ohhh...

so

SELECT * FROM sys.database_principals

There is the users accounts in there for some reason... And its got the default schema name of there own name..

Apart from those users.....

hey, yes we use groups.

for some reason they are in a 2. (1 with sysadmin, 1 with db_owner) someone put them into sysadmin which stopped it happening

no individual logins...

Hey,

Currently blank (GUI -> Security -> Users -> User -> right click properties -> User Mapping -> default Schema)

Im trying to replicate it on my box using execute as...

.

Thought it might be network contention.. But SQL Monitor doesnt show the NIC ever going near 10% at any point in the day..

Hoping someone could explain..

Hi thanks for the reply.

Tried with MAXDOP 1 and got the same result..

thanks sir that's perfect!

ohh Thanks..

adding now..

simple and effective!

thanks sorted it..

S

!!!

combining all your fine skills i have it working!

Few things i found...

In reg ErrorLogFile was pointing to a folder that didnt exist

In reg WorkingDirectory was pointing...

Hi Howard,

I have the Dump Directory in the agent properties pointing to the same log folder as the MSSQLService log folder. (As i said using the same account for...

Hi MarkusB,

Thanks im properly being dim..

But wouldn't that create a temp table on every server, with the results of only the server its created on. I would like...

Hi,

Divine Flame:

thanks i was aware of doing it in ssis, was hoping there might be a simpler way with TSQL for one off type events.

ard5karthick:

Id like to say run the...

Hi anthony.greengave me a simple solution using

select *

from auditcategory

UNION

select 999, 'Discount'

For the param query.

Seems to get it working. Thanks Anthony again and apologies for ending up with...