General tab on publication property has subscription section. One of the options is "Subscriptions never expire". 

Sorry for the confusion. I had to drop the subscription and recreated successfully. Issue is...

I have it as never expires.

I have similar issue posted recently. Please visit to find more information.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=168805

Windows 2000: SQL Server 2000: SP3

DB size: about 5 GB

dbcc checkdb was not able to read pages. I had nightly full backup at(3:30 am)and tran backup every 3 hours (Between...

Following are the error messages:

SQL Server log has following error messages:

SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..

***********************

The...

Thanks for your help.

sincerely,

Hemant Trivedi

It's usually between 5 and 6 AM. SQL Server backup jobs run between 8:00 pm to 9:00 pm. It takes less than 3 minutes for each backup to complete. Backups are on disk...

Unfortunately, We do not have EMC frame tools. Only one third party component that we run is veritas backup utility for tape back up every night.

You may have to modified based on your requirements.

Senior SQL Server DBA is needed requiring 4+ years of MS SQL 7/2k DBA experience on Production Environment....

http://www.sqlservercentral.com/scripts/contributions/450.asp

"Change DTS package owner"

This link may help you to change the dts package owner.

Thanks.

I was trying to delete the post but it does not have feature to delete your own post.

thanks.