You are using "same" a few times and it's not clear what you are referring to.

If there is a conflict of resources between the jobs, it could be blocking. It...

sp_help_revlogin is what I'd recommend.

Saw another note that it's .NET Framework 2.0, so where you can run that you can probably make Powershell work.

It should work with 2005.

From here: http://technet.microsoft.com/en-US/library/ee177003.aspx

I believe XP/Win2K3 are the earliest you can use.

With SQL Server, I'd guess SQL Server 2005, but it might be 2008.

Have you created a full text index on the table? I don't believe you can do this on a temporary table, so it might be on a permanent one.

If...

As a note for formatting, please only highlight (select) the code when clicking the formatting options. Like this

select myCol

from MyTable

If you have notes or text, keep them outside the...

The extension of the files for backups (or data /log files) has no meaning. By convention we use .BAK, .DFF, and .TRN, but it isn't required.

Point in time uses the...

You should have to provide the schema. It prevents issues with naming collisions.

I can't remember if this worked in 2005 for me, but in 2008 and R2, this hasn't worked...

The question was poorly worded and I missed the total disk activity in edit.

The question has been corrected and points awarded back as of a few minutes ago.

Seems strange. Can you check/post the execution plan in both cases?

Closing this as it has gotten out of hand.

If you disagree with an answer, please feel free to disagree without using insults or name calling. This is a professional forum...

Can someone let me know when Steve Smith is planning on showing up this year? I'll add him back to me line up then.

I'm not sure there's a stairway here, but we'll debate it. The stairways were designed to get you up to speed on certain SQL Server technologies. This is near the...

Users working with data don't impact the data reading portion of the backup. They can impact the log, as noted above, but that's mostly depending on the amount of logging...

There might be something in Windows, but I'm not familiar enough to know what you'd have to check. Someone or something (patch, SP) might have altered the dependency somehow. Or...