This should help ...

DECLARE

@JobIDUNIQUEIDENTIFIER

SET @JobID = 'jobid from sysjobs for your job in question'

IF OBJECT_ID('tempdb.dbo.#JobStatus') IS NOT NULL

DROP TABLE #JobStatus

CREATE TABLE #JobStatus

(

Job_IDUNIQUEIDENTIFIER,

Last_Run_DateINT,

Last_Run_TimeINT,

Next_Run_DateINT,

Next_Run_TimeINT,

Next_Run_Schedule_IDINT,

Requested_To_RunINT,

Request_SourceINT,...

Perfect, thanks!

Yeah I had thought about that, but again, this maintenance routine needs to support SQL2000 and above. While it is a good workable solution, I simply log before and after...

I had quite a few problems going from standard to developer using the gui install, but when I did it from the command prompt, it went smooth.

http://msdn2.microsoft.com/en-us/library/ms144259.aspx

Works best if you shutdown all services (sql server, agent, browser, fulltext, etc.), then apply to avoid a reboot. Personally I still prefer to reboot the server after applying for...

Is TCP/IP enabled in SQL Server Configuration Manager per instance?

Ah ok, well, thanks for the help and info!

Yeah I saw that ... what are those _WA tables?

Well, sys.indexes does not pull back all the objects that sysindexes does ... so perhaps I'm doing it wrong in 2k5.

Any advice would be most welcome.

Thanks

So is it best practice than to find the original value of the index fill factor and pass that into the rebuild?

Steve Jones - Editor (2/29/2008)

---

Sorry, the only thing I've hard back is use a CLR procedure to log this information, which seems overly complicated.

I can get the data out in...

Matt Miller (2/29/2008)

---

I was testing using the Alter...rebuild, since the DBCC REINDEX is falling out of favor these days.

That probably bears confirmation. Should be easy to verify with a...

Perfect, and just to confirm, it is the same between 2k (dbreindex) and 2k5 (rebuild/reorganize)?

Thanks again

Ok, but what if you don't pass a fillfactor? Does it default to it's original value or the database default?

Does the same thing apply to rebuild/reorganize?

Anyone?