Thanks for the reply, PW,

Oh, how I wish it was possible to change the format of the code column!  Sadly, it's been there for about 3 years now, and there...

"So suppose Code_2 has a matching value"

Hi Chris,

One tip that you may not have realised (apologies if you have) is that when you right click on the job in the jobs listing and select 'Job History',...

This could be down to lots of things.  First thing you need to do though is generate an execution plan for both servers and compare them.

If you post the results...

Matthew,

What you have effectively by running the backup log command is emptied the water out of a bucket.  The contents of the bucket are gone, but the bucket still remains,...

Hi Matthew,

Here is the command you need to run to carry out Ian's suggestion.

backup log <DB Name Here> with truncate_only

After this, you need to consider the backup solution you require for this db,...

You are right Dave, it does.  However, it does not appear to actually display what you would expect as all the dates in my last_altered column match the dates in...

Hi Florent,

I think there is a much easier way of doing this.  There is a system stored procedure which is undocumented called sp_msForEachDB. It will run the command in the parameter...

If you have a database which is configured to have a recovery model of 'Full', and you carry out an update to many rows in a table, then the transaction...

Sorry Luke, I can't help with your reqest, but I have had a look at your app, and it looks interesting.  Just thought I'd let you know. Look forward to seeing...

Here is a script I wrote which uses Terry's technique, and expands on it.  It gets all the sysprocesses into a temp table, then waits for (default) five seconds.  It then...

Hi Murali,

In addition to the above, I would add that if you do not need to back up the transaction log, you should set the Database Recovery mode to 'Simple'...

Thanks for the reply, peterhe.  Sadly, it does run uncompiled sql statements like select, update etc.  All objects are owned by dbo though.

You need to use your second solution.  The AuthorID column in Documentation will be a foreign key, and the UserID column in Author table will be the primary key and...

Many Thanks for your reply, Chris. It looks like I will have to put up with a naming convention which, to me in any case, is illogical.

Martin