-
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'+...
Last updated: -
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 ?
Last updated: -
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
Last updated: -
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?
Last updated: