I am running SQL 2000 SP3A.  The answer given is correct. 

Here's another free tool (at least until the end of May) http://www.x-sql.com/  This one compares DML, triggers, constraints etc but not data.   And it will create the sync script. ...

Use host_name() or host_id().  

 eg.

ALTER TRIGGER ordertr

ON Orders

FOR INSERT

AS

DECLARE @msg varchar(2000)

SET @msg = 'net send ' + CAST(host_name() AS varchar(30)) + ' test'

  EXEC master.dbo.xp_cmdshell @msg

I would include code that calls a mail program in the trigger to email the user.  This assumes you have or can easily get the users' email address.  I assume...

See http://www.yessoft.com/ for a free compare tool.  It only compares, it does not create a script to resolve differences.

For syntax help with DTSRUN see http://www.sqldts.com/?301

I don't understand what you would want generated if the table doesn't exist.  How do greate an INSERT statement if there are no columns to insert?  Most of the tools...

For a format of format of nnn-nn-nnnn   how about:

EXEC sp_addtype SSN, 'VARCHAR(11)', 'NOT NULL'

GO

CREATE TABLE ShowSSNUsage

    (EmployeeID        INT PRIMARY KEY,

    EmployeeSSN        SSN,

    CONSTRAINT CheckSSN CHECK ( EmployeeSSN LIKE

        '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]' )

   ...

Juanita: 

If you don't remove the guest id I can't think of any way to make 'master' not display in the object browser. If you remove 'guest' you may create...

the same table....  Definitely not trivial.  You will need to have date last updated and know which columns were updates on which box to determine how to merge the rows. ...

If guest is removed from master then anyone wanting to execute stored procs that exist in master will not be able to unless they are a member of some server...

QA is administrative tool.  Personally I would not be happy if some databases/tables didn't show up just because I haven't been given read access.  However, I understand what you want. ...

Are the table to be updated on the ISP the same as the ones on your main database?  If they are different you could look into DTS to do the...

Check if http://support.microsoft.com/default.aspx?scid=kb;EN-US;319892 applies.  There is info in the UMS Scheduler Health section which might be related.

• Security tab of the SQL Server Properties in Enterprise manager will tell you what account is being used to run SQL Server.  You can change this to a local or...