How can we help you today? How can we help you today?

Exception when changing server connection

Hi,

If you are using SSMS on a test server with a script working on database called MyDb_Dev and then change the connection to a production server that only has live databases, an exception occurs if there is a database called MyDB_Dev that is offline.

Jonathan
fatherjack2
0

Comments

1 comment

Sort by
  • simon.jackson
    Currently we show errors when we can't cache the database it looks like you're writing a query against. Management studio is clever enough to switch your query onto master in the case of offline databases, prompt isn't quite clever enough to realise this yet!

    I've raised the issue in our bug tracking system, and we'll consider changing the behaviour in a future release.

    Thanks

    Simon
    simon.jackson
    0

Add comment

Please sign in to leave a comment.