i take a backup of master EVERYDAY because there is nothing better than seeing this at 7 am on a workday;

CHECKDB found 1 allocation errors and 2 consistency errors in...

your login is not synced with the old 2000 DB.

you can access the 2000 DB by either using you current 2008 sa or any login that is a sysadmin.

OR

you can...

My advise would be don't bother backing up the witness.

If something ever happened to the witness, it is much quicker and easier to asign a new witness instance and just...

From SSMS

right click on the database you want to log ship.

choose Tasks

choose Ship Transaction Logs...

If still not there, re-install SSMS with the Management Tools - Complete option checked....

weird , i added this....

Create Table #Temp_Users

(

Name...

works perfect for me 😎

sure....

see new script

See attachment.

It uses sp_msforeachdb

I have to respectfully disagree with you.

you have told me that you know your SQL server can relay properly because you can telnet on port 25 to your local server.

now...

Well, imho, i wouldn't.

Since SQL 2005 and beyond has its own process for sending SMTP mail, I am not sure why you would NEED to relay via your SQL server?...

you cannot insert a value into the identity column. SQL will do that for you.

use;

USE Database1;

INSERT INTO Job_Titles

(EE0_1_Classification,Job_Title,Job_Description,Exempt_NonExempt_Status)

VALUES('Office/Clerical','Stocker','Stock supplies','E'),

('Sales Worker','Cashier','Accept incoming money','N')

:hehe: you run mail relay services on your SQL Server????? :hehe:

that seems to look ok... I have two follow-up questions;

1. How did you verify that access to the mail relay was good?

2. Does your SQL Server sit on a...

what is the output of the Database Mail Log?

you can check two things that I have had to fix when coming into a new project where DB Mail is not working. (always because it is misconfigured)

1. Verify that...