1
  • 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:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following