I just tried it here and got the same results. It's not you or your install if that helps. Might want to try patching up to 1077.

Can anyone confirm...

October 2, 2002 Release

A revocation of public access on an extended stored procedure.

A fix for the escalation of privileges vulnerability on certain stored procedures.

A fix for an unchecked buffer in...

Wondering the same. Going to have to dig through the hot fixes. 1077 is sp4 with hotfixes right

quote:

---

It works for me. My...

that's only if you're moving both at the same time. Sposse I don't want to move msdb?

quote:

---

You have to move model...

SQL 7.0.0.1063.

I have the same problem with another database. This database was broken into 3 files the mdf id 100mb using 1.5mb, tlog1 10mb and tlog2 513mb combined...

I know and I can't get it to be empty either.

quote:

---

Your log file does't seem to be empty. Try to backup...

Thanks for the quick reply. I tried the following

use EVMECASECU0z

go

dbcc shrinkfile (EVMECASECU010LOG71,emptyfile)

go

alter database EVMECASECU0Z remove file EVMECASECU010LOG71

I get:

DbId FileId CurrentSize MinimumSize UsedPages ...

Oh you're going the oppisite way. You need to write a program (C, JMS, VB ). Not complicated, but it takes knowing your environment. Too many options to go through...

We monitor MQSeries with TBSM and a SQL backend, bit expensive. What are you looking to collect?

To be frank I'm not totally versed in MQSeries but I have...

Only the databases (not the server) that you log ship are in standby.

I have a situation where my production databases are standby servers for other production server and...

You can always back them up or archive them to a seperate location.

quote:

---

U can run sp_cycle_errorlog, but the number...

What do your indexes look like? How many col, clustered, fill factor? Maybe it only takes a couple of inserts to cause page splitting on your indexes. Enough page splitting...

Allens answer is right on, you just need to do a little research. The procedure I use is basically restart my transaction log for dummys(no offense) Oh and please thank...

Try this then increase log file to the size needed. 500 meg sounds abit high. If you only do full backups then make sure you have truncate log on check...

Try this

CREATE PROCEDURE dbo.usp_ReCreateTranLog

/*************************************************************************

FILENAME:

SQL SERVER OBJECT NAME:

dbo.usp_ReCreateTranLog

AUTHOR:

Phillip Carter

DATE WRITTEN:

26 Feb 2002

PURPOSE:

Detach and reattach database without specifying transaction log.

causing SQL Server to create log file...