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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
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


















Thanks for your registration, follow us on our social networks to keep up-to-date