Is there system tray icon of Sql2005

There is a system tray icon in Sql 2000, but I can find wiht Sql2005.
Is there system tray icon of Sql2005?
ad (flying@.wfes.tcc.edu.tw) writes:
> There is a system tray icon in Sql 2000, but I can find wiht Sql2005.
> Is there system tray icon of Sql2005?
Yes, at http://www.sqldbatips.com/showarticle.asp?ID=46. No, it does not
come with SQL 2005.
By the way, SQL 2005 questions are best asked in the SQL 2005 newsgroups.
Access information here: http://go.microsoft.com/fwlink/?linkid=31765.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
|||Note that this does not currently work against the June CTP (well not for me
anyway). There will be an updated version coming out soon (as soon as I find
some time) which will be local server only (since this seems to be the major
use of it - to manage local services) which should make it a good deal
faster also.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns96CE11BB5B86Yazorman@.127.0.0.1...
> ad (flying@.wfes.tcc.edu.tw) writes:
> Yes, at http://www.sqldbatips.com/showarticle.asp?ID=46. No, it does not
> come with SQL 2005.
> By the way, SQL 2005 questions are best asked in the SQL 2005 newsgroups.
> Access information here: http://go.microsoft.com/fwlink/?linkid=31765.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp
>

Is there system tray icon of Sql2005

There is a system tray icon in Sql 2000, but I can find wiht Sql2005.
Is there system tray icon of Sql2005?ad (flying@.wfes.tcc.edu.tw) writes:
> There is a system tray icon in Sql 2000, but I can find wiht Sql2005.
> Is there system tray icon of Sql2005?
Yes, at http://www.sqldbatips.com/showarticle.asp?ID=46. No, it does not
come with SQL 2005.
By the way, SQL 2005 questions are best asked in the SQL 2005 newsgroups.
Access information here: http://go.microsoft.com/fwlink/?linkid=31765.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Note that this does not currently work against the June CTP (well not for me
anyway). There will be an updated version coming out soon (as soon as I find
some time) which will be local server only (since this seems to be the major
use of it - to manage local services) which should make it a good deal
faster also.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns96CE11BB5B86Yazorman@.127.0.0.1...
> ad (flying@.wfes.tcc.edu.tw) writes:
> Yes, at http://www.sqldbatips.com/showarticle.asp?ID=46. No, it does not
> come with SQL 2005.
> By the way, SQL 2005 questions are best asked in the SQL 2005 newsgroups.
> Access information here: http://go.microsoft.com/fwlink/?linkid=31765.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
>

Is there system tray icon of Sql2005

There is a system tray icon in Sql 2000, but I can find wiht Sql2005.
Is there system tray icon of Sql2005?ad (flying@.wfes.tcc.edu.tw) writes:
> There is a system tray icon in Sql 2000, but I can find wiht Sql2005.
> Is there system tray icon of Sql2005?
Yes, at http://www.sqldbatips.com/showarticle.asp?ID=46. No, it does not
come with SQL 2005.
By the way, SQL 2005 questions are best asked in the SQL 2005 newsgroups.
Access information here: http://go.microsoft.com/fwlink/?linkid=31765.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp|||Note that this does not currently work against the June CTP (well not for me
anyway). There will be an updated version coming out soon (as soon as I find
some time) which will be local server only (since this seems to be the major
use of it - to manage local services) which should make it a good deal
faster also.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns96CE11BB5B86Yazorman@.127.0.0.1...
> ad (flying@.wfes.tcc.edu.tw) writes:
>> There is a system tray icon in Sql 2000, but I can find wiht Sql2005.
>> Is there system tray icon of Sql2005?
> Yes, at http://www.sqldbatips.com/showarticle.asp?ID=46. No, it does not
> come with SQL 2005.
> By the way, SQL 2005 questions are best asked in the SQL 2005 newsgroups.
> Access information here: http://go.microsoft.com/fwlink/?linkid=31765.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>

Is there reporting service in Sql2005 express?

