Use the below one which will give the access in the current database.

sp_helprotect [ [ @name = ] 'object_statement' ]

[ , [ @username = ]...

Hi,

Wht ever steve has suggested will work. In past same i have fixed this kind of issue with the same way.

Hi,

Wht ever the command you have mentioned will work.

once again from master..

===================

Alter database tempdb modify file (name = templog

, filename = 'PATH_TO_NEW_LOCATION_OF_TEMPDB_DATAFILE\templog.ldf')

go

Hi,

Add the log file to the DTS package. I will help you in knowing how dts is running where you are getting error.

Hi,

You can grant the user  sa permission.  Or open a DTS package and manually  try to save a package in the SQL2005 Server.

There is no table  which will provide rollback details to you. Pls check the system tables in the MSDB tables. Where there is a logshipping tables exist it will have...

Hi,

What ever richard has suggested is the best way for you as there is no option to start it automatically.  

HI,

Have you checked what all the activities the users are running.  Sometimes it happens the tranlog grows very badly. If you are not able to find any activities in the server...

Steve is right. Pls proceed with the steve's suggestion. Do reply if still you are not able to identify the issue. 

1. Check for SQL Server Logs if any notifiable errors appeared....

HI,

I need to Monitor the Error Log contents for any new errors are there   in the log. In Case of any new errors found the same has to  send a...

Robert,

Yes you r right i had a issue with sp_rename.

I executed that part  in a seprate step in a job. So that was not a problem.

Hi Udin,

Thanks for the help i have Done it.

Thanks !!!

Let me check this.

Remaning Steps what ever iam performing is the best method available ?

Wht do you feel this. Renaming of table can be done only with sp_rename is...

HI,

Can u say what Kind of backup methods you are following for this database.

1. TO Reduce the database size you have to shrink the database.

2. If you are having a...

Make sure u  r backup has got all the new details which you have entered the the master database .

1. changes in databases.

2. Changes in server settings