if you don't mind being asked, where? and how is that "thing" is being re-indexed? That pretty much proves my "gut" feeling about it..

thanks a million for your help.

thanks all for chatting about it.

So, if they are now all views, is the actual info stored in the meta-data somewhere? Where then? Views are only snapshots of tables.....

I get only dtproperty in return if I execute that. What about what use to be sysindexes, sysobjects, sysprotects, etc, etc.. can see any of those anymore in the not...

can't compile this proc on SQL Server 2005 SP2, x64

get error:

Msg 102, Level 15, State 1, Procedure sp_who3, Line 49

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Procedure sp_who3,...

Folks, is there a good link to study administration of SQL Server 2000 and 2005 multi-instancing administration? Particularly, I need to see how can I query all the isntances from...

well.. this firm has no build standards to say the least.. so any sample or template is greatly appreciated.

did anyone ever did a paper on that? i can't believe that no one ever did..

Guys, my boss is asking me to come up with a simple document where we have SQL Server 2005 standards SAS70 complaint. I am not a new to SQL Server...

Christofer, your app.. is it your home app or something I can buy of the market?

lalafafa

Christofer, thank you. I think you are the winner of my question/answer competition. I will enforse this rule. It will be a hell lot easier to just "REPLACE ALL" in...

that is a problem... Some are small, some are medium and some are huge.. no luck here.

lalafafa