also, if i remember correctly truncate will reset any seed\incremental value on ID columns,etc

yes, i thought of that but running it through SSMS the query takes a short while and thats just on my laptop. Imagine on a server with 4 or more...

RBarryYoung (4/13/2009)

---

I apologize, but unfortunately, because of conflicts between VS 2005/.net 2.0 and VS 2008/.net 3.5, my SMO dev environment is down right now so I cannot effectively test anything.

I...

this should cut down on the amount of procedures returned

select 'exec sp_helptext ' + name from sys.objects where type = 'P'

and is_ms_shipped <> 1

order by name

you dont want...

presumably you are using sql2005 standard x64?

you may want to set the min memory to something sensible!

hmm ok, the enumavailablemedia is pretty straight forward but i cant find any usage info for enumdirectories. Currently my treeview is populated with 2 logical drives and some folder entires...

set up a simple server side trace and leave it running for a day or so. Should be able to find out/what is changing the status!

has the TCP/IP port number been changed under TCP/IP settings?

David, this parameter stops the service being updated (i.e. running/stopped/etc) in the services.msc

Flo\Barry

thanks a lot, i only need the drive name and then the folders underneath. I'll check out the items posted and see how i get on

Regards

Perry

samsql

to start, can you please post the following info

SQL server version/edition:

OS version/edition:

min memory for sql:

max memory for sql:

you say the server has 16GB ram is that correct?

what exactly do you...

i need to populate a treeview object with fixed drives and their folders

did you remember to add the extra required resources under cluster administrator for disk, IP, Name, etc.

your 2nd instance will use separate disk resources, etc 😉

i take your point, the point of investing in a SAN though is you can lose a switch or a disk and the array is still available. The OP states...

incidentally, exactly where did you change the sql service account credentials from local to domain user?