same thing happens when i try to connect to localhost. ( im using http://localhost/reportsvd/Pages/Folder.aspx , as i configured the reporting manager virtual directory to be reportsVD).

how do you delete...

it doesnt. ive tried this exactly with the sql server service account and my account, both of which have admin access in this case. even tried it with Domain\servername$ but...

one of the first things i tried, under my credentials, and...

I tried this but no joy. I found in the error logs an error saying "Login failed for NT Authorityetwork service". I added this account as a logon with admin...

cool, thanks, the query works,however i should have been clearer. i cant do this via joins. a subquery will not be very efficient when there are many thousands of rows...

please ignore. i was doing all sorts of joins to try to resolve this. just needed a

" select max(orderRenewalID).......having count(orderrenewalRef)<=1"

Apologies for the unnecessary post.

absolutely correct Andreas. I can see now there are a number of tables with indexes that are not regularly used ( although the server wsa rebooted only 3 days ago...

what about for table reads and writes? again, im aware of read and write info for indexes in the DMV's, but not for the actual table.

i could write a query...

checked that already, there is only index info in the dmv's, but nothing for table size. all i can find to determine tablesize is sp_spaceUsed, but id much rather find...

cool. thanks guys. i was just playing with sql in a moment of bordom and then wondered how to find the LSN. you have answered my questions perfectly. i wonder...

yes, im aware of this, i was just wondering if there was something i missed out on, as these two lines contradict eachother.

is member is perfect. im playing with resource governor and want to write a classifier UDF. this should work nicely. thanks a mil.

i was afraid of that. unsafe assemblies is disabled on my system for security reasons. thanks anyway

actually, instead of calling old OLE commands, is there a way of calling .NET commands instead of using Scripting.filesystemobject?

i would like to try the sp_OACreate method of doing this. Ive tried to look it up online ( spent the last 45 mins) but all i can find out...