here is my query:

DECLARE @s-2 GEOMETRY

SET @s-2 = ( SELECT geom

FROM dbo.SHAPE...

I closed and reopened it and it still shows mdf only.there are some tasks running on my workstation,once they are done i'll restart my workstation.I'll post the results.At the same...

Any idea what is wrong with my SSMS?

OK.I was connecting to this server from my workstation.When i actualy opened SSMS from that server it shows both files.Looks like problem comes from my workstation.

type_desc data_space_id name physical_name state_desc size max_size growth

ROWS 1 PRD E:\DB_Data\PRD_COPY.mdf ONLINE 1862400 -1 38400

LOG 0 PRD_log G:\DB_Log\PRD_COPY_log.LDF ONLINE 704000 -1 10

type_desc data_space_id name physical_name state_desc size max_size growth

ROWS 1 PRD E:\DB_Data\PRD_COPY.mdf ONLINE 1862400 -1 38400

LOG 0 PRD_log G:\DB_Log\PRD_COPY_log.LDF ONLINE 704000 -1 10

type_descdata_space_idname physical_name state_descsize max_size ...

fileidgroupidsizemaxsizegrowthstatusperfdbidnamefilename

111862400-138400208PRDE:\DB_Data\PRD_COPY.mdf

20704000-110104864208PRD_logG:\DB_Log\PRD_COPY_log.LDF

There is only 1 row for mdf

All i see is mdf file

Sorry, i can't.

Yes.Finaly!!!!!!!!!!!!!!!!!!

Ok.here are the steps i did:

Create Credentials

Create Proxy

From Export Data i saved SSIS in MSDB(instead of file system)

Create Agent job using Proxy account.

Thank you very much for your time and...

DontSaveSensitive

DontSaveSensitive

yes