You're right Colin, the admin course is a good place to start. I took a 5-day SQL course (MS Course 2780B, Maintaining a Microsoft SQL Server 2005 Database) and coupled...

horace (1/8/2008)

---

Thanks, I'm making progress. I can now get a list of the tables (50 of them), but I dont want to click 150 times for insert, update, and...

You can right click on the Job that runs the backup and go to properties. On the left hand side choose Notifications. There you can set SQL server to email...

Here's a good article with recommendations you may want to look at:

http://www.sql-server-performance.com/articles/dba/self_taught_dba_p1.aspx

Ah ok I think I'm understanding you a bit now. My personal take on that situation is if CU3 addresses your problem and the current release is CU4 then I'd...

I typically wait for full service packs before I move to production unless there really is a pressing need to apply a CU. If you have the resources you could...

Why don't you use SQL mail for your 2000 instance and DB Mail for your 2005 instance?

This sounds like a job for...duh duh duh dah...SCHEMAS! Check your SBO for schemas [SQL Server] and read up a bit on schemas and how to create/manage them. To me...

Just out of...

SQL 2005 gives you a wide range of options for setting up custom alerts, including Windows errors (I believe). If you right-click Alerts and setup a new alert, under the...

What database are you querying off of? Try this:

Use master

EXEC sp_validatelogins

GO

Also this command only gives you logins that no longer exist but still have access to the instance. I'll check...

I had this similar issue but found the solution (at least for me anyhow). For an install of Virtual Center I temporarily had to make another account the dbo on...