Karl

Thanks for that.

getting this error ?

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'Sys.master_files'.

Any ideas ?

Karl

Many thanks , looking great.

How would I change it to display results with only the column headers once ?

I.e. no requirement for each databases , only need it once ,...

Karl

many thanks for prompt reply.

Looks very useful , is there any way it can be run just once on each instance to return the stats for all the databases on...

Lowell

spot on many thanks 🙂

Cheers Paul for reply

Well, did as you suggested and removed SQL 2005. Re-installed. No service pack installed yet.

SQL Agent jobs created fine , jobs run fine.

Now about SP2 what do...

ok thanks for that , with SQL 2000 I have looked about but could not see where that is ?

I have inserted install cd and looked through there but could...

John

Many thanks for quick repsonse.

Ok I have that list , can you explain how I go about transferring the owner to another owner ?

Will this effect the app...

Jo

Many thanks for your help , that has worked a treat. Now have to understand fully what is going on.

Many thanks once again

Jo

Many thanks for this , when I try to run the code from /*inserting new values*/ I get an error.

Syntax error. (Missing operator) in query expression '...'.

Trying to run this...

Spot on .. thank you

Thanks very much for this.

Guess it was my fault for not explaining correctly. Need a bit more info.

I need to get the IP address of the machines I have connected...

Karl

Excellent , many thanks , that the fella !

Cheers

many thanks everyone , all good stuff. Keep em coming so I have something to back with !

Yelena

Hi , can connect via the console to both machines , both ways. No problems in stopping or starting any services that way.

That seems to work fine.

Yelena

Thanks for reply.

Have tried both windows and SQL connections.Windows account had sysadmin. Still the same issue on both attempts, the icon stays white !!