Hi,
Is there reporting service in Sql2005 express?
No. Standard Edition and up.
Regards
Mike
"ad" wrote:

> Hi,
> Is there reporting service in Sql2005 express?
>
>
|||If I develop my web application with VS2005, and my Web Application used
Reporting Service.
Can I bundle reporting service in the install package to my customer?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
:DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...[vbcol=seagreen]
> No. Standard Edition and up.
> Regards
> Mike
> "ad" wrote:
|||reporting services is an add-on and anyone having a valid SQL Server license
can use it without ptoblems. And for the case of bundling, you might need to
bundle the reports alone. If the customer has a valid SQL Server then they
can install RS and deploy your solution.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> If I develop my web application with VS2005, and my Web Application used
> Reporting Service.
> Can I bundle reporting service in the install package to my customer?
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
> :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
>
|||But if my customer have only the express version my Sql 2005,
Can they install RS in they web site?
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> glsD
:uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> reporting services is an add-on and anyone having a valid SQL Server
license
> can use it without ptoblems. And for the case of bundling, you might need
to[vbcol=seagreen]
> bundle the reports alone. If the customer has a valid SQL Server then they
> can install RS and deploy your solution.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
used
>
|||Hi
No, Express is not enough to have a valid RS license. If you are using RS,
you have to use Standard Edition or better.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
> But if my customer have only the express version my Sql 2005,
> Can they install RS in they web site?
> "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> glsD
> :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> license
> to
> used
>
|||In the article http://www.microsoft.com/sql/spotlig...dsqlserver.asp
it say Express Edition replaces MSDE and provides a new set of capabilities
such as XCopy deployment, a very easy to understand licensing model, a
graphical management tool, and also SQL Server Reporting Services controls
so you can quickly build reports off your Express Edition data. Express
Edition also gives partners the ability to embed a database into their
applications at no cost to the partner. The Express Edition is free and
completely redistributable.
Is it meaning we can use Express edition with reporting service?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> No, Express is not enough to have a valid RS license. If you are using RS,
> you have to use Standard Edition or better.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
need
>
|||See also my previous answers to you on
microsoft.public.sqlserver.reportingsvcs.
You can use SQL Express as a data source for Reporting Services.
You, or your customers, will still need a copy of SQL Server Standard
or Enterprise to hold the metadata Catalog for Reporting Services.
The bottom line is that Reporting Services 2005 is "free" only to
those with a licensed copy of SQL Server 2005 Standard or Enterprise.
Andrew Watt
MVP - InfoPath
On Sun, 10 Apr 2005 14:20:55 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:

>In the article http://www.microsoft.com/sql/spotlig...dsqlserver.asp
>it say Express Edition replaces MSDE and provides a new set of capabilities
>such as XCopy deployment, a very easy to understand licensing model, a
>graphical management tool, and also SQL Server Reporting Services controls
>so you can quickly build reports off your Express Edition data. Express
>Edition also gives partners the ability to embed a database into their
>applications at no cost to the partner. The Express Edition is free and
>completely redistributable.
>Is it meaning we can use Express edition with reporting service?
>
>"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
>:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
>need
>

Is there reporting service in Sql2005 express?

Hi,
Is there reporting service in Sql2005 express?No. Standard Edition and up.
Regards
Mike
"ad" wrote:

