I'm new, so I can only say that I *think* your sequence and understanding is correct, and what you laid out will accomplish what you seek.

But I do know that...

I've had some luck with 'Beginning SQL Server 2005 Administration' (Dan Wood, Chris Leiter, Paul Turley - Wrox.com).

Whether you devote additional time to 2000 specific books probably depends on what...

A query on Google will provide you with many links (Search on "differences between stored procedures and user defined functions").

Many of the links I'm unable to access due to filters,...

Yes, even drilling down to the correct step doesn't...

Almost exactly the same, but without FROM WINDOWS, and of course no domain, and also specifying a password:

USE [AdventureWorks]

GO

CREATE LOGIN [SQLUser] WITH PASSWORD=N'password', DEFAULT_DATABASE=[AdventureWorks]

GO

USE [AdventureWorks]

GO

CREATE USER [SQLUser] FOR LOGIN [SQLUser]

GO

USE...

Certain things that work in 2000 will break in 2005, but there are individuals on here with much more specific knowledge on those items than me.

One suggestion: Run Upgrade Advisor...

Have you looked at the details in the job history for the actual step, step 1? From what you cut/pasted, that sounds like the information from the overall job...

USE master

EXEC sp_validatelogins

GO

That's not correct, that date is the date associated with the service pack itself, not when it was installed. Try Add/Remove Programs - Look for the service pack in...

Chandrachurh Ghosh (4/25/2008)

Check out the orphaned users using the following script -

SELECT UserName = name

FROM sysusers

WHERE issqluser = 1

AND sid is not null

AND sid <> 0x0

AND suser_sname(sid) is null

ORDER BY...

Matt Miller (4/28/2008)

In order for that to work the way you want - you'd have to add in to the @Mycommand what you want to query for/execute in each database.

Your...

USE MSDB

DECLARE @jobname VARCHAR(150)

DECLARE @string VARCHAR(250)

DECLARE job_cursor CURSOR

FOR SELECT DISTINCT name

FROM dbo.sysjobs

OPEN job_cursor

FETCH NEXT FROM job_cursor INTO @jobname

WHILE @@fetch_status = 0

BEGIN

SET @string = 'sp_help_jobschedule @job_name =...

Cory Ellingson (4/3/2008)

2 Something like this as well?

SELECT 'Total Remaining Disk Space' = SUM(MB_Free)

FROM #DrvSpace

WHERE DriveLetter <> 'C'

Be careful, I had a Quorum drive as well (for the...

bah... give me my point! :hehe:

This is resolved. Apparently the SP on the server (which is encrypted) was using an old version that did utilize xp_sendmail. The SP source, prior to encryption, is...