SQL Admin Reports

[SSG]

Are there any ready to reports or report templates in SQL Server 7.0 that
inform DBAs about:

1. Space Used by various databases on the server.
2. Users and their privileges
3. Any other diagnostic reports.

sp_spaceused and DBCC sqlperf all operate at the database level. Is there
anything that works at the server level?

[DaveSatz]

check these out for a little help:
http://www.dbmaint.com/utilproc.html
http://www.geocities.com/laplassoft/

--
HTH,
David Satz
Principal Software Engineer
Hyperion Solutions
->Using SQL Server 7.0 SP3/6.5 SP5a/Cold Fusion 4.5.1 SP2/VSS
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------

"SSG" <sgodkhindi@email.com> wrote in message
news:3ac0e51b$1@news.devx.com...
>
> Are there any ready to reports or report templates in SQL Server 7.0 that
> inform DBAs about:
>
> 1. Space Used by various databases on the server.
> 2. Users and their privileges
> 3. Any other diagnostic reports.
>
> sp_spaceused and DBCC sqlperf all operate at the database level. Is there
> anything that works at the server level?
>
>

[Phill]

Also have a look at Change Manager by Embarcadero.
http://www.embarcadero.com/products/administer/cmdatasheet.htm

"SSG" <sgodkhindi@email.com> wrote:
>
>Are there any ready to reports or report templates in SQL Server 7.0 that
>inform DBAs about:
>
>1. Space Used by various databases on the server.
>2. Users and their privileges
>3. Any other diagnostic reports.
>
>sp_spaceused and DBCC sqlperf all operate at the database level. Is there
>anything that works at the server level?
>
>

[Geir O. Hansen]

"SSG" <sgodkhindi@email.com> wrote:
>
>Are there any ready to reports or report templates in SQL Server 7.0 that
>inform DBAs about:
>
>1. Space Used by various databases on the server.
>2. Users and their privileges
>3. Any other diagnostic reports.
>
>sp_spaceused and DBCC sqlperf all operate at the database level. Is there
>anything that works at the server level?
>
>
Hello
Start with SQL Query Analyser,
select Transact SQL Help, and system tables.
As you can see, there is a lot of information to collect...

Try this
to se the size of any of your databases, start a new VB prosjekt
Add a command button, one label and one ADO Datagrid
Paste this code:

Private Sub Command1_Click()
'references: Microsoft Scripting Runtime
'ADO 2.5/2.6
'Controls ADO Datagrid
Dim db As ADODB.Connection
Set db = New ADODB.Connection
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
With db
.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=sa;Initial Catalog=Master;Data Source=GEIRH"
Edit the line above
.CursorLocation = adUseClient
.Open
End With
With rs
.ActiveConnection = db
.CursorLocation = adUseClient
.CursorType = adOpenForwardOnly
.LockType = adLockReadOnly
End With
Set rs = db.Execute("SELECT name,dbid,filename FROM sysdatabases")
Set DBGrid1.DataSource = rs
End Sub

Private Sub DBGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
On Error GoTo err_trap
Dim m As FileSystemObject
Dim f As File
Set m = New FileSystemObject
Set f = m.GetFile(DBGrid1.Columns(2).Text)
Label1.Caption = f.Size & "-" & f.DateLastModified
Exit Sub
err_trap:
'When loading clear error in rowcol events
Resume Next
End Sub

Geir O. Hansen
n-Tier Consulting

[SSG]

Thanks David for the suggestion.
"DaveSatz" <davidsatz@yahoo.com> wrote:
>check these out for a little help:
>http://www.dbmaint.com/utilproc.html
>http://www.geocities.com/laplassoft/
>
>--
>HTH,
>David Satz
>Principal Software Engineer
>Hyperion Solutions
>->Using SQL Server 7.0 SP3/6.5 SP5a/Cold Fusion 4.5.1 SP2/VSS
>(Please reply to group only - emails answered rarely)
>-----------------------------------------------------------------
>
>"SSG" <sgodkhindi@email.com> wrote in message
>news:3ac0e51b$1@news.devx.com...
>>
>> Are there any ready to reports or report templates in SQL Server 7.0 that
>> inform DBAs about:
>>
>> 1. Space Used by various databases on the server.
>> 2. Users and their privileges
>> 3. Any other diagnostic reports.
>>
>> sp_spaceused and DBCC sqlperf all operate at the database level. Is there
>> anything that works at the server level?
>>
>>
>
>