I get invalid object when I tried to execute sp_msforeachdb

What would be input which I need to apply in this case?

Msg 201, Level 16, State 4, Procedure sp_MSforeachdb, Line 0

Procedure...

Thanks alot

But If the user db .mdf/ldf files gets corrupted at 1PM, is it possible in this case (point in time)?

Following command:

use master

select 'kill',56 from master..sysprocesses where db_name(dbid) =  'PIT_TEST'

Prints nothing: (0 row(s) affected)

I was able to recover the data, simply updating the changed records, but still trying to figure...

Tried according to ALZDBA, still getting same error.  Please see the attachment, as you can see just the background processors are running, closed...

How to create a role which will be member of fixed db role?  Thanks

So users should be scripted on weekly basis in case of DR, databases/users/jobs can be move to other server if you are in standalone environment??

Login doesnt exist on the server but users are part of user db which are need to be fixed on QA server.  Update_one doesnt help either:

sp_change_users_login 'update_one', TestUser, 'TestUser'

Server: Msg 15291, Level...

I get something like..

Server: Msg 15290, Level 16, State 1, Procedure sp_change_users_login, Line 166

Terminating this procedure. The Action 'AUTO_FIX' is incompatible with the other parameter values ('UserName', '(null)').

anybody?

please see the reason above

After running the tracer it shows hostname connections within the network, please advice how to capture TDS packets, is this is something needs to be done by the network...

Getting following error when I tried to run 2nd script:

/*-----------------------------

SELECT NAME AS NameOfFile,

CAST

((SIZE/128.0 -CAST(FILEPROPERTY(NAME, 'SpaceUsed' )AS INT)/128.0)AS INT) AS AvailableSpaceInMB FROM DBNAME..SYSFILES

-----------------------------*/

Server: Msg 208, Level 16, State 1, Line 1

Invalid...

No user DBs are replicated

Anybody???