Need to use the database name while creating the role

I need to create 2 database roles(need to write the script for this task) databasename_dbo_reader and databasename_dbo_writer for all the databases on a server. I have tried the below Declare @databasename sysname SELECT @databasename = (SELECT DB_NAME()) exec ('CREATE ROLE'+...

PrasannaSql5 pointsBadges:

How can I write a SQL query to get the database name ?

How can I write a SQL query to get the DB name ? Usually we use SELECT DB_NAME() AS DataBaseName, but at that time teh DB is in use. If we didn;t write use [dbname][/dbname], is there any way to get the DB name ?

KulkarniMandar5 pointsBadges:

anybody can tell me that how to create setup which will accept database name & server name

anybody can tell me that how to create setup which will accept database name & server name trhough which i can create database in perticular server during setting up the application. i mean to say i don want create manually in sql Server, which should be created during sepup only

Vshikarpursan5 pointsBadges:

Missing Database Name and toolbar

Why does the name of the database and the associated toolbar not show up when I look at the list of tables IN that data base. It does for most of my databases but not for one of them. How do I fis this?

LarryThompson5 pointsBadges: