Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Changes the database which specified spid context to the specified database Expand / Collapse
Author
Message
Posted Tuesday, June 4, 2013 10:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 6, 2013 7:12 PM
Points: 2, Visits: 7
hi,
I want changes the database which specified spid context to the specified database

A spid:53, current database :test
B spid:54, current database :master

now, i'm B, I want change A current database to master also, what should I do? TSQL.
Post #1460023
Posted Wednesday, June 5, 2013 2:11 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:02 AM
Points: 42,470, Visits: 35,543
You can't change someone else's database context. Find whoever's running session 53, ask them to change to master.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1460073
Posted Thursday, June 6, 2013 7:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 6, 2013 7:12 PM
Points: 2, Visits: 7
THX!
Post #1460933
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse