What you can do is lower the log file size on the source system, if it's appropriate, and then take a backup with a smaller log file.

Or get more disk...

For passwords, I typically just store a hash. Use a one-way function, compare hashes to see if it's a valid input.

I don't think you can disable a trigger in SQL 2000.

2005, sys.triggers.

That looks like an interview or test question.

Please make your own attempt and we'll help. You might want to look in Books Online for samples of stored procedure and insert...

Can't you degrag the file on the drive? If it's really fragmented, I'd take some downtime on a weekend and try to clean it up.

There is a day or two a year in my town. The announce it on signs and their website. It costs a little to recycle, and hopefully it's worth it.

Are you assuming that this thread made sense at one point?

What are you planning on logging? If it's a simple insert of the event, the overhead is supposed to be minimal. Keep in mind that these actions trigger events and...

Thanks for the update. All traces are in SQL Server so you can determine what is active.

you could run it through the upgrade advisor, but without seeing the script, there's no way we can guess as to what might be broken.

lots of stuff works, but if...

Great to see so many people investing in themselves and taking responsibility for their career.

Just by visiting SQLServerCentral you're doing that. Learning, reading, asking/answering questions, those are part of...

We might allow this, a low priority item, but I'll see if there's a way to do this easily in the settings.

That's not a bad idea, Richard. I'll see if there's a setting.

We've banned number of IPs/Users, but they keep trying new places.

Submit it as a bug on Connect. I'd agree with you that it should show that in the GUI.

link adjusted, apparently I'm URL challenged.