Haha thanks! 🙂 You are a legend have a good weekend!!!:-D

I keep missing the simple things... sorry and thanks for your help

EXEC ('USE REMOTE_TEST

SELECT DISTINCT QUOTENAME(sm.[Name]) + ''.'' + QUOTENAME(OBJECT_NAME(s.[object_id]))

AS [Table] FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS s

INNER JOIN sys.indexes AS i ON s.object_id = i.object_id...

Damn that was quick!!!!

thanks 🙂

thanks for your guys help will look into it... and get on redgate for more assistance but got a feeling they going to say they dont support the IIS component...

Great article sadly I am a guilty of all those errors 🙂 haha

Thanks for the article

Ive used Spotlight Enterprise manger as well as Foglight both by quest

i would highly recommend Spotlight.. my experience with foglight to be honest not at all a tool i'd ever...

Hey Ray

thanks for the reply mate 🙂

Yes its the strangest thing im on the active node now and i can access the path perfectly ive checked permissions...

Thanks alot

Will definately give that a try

SQL 2005 Enterprize edition!!

Iv tried everything mentioned in this here forum thingie its happening..

Auto shrink is set to false! and still happening

i cant understand this?? can you say wierd:D