Is it possible to send database name as parameter to Stored procedure ?

Create Proc dbo.MyTestPRoc
    @dbname Varchar(25)
AS
    USE @dbname

    SELECT * FROM YourTable --Table from your selected database
GO

//If you want to pass dbname and also table name
Create Proc dbo.MyTestPRoc
    @dbname Varchar(25),
    @tblname Varchar(25)
AS
    USE @dbname
    
    SELECT * FROM @tblname 
GO

USE @DBName
GO

DECLARE @AccountName nvarchar(260)
SET @AccountName = 'DotnetSpider\Anil.Pandey'

if not exists (select name from syslogins where name = @AccountName and hasaccess = 1 and isntname = 1)
BEGIN
EXEC sp_grantlogin @AccountName
END
GO

http://stackoverflow.com/questions/3943823/sql-server-how-to-get-a-database-name-as-a-parameter-in-a-stored-procedure