SQL 2005 Standard SP2 x64. Yes, it's part of a cluster but not an MS SQL cluster.

Thanks for the quick replies. Does anyone know of a good reference site where I can do some further reading on this?

Delete the data from your table then run the following command:

DBCC CHECKIDENT ('yourtablename', RESEED, 1);

This will set the identity column's seed value back to 1.

That doesn't give the size of the current database. It relates to the database with an ID of 1.

I took the information from sys.sysaltfiles instead but thanks for the...

CREATE TRIGGER triggername

ON tablename

FOR INSERT

AS

INSERT audittable

SELECT * FROM Inserted

GO

Do you have error logging turned on for your DTS package? What does the log say?

You are only increasing the number of places after the decimal point, not the size of the field. The length remains at 16 which actually reduces the number before...

Look up the DATEDIFF function on MSDN.

The syslogins table stores server logins and the sysusers table stores the users of a database. They both contain a mix of Windows and SQL logins. I'm not...

Do you mean one group or one user in a group? Whichever user it is needs to be added to the database role SQLAgentOperatorRole in the msdb database. ...

Hi,

The default database is the user database (in multi user mode) that is being accessed and there is a user mapped, which is a member of db_owner.

DELETE FROM e

FROM employee e

JOIN employee f ON e.Name = f.Name AND e.empssn = f.empssn

WHERE e.id < f.id