> "When issuing the DEFRAG C: -A-V command,, you get a lot of information, but you can not decide if it is good or bad.

MS are using percentage, but you...

> "Suppose that the level of chaos (i.e. fragmentation) of the data in a given Data Base can be calculated and quantified. Such a factor will alert the System Manager...

Sql mail is not officially supported for MSDE.

".........Don't use write caching without a battery backup. Most caching controllers include a battery or offer one as an option. This battery retains data in the cache in...

FWIW one might consider testing / implementing ECM for the DDL comparisons and something like Monarch for the data comparisons. HTH

"Another is that it's a temp table, so the rules don't really apply. More than the first argument, I think there is some validity to this position. Not a lot,...

> Say you've got a 100g drive with a 40g database and for purposes of discussion the backup is also 40g, leaving you a cool 20g free. Add 10% to...

The logic describing the "fundamental problem" is fairly sound.

"This illustrates a major problem with SQL NULLS and the way they are used.  There are essentially two reasons for missing...

"I also see the state/reason for missing data as a separate attribute from the data itself.  That's why I believe it should be separated into its own column from the...

"To my mind there are far too many possible reasons that data could be missing to try to implement a separate 'NULL' type 'mark' for each situation, in the same...

> The MS SP's (it seems) have to be run in each DB separately and the information correlated.

Use Master

Go

Exec master..sp_HelpUser

Exec pubs..sp_HelpUser

Exec northwind..sp_HelpUser

...MS Supplies the following:

Exec sp_HelpLogins

Exec sp_HelpUser

Exec sp_HelProtect

Exec sp_HelpSrvRoleMember

Exec sp_HelpRoleMember

Implementing roles is very good advice; scripts that attempt to address the requirement are usually somewhat limited (especially if users may create database objects) Some procedures that may be of...

RE: Q1 What is FCB for invalid file ID means?? Now to my problem. The following error I'm getting on my SQL Server machine. I tried to get the...

RE: 1. why would executing an sp as simple as this (see below) cause a lock timeout? At any given time, there could be 20 or more requests to execute...