They have created the schema right? Also for some reason db_owner hasnt been removed as it? Shouldnt of as they created the DB and with dbcreator should get...

Damn them for updating BOL,

Thanks for that, just so you know its not me going crazy

I would say have they created the schema? or has something gone funny with permissions when the db was created?

i've just tested this on my test bed and working as...

Ah as in public internet facing.

So for an internal intranet with a company user base of 50 I could licence on a user cal/server method and not CPU.

Suppose it then...

Correct me if I'm wrong on this, but from my understanding, any SQL server which is accessed from the web needs to be done on a per processor basis.

Sorry Corgi, maybe its me reading the thread wrong.

Is the problem that he can create other schemas and objects? Or is the problem that if they try to select...

if you create a blank trace using the blank template and just enable the following event

Security Audit --> Audit Login Failed, you should eventually get a hit.

as its a sql...

learn something new every day

if none of the accounts can log in as a sysadmin then the only way would be to start SQL in single user mode.

first ensure you can log on as...

Load the data into a holding table, then you could write a t-sql task to only copy the data you need passing in a variable

state 38 is database doesn't exist/no longer exists or login doesn't have access to the requested database.

I know this is basic but the db's...

Learned something new on this, thanks Gail.

Engr Shafiq (2/29/2012)

anthony.green (2/29/2012)

Gianluca Sartori (2/29/2012)

GilaMonster (2/29/2012)

Gianluca Sartori (2/29/2012)

GilaMonster (2/29/2012)

The marketing launch event is in a couple of days. Availability...

MaxErrorCount is at the SSIS package level, so the SSIS package can only raise 1 error before failing

your saying that the job continues to run after the ssis package fails...

whats the logic in the actual job

eg

STEP_____OnSuccess_____OnFailure

step 1____GoToNext______GoToNext

step 2____GoToNext______GoToNext

step 3____QuitSuccess____QuitFailure

so if the SSIS package is run in step 1, it will continue to step 2 as on failure is set...