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

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 of the bits,...

I dont think you will personally have a problem with this as long as you are moving to the same version.

The only thing I would say is that with backing...

Depends what you want to use it for.

Please detail what you are trying to acheive.

Sorry guys, it was a bit much, there where a few posts the day I changed to that avatar which made me upload it as I did feel like banging...