> Hi,
> Is there reporting service in Sql2005 express?
>
>|||If I develop my web application with VS2005, and my Web Application used
Reporting Service.
Can I bundle reporting service in the install package to my customer?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
:DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...[vbcol=seagreen]
> No. Standard Edition and up.
> Regards
> Mike
> "ad" wrote:
>|||reporting services is an add-on and anyone having a valid SQL Server license
can use it without ptoblems. And for the case of bundling, you might need to
bundle the reports alone. If the customer has a valid SQL Server then they
can install RS and deploy your solution.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> If I develop my web application with VS2005, and my Web Application used
> Reporting Service.
> Can I bundle reporting service in the install package to my customer?
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
> :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
>|||But if my customer have only the express version my Sql 2005,
Can they install RS in they web site?
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> glsD
:uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> reporting services is an add-on and anyone having a valid SQL Server
license
> can use it without ptoblems. And for the case of bundling, you might need
to
> bundle the reports alone. If the customer has a valid SQL Server then they
> can install RS and deploy your solution.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
used[vbcol=seagreen]
>|||Hi
No, Express is not enough to have a valid RS license. If you are using RS,
you have to use Standard Edition or better.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
> But if my customer have only the express version my Sql 2005,
> Can they install RS in they web site?
> "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> glsD
> :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> license
> to
> used
>|||In the article http://www.microsoft.com/sql/spotli...ndsqlserver.asp
it say Express Edition replaces MSDE and provides a new set of capabilities
such as XCopy deployment, a very easy to understand licensing model, a
graphical management tool, and also SQL Server Reporting Services controls
so you can quickly build reports off your Express Edition data. Express
Edition also gives partners the ability to embed a database into their
applications at no cost to the partner. The Express Edition is free and
completely redistributable.
Is it meaning we can use Express edition with reporting service?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
> Hi
> No, Express is not enough to have a valid RS license. If you are using RS,
> you have to use Standard Edition or better.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
need[vbcol=seagreen]
>|||See also my previous answers to you on
microsoft.public.sqlserver.reportingsvcs.
You can use SQL Express as a data source for Reporting Services.
You, or your customers, will still need a copy of SQL Server Standard
or Enterprise to hold the metadata Catalog for Reporting Services.
The bottom line is that Reporting Services 2005 is "free" only to
those with a licensed copy of SQL Server 2005 Standard or Enterprise.
Andrew Watt
MVP - InfoPath
On Sun, 10 Apr 2005 14:20:55 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:

>In the article http://www.microsoft.com/sql/spotli...ndsqlserver.asp
>it say Express Edition replaces MSDE and provides a new set of capabilities
>such as XCopy deployment, a very easy to understand licensing model, a
>graphical management tool, and also SQL Server Reporting Services controls
>so you can quickly build reports off your Express Edition data. Express
>Edition also gives partners the ability to embed a database into their
>applications at no cost to the partner. The Express Edition is free and
>completely redistributable.
>Is it meaning we can use Express edition with reporting service?
>
>"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD
>:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
>need
>

Is there reporting service in Sql2005 express?

Hi,
Is there reporting service in Sql2005 express?No. Standard Edition and up.
Regards
Mike
"ad" wrote:
> Hi,
> Is there reporting service in Sql2005 express?
>
>|||If I develop my web application with VS2005, and my Web Application used
Reporting Service.
Can I bundle reporting service in the install package to my customer?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
:DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
> No. Standard Edition and up.
> Regards
> Mike
> "ad" wrote:
> > Hi,
> > Is there reporting service in Sql2005 express?
> >
> >
> >|||reporting services is an add-on and anyone having a valid SQL Server license
can use it without ptoblems. And for the case of bundling, you might need to
bundle the reports alone. If the customer has a valid SQL Server then they
can install RS and deploy your solution.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> If I develop my web application with VS2005, and my Web Application used
> Reporting Service.
> Can I bundle reporting service in the install package to my customer?
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
> :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
> > No. Standard Edition and up.
> >
> > Regards
> > Mike
> >
> > "ad" wrote:
> >
> > > Hi,
> > > Is there reporting service in Sql2005 express?
> > >
> > >
> > >
>|||But if my customer have only the express version my Sql 2005,
Can they install RS in they web site?
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D
:uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> reporting services is an add-on and anyone having a valid SQL Server
license
> can use it without ptoblems. And for the case of bundling, you might need
to
> bundle the reports alone. If the customer has a valid SQL Server then they
> can install RS and deploy your solution.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> > If I develop my web application with VS2005, and my Web Application
used
> > Reporting Service.
> >
> > Can I bundle reporting service in the install package to my customer?
> >
> >
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
> > :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
> > > No. Standard Edition and up.
> > >
> > > Regards
> > > Mike
> > >
> > > "ad" wrote:
> > >
> > > > Hi,
> > > > Is there reporting service in Sql2005 express?
> > > >
> > > >
> > > >
> >
> >
>|||Hi
No, Express is not enough to have a valid RS license. If you are using RS,
you have to use Standard Edition or better.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
> But if my customer have only the express version my Sql 2005,
> Can they install RS in they web site?
> "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D
> :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
>> reporting services is an add-on and anyone having a valid SQL Server
> license
>> can use it without ptoblems. And for the case of bundling, you might need
> to
>> bundle the reports alone. If the customer has a valid SQL Server then
>> they
>> can install RS and deploy your solution.
>> --
>> HTH,
>> Vinod Kumar
>> MCSE, DBA, MCAD, MCSD
>> http://www.extremeexperts.com
>> Books Online for SQL Server SP3 at
>> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
>> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
>> > If I develop my web application with VS2005, and my Web Application
> used
>> > Reporting Service.
>> >
>> > Can I bundle reporting service in the install package to my customer?
>> >
>> >
>> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
>> > :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
>> > > No. Standard Edition and up.
>> > >
>> > > Regards
>> > > Mike
>> > >
>> > > "ad" wrote:
>> > >
>> > > > Hi,
>> > > > Is there reporting service in Sql2005 express?
>> > > >
>> > > >
>> > > >
>> >
>> >
>>
>|||In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
it say Express Edition replaces MSDE and provides a new set of capabilities
such as XCopy deployment, a very easy to understand licensing model, a
graphical management tool, and also SQL Server Reporting Services controls
so you can quickly build reports off your Express Edition data. Express
Edition also gives partners the ability to embed a database into their
applications at no cost to the partner. The Express Edition is free and
completely redistributable.
Is it meaning we can use Express edition with reporting service?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
> Hi
> No, Express is not enough to have a valid RS license. If you are using RS,
> you have to use Standard Edition or better.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
> > But if my customer have only the express version my Sql 2005,
> > Can they install RS in they web site?
> > "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D
> > :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
> >> reporting services is an add-on and anyone having a valid SQL Server
> > license
> >> can use it without ptoblems. And for the case of bundling, you might
need
> > to
> >> bundle the reports alone. If the customer has a valid SQL Server then
> >> they
> >> can install RS and deploy your solution.
> >>
> >> --
> >> HTH,
> >> Vinod Kumar
> >> MCSE, DBA, MCAD, MCSD
> >> http://www.extremeexperts.com
> >>
> >> Books Online for SQL Server SP3 at
> >> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
> >>
> >> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> >> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
> >> > If I develop my web application with VS2005, and my Web Application
> > used
> >> > Reporting Service.
> >> >
> >> > Can I bundle reporting service in the install package to my customer?
> >> >
> >> >
> >> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
> >> > :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
> >> > > No. Standard Edition and up.
> >> > >
> >> > > Regards
> >> > > Mike
> >> > >
> >> > > "ad" wrote:
> >> > >
> >> > > > Hi,
> >> > > > Is there reporting service in Sql2005 express?
> >> > > >
> >> > > >
> >> > > >
> >> >
> >> >
> >>
> >>
> >
> >
>|||See also my previous answers to you on
microsoft.public.sqlserver.reportingsvcs.
You can use SQL Express as a data source for Reporting Services.
You, or your customers, will still need a copy of SQL Server Standard
or Enterprise to hold the metadata Catalog for Reporting Services.
The bottom line is that Reporting Services 2005 is "free" only to
those with a licensed copy of SQL Server 2005 Standard or Enterprise.
Andrew Watt
MVP - InfoPath
On Sun, 10 Apr 2005 14:20:55 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
>it say Express Edition replaces MSDE and provides a new set of capabilities
>such as XCopy deployment, a very easy to understand licensing model, a
>graphical management tool, and also SQL Server Reporting Services controls
>so you can quickly build reports off your Express Edition data. Express
>Edition also gives partners the ability to embed a database into their
>applications at no cost to the partner. The Express Edition is free and
>completely redistributable.
>Is it meaning we can use Express edition with reporting service?
>
>"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
>:uTPpBGUPFHA.2132@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> No, Express is not enough to have a valid RS license. If you are using RS,
>> you have to use Standard Edition or better.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
>> news:uCRRiuTPFHA.3408@.TK2MSFTNGP14.phx.gbl...
>> > But if my customer have only the express version my Sql 2005,
>> > Can they install RS in they web site?
>> > "Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> ¼¶¼g©ó¶l¥ó·s»D
>> > :uw$o6sQPFHA.2356@.TK2MSFTNGP14.phx.gbl...
>> >> reporting services is an add-on and anyone having a valid SQL Server
>> > license
>> >> can use it without ptoblems. And for the case of bundling, you might
>need
>> > to
>> >> bundle the reports alone. If the customer has a valid SQL Server then
>> >> they
>> >> can install RS and deploy your solution.
>> >>
>> >> --
>> >> HTH,
>> >> Vinod Kumar
>> >> MCSE, DBA, MCAD, MCSD
>> >> http://www.extremeexperts.com
>> >>
>> >> Books Online for SQL Server SP3 at
>> >> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>> >>
>> >> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
>> >> news:eq$L2rPPFHA.508@.TK2MSFTNGP12.phx.gbl...
>> >> > If I develop my web application with VS2005, and my Web Application
>> > used
>> >> > Reporting Service.
>> >> >
>> >> > Can I bundle reporting service in the install package to my customer?
>> >> >
>> >> >
>> >> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D
>> >> > :DC032C75-697C-4D43-9059-31DF1195833E@.microsoft.com...
>> >> > > No. Standard Edition and up.
>> >> > >
>> >> > > Regards
>> >> > > Mike
>> >> > >
>> >> > > "ad" wrote:
>> >> > >
>> >> > > > Hi,
>> >> > > > Is there reporting service in Sql2005 express?
>> >> > > >
>> >> > > >
>> >> > > >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>

