that looks interesting

ryan - i beleive that is your only way - sql is trying to create the tempdb files when it starts and it can't, so it shuts down.

as far as...

MisLead (5/15/2012)

---

Does anybody no sql command in ADO.NET connection support "order by " clause or if there is a work around for it. I am trying to avoid ...

ive found the easiest way to do this is to mount a new drive with the same drive letter as the failed one.

then boot sql server and modify the...

a usefull insight into the impact - there are many detailed articles on this, but none that are as simple and clear....

one thing you missed though... your server has...

just an update

after some testing we have adopted a different approach - it wasn't service broker that was the problem (as mentioned in the previous 2 posts)

the 64 bit...

it's not been implemented by quantix has it ?

i think i hit the jackpot

http://msdn.microsoft.com/en-us/library/dd576261(v=sql.100).aspx

finally after 2 days worth of digging 😀

i did find this interesting snippet

http://datageekgal.blogspot.co.uk/2008/07/sql-server-service-broker-archival.html

ARCHIVAL TIP #5: TUNE THE NUMBER OF QUEUE READERS

I've yet to find a solid recommendation for choosing the number of queue readers (threads) to activate...

thanks for the reply lynn

i have to assume that the files will be constant and a 24*7 basis, and that the number of files will be more than a single...

its an old script from sql 2000 days - sorry

lookking at it now

Lynn Pettis (5/14/2012)

---

Going with the "it depends" answer. How many files are being processed, how often are they processed, how big is each file that is being processed, how...

ooops - slight tweak to my code

create table ##res(db varchar(100), fileid bigint,filesize float,spaceused float,freespace float,name varchar(255) ,fname varchar(max))

exec sp_msforeachdb 'use ? insert into ##res select ''?'',* from (

select

a.FILEID,

[FILE_SIZE_MB] =

convert(decimal(12,2),round(a.size/128.000,2)),

[SPACE_USED_MB]...

i dont think you need SSIS to do this

you should be able to modify the script below to do what you need

create table ##res(db varchar(100), fileid bigint,filesize float,spaceused float,freespace...