Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Trying to bypass via tsql a database when it is offline


Trying to bypass via tsql a database when it is offline

Author
Message
Erland Sommarskog
Erland Sommarskog
SSC Eights!
SSC Eights! (975 reputation)SSC Eights! (975 reputation)SSC Eights! (975 reputation)SSC Eights! (975 reputation)SSC Eights! (975 reputation)SSC Eights! (975 reputation)SSC Eights! (975 reputation)SSC Eights! (975 reputation)

Group: General Forum Members
Points: 975 Visits: 866
Yes and no.

That is, you can put your procedure in master and call it sp_somename. Then you can invoke it as

EXEC archer..sp_somename

The procedure will then execute in the context of the database you specified.

However, this is not supported and it could break, for instance if Microsoft ships a system procedure with name you use. Or it just stops working.

Note here that the procedure name must start with sp_.

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Patti Johnson
Patti Johnson
SSC Veteran
SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)

Group: General Forum Members
Points: 261 Visits: 949
That is very good news. I found a way of doing the procedure not knowing that you can do it the way you had mentioned. I will try it your way now and determine which is better. Thanks alot for your assistance.

Patti
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search