Under Cubes I can find dimension but how to find which dimension is coming from which data source ?

I am in SSMS -Analysis Service ,i want to find list of Fact tables and Dimension tables coming from each data source.

we are manually doing for long time,but i need to automate that one.

How to overcome this one ? pls guide me.

if you dont mind can you share any script or batch file to map network drive in start up task.

Can you try the below query.i hope it will help you.

select tbl.[name] TableName,

ind.[name] IndexName,

mn.index_type_desc IndexType,

mn.avg_fragmentation_in_percent [FRAG_%]

from sys.dm_db_index_physical_stats (null, null, null, null, null )as mn

inner join sys.tables tbl on tbl.[object_id] =...

I tried various possibilities,no luck...

here my small doubt i need IIS service in Server or i need to enable SMTP service in server ?

IIS and SMTP services are not available...

I am using my own mail Id for DBmail account.Test mail itself not going.

Other server we are using window authentication credentials only.

I restarted SQL Server Agent also.But no luck.

SMTP Server IP is configured in Database mail Account.but mail is not delivery.Any services i need to enable in the server ?

From other server Database mail is working.

hi all

still i cant find the solution. please help me out.

this part get the latest seqno from table EPOSSDataExtractSequence, this seqno update every 40 min, once the scheduler run...

no bulk insert , reading line by line and inserting in to the table using .net scheduler.

Thanks for the help. we sort out the problem.we rework on the cursor which taking more time.

Really very thanks for all, i will work on it to increase the performance.

thanks alot.