Your telling me... 🙂

Its one of those vendor apps that like to come in and have sysadmin access to everything... this is not the only bad part of this product......

yes, that would be handy, I hard coded the database name when I was playing with that inner query, but I imagine the for each loop grabs the database names...

Wrong!

Ok I know now...

I just extracted that inner query and played with it..

select

a.FILEID,

[FILE_SIZE_MB] =

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

[SPACE_USED_MB] =

convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)),

[FREE_SPACE_MB] =

convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,

NAME = left(a.NAME,15),

FILENAME = left(a.FILENAME,60)

from

wslogdb70_2.dbo.sysfiles a

where filename like '%wslogdb70_%.mdf'

I think this will...

ok, thanks,...

replicating 2 databases into our sandbox and I'll give that script a try...

So I think all I need to do is add an AND to where clause such as

...

from

?.dbo.sysfiles...

I hope, here's what I did...

- I got domain user ID created by our security department. It only has domain user rights.

- Created a credential and used that domain user...

Humm... yeah I read that somewhere on the net during my initial investigation of my issue... I did thnk of another solution of adding a role to the MSDB database,...

We have a similar account for us DBA's here also, use to administer database servers. The services on the other hand are not managed by us, but by our security...

yeah, that's the part that wouldn't work when we tried using our configured domain account for this service.... The only way to get it started was to have that domain...

I actually did have the renaming part done as a seperate step in the scheduled job, but there was one reason why I put it directly in the SP, I...

nope, I think thats where the problem lies.... Is there a way to do this withot having to use xp_cmdshell, I know using this presents security hole. maybe this...

oh yeah, as I mentioned, it works like 95% of the time... for some odd reason, about once a week it will fail randomly, I'm trying to develop a pattern...