Does SQL Server 2005 Workgroup edition support scheduling report?

Hello,

In the feature list of workgroup edition, it says Reporting services is included.

After I finally installed it, the reporting service is there as expected. But what is missing is the subscription tab in the report manager. Then I went to Reporting service Configuration Manager, and I saw emailing setting is there (which indicates scheudling and emailling is supported), then I setup valid sender email address and SMTP server, but the Subscription tab is still missing.

Could anyone (from microsoft) tell me whether emailling and scheduling are supported in Workgroup edition or not?

Thanks a lot!

Details about available RS features per edition can be found here: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

Subscriptions are available for Standard Edition and Enterprise Editions. Data-driven subscriptions are Enterprise Edition only.

-- Robert

sql

does MSSQL have the ability to do "named row types?"

Hi all. We have a mix of informix and mssql server and I want to know
if something we do in informix has an analogous feature in MSSQL. We
can define a "row type" in informix, like so:

create row type name_1(fname char(20),lname char(20));

The when we create any table that includes a first and last name, we
do so using this row type like so:

create table sometable(name name_1, some column,...etc)

This allows us to set a standard for certain common fields and avoids
having different developers build the same type of field in more than
one way, different lengths, etc.

Is there a similar function in MSSQL server?sumGirl (emebohw@.netscape.net) writes:
> Hi all. We have a mix of informix and mssql server and I want to know
> if something we do in informix has an analogous feature in MSSQL. We
> can define a "row type" in informix, like so:
> create row type name_1(fname char(20),lname char(20));
> The when we create any table that includes a first and last name, we
> do so using this row type like so:
> create table sometable(name name_1, some column,...etc)
> This allows us to set a standard for certain common fields and avoids
> having different developers build the same type of field in more than
> one way, different lengths, etc.
> Is there a similar function in MSSQL server?

In SQL 2000, no.

In SQL 2005, which currently is in beta, you can define structured types
in CLR languages like Visual Basic or C#, but it's not really the same
thing as the Informafix feature. I assume that in the Informix case you
can still say:

SELECT fname FROM sometable WHERE ...

and thus refer to the individual columns directly. With a CLR type in
SQL2005 you would have to say:

SELECT name.fname FROM sometable WHERE ...

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Documenting and searching a schema

Hi experts,
is there any external tool or feature within SQL Server 2005, which
enables a searchable documentation of schemas?
What I would like to do is to add descriptions to tables, columns and
foreign key relations describing their meaning in detail. By the term
"description" I do not mean a meaningful name, but (where required) a
longer, formatted text. Additional a google-like keyword search would
be nice, to be able to find matching elements, like e.g. all tables or
columns containing "customer" in the description text. The list of
search results should list the matching elements and show the first
few words of the description (very similar to the way google lists its
search results). If an element from the list is choosen, then the full
description should become visible. If the found elements could then be
dragged and dropped directly to a query builder - that would be
perfect!
As I don't think that I'm the first one thinking about enabling
documentation and search on database schemas, there should be tools
already existing for that purpose. But as I don't know any of them -
could you please suggest me some?
Kind regards,
Max
(send.me.all.email@.googlemail.com) writes:
> is there any external tool or feature within SQL Server 2005, which
> enables a searchable documentation of schemas?
> What I would like to do is to add descriptions to tables, columns and
> foreign key relations describing their meaning in detail. By the term
> "description" I do not mean a meaningful name, but (where required) a
> longer, formatted text. Additional a google-like keyword search would
> be nice, to be able to find matching elements, like e.g. all tables or
> columns containing "customer" in the description text. The list of
> search results should list the matching elements and show the first
> few words of the description (very similar to the way google lists its
> search results). If an element from the list is choosen, then the full
> description should become visible. If the found elements could then be
> dragged and dropped directly to a query builder - that would be
> perfect!
> As I don't think that I'm the first one thinking about enabling
> documentation and search on database schemas, there should be tools
> already existing for that purpose. But as I don't know any of them -
> could you please suggest me some?
You could look into SQLDoc from Red Gate (http://www.red-gate.com/). The
tool permits you to enter extended properties per table (not on column
level), and you can then generate a web site or HTML Help from the database.
Since HTML Help is searchable, this may be what you are looking for. You
can download a 14-day eval to have a look.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Get a copy of Doc from ApexSQL (www.apexsql.com).
TheSQLGuru
President
Indicium Resources, Inc.
<send.me.all.email@.googlemail.com> wrote in message
news:1184095671.151380.170660@.o61g2000hsh.googlegr oups.com...
> Hi experts,
> is there any external tool or feature within SQL Server 2005, which
> enables a searchable documentation of schemas?
> What I would like to do is to add descriptions to tables, columns and
> foreign key relations describing their meaning in detail. By the term
> "description" I do not mean a meaningful name, but (where required) a
> longer, formatted text. Additional a google-like keyword search would
> be nice, to be able to find matching elements, like e.g. all tables or
> columns containing "customer" in the description text. The list of
> search results should list the matching elements and show the first
> few words of the description (very similar to the way google lists its
> search results). If an element from the list is choosen, then the full
> description should become visible. If the found elements could then be
> dragged and dropped directly to a query builder - that would be
> perfect!
> As I don't think that I'm the first one thinking about enabling
> documentation and search on database schemas, there should be tools
> already existing for that purpose. But as I don't know any of them -
> could you please suggest me some?
> Kind regards,
> Max
>