Check current database name by using DB_NAME() : db_name « System Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Functions
3. db_name

5> USE Northwind;
6> DECLARE @db AS NVARCHAR(258);
7> SET @db = QUOTENAME(N'pubs');
8> EXEC(N'USE ' + @db + ';');
9> SELECT DB_NAME();
10> GO