Viewing 15 posts - 8,236 through 8,250 (of 9,253 total)
also, if i remember correctly truncate will reset any seed\incremental value on ID columns,etc
April 15, 2009 at 6:57 am
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...
April 13, 2009 at 4:47 pm
RBarryYoung (4/13/2009)
I...
April 13, 2009 at 10:10 am
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...
April 13, 2009 at 6:35 am
presumably you are using sql2005 standard x64?
you may want to set the min memory to something sensible!
April 13, 2009 at 6:19 am
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...
April 13, 2009 at 6:16 am
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!
April 12, 2009 at 2:24 pm
has the TCP/IP port number been changed under TCP/IP settings?
April 12, 2009 at 5:38 am
dobrien (3/11/2008)
-c(still don't know what this is for)
David, this parameter stops the service being updated (i.e. running/stopped/etc) in the services.msc
April 12, 2009 at 5:36 am
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
April 11, 2009 at 9:41 am
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...
April 11, 2009 at 6:13 am
i need to populate a treeview object with fixed drives and their folders
April 11, 2009 at 5:29 am
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 😉
April 11, 2009 at 3:51 am
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...
April 11, 2009 at 3:36 am
incidentally, exactly where did you change the sql service account credentials from local to domain user?
April 10, 2009 at 4:58 pm
Viewing 15 posts - 8,236 through 8,250 (of 9,253 total)