Hello,

Nothing is static - all requests are evaluated on a case by case for the business driver. Having said this, here is our environment's general guidelines:

Production DB Servers: are locked...

Excellent. Thanks.

Any thoughts on how to capture the sqlsp.log date in a sql statement? I would like to create a report using sp_sendmail with @@version and date of the sqlsp.log?

Hi, I find that you can't add triggers to the system tables ... any other suggestions?

thanks ... but is there a way to see all the objects at once? In MSSQL2000, using Enterprise Manager, there was a "Permissions" button when the db role's properties box...

Hi Brian, thanks for the whitepaper. I did a quick test and was unable to get/loacte the screen shot (Figure 12: Setting the Information in MS Access). Could you further...

Hi Steve,

that's exactly want i'm looking for. It beats trying work-arounds "sp_helpfilegroup".

Hi,

Is there a method to re-index a particular FileGroup? ie: just the PRIMARY and not others ie: FG2; FG3 (these are set to READ ONLY).

Hi guys,

many thanks for the knowledge transfer. I agree that it might be best to go for a server-wide FILLFACTOR setting ... any suggestions ie: 70%? 80%??

Hi,

So if the vaule in DBREINDEX is omitted, it's the same as entering a 0? Also, if no FILLFACTOR was specified during INDEX creation, what would be the default value? Is...

perfect. i'll try both methods.

EM uses sysindexes ... much quicker than a full table scan ie: select count(*) ... i used the DBCC command with success. Thanks noeld.

Hello rsharma,

I changed the options in QA ... great, many thanks. Could you provide me an example of what you mean by a string operation to display it's entirety?

Hi .... whoaaa ... I have to update each workstation's EM and QA tools???? re: developers pc's? Is this new for SP4? I don't remember doing that for SP3 upgrade? It...

Mike ... lol ... that's not bad.

Great.