decided to help myself out and change some data between the inserts so hopefully! it should show something.. as nothing will have changed otherwise and a blank screen is maybe...

Bit better build and some data!

TABLE for data

create table dbo.tempserverconfig (

id int identity (1,1)constraint PK_tempconfig_id primary key clustered,

servername sql_variant,

instance sql_variant,

[name]sql_variant,

value sql_variant,

value_in_use sql_variant,

[date] date

)

Insert data

insert into dbo.tempserverconfig ...

Hi and thanks for the quick replies!

Eugene Elutin

Ill write a script for putting data in there. Thanks I should have done that when i orginally posted :/

weberharter

Thank you for...

Well you are a genius...

very simple.. and rather annoying on my part....

thank you!

After some incredibly simple and effect advice from a friend.. I looked at the Install logs to find out why it was stopping!

Very simple.. coping the config file that...

I don't use it myself but i only hear good things about the SSMS Tools pack by Mladen Prajdic, I think that does what you looking for and works on...

UPDATE!

So I commented out

; UIMODE="Normal"

and changed

IACCEPTSQLSERVERLICENSETERMS="True"

from 1 to TRUE.

Still not working.. Ive tried changing QUIET to False (and turning either QUIET on or QUIETSIMPLE is wrong)...

Thank you sir,

Id managed to get this far! yours is a lot better!!!

SELECT

p.permission_name ,

p.state_desc ,

o.name,

o.type_desc

FROM sys.database_permissions AS p

JOIN sys.objects AS o

ON p.major_id = o.object_id

ORDER BY...

thanks Gail!

good to know..

Hi all,

Thanks for all the replies,

michael.higgins

Thanks for another method! reall helpful to see alternate ways..

GilaMonster

Interesting, so when using dynamic sql you never put in GO? How is it...

Sorry Paul missed your post!

ill take a look at them when i do it again.. hopefully help track it down some more...

guessing it has to be some sort of...

hi!

yes i ran them i ssms.. it was against the same database / machine seemed to get stuck but did finish eventually.. nothing else was happening on the box.

Ill...

Thanks Evil..

makes sense!

Hi Evil 😀

So having no cluster Indexs on any tables and a few non-cluster is normal? i have a really small set of dbs to look at so...

Thanks Gail 🙂