This is the good old procedure from SQL 7.0. It works great.

create proc sp_force_shrink_log   

/*   

*************************************************************   

Name: sp_force_shrink_log   

Description:   

  Shrink transaction log of the current database in SQL Server...

Check the article below.

http://support.microsoft.com/kb/246133#4

You can restore used databases as Steve suggested or also copy the data files from SQL 7.0 to SQL 2000.

I think that this error indicates that your connection is opening up with your application and might be your connection is breaking up while performing some reads. Not sure what...

Check the role TargetServerRole in msdb. This should give you permissions to view the jobs.

Try running DBCC CHECKDB and verify that everything is fine on the database. Regarding writing to the log file, Truncate log on checkpoint will only truncate completed transactions on a checkpoint....

You can check if any of your enterprise admins can help you figure out where the host is located ? Something we also do is we have alerts set up...

Can't open default user database. Login failed

For this error, check the default database to which the login has been assigned and make sure that your login has access to that...

This is a workaround but doesn't answer why it is sitting with the blinking cursor. Schedule the DTS package with any schedule. Open the job which is created and copy the...

That is weird. You can copy the data and log files for model database from another server and attach them on this server.

Kevin,

If you select the first option, reorganize data and index options, you should not be concerned about updating the statistics. The statistics will be updated with the index rebuild.

Regarding the...

Make that user the owner of the database. The database owner shares the alias name dbo within a database and hence any objects created by that user would be prefixed...

Can you try giving the UNC path ?

Just in addition to what Frank advised, under pageheader, m_objId gives you the object id

Check this out.

http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=110031

1) When you execute the package, the latest version of the package will be executed.

2) If you right click the package, and click on version, you should be able to see the...