did you restart the sql instance after you granted the windows auth for IFI ?

no. The current collection of cumulative updates (hotfixes):

http://support.microsoft.com/kb/981356

Indeed, like Michael Valentine Jones explained:

Instant file Initialization isn't used for log files.

Log files need to be able to be written to as fast as possible.

The fastest way is of...

- Are you trying to validate the operators email address ??

- If you just want to modify the operator I would create another operator and alter the job to use...

- You should also estimate how many rows you expect to fit into a single page (8060 bytes) and project that to your full set.

- if you designed your system...

No problem. Enjoy your first coffee 😉

eeuhm ... and indeed, a deny will always overrule the others, even with the user defined db roles.

That's why ms performs role membership tests...

Brandie Tarvin (1/28/2011)

---

...

ALZDBA (1/28/2011)

---

btw One shouldn't use user definend objects in the dbo schema any more. That's a bad habit that's been implemented when a replication bug has been discovered...

WayneS (1/27/2011)

---

Just to clarify, the way that I thought security worked was that if you specified a security setting at a higher level (either GRANT or DENY), that it would...

Or use the service account to connect to your sql instance and change the sa password.

Before doing this, double check no application connects using sa for login. (modify pwd needed...

How about:

Declare @status INT

, @jobID uniqueidentifier

, @mon int

Declare @rc int

Declare @cnt INT

Select @jobID = job_id

from sysjobs

where name = 'testing_sample_ssis'

print 'start'

Exec...

your sp_stop_job procedure ends normally.

So, your next statement is still executed in the "begin try" part.

Declare @rc int

BEGIN TRY

print 'start'

Exec @rc=msdb..sp_stop_job 'yourjob'

if...

We receive many "sspi handshake failed" at dns-server reboot time (win 2003 domain). transparency with secondary dns servers doesn't seem so transparent after all 🙁

another alternative might be

SELECT *

, ROW_NUMBER() OVER ( ORDER...

- What's the actual error message your apps receive ?

- Can it be applying win updates on a dns server ( including reboot ) somewhere in your chain causes this...

-- removed xpost notice because Steve already pointed the other thread --

Good job, Steve