dcsimg
Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed


Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Jun 23, 2004

MSSQL Server Reporting Services: Managing Reporting Services: Data-driven Subscriptions, and External Data Sources for Subscriber Data - Page 5

By William Pearson

The new database appears among any other databases that were already in existence, as shown in Illustration 10.

Click for larger image

Illustration 10: The New Database Appears (Circled)

Now let's create a table to contain our Subscriber information.

14.  Expand the RS_Subscription database by clicking the "+" sign to its immediate left, from the left pane in the Management Console, as shown in Illustration 11.

Click for larger image

Illustration 11: Expand the RS_Subscription Database

15.  Right-click the Tables node within the expanded database.

16.  Select New Table ... from the context menu that appears, as depicted in Illustration 12.


Illustration 12: Select New Table ...

The Table Designer appears. Here we can easily create columns and other table details.

17.  Add the columns and details depicted in Table 1 to the appropriate places in the Table Designer grid.

Column Name

Data Type

Length

Allow Nulls

Description

Participant

Varchar

50

Unchecked

Subscriber Name

File_Share

Varchar

165

Unchecked

File Share Qualified Name

Identification_No

Varchar

50

Unchecked

Associate ID Number

Media_Format

Varchar

50

Unchecked

Report File Type

Parameter

Varchar

50

Unchecked

Filter Parameter

Table 1: New Table Construction Details

Once the information in the table is entered, the Table Designer grid will appear as shown in Illustration 13.


Illustration 13: The Completed Table Designer Grid

18.  Click the Save icon, depicted in Illustration 14, to name and save the new table.


Illustration 14: The Save Icon

The Choose Name dialog appears.

19.  Enter the following as the table name:

SubscriberDetails

The Choose Name dialog appears as shown in Illustration 15.


Illustration 15: The Completed Choose Name Dialog

20.  Click OK.

21.  Close the Table Designer grid by double-clicking the Enterprise Manager icon to the left of the Save icon (circled in Illustration 16).

NOTE: Be sure to double-click the correct icon - the one on the Table Designer bar, not the one on the Management Console bar, as is noted in Illustration 16.


Illustration 16: Closing Table Designer

Once Table Designer closes, we see the new SubscriberDetails table, among the system tables of the RS_Subscription database, as shown in Illustration 17.


Illustration 17: The New Table Appears ...



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM