Where do you get a newer msenv.dll file, and does this solution work for SQL Server 2005?

I have been using DBArtisan for many years. Currently I am using version 8.6.1 for Oracle and SQL Server. I find it more useful of the Oracle databases...

I would say Sr. DBA is the correct title for this position, not Jr. DBA. I don't think a Jr. DBA would concern themselves as much as you with...

Check out Microsoft's site. It has a free trial as well as pricing and licensing information. http://www.microsoft.com/systemcenter/operationsmanager/en/us/default.aspx

Just because you use a wizzard or maintenance plan to run jobs does not mean you should stop monitoring your systems. Even if you run your own scripts you...

I agree with what everyone else has been saying so far. I use the maintenance plans for most of my databases, except for the few that need a little...

Are you upgrading your 2000 database to 2005? If so, you can still run your 2000 DTS packages in 2005. Or you can convert them using the Package...

Has anyone come up with an answer to this problem? I just received the same error after upgrading from SQL Server 2000 to 2005.

If you decide to set the database to single user mode, don't forget to set it back to multi user mode when finished.

ALTER DATABASE [Database_Name] SET MULTI_USER

I hope you called a lawyer to see if you could charge this guy with something. That's just wrong. :angry:

The user scott should only be used testing purposes only. Scott has limited priveleges in the database and can not create new users. I agree with the previous...

I have uploaded an attachment of a .vbs file (I changed the extension to .txt for uploading) that I put together to monitor windows services every few minutes and e-mail...

Look at these posts to find out how the transaction log works and how to maintain it. These should answer all of your questions.

http://www.sqlservercentral.com/articles/Design+and+Theory/63350/

http://www.sqlservercentral.com/articles/64582/

GSquared - Thanks for the reply. It was very helpful. I will check out your article for more information.

David - No errors in the Event logs.

This is an application for higher education where students can go online to drop or add courses. Sometimes when trying to drop or add a course, the system hangs...