Okay, the script works well and does what it says.

WOuld be interesting to kick off a small debate to find out what people will do with this and how it...

Great script and some interesting procedures posted I was not aware of.

Whilst this seems to do a fair job of auditing all users in the current instance of the server,...

Msg 139, Level 15, State 1, Line 0

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 1, Line 29

Must declare the scalar variable "@End".

Msg 137, Level...

I like what you have done although I have not tried running the script yet.

Ideally I would like to copy the database to another server, not onto the same server...

I concur with the previous question... I regularly run reorg_re-index on all tables and trying to work out what exactly this script is doing. The only clue is in the...

Great article and equally good and interesting responses.

Food for thought. Whilst Mirroring in my mind used to be a great feature when we used to build Servers (physical) for SQL,...

Like the idea.

I would suggest altering the script in the following ways

1. Read the website url's from a table

2. On success/fail write datetime and url and pass/fail to table for...

What version of SQL is this script meant for?

I also got the line errors

when you copy and paste the script from the webbrowser (firefox in my case) into SSMS it does not seem to work.

I have now copied...

Would it be possible to amend this to also work on 2008 R2?

Also, seem to get an error when it reaches an offline database (so could be modified to ignore...

I get

...

Unexpected token '}' in expression or statement.

At C:\ListOfLocalAdmins.ps1:3 char:69

+ $admins = $admins |? {$_.groupcomponent â?"like '*"Administrators"'} <<<<

+ CategoryInfo ...

Thanks for this. Looks like something that I could use. A few minor errors, I think many of them are due to website converting from " (double quotes) to ''...

Not a bad suggestion. I have considired this, but not done it.

I dont know whether the last six months worth of data is any smaller in comparison to previous.

My...

Thank you for the responses.

The backups are no longer failing. They were failing due to lack of disk space and this has now been sorted, partly down to allocating more...

Sorry I cannot really answer that.... as the server had been neglected, the backups appear to have failed for some time now.

Not sure it helps, but I noted as soon...