Sorry Mate, I didn't quite pick it up before. Now I get the point. Thanks very much. That should help me.

Thanks again

Thanks very much mate. The 'DB_Name()' is going to be helpful for me on this. I shall have a go at it.

Thanks

Thanks for the reply. I agree that just backing up and not shrinking would help the performance. If I backup the log with truncate option whilst replication is on, we...

Thanks for the help.

Thanks very much for the help.

Thanks very much. This is much quicker way. I actually ended up having a temp table (same structure as 'XP_sqlagent_enum_jobs' return values) and inserted the data from 'XP_sqlagent_enum_jobs' into it....

Thanks Jamico, It worked. Thanks very much

Thanks Steve. The idea is to create an dynamic datamart which could be installed over any application database system. So the actual database will not have any triggers written on....

Thanks Scorpion_66. The idea is to develop a installable version of an application that will create a datamart for any database. So instead of adding to the database setup on...