Is there reporting service in Sql2005 express?

Dear Sir,
Is there reporting service in Sql2005 express?On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>Dear Sir,
>Is there reporting service in Sql2005 express?
>
Hi,
I answered your question on
microsoft.private.sqlserver2005.reportingsvcs.
The answer is "No".
Andrew Watt
MVP - InfoPath|||But
In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
It say that there is SQL Server Reporting Services controls in Express
Edition.
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
'?:9meg51td7sf0ni35islj8nb0ob2al098i2@.4ax.com...
> On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
> >Dear Sir,
> >Is there reporting service in Sql2005 express?
> >
> Hi,
> I answered your question on
> microsoft.private.sqlserver2005.reportingsvcs.
> The answer is "No".
> Andrew Watt
> MVP - InfoPath|||Hi,
Your question was whether there was a reporting service in SQL Server
2005 Express. The answer I gave you is correct.
I can see the graphic you are referring to and it does mention
reporting services controls. The controls referred to are found in
Visual Studio (see, for example, "Create Reports Faster" on
http://www.microsoft.com/sql/express/).
The wizard and controls coming from Visual Studio is also made clear
in http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp.
I hope that helps.
Andrew Watt
MVP - InfoPath
On Sun, 10 Apr 2005 14:14:18 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>But
>In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
>It say that there is SQL Server Reporting Services controls in Express
>Edition.
>
>
>"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
>'?:9meg51td7sf0ni35islj8nb0ob2al098i2@.4ax.com...
>> On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>> >Dear Sir,
>> >Is there reporting service in Sql2005 express?
>> >
>> Hi,
>> I answered your question on
>> microsoft.private.sqlserver2005.reportingsvcs.
>> The answer is "No".
>> Andrew Watt
>> MVP - InfoPath
>|||Thank,
But I still a little confuse.
Dose it mean that if I use VS 2005, I can use report controls with Sql 2005
express?
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
'?:tfkh515gh1lujll3ovacs7b1blhnp0egs5@.4ax.com...
> Hi,
> Your question was whether there was a reporting service in SQL Server
> 2005 Express. The answer I gave you is correct.
> I can see the graphic you are referring to and it does mention
> reporting services controls. The controls referred to are found in
> Visual Studio (see, for example, "Create Reports Faster" on
> http://www.microsoft.com/sql/express/).
> The wizard and controls coming from Visual Studio is also made clear
> in http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp.
> I hope that helps.
> Andrew Watt
> MVP - InfoPath
> On Sun, 10 Apr 2005 14:14:18 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
> >But
> >
> >In the article http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
> >
> >It say that there is SQL Server Reporting Services controls in Express
> >Edition.
> >
> >
> >
> >
> >
> >"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
> >'?:9meg51td7sf0ni35islj8nb0ob2al098i2@.4ax.com...
> >> On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
> >>
> >> >Dear Sir,
> >> >Is there reporting service in Sql2005 express?
> >> >
> >> Hi,
> >>
> >> I answered your question on
> >> microsoft.private.sqlserver2005.reportingsvcs.
> >>
> >> The answer is "No".
> >>
> >> Andrew Watt
> >> MVP - InfoPath
> >
>|||The new report controls (should be available with Beta 2 of Widbey (VS
2005)) can work both with and without Reporting Services Server. What this
means is that you can create a report and show it in your asp.net web page
or with a winform control without any server piece. If Reporting Services
Server is there it will use it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:%23tTcTNbPFHA.1392@.TK2MSFTNGP10.phx.gbl...
> Thank,
> But I still a little confuse.
> Dose it mean that if I use VS 2005, I can use report controls with Sql
> 2005
> express?
> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
> '?:tfkh515gh1lujll3ovacs7b1blhnp0egs5@.4ax.com...
>> Hi,
>> Your question was whether there was a reporting service in SQL Server
>> 2005 Express. The answer I gave you is correct.
>> I can see the graphic you are referring to and it does mention
>> reporting services controls. The controls referred to are found in
>> Visual Studio (see, for example, "Create Reports Faster" on
>> http://www.microsoft.com/sql/express/).
>> The wizard and controls coming from Visual Studio is also made clear
>> in http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp.
>> I hope that helps.
>> Andrew Watt
>> MVP - InfoPath
>> On Sun, 10 Apr 2005 14:14:18 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>> >But
>> >
>> >In the article
>> >http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
>> >
>> >It say that there is SQL Server Reporting Services controls in Express
>> >Edition.
>> >
>> >
>> >
>> >
>> >
>> >"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
>> >'?:9meg51td7sf0ni35islj8nb0ob2al098i2@.4ax.com...
>> >> On Sat, 9 Apr 2005 18:05:48 +0800, "ad" <ad@.wfes.tcc.edu.tw> wrote:
>> >>
>> >> >Dear Sir,
>> >> >Is there reporting service in Sql2005 express?
>> >> >
>> >> Hi,
>> >>
>> >> I answered your question on
>> >> microsoft.private.sqlserver2005.reportingsvcs.
>> >>
>> >> The answer is "No".
>> >>
>> >> Andrew Watt
>> >> MVP - InfoPath
>> >
>

is there anyway to raise a warning from a UDF (in sql2000 and/or in SQL2005)

cos RAISERROR isnt callable, but I really want to indicate a non-fatal warning to be passed back to the client (C++ code)

You are limited to a single output either way dealing with a scalar or table valued function. The only way you could pass back a message of some sort would be to overwrite the scalar return value or add a column to your table return. Neither of those sound particulary appealing but you have few options.|||In SQL Server 2005, you could replace the TSQL UDF with CLR UDF and raise exception in your CLR code. But this is not a pretty implementation and depending on the TSQL code you will get worse performance. So best is to modify the UDF to a SP or just check for absence of row or special value like NULL.

Is there any free tools taht I could read t sql 2005 log files

Hi,
I need to read sql2005 log files. Red gate has sql2000 one for free. I need
sql2005.
any ideas?
thanks
I don't of any free tools. As a matter of fact, they are pretty pricey since
people are usually in a bind when they go looking for them. However, I
believe they are just a gui on dbcc log so you could look into that command.
It is pretty cryptic though.
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>
|||I tried. It desn't really tell me anything.
What I need is that It shows the sql stetement (update, select and delete
ect.. and user name....)
Thanks
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
>I don't of any free tools. As a matter of fact, they are pretty pricey
>since people are usually in a bind when they go looking for them. However,
>I believe they are just a gui on dbcc log so you could look into that
>command. It is pretty cryptic though.
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://feeds.feedburner.com/statisticsio
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
>
|||On Thu, 10 Apr 2008 15:59:48 -0400, Mecn wrote:

> I tried. It desn't really tell me anything.
> What I need is that It shows the sql stetement (update, select and delete
> ect.. and user name....)
> Thanks
The log does not store sql statements. It only stores information regarding
changes that were made to pages in the database (i.e. were rows
inserted/updated/deleted).
Thanks,
Marcel van der Holst
SQL Server Storage Engine Team.
[vbcol=seagreen]
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
|||Pay the money (surprisingly little, actually) for apexsql.com's Log product.
Every production environment should have a tool such as this available for
the 'holy-shit' times. Also helps trememdously during
debugging/troubleshooting scenarios too.
Disclaimer: I work closely with Apex, I use and promote their products to
my clients. If you tell them TheSQLGuru sent you you can pick up a nice
discount (and I will receive a small referral fee). They have a wide array
of very useful SQL Server-specific tools.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>

Is there any free tools taht I could read t sql 2005 log files

Hi,
I need to read sql2005 log files. Red gate has sql2000 one for free. I need
sql2005.
any ideas?
thanksI don't of any free tools. As a matter of fact, they are pretty pricey since
people are usually in a bind when they go looking for them. However, I
believe they are just a gui on dbcc log so you could look into that command.
It is pretty cryptic though.
--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>|||I tried. It desn't really tell me anything.
What I need is that It shows the sql stetement (update, select and delete
ect.. and user name....)
Thanks
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
>I don't of any free tools. As a matter of fact, they are pretty pricey
>since people are usually in a bind when they go looking for them. However,
>I believe they are just a gui on dbcc log so you could look into that
>command. It is pretty cryptic though.
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://feeds.feedburner.com/statisticsio
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
>> Hi,
>> I need to read sql2005 log files. Red gate has sql2000 one for free. I
>> need sql2005.
>> any ideas?
>> thanks
>|||On Thu, 10 Apr 2008 15:59:48 -0400, Mecn wrote:
> I tried. It desn't really tell me anything.
> What I need is that It shows the sql stetement (update, select and delete
> ect.. and user name....)
> Thanks
The log does not store sql statements. It only stores information regarding
changes that were made to pages in the database (i.e. were rows
inserted/updated/deleted).
Thanks,
Marcel van der Holst
SQL Server Storage Engine Team.
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
>>I don't of any free tools. As a matter of fact, they are pretty pricey
>>since people are usually in a bind when they go looking for them. However,
>>I believe they are just a gui on dbcc log so you could look into that
>>command. It is pretty cryptic though.
>> --
>> Jason Massie
>> Web: http://statisticsio.com
>> RSS: http://feeds.feedburner.com/statisticsio
>> "Mecn" <mecn@.yahoo.com> wrote in message
>> news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
>> Hi,
>> I need to read sql2005 log files. Red gate has sql2000 one for free. I
>> need sql2005.
>> any ideas?
>> thanks
>>|||Pay the money (surprisingly little, actually) for apexsql.com's Log product.
Every production environment should have a tool such as this available for
the 'holy-shit' times. Also helps trememdously during
debugging/troubleshooting scenarios too.
Disclaimer: I work closely with Apex, I use and promote their products to
my clients. If you tell them TheSQLGuru sent you you can pick up a nice
discount (and I will receive a small referral fee). They have a wide array
of very useful SQL Server-specific tools.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>