Hi,

Surely if you can extract the SA Hash from the syslogins table and then crack it , this is a security hole.

not being pedantic , just an overthought

Matt

So is :-

select * from syslogins

Not an issue then?

Sorry my bad , i looked at the code and it wasnt bounding i

So i chnaged it slightly

SELECT DB_NAME() AS DatabaseName, Object_name(i.object_id) AS TableName, i.index_id, name AS IndexName,...

Because when i execute this i get the following error:-

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "a.index_id" could not be bound.

Removing the AS TableName syntax removes this...

Thanks , not to be pedantic , the code was wrong on the Object_id and had to omit as Table_name(see below)

SELECT DB_NAME() as DatabaseName , Object_name(a.object_id), a.index_id, name, avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats...

Have you tried:-

EXEC master.dbo.sp_configure 'show advanced options', 1

RECONFIGURE

EXEC master.dbo.sp_configure 'xp_cmdshell', 1

RECONFIGURE

Matt

Can you not put at the top of the script

Use [Master]

go

Would be a lot simpler