I will try to do thri SSIS as Millions Transactions are in question or i will create more Publishers & divide Tables(Articles) within them, so that i can have more associations...

Thanks for your all help & above mentioned link is very helpfull. thanks again.

thanks for your all help & suggestions.

I hope this will be helpfull.

http://www.sqlmag.com/articles/index.cfm?articleid=93150&

thanks.

http://support.microsoft.com/?kbid=555128

http://msdn2.microsoft.com/en-us/library/ms179313.aspx

i hope this will help.

if you are going to install SQL 2005 on top of SQL 2000 as named instance, first on test env........ before moving to production. IMP factor is about .NET framework...

thanks for the link & help.

C# or VB.net with SQL 2000/2005 is good match & paid well.

Never mind, i got the answer for design window. thanks

Thanks for your reply, i do have question. when you say design window whatyou mean by that. can you please tell me how to populate that design window.

check the Email profile if some thing as changed & also coordinate with Exchange Admin to make sure that nothing as changed from there ends.

Thanks

This is an open wide error which can point to Users Role/Login, Re-complie of OLD SP, DB_OWNER role is missing when you migrate/transfer Database/tables from SQL 2000. worst come you...

Please see the link, is very helpfull.

http://www.informit.com/articles/article.asp?p=21644&rl=1

Thanks

1> This article from Tibor Karaszi may be helpfull to you.

http://www.karaszi.com/sqlserver/info_corrupt_suspect_db.asp

2> This i found from another resource (Thanks to Satya SKJ)

This causes if any data file...

This is not the solution & i think you might have done some research already like:-

a> Event log files on USB 2.0 NAS

b> Not sure if Alert emails have...