That's a lot to cover in one answer

I'll start with the first point and then maybe move onto the rest when i get...

Hi Francis, to the best of my knowledge SQL doesn't do versioning (with the exception of DTS packages).

That's why change control is so important to get right.

Sorry I couldn't help...

Just to add that it's often much easier in multi-user environments where more than a couple of users need similar access to create a single role and grant permissions to...

LiteSpeed 2005 and SQL Backup are both really good at this sort of thing, I have no problems with recomending either of them to you.

Hmmmm.... just to add my 2 cents.

Over the years I've worked in huge organisations and small organisations and the main thing that I can add to the above is that...

Yep, we use a SAN for this, whilst i agree it is a single point of failure there's generally a good amount of redundancy built in (failover disks, multiple paths,...

With SQL 2000 you needed to buy enterprise if you wanted to do clustering, however, with SQL 2005 you can now do a 2 node cluster with the STD version.

If...

Hi Dave,

what accounts are your sql server and sql agent running under, this sounds like a security issue which generally means that the sql agent doesn't have the correct set...

Can I just say that I have no problem with women being on top

oops, slightly off topic I think

and now that it's friday we can all play much more than during the 'working' week

Because you want the cluster administrator rather than windows to control which node the service is started on

lol, no way you're Bunny

Them's fighting words if ever i heard em, prepare to be thrashed

Hi Pete,

Yes, the only way to do a point in time restore is to do a restore of the full DB (with norecovery set) followed by everything up to the...

I think this does what you want

SET @cmd =  'declare @rows int; ' +

  'SELECT * INTO [mail_bounceback_' + CONVERT(varchar(10), @today, 112) +...

Thanks Lee,