Embedded Code

Hi all,
I have a report in which I use some embedded code.
The assemblies I use are standard .NET assemblies.
In my PC the rendering of the report goes fine, but when i try to render
this report on another machine, the fields that call the embedded code
(code!some_function) do not render correctly.
Any help would be appreciated,
thnks!
GoncaloYour assembly dll files must be copied to the ReportServer\bin folder of the
report server for your reports to work after being deployed to the server. If
you are previewing from Report Designer, the assembly dll files must be
copied to the 80\Tools\Report Designer folder also.
Charles Kangai, MCDBA, MCT
"Goncalo" wrote:
> Hi all,
> I have a report in which I use some embedded code.
> The assemblies I use are standard .NET assemblies.
> In my PC the rendering of the report goes fine, but when i try to render
> this report on another machine, the fields that call the embedded code
> (code!some_function) do not render correctly.
> Any help would be appreciated,
> thnks!
> Goncalo
>|||Thanks Charles, but I already did that and it still doesn't work.
The dll's I use are System.Data.dll and System.Web.dll.
Could it be that I must set some kind of permissions or perhaps change the
web.config file to add these references?
Thanks in advance,
Gonçalo
"Charles Kangai" wrote:
> Your assembly dll files must be copied to the ReportServer\bin folder of the
> report server for your reports to work after being deployed to the server. If
> you are previewing from Report Designer, the assembly dll files must be
> copied to the 80\Tools\Report Designer folder also.
> Charles Kangai, MCDBA, MCT
> "Goncalo" wrote:
> > Hi all,
> > I have a report in which I use some embedded code.
> > The assemblies I use are standard .NET assemblies.
> >
> > In my PC the rendering of the report goes fine, but when i try to render
> > this report on another machine, the fields that call the embedded code
> > (code!some_function) do not render correctly.
> >
> > Any help would be appreciated,
> > thnks!
> > Goncalo
> >|||If you are using the built-in .NET assembly dll's you do not need to copy the
files. However, you may need to add references to them in your report. Access
the Report Properties screen by right-clicking the report selector and
choosing Properties. On the References tab, add references to any DLLs you
use in your report.
Charles Kangai, MCDBA, MCT
"Goncalo" wrote:
> Thanks Charles, but I already did that and it still doesn't work.
> The dll's I use are System.Data.dll and System.Web.dll.
> Could it be that I must set some kind of permissions or perhaps change the
> web.config file to add these references?
> Thanks in advance,
> Gonçalo
> "Charles Kangai" wrote:
> > Your assembly dll files must be copied to the ReportServer\bin folder of the
> > report server for your reports to work after being deployed to the server. If
> > you are previewing from Report Designer, the assembly dll files must be
> > copied to the 80\Tools\Report Designer folder also.
> >
> > Charles Kangai, MCDBA, MCT
> >
> > "Goncalo" wrote:
> >
> > > Hi all,
> > > I have a report in which I use some embedded code.
> > > The assemblies I use are standard .NET assemblies.
> > >
> > > In my PC the rendering of the report goes fine, but when i try to render
> > > this report on another machine, the fields that call the embedded code
> > > (code!some_function) do not render correctly.
> > >
> > > Any help would be appreciated,
> > > thnks!
> > > Goncalo
> > >|||Thanks once again Charles! I have done that already but it didn't work either.
I know now what is going wrong.
In my custom code I use a connection to a database. When I render the report
with the Report Designer everything goes fine but when I deploy it to the
ReportServer I get an exception:
"System.Security.SecurityException: Request for the permission of type
System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet
grantedSet, PermissionSet deniedSet, CodeAccessPermission demand,
PermissionToken permToken)
at System.Security.CodeAccessSecurityEngine.Check(PermissionToken
permToken, CodeAccessPermission demand, StackCrawlMark& stackMark, Int32
checkFrames, Int32 unrestrictedOverride)
at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission
cap, StackCrawlMark& stackMark)
at System.Security.CodeAccessPermission.Demand()
at System.Data.SqlClient.SqlConnectionString.Demand(SqlConnectionString
constr)
at System.Data.SqlClient.SqlConnection.Open()
at CalculosDiversos.CalculosDiversos.cambios(String xMoeda1, String
xMoeda2, Int32 iAno, Int32 iMes) in E:\Projectos\Clientes\Consulado
Angola\Relatorios\Bibliotecas
Auxiliares\CalculosDiversos\CalculosDiversos.vb:line 254"
Must I edit some .config file so that I can get those permissions?
Thanks in advance,
Goncalo
"Charles Kangai" wrote:
> If you are using the built-in .NET assembly dll's you do not need to copy the
> files. However, you may need to add references to them in your report. Access
> the Report Properties screen by right-clicking the report selector and
> choosing Properties. On the References tab, add references to any DLLs you
> use in your report.
> Charles Kangai, MCDBA, MCT
> "Goncalo" wrote:
> > Thanks Charles, but I already did that and it still doesn't work.
> > The dll's I use are System.Data.dll and System.Web.dll.
> > Could it be that I must set some kind of permissions or perhaps change the
> > web.config file to add these references?
> >
> > Thanks in advance,
> > Gonçalo
> >
> > "Charles Kangai" wrote:
> >
> > > Your assembly dll files must be copied to the ReportServer\bin folder of the
> > > report server for your reports to work after being deployed to the server. If
> > > you are previewing from Report Designer, the assembly dll files must be
> > > copied to the 80\Tools\Report Designer folder also.
> > >
> > > Charles Kangai, MCDBA, MCT
> > >
> > > "Goncalo" wrote:
> > >
> > > > Hi all,
> > > > I have a report in which I use some embedded code.
> > > > The assemblies I use are standard .NET assemblies.
> > > >
> > > > In my PC the rendering of the report goes fine, but when i try to render
> > > > this report on another machine, the fields that call the embedded code
> > > > (code!some_function) do not render correctly.
> > > >
> > > > Any help would be appreciated,
> > > > thnks!
> > > > Goncalo
> > > >|||This is a well documented scenario. You are trying to access an external
resource from your code. By default SQLRS does not allow this unless you
configure code access security. Code running on your report server is only
granted Execute permission, by default, which means that only in-memory
computations are allowed. Access to files, databases, URLs, etc. are not
allowed. Please look up the documentation to see how to configure code access
security. You will need to do three things:
1) Modify your code to assert the database access permission.
2) configure the rspreviewpolicy.config file in the Report Designer folder
if you want to test your permissions in the Designer (viewing report using
Debug/Start).
3) configure the rssvrpolicy.config file in the ReportServer folder if you
are going to deploy the report that uses your assembly.
Charles Kangai, MCDBA, MCT
"Goncalo" wrote:
> Thanks once again Charles! I have done that already but it didn't work either.
> I know now what is going wrong.
> In my custom code I use a connection to a database. When I render the report
> with the Report Designer everything goes fine but when I deploy it to the
> ReportServer I get an exception:
> "System.Security.SecurityException: Request for the permission of type
> System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0,
> Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
> at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet
> grantedSet, PermissionSet deniedSet, CodeAccessPermission demand,
> PermissionToken permToken)
> at System.Security.CodeAccessSecurityEngine.Check(PermissionToken
> permToken, CodeAccessPermission demand, StackCrawlMark& stackMark, Int32
> checkFrames, Int32 unrestrictedOverride)
> at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission
> cap, StackCrawlMark& stackMark)
> at System.Security.CodeAccessPermission.Demand()
> at System.Data.SqlClient.SqlConnectionString.Demand(SqlConnectionString
> constr)
> at System.Data.SqlClient.SqlConnection.Open()
> at CalculosDiversos.CalculosDiversos.cambios(String xMoeda1, String
> xMoeda2, Int32 iAno, Int32 iMes) in E:\Projectos\Clientes\Consulado
> Angola\Relatorios\Bibliotecas
> Auxiliares\CalculosDiversos\CalculosDiversos.vb:line 254"
>
> Must I edit some .config file so that I can get those permissions?
> Thanks in advance,
> Goncalo
>
> "Charles Kangai" wrote:
> > If you are using the built-in .NET assembly dll's you do not need to copy the
> > files. However, you may need to add references to them in your report. Access
> > the Report Properties screen by right-clicking the report selector and
> > choosing Properties. On the References tab, add references to any DLLs you
> > use in your report.
> >
> > Charles Kangai, MCDBA, MCT
> >
> > "Goncalo" wrote:
> >
> > > Thanks Charles, but I already did that and it still doesn't work.
> > > The dll's I use are System.Data.dll and System.Web.dll.
> > > Could it be that I must set some kind of permissions or perhaps change the
> > > web.config file to add these references?
> > >
> > > Thanks in advance,
> > > Gonçalo
> > >
> > > "Charles Kangai" wrote:
> > >
> > > > Your assembly dll files must be copied to the ReportServer\bin folder of the
> > > > report server for your reports to work after being deployed to the server. If
> > > > you are previewing from Report Designer, the assembly dll files must be
> > > > copied to the 80\Tools\Report Designer folder also.
> > > >
> > > > Charles Kangai, MCDBA, MCT
> > > >
> > > > "Goncalo" wrote:
> > > >
> > > > > Hi all,
> > > > > I have a report in which I use some embedded code.
> > > > > The assemblies I use are standard .NET assemblies.
> > > > >
> > > > > In my PC the rendering of the report goes fine, but when i try to render
> > > > > this report on another machine, the fields that call the embedded code
> > > > > (code!some_function) do not render correctly.
> > > > >
> > > > > Any help would be appreciated,
> > > > > thnks!
> > > > > Goncalo
> > > > >|||I have the same issue did you get a resolution to this?
Regards
Toby.
"Goncalo" <Goncalo@.discussions.microsoft.com> wrote in message
news:A1F2CBB5-5B79-4C85-B2BA-A09C13E1109B@.microsoft.com...
> Thanks once again Charles! I have done that already but it didn't work
> either.
> I know now what is going wrong.
> In my custom code I use a connection to a database. When I render the
> report
> with the Report Designer everything goes fine but when I deploy it to the
> ReportServer I get an exception:
> "System.Security.SecurityException: Request for the permission of type
> System.Data.SqlClient.SqlClientPermission, System.Data,
> Version=1.0.5000.0,
> Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
> at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet
> grantedSet, PermissionSet deniedSet, CodeAccessPermission demand,
> PermissionToken permToken)
> at System.Security.CodeAccessSecurityEngine.Check(PermissionToken
> permToken, CodeAccessPermission demand, StackCrawlMark& stackMark, Int32
> checkFrames, Int32 unrestrictedOverride)
> at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission
> cap, StackCrawlMark& stackMark)
> at System.Security.CodeAccessPermission.Demand()
> at System.Data.SqlClient.SqlConnectionString.Demand(SqlConnectionString
> constr)
> at System.Data.SqlClient.SqlConnection.Open()
> at CalculosDiversos.CalculosDiversos.cambios(String xMoeda1, String
> xMoeda2, Int32 iAno, Int32 iMes) in E:\Projectos\Clientes\Consulado
> Angola\Relatorios\Bibliotecas
> Auxiliares\CalculosDiversos\CalculosDiversos.vb:line 254"
>
> Must I edit some .config file so that I can get those permissions?
> Thanks in advance,
> Goncalo
>
> "Charles Kangai" wrote:
>> If you are using the built-in .NET assembly dll's you do not need to copy
>> the
>> files. However, you may need to add references to them in your report.
>> Access
>> the Report Properties screen by right-clicking the report selector and
>> choosing Properties. On the References tab, add references to any DLLs
>> you
>> use in your report.
>> Charles Kangai, MCDBA, MCT
>> "Goncalo" wrote:
>> > Thanks Charles, but I already did that and it still doesn't work.
>> > The dll's I use are System.Data.dll and System.Web.dll.
>> > Could it be that I must set some kind of permissions or perhaps change
>> > the
>> > web.config file to add these references?
>> >
>> > Thanks in advance,
>> > Gonçalo
>> >
>> > "Charles Kangai" wrote:
>> >
>> > > Your assembly dll files must be copied to the ReportServer\bin folder
>> > > of the
>> > > report server for your reports to work after being deployed to the
>> > > server. If
>> > > you are previewing from Report Designer, the assembly dll files must
>> > > be
>> > > copied to the 80\Tools\Report Designer folder also.
>> > >
>> > > Charles Kangai, MCDBA, MCT
>> > >
>> > > "Goncalo" wrote:
>> > >
>> > > > Hi all,
>> > > > I have a report in which I use some embedded code.
>> > > > The assemblies I use are standard .NET assemblies.
>> > > >
>> > > > In my PC the rendering of the report goes fine, but when i try to
>> > > > render
>> > > > this report on another machine, the fields that call the embedded
>> > > > code
>> > > > (code!some_function) do not render correctly.
>> > > >
>> > > > Any help would be appreciated,
>> > > > thnks!
>> > > > Goncalo
>> > > >|||@.charles kangai: can you also explain how this must be done? Your kind of
answer is the one i like most!!! Especially it includes wrong hints as in
your answer!
In my case the following helps:
The .net code must be modified by write a line direct above your function
like this:
<PermissionSet(SecurityAction.Assert, Unrestricted:=True)> _
Public Function InitOracleConn() As Boolean
...
End Function
The rssrvpolicy.config and RSReportServer.config must be modified. You need
something more as described in the documentation. I did it in the following
way:
I added this code to RSReportServer.config before the </Configuration> Tag:
---
<CustomAssemblies>
<Default>
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution"
/>
</PermissionSet>
</Default>
</CustomAssemblies>
<CustomAssemblies>
<Assembly Name="AIDAReportTranslator, Version=1.0.1.2, Culture=neutral,
PublicKeyToken=null">
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution, Assertion"
/>
</PermissionSet>
</Assembly>
<Default>
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution"
/>
</PermissionSet>
</Default>
</CustomAssemblies>
---
In the rssrvpolicy.config I added this code before the
</NamedPermissionSets> Tag
---
<PermissionSet class="NamedPermissionSet"
version="1"
Name="MyNewFilePermissionSet"
Description="A special permission set that grants read access to my file.">
<IPermission class="Microsoft.Data.Odbc.OdbcPermission"
version="1"
Flags="Assertion, Execution"/>
</PermissionSet>
--
and I added the following code group after the last code group:
---
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="MyNewCodeGroup"
Description="A special code group for my custom assembly.">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Programme\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin\AIDAReportTranslator.dll"/>
</CodeGroup>
---
The file rspreviewpolicy.config must not be modified ! ! !
Ths
"Charles Kangai" wrote:
> This is a well documented scenario. You are trying to access an external
> resource from your code. By default SQLRS does not allow this unless you
> configure code access security. Code running on your report server is only
> granted Execute permission, by default, which means that only in-memory
> computations are allowed. Access to files, databases, URLs, etc. are not
> allowed. Please look up the documentation to see how to configure code access
> security. You will need to do three things:
> 1) Modify your code to assert the database access permission.
> 2) configure the rspreviewpolicy.config file in the Report Designer folder
> if you want to test your permissions in the Designer (viewing report using
> Debug/Start).
> 3) configure the rssvrpolicy.config file in the ReportServer folder if you
> are going to deploy the report that uses your assembly.
> Charles Kangai, MCDBA, MCT
> "Goncalo" wrote:
> > Thanks once again Charles! I have done that already but it didn't work either.
> > I know now what is going wrong.
> > In my custom code I use a connection to a database. When I render the report
> > with the Report Designer everything goes fine but when I deploy it to the
> > ReportServer I get an exception:
> >
> > "System.Security.SecurityException: Request for the permission of type
> > System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0,
> > Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
> > at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet
> > grantedSet, PermissionSet deniedSet, CodeAccessPermission demand,
> > PermissionToken permToken)
> > at System.Security.CodeAccessSecurityEngine.Check(PermissionToken
> > permToken, CodeAccessPermission demand, StackCrawlMark& stackMark, Int32
> > checkFrames, Int32 unrestrictedOverride)
> > at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission
> > cap, StackCrawlMark& stackMark)
> > at System.Security.CodeAccessPermission.Demand()
> > at System.Data.SqlClient.SqlConnectionString.Demand(SqlConnectionString
> > constr)
> > at System.Data.SqlClient.SqlConnection.Open()
> > at CalculosDiversos.CalculosDiversos.cambios(String xMoeda1, String
> > xMoeda2, Int32 iAno, Int32 iMes) in E:\Projectos\Clientes\Consulado
> > Angola\Relatorios\Bibliotecas
> > Auxiliares\CalculosDiversos\CalculosDiversos.vb:line 254"
> >
> >
> > Must I edit some .config file so that I can get those permissions?
> >
> > Thanks in advance,
> > Goncalo
> >
> >
> > "Charles Kangai" wrote:
> >
> > > If you are using the built-in .NET assembly dll's you do not need to copy the
> > > files. However, you may need to add references to them in your report. Access
> > > the Report Properties screen by right-clicking the report selector and
> > > choosing Properties. On the References tab, add references to any DLLs you
> > > use in your report.
> > >
> > > Charles Kangai, MCDBA, MCT
> > >
> > > "Goncalo" wrote:
> > >
> > > > Thanks Charles, but I already did that and it still doesn't work.
> > > > The dll's I use are System.Data.dll and System.Web.dll.
> > > > Could it be that I must set some kind of permissions or perhaps change the
> > > > web.config file to add these references?
> > > >
> > > > Thanks in advance,
> > > > Gonçalo
> > > >
> > > > "Charles Kangai" wrote:
> > > >
> > > > > Your assembly dll files must be copied to the ReportServer\bin folder of the
> > > > > report server for your reports to work after being deployed to the server. If
> > > > > you are previewing from Report Designer, the assembly dll files must be
> > > > > copied to the 80\Tools\Report Designer folder also.
> > > > >
> > > > > Charles Kangai, MCDBA, MCT
> > > > >
> > > > > "Goncalo" wrote:
> > > > >
> > > > > > Hi all,
> > > > > > I have a report in which I use some embedded code.
> > > > > > The assemblies I use are standard .NET assemblies.
> > > > > >
> > > > > > In my PC the rendering of the report goes fine, but when i try to render
> > > > > > this report on another machine, the fields that call the embedded code
> > > > > > (code!some_function) do not render correctly.
> > > > > >
> > > > > > Any help would be appreciated,
> > > > > > thnks!
> > > > > > Goncalo
> > > > > >

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:
> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you need
> additional information. Thank you.
>
>|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
>> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
>> Edition Server. We setup some maintenance jobs under Database
>> Maintenance
>> and would like to setup e-mail notification. When we setup
>> notifications,
>> we got the following error message: "Error 22022: SQLServerAgent Error:
>> The SQLServer Agent mail session is not running; check the mail profile
>> and/or the SQLServerAgent service startup account in the SQLServerAgent
>> Properties dialog." What do we need to do? Please let us know if you
>> need
>> additional information. Thank you.
>>

Email Alert in SQL Server2000

can somebody help me to setup email alerts in SQL Server 2000 standard edition whenever, backup is successful OR failed to complete.

Thanks,

I'll assume you're doing scheduled backups via SQL Server Agent

1. Configure SQL Server to use SQL Mail (Check Books Online SQL Mail)

2. Add an operator to SQL Server Agent with the relevant email address

3. In your SQL Job, notifications tab, check the box to email, select your operator and also selec to alert whenever the job completes.

HTH!

Editions

Can someone tell me what is the difference between
RS Developer Edition
RS Standard Edition
RS Enterprise Edition
What should I be installing on the reporting service server that I don't
intend to do report development on?http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_72jq.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Frank" <nospam@.nospam.org> wrote in message
news:%23ecRMB4mEHA.3900@.TK2MSFTNGP10.phx.gbl...
> Can someone tell me what is the difference between
> RS Developer Edition
> RS Standard Edition
> RS Enterprise Edition
> What should I be installing on the reporting service server that I don't
> intend to do report development on?
>|||thank you.
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:%23624VK5mEHA.3756@.TK2MSFTNGP11.phx.gbl...
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_72jq.asp
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Frank" <nospam@.nospam.org> wrote in message
> news:%23ecRMB4mEHA.3900@.TK2MSFTNGP10.phx.gbl...
>> Can someone tell me what is the difference between
>> RS Developer Edition
>> RS Standard Edition
>> RS Enterprise Edition
>> What should I be installing on the reporting service server that I don't
>> intend to do report development on?
>>
>

