Determine Index Size

Can anyone help me figure out the size used by my indexes?
TIA
RobEXEC sp_spaceused
optional:
EXEC sp_spaceused '<table name>'
--
Jacco Schalkwijk
SQL Server MVP
"Rob Diamant" <zzjunk.robd@.usi.com> wrote in message
news:eBBqoa0uDHA.540@.tk2msftngp13.phx.gbl...
> Can anyone help me figure out the size used by my indexes?
> TIA
> Rob
>|||Use can query the "used" column in sysindexes table for Indid = 1 , indid
between 2 and 249
select object_name(id) as Table_name,sum(used) from sysindexes
where indid between 1 and 249
group by object_name(id)
Thanks
Hari
MCDBA
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:#b4gKg0uDHA.1756@.TK2MSFTNGP09.phx.gbl...
> EXEC sp_spaceused
> optional:
> EXEC sp_spaceused '<table name>'
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Rob Diamant" <zzjunk.robd@.usi.com> wrote in message
> news:eBBqoa0uDHA.540@.tk2msftngp13.phx.gbl...
> > Can anyone help me figure out the size used by my indexes?
> >
> > TIA
> >
> > Rob
> >
> >
>sql

Determine if Service Pack 1 is installed on SQL 2005 ?

How can I determine if SP1 is installed for SQL Server 2005?

TIA

select @.@.version

Frank

|||

Since this is the SSIS forum, I thought a SSIS specific method my be usefull. Since you don't have to install the DB engine, you may just have SSIS installed, so the normal @.@.VERSION does not work anymore. One method is to check the File Version of the SSIS Service, C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.exe

Right-click the file and select Properties. On the Version tab check the File Version property. RTM shows 9.00.1399.00, SP1 shows 9.00.2047.00

Strictly speaking the MsDtsSrvr.exe may not always be updated with a service pack or patch, so the version may reflect an older level. An alternative method is to check the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup, values Version and PatchLevel give the service pack and hotfix level respectively. The RTM values are both 9.00.1399.06, and SP1 is 9.1.2047.00. Note the 9.1 rather than 9.0 for the SP1 version.

|||Actually "select @.@.version" works well in 2005.