Gails wonderful article explains it all very well.

Just in case you still want other refs :

- http://blog.sqlauthority.com/2009/12/15/sql-server-difference-temptable-and-table-variable-temptable-in-memory-a-myth/

- http://blogs.msdn.com/sqlserverstorageengine/archive/2008/03/30/sql-server-table-variable-vs-local-temporary-table.aspx

- http://www.sqlskills.com/blogs/Kimberly/post/Understanding-TempDB-table-variables-v-temp-tables-and-Improving-throughput-for-TempDB.aspx

/* check no jobs are using your operator */

IF EXISTS ( Select J.name as JobName

...

This could well be an appetizer kind of session.

Just get an overload of hotspot topics to pick a detailed session on the issues that got your interest.

Might even work very...

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 🙁