Edition Differences

Hello all,
What are the major differences between the standard and the enterprise
editions? Can you still do the same things with standard as you do with the
enterprise edition?
Thanks.
Look at
http://www.microsoft.com/sql/evaluat...s/choosing.asp
and
http://www.microsoft.com/sql/techinf...ng/ChoosEd.doc
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Gale Coleman" <gcoleman@.legalassist.org> wrote in message
news:OgHRHbqlEHA.2380@.TK2MSFTNGP14.phx.gbl...
> Hello all,
> What are the major differences between the standard and the enterprise
> editions? Can you still do the same things with standard as you do with
the
> enterprise edition?
> Thanks.
>

Edition Differences

Hello all,
What are the major differences between the standard and the enterprise
editions? Can you still do the same things with standard as you do with the
enterprise edition?
Thanks.Look at
http://www.microsoft.com/sql/evaluation/features/choosing.asp
and
http://www.microsoft.com/sql/techinfo/planning/ChoosEd.doc
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Gale Coleman" <gcoleman@.legalassist.org> wrote in message
news:OgHRHbqlEHA.2380@.TK2MSFTNGP14.phx.gbl...
> Hello all,
> What are the major differences between the standard and the enterprise
> editions? Can you still do the same things with standard as you do with
the
> enterprise edition?
> Thanks.
>

