thanks for the response; I had considered the DBCC INDEXDEFRAG, but wasn't too sure whether the outcome was timely and considerate of disk space/log size

So in terms of speed is...

This is what I have done in the past; using bcp to drop the data from the table into a file, truncate the table and then reimport the data into...

Thanks for the reponse Michael. Yeah it all makes sense, alas I am no good with code yet, so will have to look at the other solution you offered.

I...

Can anyone point me in the right direction to understand the syntax needed to work with expressions to allow dynamic attachments?

Thanks in advance

Troy

Okay cool - it is good just getting an understanding of what these things mean and how they come about.

I am already using the INCLUDE feature across a number...

Beauty - that could very well be the case!!! thanks for the explaination Crispin.

Cheers

Troy

thanks guys for the feedback - I understand both your points and can appreciate it is hard to say "this is the solution" when it comes to indexing...the part which...

Thanks again for the response - yes I get the same response as you when removing the namespace reference out of the xml.

I cannot remove the reference out of...

Thanks Gail for the reply. Yeah I had sort of figured that it was something to do with the schema definitiion, but if I remove it, the statement doesn't return...

Brilliant - thanks for both the replies, you have offered some ways around the issue I was after, and it is now working!

Thanks again - much appreciated!

Thanks for the post Kevin. I am fully aware that I can add more disk, remove aps, etc etc to gain disk space - I was more interested to understand...

yeah I have been wary of taking these things as gospel too - thanks for the link and the thoughts guys!

Cheers

Hi, Just been playing around more with this and looking further into it and it would appear as though the HTTP connection in VS doesn't want to talk nicely to...

Hi,

Further to this - I have deleted the namespace and recreated it. Previously it was using port 80; whereas now I have changed it to using port 8080. Now it...

The interesthing thing is that the web sites under IIS Admin are "stopped" - and checking the event log initially when booting up it says:

Unable to bind to the...