Following on from the above I would like to know of a way to find the size and available space of different database files.

I tend to use these scripts for space...

reporting services isn't cluster aware.  I would have thought you could simply pop the cd in run and re-run set-up to add the extra components on each physical server?

what would be intersesting for would be how you would best partition your filesystem - how do marry the best practice of separate disks and channels for tempdb, data files,...

How do you transer password when the login pre-exists though? 

You would have to script out any exisiting roles, then drop these, then drop the login then add the logins and...

the t-sql shutdown command worries me! -what if someone could enter the command with some sort of sql injection!  Could this be disabled in some way?

it's one of those days.  I disconencted and reconencted and AOK!

ignore this email I was on the wrong server (ggot mixed up between our hostspare and live system). !

answered my only problem  - the object owner was the previous service account, changed the db_changeowner.

That's smashing Nicholas, works a treat so it seems.  There are a few errors whereby for some reason I have a few logins at the database level that do not...

I don't have any installed on the same machine, but I cam accros a gotcha the other day where I tried to restore the master database from sql enterprise over...

I looked at Litespeed and found it to be way too expensive for us, for their standard product their pricing is below, they would offer some...

I had problems on another user db where by I had to run checkdb, repair fast.  I found that I had to run the command several times to correct the...

yes all the objects and stored procedure are owned by the dbo.

Oh, I thought if you had permissions to execute a stored procedure, then you could run it and that sproc would do anything for you it was supposed to do, such as...

Well I've been stumped on this one, I've had to grant him explicitly select permissions despite not finding any deny's on the object.

In another permissions problem I'm unable to find...