Edition Compatibility

Hi all,
I am under the impression that one can not Log Ship from enterprise edition to standard edition. Anyone have any documentation they can point me to?
TIA,
SQLPoet

The problem is Log Shipping comes with only the Enterprise edition not the standard but you can use the backup and restore wizard to do most of what you do with Log shipping. Try the links below for Microsoft provided Log shipping tutorial and another with the advantages and disadvantages of Log Shipping. Hope this helps.
http://www.informit.com/articles/article.asp?p=331402&rl=1

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx

|||Thanks Gift...
I do understand that it comes with enterprise. The question is can I log ship from enterprise to standard if I never plan to promote the standard copy?
SQLPoet|||The answer is no because Log Shipping is not part of the Standard Edition. That is the reason I gave you the first link because it explains the alternative of the none production Developer edition which comes with Log Shipping. Hope this helps.

Editing the Subject textbox on SSRS Email Standard Subscription

Hi

Does anyone know if it is possible to edit the subject text box of a Standard Email Subscription so that it contains report variables other than the default Globals and if so, how?

Basically I want to add a value field from the report I'm emailing into the subject line. I've already discovered that you cannot use the rest of the Global variables in the subject line other than the default @.ReportName and @.ExecutionTime.

The variable I want to add is in the report dataset.

Any help would be greatly appreciated.

Thanks

RW

Sorry, I don't have the link to the site I saw this on, but I did read that @.ReportName and @.ExecutionTime are the only 2 parameters available.

Editing text fields using standard tools

Is there possibility to edit easily data type "text" field using standard tools such as SQL server 2005 Management Studio or Server Explorer in Visual Studio 2005 Professional. I want multiline editing akin to multiline textbox in Windows Form. I understand that something may be written/generated in Windows Forms , but I want this possibility for any table.
My pressing "Enter" to create another line for in-place editing just leaves a text cell for the tools mentioned above.
No, I am afraid they don′t. Some editors support Shift+Enter or Alt+Enter, but as far as I know these one don′t.

Jens K. Suessmeyer.

http://www.sqlserver2005.de