there's an article on something similar labeled "exotic joins" i think; if you search and read that, it can help you understand some of the less logical reasons to join...

looked like the "enhanced" version has an error in it;

this is my slightly edited version of the same script; it runs without errors on both a 2005 and 2008 database:

db_documentation_enhanced.txt

take a look at this wonderful script contribution:

Comprehensive HTML Database Documentation(Revised)[/url]

it produces well formatted, informative html document, which you could then copy and paste into excel, or open with excel.

I've...

i went to the trouble of creating a stored proc that does this;

as previous posters already identified, the actual statement is never saved...all you can do is script out the...

who created the users is not saved anywhere...with a minor exception.

SQL does not keep track of who created or modified anything...except for a short period in the default trace.

the...

i think the 2005 %%LockRes%% row identifier and the 2008's equivalent %%physloc%% only tell you how the data is stored, which is based in the clustered index of the table...

i have this saved in my snippets as a DR framework from a post that appeared on SSC fairly recently...I thought simon provided a pretty good list of things to...

also notehow a DEFAULT constraint is used! default does not mean "replace null with the default value", it means "if not included, use THIS"

if you include a value in your...

i thought re-enabling the constraint prevents future...

if you disable FK's, then insert, then renable, a FK is is_not_trusted = 1 if there is data in the child table that violates the FK constraint right (like inserting...

another option is that SSIS can migrate data both to-and-from SQL to another data source....all you need is an ODBC connection.

you could set up a package with the import/export wizard...

run the msi and click next five or six times....

seriously, an "application" server is just another server that is being used for a specific purpose.

you would have to decide if...

I believe that you can connect as sa(if you know the password), and then add the the right groupsto the sysadmin group.

otherwise as a local administrator, you need to connect...

there may be a more streamlined way to do it, but this works:

--results:

BDayYearBegin dob ...

mostly your problem is your design is not using an identity...but it is also procedurally based, and not thinking in terms of SET based solutions.

what if i were to insert...