Jamie, the point is that any agent job you attempt to create that will notify you that agent is down or going down will never fire since, well Agent is...

sysxlogins is an undocumented system table in SQL 2000. I would be more concerned if syslogins had questionable data. Unless you feel your system is compromised I would...

I believe that sysxlogins also stores remote logins for any linked servers set up on this particular instance in addition to the local logins.

I guess you could store it as HTML or as rich text in an ntext or xml data type field.

Use the AfterUpdate or Change event. LostFocus would fire even if you did not change anything.

You do not need to enable AWE, however you MUST grant the service account for SQL the ability to Lock Pages in Memory. Trust me, just went through this...

Specifically SQL Compare in the SQL Toolbelt suite. You can purchase the tools ala carte if you wish.

I really like the Red-Gate tool as well, in the scheme of things I don't see that it was all that pricey either. We purchased it as part of...

Also provide us with O/S and SP settings as well as 64 v. 32 bit and SQL Edition and SP. Also confirm your memory settings and whether the SQL...

Perhaps a little more information is in order: Can you tell us how you expect to search these records (what column(s) are expected to be in the WHERE clause...

Thanks Guru, will do.

I found our issue was that I took for granted that as a member of the Local Administrators group, the SQL service was implicitly granted the right to lock pages...

Clustering provides high-availability and DR for hardware failure, but not site failure.

Mirroring or Log Shipping provides DR for hardware failure and site failure, but depending upon how you set up...

I'll answer that question by explaining how we handle db/log sizing where I work. Most of our databases are vendor-created. I have the Analysts and the vendors determine...

The only way you could calculate this is if you were querying the system tables for that data and storing it in a table for later use. SQL does...