- with sql2005 you would use ddl-triggers saving everything you would want to.

- with sql2000 you could try to use this trace but would not have that much detail as...

you could use smtpmail in stead of sqlmail.

have a look at SQLDev.Net

- If it all started all of a sudden, I would begin with starting a sql trace for e.g. one hour. Then examine the results and search for big consumers....

- What do you want to monitor about the errorlog ? Size or content ?

- we use a scheduled (sqlagent) job to start new errorlogs at least every week using...

- generaly it's not a good practise to create userobjects in system databases. (master, msdb, modeldb)

- also when you create a login or grant connect to a server, be sure...

No ! Because :

- you never know when it's going to decide to shrink.

- the shrink operation will have it's impact on the system and for the users

- your database...

If you choose for the 2-column solution put the columns first which has the most unique values ! So it filters on top of the tree

- as long as you keep in mind that identity may leave you some gaps

- when you use objects with identity in parallel (insert with multiple users) you'll see...

- saving the storage from float to int will save you space in the parent table and in de child-tables !

- indexes based on int will be smaler so they...

just my 2ct

- check the queryplan your delete query is using ! If it shows a scan, you're in troubles.

- provide an index on column Expires to support the delete.

-...

- AFAIK there is no "alter database xyz modify filegroup FG3 set offline"

- Did you take a look at "Performing Piecemeal Restores " in books online ?

- in a...

- Check out Try/Catch in Books online (BOL)

- Scan / Seek see BOL "Table and Index Organization", "Reading Pages ", "Nonclustered Index Structures", "Clustered Index Structures",...

- Keep in mind that what you do within a trigger is "in transaction" ! Timeouts, locking,... !!

- keep in mind there may be more than one row involved in the...

just to add to Michael Valentine Jones ' reply  :

don't forget to throw everyone out of the database befor you try to restore...

1) yes

2) that should be quit easy. At install time there are demo alerts created. They are disabled. If you didn't remove them, they should still be present.

One of them...