Just check the query.It must be using some table of the database B also. Also running the profiler will help u a lot.

Also just check the what is happening in...

Hi

the problem is that it is doing an update and is blocking other statements from getting executed. So I have no other option but to the start the sql server ...

No it is not.It was there for almost 2 days with the runnable status. I use sp_who2 active.

Well I'm trying to figure that out. It is getting stuck at a particular updated statement. But why is the process still running when I have killed and  rollback completed...

Well the DTC was not running.Now I have started it but it is still giving the same error

Cannot Create an Instance of The DTS Package

Well the login has been created and I have associated with the suer also but now there is one more problem when In EM>>Security>>Login--I click on this login then it...

Thanks a lot Clive. It worked..

No I'm not able to add the login.It is saying that the suser or role already exists in the database.

We dont have the backups of the master and msdb databases.

well check for the login which you are using to open the enterprise manager and see what is the default database given for that particular login. The error message is...

From BOL

ALTER DATABASE Test1

MODIFY FILE

   (NAME = Test_log,

   SIZE = 20MB,

MaxSize=80MB 

&nbsp

GO

CREATE TABLE [dbo].[calllist] (

 [I3_RowId] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [PhoneNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [Zone] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [Status] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [CampaignName] [varchar]...

Hi

Are you doing the backups through the Database Maintenance Plans.

If yes then you need to go to the Transaction log tab and there u can set the frequesncy of the...

hi

I had got a script from here only where u need to put the login and u will get the objects owned by that login.

set nocount on

create table...