We are still using SQL 7.0 Standard.

Further to the problems experienced I am seeing LCK_M_X waits which are sproc recompilations?

Because my databases are the back-end to a web based front-end,...

I thought as much and am in the process of building this functionality into my sprocs that loop execute.

Thanks

That's what I thought.

Thanks

I thought as much... thanks for the help anyway.

Another option we are looking at is to restore the database to SQL 2000, use alter database to set the logical names,...

Thanks for the reply, but I have tried this but it does not work. The only time a logical file name appears when restoring is if you restore from device....

How would that work? I want to update the name column in MyDB..sysfiles as I need to change the logical name of the data file and log file.

Thanks for the prompt reply and I will have a look at the suggested site.

Cheers

Deon

I have found the problem...

The data been processed contained char(0) characters that caused this type of error. Well, a character 0 I think is end of string or statement character...

You will get this error because you have a go after create proc sp_force_shrink_log and not after use master. The code snippet should look like:

use master

go

create proc sp_force_shrink_log

-- Comments

@target_percent tinyint...

Thanks and any suggestions will be greatly appreciated.

Right, if we take an example of lets say:

1. We have an orders system. Orders are keyed in by 500 concurrent order entry clerks.

2. There are many changes, and these...

I agree that deployments need to be tested in a PRE-LIVE environment which we do here. This environment is identical to our LIVE environment. This is not the issue though,...

This sounds more like you a business rule which I would have implemented through a data object. If this is not feasable or you need to rollback a transaction if...

I personally think that if a new disk is too expensive on a project where a table and not a database is 58gig in size, then you are asking the...

No, maintaining idividual scripts I find is the only sensible way of keeping control over your databases. How the system is supposed to work is, developers make object level changes...