I want to drop my DB and close all connections before it When I try to do it I receive this message: Cannot drop database "DBName" because it is currently in use. Thanks..

How can I restore DB using T-SQL? I'm working on linux(ubuntu)

I need to be able to establish an ODBC connection through SQL Server authentication. How can I grant permissions for an user with ALL rights on DB? Please help :)

How to convert letters used in phone numbers into digits, i.e. input string '1-800-FLOWERS' should return '1-800-3569377', using a T-SQL? In Oracle, I would have used PL/SQL TRANSLATE function, however I need to do it in T-SQL and there is no similar function in T-SQL. Please take a look at this image - this is the transformation I am looking for Thanks!