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...

i think this should give the same results and be quicker

but without data i can't prove it

LEFT OUTER JOIN

(SELECT DsSupcode,DsLocationCode,TerminalNumber,MIN(recid) as recidmin FROM MOC_DT.dbo.TCN_Xref

WHERE

AND (group by TerminalNumber,DsLocationCode,DsSupcode )...

employ good database administrators 🙂

brillian - thanks -

"The session keys for this conversation could not be created or accessed. The database master key is required for this operation."

OOPS - forgot to create the...

oh - and i also forgot to say i switched the message type to VALIDATION=NONE just in case it was badly formed XML, didn't fix the problem

John Bates-251278 (5/11/2012)

---

Thanks, Michael.

No, I'm trying to avoid using Linked Servers.

With CMS you can query many servers via a single query. Info for all your central management servers is returned.

But...

tburk 5368 (5/10/2012)

---

I have this access query that I need to convert to sql and not quite sure what to use.

UPDATE Attribute_Data

SET Attribute_Data.AttValue = Int([AttValue])

WHERE (((IsNumeric([AttValue]))=-1) AND ((Right([AttValue],2))=".0"))

OR (((IsNumeric([AttValue]))=-1) AND...

komal145 (5/11/2012)

---

entry_id sys_Routing_Action sys_WkfStep_Current

123 ...

was i too harsh on this chap??

as for stored procedures - well frankly if your manager doesn't know how to give you permissions to add stored procedures then he should...

there is no harm in looking at the market and seeing what options are available - even go for an interview or two ... you don't have to accept the...