the core of the trigger is going to be something like this, but you didn't provide all the info needed. what values would col1 and col2 actually be assigned?

UPDATE...

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 ...