IT guy trips over the power cord?

This is a very broad topic, I think you need to narrow down exactly what you're looking for. You could write a whole book...

Might want to read this ... http://www.file.net/process/tmp9.tmp.dll.html

If you're looking for a book to learn at your own pace, the Official 70-431 book from Microsoft is nothing short of excellent.

SELECT DB_NAME(dbid)

SELECT OBJECT_NAME(objectid, dbid)

The above is correct, but something that makes life pretty easy when constantly restoring databases from a production environment into DEV/QA is to write a little post restore procedure that...

-...

Also, if you're experiencing memory pressure, you should probably allow your SQL Server service account to lock pages in memory.

Plain and simple, task manager will never accurately report memory usage. There is no 'real' way so to say to see 'actual' memory usage at any given time ... this...

SQL can track successful and unsuccessful logins by default ... you have to enable the option, which requires a SQL restart:

USE [master]

GO

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel', REG_DWORD, 3

GO

This can be...

IMHO, SimpleMachines is by far the best free MySQL forums. You can also add a portal (TinyPortal) that gives you an infinite amount of possibilities.

I'm assuming this is SQL2000 as you're referencing EM correct? You should post this in the 2000 forums normally ...

Anyways, you need to tear down replication before dropping the database....

You just want all the databases, and all the server logins?

SELECT * FROM sys.databases

SELECT * FROM sys.syslogins

SQL2005 has automated Log Shipping and can be all setup in the GUI if you want to make things easy ...

http://msdn2.microsoft.com/en-us/library/ms190640.aspx

Also, depending on the amount of transactional data you're working...

Hmm, with your responses I wouldn't be to alarmed about enabling lock pages in memory then, but it is still good practice to have it enabled.

You may want to read...

Yeah that would be nice ... but I think I'm just gonna have to bite the bullet and create a process ... was just hoping to find something someone already...

Do you have lock pages in memory enabled?

Are there other applications running on this server?

Is SSIS utilized on this server?

Is CLR in use on this server?

How many instances of SQL...