Kam,

There are HUNDREDS of reasons ... what is your objective here?

Well, msdb.dbo.sysjobs_view contains all of your job information.

You're not going to know if a SQL Agent job communicates to another server as a job can basically do anything. You can...

Please clarify ... Are you trying to figure...

Yes, use OPENROWSET.

Well, you're not really using much of your query ... that and why are you changing your recovery models for this operation? The ALTER index does not bloat the...

Toss a where clause at the end for:

WHERE a.index_id > 0

AND a.index_id < 255

That should have been the only thing causing you nulls.

Isn't R5 better for reads, just horrible for writes? Which brings up the question, what is the best bet for a warehouse? DW's usually only see writes in the off...

The real answer should be mssqlsystemresource ...

I've recently proposed purchasing gravity insurance to my bosses for these situations ...

RedGate's SQL Compare is about the best of the best in my opinion ... a little pricey, but well worth it. If you want something a bit cheaper, but not...

Books Online is your friend 🙂

As for your query ... this should fix ya up, let me know ...

SELECT

a.index_id

,b.name

,avg_fragmentation_in_percent

,c.name

,d.name

,e.name

FROM sys.dm_db_index_physical_stats (DB_ID(), NULL,NULL, NULL, NULL) AS a

JOIN sys.indexes AS...

What are the index id's from sys.indexes? If they are 0, than it is a heap, which would not be in sys.objects. If they are > 255, they are lob,...

So your linked server is from 2005 to 2000 right? Can you linked server to other 2005 instances? There is a weird issue when using a linked server from 2005...

Well, I'll be damned ... I wasn't looking at it properly due to the email address being a group ...

Anyways, both in x86 and x64, I changed the replyto email,...

My reply to works just fine ... curious to hear what you find out ... Anything you'd like me to find out from our exchange guy?