database_design

APPNOTE: Copy/overwrite Database Diagrams


— Copy/overwrite Database Diagrams from One Server to Another Server within the same instance.


— Source: PMT_MCD

— Target: PMT_MCD_2


USE PMT_MCD_2

DELETE sysDiagrams

where name in (select name from PMT_MCD.dbo.sysDiagrams)

SET identity_insert sysDiagrams on

INSERT sysDiagrams (name, principal_id, diagram_id, version, definition)

select name, principal_id, diagram_id, version, definition

from PMT_MCD.dbo.sysDiagrams

SET identity_insert sysDiagrams off

email-icon-300x2791

APPNOTE: Broadcast Email

Procedure to Notify all TRMS users of an Outage

Purpose

The following procedure may be used to generate an email message to all the user of the TRMS.

This might be used to notify them of an outage, for example.

Procedure

  1. Use the Data Export utility to export a list of all the users of the application.


  1. Select all the columns you like, but include the Email Address at least:


  1. Export this list to Excel.
  2. Within Excel, remove the users that have no email address, or outside your organization, as desired.


  3. Copy the list of email addresses into the address bar of your email message and send.
database_design

APPNOTE: How to determine if you have SQL Server admin rights

The following will tell you if you have sufficient privilege to create a new database.

The procedure will be to create a temporary database, then drop it, leaving the SQL Server instance unchanged.

Step 1 – Start SQL Server 2008 R2 Management Studio

Typically this is located in :

Start > Program Files > Microsoft SQL Server 2008 R2



You will be asked to connect to an Instance of SQL Server:


Use Windows Authentication. Your DRN account will provide your authorization.

Step 2 – Attempt to Create a Temporary Database

Click the right mouse on the Databases node, and select “New Database…


Call the database JUNK:


Press the OK button.

If no errors occur, then you have sufficient privilege.

Step 3 – Cleanup

The database JUNK will appear at the bottom of the list of databases.

Locate it and right mouse – select Delete


Click the OK button to delete (also referred to as “drop”) the JUNK database.

database_design

APPNOTE: How to determine the version of SQL Server

The PMT is specified to operate on SQL Server 2005 Service Pack 3, or better. This Application Note shows how to determine the version of SQL Server being run and its service pack level.

Instructions – from within PMT

  • Open the Administration area of the PMT.
  • Select the Database tab. You will see the following:


    The version of the SQL Server hosting the PMT database is shown.

Instructions – from within SQL Server

  • Open SQL Server 2005 Enterprise Manager
  • Create a new query on the PMT database.
  • Run the following query:

    SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

  • You should see this:


In both cases, use the following table to identify the service pack of the server:


Reference:

The following link provides greater detail on this topic.

<http://support.microsoft.com/kb/321185>