embedding a DTS package and logging/error reporting

Hi All,

When the embedded DTS package fails at runtime, and logging has been enabled for the package (and all log events selected for reporting on for the package and the task), the DTS error (i.e. any meaningful errors) are not thrown up to/caught by the SSIS/outer level. All you get is something like:

COMException - error returned from a call to a COM component.

Does anyone have any comments &/or know to get errors thrown from within an embedded DTS package, thrown up to the wrapping SSIS package?

Cheers,

Tamim.

Hi Tamim,

Try configuring your DTS package (using the old SQL 2000 designer) to log to an msdb database (it can be a SQL 2005 msdb). Then you will find the DTS messages logged to the tables eg sysdtspackagelog and sysdtssteplog.

Good luck.

Mike

embedding a DTS package and logging/error reporting

Hi All,

When the embedded DTS package fails at runtime, and logging has been enabled for the package (and all log events selected for reporting on for the package and the task), the DTS error (i.e. any meaningful errors) are not thrown up to/caught by the SSIS/outer level. All you get is something like:

COMException - error returned from a call to a COM component.

Does anyone have any comments &/or know to get errors thrown from within an embedded DTS package, thrown up to the wrapping SSIS package?

Cheers,

Tamim.

Hi Tamim,

Try configuring your DTS package (using the old SQL 2000 designer) to log to an msdb database (it can be a SQL 2005 msdb). Then you will find the DTS messages logged to the tables eg sysdtspackagelog and sysdtssteplog.

Good luck.

Mike

sql

Email Subscription not working - help please

Nothing shows up under the "Last Run" column. No error msg or entry in
reporting services or SMTP log.
Looks like reporting server is completly ignoring the subscription entry.
I'm using "once" option and selecting a time just 10-15 minutes ahead.
Here are the entries in my RSReportServer.config file:
----
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>150.8.111.82</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>altbill@.discountcar.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
----
What could be wrong... any ideas...
Thanks
AJHi, I have the exact same problem. I'm running win2003, and you?
"Amit Jain" wrote:
> Nothing shows up under the "Last Run" column. No error msg or entry in
> reporting services or SMTP log.
> Looks like reporting server is completly ignoring the subscription entry.
> I'm using "once" option and selecting a time just 10-15 minutes ahead.
> Here are the entries in my RSReportServer.config file:
> ----
> <Extensions>
> <Delivery>
> <Extension Name="Report Server FileShare"
> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <FileShareConfiguration>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> </FileShareConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>150.8.111.82</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>altbill@.discountcar.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="NULL"
> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> </Delivery>
> ----
> What could be wrong... any ideas...
> Thanks
> AJ
>
>|||I've tried it on Win2K server and Win2K professional, same issue on both
installations.
"Hennie" <Hennie@.discussions.microsoft.com> wrote in message
news:15DCD777-B85F-4D3D-893C-618D7B138F94@.microsoft.com...
> Hi, I have the exact same problem. I'm running win2003, and you?
> "Amit Jain" wrote:
>> Nothing shows up under the "Last Run" column. No error msg or entry in
>> reporting services or SMTP log.
>> Looks like reporting server is completly ignoring the subscription entry.
>> I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> Here are the entries in my RSReportServer.config file:
>> ----
>> <Extensions>
>> <Delivery>
>> <Extension Name="Report Server FileShare"
>> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <FileShareConfiguration>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> </FileShareConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="Report Server Email"
>> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <RSEmailDPConfiguration>
>> <SMTPServer>150.8.111.82</SMTPServer>
>> <SMTPServerPort></SMTPServerPort>
>> <SMTPAccountName></SMTPAccountName>
>> <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> <SMTPUseSSL></SMTPUseSSL>
>> <SendUsing></SendUsing>
>> <SMTPAuthenticate></SMTPAuthenticate>
>> <From>altbill@.discountcar.com</From>
>> <EmbeddedRenderFormats>
>> <RenderingExtension>MHTML</RenderingExtension>
>> </EmbeddedRenderFormats>
>> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> <SendEmailToUserAlias>True</SendEmailToUserAlias>
>> <DefaultHostName></DefaultHostName>
>> <PermittedHosts></PermittedHosts>
>> </RSEmailDPConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="NULL"
>> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
>> </Delivery>
>> ----
>> What could be wrong... any ideas...
>> Thanks
>> AJ
>>|||I fixed it by starting the ReportServer service. I should've have checked
it before posting.
"AJ" <amitjn_ca@.yahoo.ca> wrote in message
news:uIW6bH7AFHA.3120@.TK2MSFTNGP12.phx.gbl...
> I've tried it on Win2K server and Win2K professional, same issue on both
> installations.
> "Hennie" <Hennie@.discussions.microsoft.com> wrote in message
> news:15DCD777-B85F-4D3D-893C-618D7B138F94@.microsoft.com...
>> Hi, I have the exact same problem. I'm running win2003, and you?
>> "Amit Jain" wrote:
>> Nothing shows up under the "Last Run" column. No error msg or entry in
>> reporting services or SMTP log.
>> Looks like reporting server is completly ignoring the subscription
>> entry.
>> I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> Here are the entries in my RSReportServer.config file:
>> ----
>> <Extensions>
>> <Delivery>
>> <Extension Name="Report Server FileShare"
>> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <FileShareConfiguration>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> </FileShareConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="Report Server Email"
>> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <RSEmailDPConfiguration>
>> <SMTPServer>150.8.111.82</SMTPServer>
>> <SMTPServerPort></SMTPServerPort>
>> <SMTPAccountName></SMTPAccountName>
>> <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> <SMTPUseSSL></SMTPUseSSL>
>> <SendUsing></SendUsing>
>> <SMTPAuthenticate></SMTPAuthenticate>
>> <From>altbill@.discountcar.com</From>
>> <EmbeddedRenderFormats>
>> <RenderingExtension>MHTML</RenderingExtension>
>> </EmbeddedRenderFormats>
>> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> <SendEmailToUserAlias>True</SendEmailToUserAlias>
>> <DefaultHostName></DefaultHostName>
>> <PermittedHosts></PermittedHosts>
>> </RSEmailDPConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="NULL"
>> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
>> </Delivery>
>> ----
>> What could be wrong... any ideas...
>> Thanks
>> AJ
>>
>|||In general, when you encounter issues like this, check the reporting
services log files. You should see a event polling message and status for
any notifications that are entered. This will also tell you if there are
errors. If you do not see any service log files, you'll need to start the
service called reportserver
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Amit Jain" <amitjn_ca@.yahoo.ca> wrote in message
news:eNlilGyAFHA.2540@.TK2MSFTNGP09.phx.gbl...
> Nothing shows up under the "Last Run" column. No error msg or entry in
> reporting services or SMTP log.
> Looks like reporting server is completly ignoring the subscription entry.
> I'm using "once" option and selecting a time just 10-15 minutes ahead.
> Here are the entries in my RSReportServer.config file:
> ----
> <Extensions>
> <Delivery>
> <Extension Name="Report Server FileShare"
> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <FileShareConfiguration>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> </FileShareConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>150.8.111.82</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>altbill@.discountcar.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="NULL"
> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> </Delivery>
> ----
> What could be wrong... any ideas...
> Thanks
> AJ
>|||Like Lukasz says, check the report Server Log, if any error occured you will
find them there, in the first example of Amit i would suggest looking in the
logs of the SMTP Server (For example you could send the EMail temporary to
an virtual SMTP Server where you have full control of and relay it to the
productive server to check the logs) or just to check if the SMTP Server
accepted relayed EMails to conenct to the mail server via telnet.
--> telnet Mailserver 25
Rest can be found here:
http://www.yuki-onna.co.uk/email/smtp.html
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Koen" <Koen@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F6365949-8F76-41B7-B74A-182A7A5869C6@.microsoft.com...
> Is there an internal clock or so in reporting services ? Because i'm
> facing
> the same problem, but when i check my log files, i see that the time when
> these files were created is impossible (eg: 2 AM, when nobody's at the
> office
> and the server is shut down).
> Thanks in advance
> "Lukasz Pawlowski [MSFT]" wrote:
>> In general, when you encounter issues like this, check the reporting
>> services log files. You should see a event polling message and status
>> for
>> any notifications that are entered. This will also tell you if there are
>> errors. If you do not see any service log files, you'll need to start
>> the
>> service called reportserver
>> -Lukasz
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>> "Amit Jain" <amitjn_ca@.yahoo.ca> wrote in message
>> news:eNlilGyAFHA.2540@.TK2MSFTNGP09.phx.gbl...
>> > Nothing shows up under the "Last Run" column. No error msg or entry in
>> > reporting services or SMTP log.
>> > Looks like reporting server is completly ignoring the subscription
>> > entry.
>> > I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> > Here are the entries in my RSReportServer.config file:
>> > ----
>> > <Extensions>
>> > <Delivery>
>> > <Extension Name="Report Server FileShare"
>> > Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
>> > <MaxRetries>3</MaxRetries>
>> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> > <Configuration>
>> > <FileShareConfiguration>
>> > <ExcludedRenderFormats>
>> > <RenderingExtension>HTMLOWC</RenderingExtension>
>> > <RenderingExtension>NULL</RenderingExtension>
>> > </ExcludedRenderFormats>
>> > </FileShareConfiguration>
>> > </Configuration>
>> > </Extension>
>> > <Extension Name="Report Server Email"
>> > Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
>> > <MaxRetries>3</MaxRetries>
>> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> > <Configuration>
>> > <RSEmailDPConfiguration>
>> > <SMTPServer>150.8.111.82</SMTPServer>
>> > <SMTPServerPort></SMTPServerPort>
>> > <SMTPAccountName></SMTPAccountName>
>> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> > <SMTPUseSSL></SMTPUseSSL>
>> > <SendUsing></SendUsing>
>> > <SMTPAuthenticate></SMTPAuthenticate>
>> > <From>altbill@.discountcar.com</From>
>> > <EmbeddedRenderFormats>
>> > <RenderingExtension>MHTML</RenderingExtension>
>> > </EmbeddedRenderFormats>
>> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
>> > <ExcludedRenderFormats>
>> > <RenderingExtension>HTMLOWC</RenderingExtension>
>> > <RenderingExtension>NULL</RenderingExtension>
>> > </ExcludedRenderFormats>
>> > <SendEmailToUserAlias>True</SendEmailToUserAlias>
>> > <DefaultHostName></DefaultHostName>
>> > <PermittedHosts></PermittedHosts>
>> > </RSEmailDPConfiguration>
>> > </Configuration>
>> > </Extension>
>> > <Extension Name="NULL"
>> > Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
>> > </Delivery>
>> > ----
>> > What could be wrong... any ideas...
>> > Thanks
>> > AJ
>> >
>>

email report

Hi,
I have an issue with emailing a report.
I am using SQL 2005 reporting service, and schedule a report to be sent to
my email account. The log in report subscription showed the report has been
sent successful, but I never receive the report. Where could the problem be?
Thanks,On Mar 18, 8:18 pm, qjlee <q...@.discussions.microsoft.com> wrote:
> Hi,
> I have an issue with emailing a report.
> I am using SQL 2005 reporting service, and schedule a report to be sent to
> my email account. The log in report subscription showed the report has been
> sent successful, but I never receive the report. Where could the problem be?
> Thanks,
Do you have a firewall that could be blocking the .rdl extension?
Enrique Martinez
Sr. SQL Server Developer

email notificaiton when log files are getting large

Can SQL send me an email alert when log files are getting large?
Thanks,
JM
You can set up an alert that fires when the % used space in a log goes above
a certain threshold. Unfortunately, you'd need to set up one such alert per
database.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Joe Murphy" <spam@.spamthis.com> wrote in message
news:OdCtSbHPGHA.1832@.TK2MSFTNGP11.phx.gbl...
Can SQL send me an email alert when log files are getting large?
Thanks,
JM
|||How to?
_______________________________
http://boston.craigslist.org/about/b.../62974620.html
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uPDMueHPGHA.536@.TK2MSFTNGP09.phx.gbl...
> You can set up an alert that fires when the % used space in a log goes
> above
> a certain threshold. Unfortunately, you'd need to set up one such alert
> per
> database.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Joe Murphy" <spam@.spamthis.com> wrote in message
> news:OdCtSbHPGHA.1832@.TK2MSFTNGP11.phx.gbl...
> Can SQL send me an email alert when log files are getting large?
> Thanks,
> JM
>
|||What version of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joe Murphy" <spam@.spamthis.com> wrote in message news:%23soU6wHPGHA.3728@.tk2msftngp13.phx.gbl...
> How to?
> --
> _______________________________
> http://boston.craigslist.org/about/b.../62974620.html
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uPDMueHPGHA.536@.TK2MSFTNGP09.phx.gbl...
>
|||I'd be interested in SQL2000 (SP3)
Regards,
Hank Arnold
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23cPC6SIPGHA.3984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> What version of SQL Server?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Joe Murphy" <spam@.spamthis.com> wrote in message
> news:%23soU6wHPGHA.3728@.tk2msftngp13.phx.gbl...
|||Enterprise Manager, Management, SQL Server Agent, right-click Alerts, New Alert.
Specify a performance condition alert with the desired perf mon counter.
And first you create your operator and make sure that SQL Mail is functioning properly.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Hank Arnold" <rasilon@.aol.com> wrote in message news:%23Y6DHDSPGHA.3408@.TK2MSFTNGP12.phx.gbl...
> I'd be interested in SQL2000 (SP3)
> --
> Regards,
> Hank Arnold
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23cPC6SIPGHA.3984@.TK2MSFTNGP14.phx.gbl...
>
|||OK, but that doesn't seem to work when trying to measure a threshold. Say
when the transaction log reaches N% of total allocated size.
That's the kind of thing I'm looking for.
Thanks,
JM
_______________________________
http://boston.craigslist.org/about/b.../62974620.html
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OPnG5UVPGHA.3264@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Enterprise Manager, Management, SQL Server Agent, right-click Alerts, New
> Alert.
> Specify a performance condition alert with the desired perf mon counter.
> And first you create your operator and make sure that SQL Mail is
> functioning properly.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Hank Arnold" <rasilon@.aol.com> wrote in message
> news:%23Y6DHDSPGHA.3408@.TK2MSFTNGP12.phx.gbl...
|||Did you specify *performance condition alert*? I'm not talking about the regular event alerts...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joe Murphy" <spam@.spamthis.com> wrote in message news:%23Nw4iLuPGHA.3848@.TK2MSFTNGP12.phx.gbl...
> OK, but that doesn't seem to work when trying to measure a threshold. Say
> when the transaction log reaches N% of total allocated size.
> That's the kind of thing I'm looking for.
> Thanks,
> JM
> --
> _______________________________
> http://boston.craigslist.org/about/b.../62974620.html
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OPnG5UVPGHA.3264@.TK2MSFTNGP11.phx.gbl...
>
|||Here's a sample script:
-- Script generated on 3/3/2006 8:48 PM
-- By: BMCI04\Administrator
-- Server: BMCI04\SQL2000
BEGIN TRANSACTION
DECLARE @.JobID BINARY(16)
DECLARE @.ReturnCode INT
SELECT @.ReturnCode = 0
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name =
N'[Uncategorized (Local)]') < 1
EXECUTE msdb.dbo.sp_add_category @.name = N'[Uncategorized (Local)]'
-- Delete the job with the same name (if it exists)
SELECT @.JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'Backup Northwind Log')
IF (@.JobID IS NOT NULL)
BEGIN
-- Check if the job is a multi-server job
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobservers
WHERE (job_id = @.JobID) AND (server_id <> 0)))
BEGIN
-- There is, so abort the script
RAISERROR (N'Unable to import job ''Backup Northwind Log'' since there
is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
-- Delete the [local] job
EXECUTE msdb.dbo.sp_delete_job @.job_name = N'Backup Northwind Log'
SELECT @.JobID = NULL
END
BEGIN
-- Add the job
EXECUTE @.ReturnCode = msdb.dbo.sp_add_job @.job_id = @.JobID OUTPUT ,
@.job_name = N'Backup Northwind Log', @.owner_login_name = N'sa', @.description
= N'No description available.', @.category_name = N'[Uncategorized (Local)]',
@.enabled = 1, @.notify_level_email = 0, @.notify_level_page = 0,
@.notify_level_netsend = 0, @.notify_level_eventlog = 2, @.delete_level= 0
IF (@.@.ERROR <> 0 OR @.ReturnCode <> 0) GOTO QuitWithRollback
-- Add the job steps
EXECUTE @.ReturnCode = msdb.dbo.sp_add_jobstep @.job_id = @.JobID, @.step_id =
1, @.step_name = N'Backup', @.command = N'backup log Northwing to disk =
''C:\Temp\Northwind.trn''', @.database_name = N'master', @.server = N'',
@.database_user_name = N'', @.subsystem = N'TSQL', @.cmdexec_success_code = 0,
@.flags = 0, @.retry_attempts = 0, @.retry_interval = 1, @.output_file_name =
N'', @.on_success_step_id = 0, @.on_success_action = 1, @.on_fail_step_id = 0,
@.on_fail_action = 2
IF (@.@.ERROR <> 0 OR @.ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @.ReturnCode = msdb.dbo.sp_update_job @.job_id = @.JobID,
@.start_step_id = 1
IF (@.@.ERROR <> 0 OR @.ReturnCode <> 0) GOTO QuitWithRollback
-- Add the Target Servers
EXECUTE @.ReturnCode = msdb.dbo.sp_add_jobserver @.job_id = @.JobID,
@.server_name = N'(local)'
IF (@.@.ERROR <> 0 OR @.ReturnCode <> 0) GOTO QuitWithRollback
END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@.@.TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:
IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Backup
Northwind Log'))
-- Delete the alert with the same name.
EXECUTE msdb.dbo.sp_delete_alert @.name = N'Backup Northwind Log'
BEGIN
EXECUTE msdb.dbo.sp_add_alert @.name = N'Backup Northwind Log', @.message_id =
0, @.severity = 0, @.enabled = 1, @.delay_between_responses = 60,
@.performance_condition = N'MSSQL$SQL2000:Databases|Log File(s) Used Size
(KB)|Northwind|>|25', @.include_event_description_in = 5, @.job_name =
N'Backup Northwind Log', @.category_name = N'[Uncategorized]'
END
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Joe Murphy" <spam@.spamthis.com> wrote in message
news:%23Nw4iLuPGHA.3848@.TK2MSFTNGP12.phx.gbl...
OK, but that doesn't seem to work when trying to measure a threshold. Say
when the transaction log reaches N% of total allocated size.
That's the kind of thing I'm looking for.
Thanks,
JM
_______________________________
http://boston.craigslist.org/about/b.../62974620.html
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OPnG5UVPGHA.3264@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Enterprise Manager, Management, SQL Server Agent, right-click Alerts, New
> Alert.
> Specify a performance condition alert with the desired perf mon counter.
> And first you create your operator and make sure that SQL Mail is
> functioning properly.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Hank Arnold" <rasilon@.aol.com> wrote in message
> news:%23Y6DHDSPGHA.3408@.TK2MSFTNGP12.phx.gbl...

email for db changes

Other than Log Explorer, is there a tool that can email me whenever db
changes are made? (Tables/ Procs/ etc.)
TIA, ChrisRwww.LogPi.com, but no e-mails.
Wait for SQL 2005 where this functionality is provided for system tables.
For SQL server 2000 and 2005, user table auditing is best done though
triggers.
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/
"ChrisR" <noemail@.bla.com> wrote in message
news:%2390HsdwNFHA.3988@.tk2msftngp13.phx.gbl...
> Other than Log Explorer, is there a tool that can email me whenever db
> changes are made? (Tables/ Procs/ etc.)
> TIA, ChrisR
>

email for db changes

Other than Log Explorer, is there a tool that can email me whenever db
changes are made? (Tables/ Procs/ etc.)
TIA, ChrisR
www.LogPi.com, but no e-mails.
Wait for SQL 2005 where this functionality is provided for system tables.
For SQL server 2000 and 2005, user table auditing is best done though
triggers.
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/
"ChrisR" <noemail@.bla.com> wrote in message
news:%2390HsdwNFHA.3988@.tk2msftngp13.phx.gbl...
> Other than Log Explorer, is there a tool that can email me whenever db
> changes are made? (Tables/ Procs/ etc.)
> TIA, ChrisR
>

email for db changes

Other than Log Explorer, is there a tool that can email me whenever db
changes are made? (Tables/ Procs/ etc.)
TIA, ChrisRwww.LogPi.com, but no e-mails.
Wait for SQL 2005 where this functionality is provided for system tables.
For SQL server 2000 and 2005, user table auditing is best done though
triggers.
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/
"ChrisR" <noemail@.bla.com> wrote in message
news:%2390HsdwNFHA.3988@.tk2msftngp13.phx.gbl...
> Other than Log Explorer, is there a tool that can email me whenever db
> changes are made? (Tables/ Procs/ etc.)
> TIA, ChrisR
>

email alert log shipping out of sync?

Hello all,
Windows 2000 Log shipping Qu.
I have successfully set up log shipping but would like the monitor server to
send an email if the servers become out of sync. It seems that the default
is only to log the event in the app log does anyone know how to set up an
email alert?
Thanks in advance foir the help, Simon.If you do not have SQL mail setup, one easy alternative is to use
xp_smtp_mail. All the required information you needed regarding this can be
found at:
http://www.sqldev.net/xp/xpsmtp.htm
Anith|||Thanks for the advice - I can use SQL mail but I'm not sure how to fire the
event:
Do the monitor server jobs (listed below) fail when there is a problem or do
they simply log the event in app log?
Log Shipping Alert Job - Backup &
Log Shipping Alert Job - Restore
Thanks again.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:Olz9OPbHFHA.2420@.TK2MSFTNGP14.phx.gbl...
> If you do not have SQL mail setup, one easy alternative is to use
> xp_smtp_mail. All the required information you needed regarding this can
> be found at:
> http://www.sqldev.net/xp/xpsmtp.htm
> --
> Anith
>|||In your job, create a new step ( say step 2 ) with the functionality to
email required addressee. On the initial step, set the "on failure action"
to goto step 2. Make sure set the "on success action" as Quit with success.
Anith

email alert log shipping out of sync?

Hello all,
Windows 2000 Log shipping Qu.
I have successfully set up log shipping but would like the monitor server to
send an email if the servers become out of sync. It seems that the default
is only to log the event in the app log does anyone know how to set up an
email alert?
Thanks in advance foir the help, Simon.
If you do not have SQL mail setup, one easy alternative is to use
xp_smtp_mail. All the required information you needed regarding this can be
found at:
http://www.sqldev.net/xp/xpsmtp.htm
Anith
|||Thanks for the advice - I can use SQL mail but I'm not sure how to fire the
event:
Do the monitor server jobs (listed below) fail when there is a problem or do
they simply log the event in app log?
Log Shipping Alert Job - Backup &
Log Shipping Alert Job - Restore
Thanks again.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:Olz9OPbHFHA.2420@.TK2MSFTNGP14.phx.gbl...
> If you do not have SQL mail setup, one easy alternative is to use
> xp_smtp_mail. All the required information you needed regarding this can
> be found at:
> http://www.sqldev.net/xp/xpsmtp.htm
> --
> Anith
>
|||In your job, create a new step ( say step 2 ) with the functionality to
email required addressee. On the initial step, set the "on failure action"
to goto step 2. Make sure set the "on success action" as Quit with success.
Anith

email alert log shipping out of sync?

Hello all,
Windows 2000 Log shipping Qu.
I have successfully set up log shipping but would like the monitor server to
send an email if the servers become out of sync. It seems that the default
is only to log the event in the app log does anyone know how to set up an
email alert?
Thanks in advance foir the help, Simon.If you do not have SQL mail setup, one easy alternative is to use
xp_smtp_mail. All the required information you needed regarding this can be
found at:
http://www.sqldev.net/xp/xpsmtp.htm
--
Anith|||Thanks for the advice - I can use SQL mail but I'm not sure how to fire the
event:
Do the monitor server jobs (listed below) fail when there is a problem or do
they simply log the event in app log?
Log Shipping Alert Job - Backup &
Log Shipping Alert Job - Restore
Thanks again.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:Olz9OPbHFHA.2420@.TK2MSFTNGP14.phx.gbl...
> If you do not have SQL mail setup, one easy alternative is to use
> xp_smtp_mail. All the required information you needed regarding this can
> be found at:
> http://www.sqldev.net/xp/xpsmtp.htm
> --
> Anith
>|||In your job, create a new step ( say step 2 ) with the functionality to
email required addressee. On the initial step, set the "on failure action"
to goto step 2. Make sure set the "on success action" as Quit with success.
--
Anith

EM can't connect to server

I suddenly can't work with my Enterprise Manager.
It tells me that log in failed - Can't access user's default database.
What can I do about it?
I really need to fix it fast.
Thanks a lot
Shimon.Shimon Sim wrote:
> I suddenly can't work with my Enterprise Manager.
> It tells me that log in failed - Can't access user's default
> database.
> What can I do about it?
> I really need to fix it fast.
> Thanks a lot
> Shimon.
Connect from Query Analyzer and change the default database for the user
you are using to login from SQL EM.
sp_defaultdb 'user', 'db'
David Gugick
Quest Software
www.imceda.com
www.quest.com|||I can't connect using QA either.
Thanks,
Shimon.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:u6P6UNmYFHA.2264@.TK2MSFTNGP10.phx.gbl...
> Shimon Sim wrote:
> Connect from Query Analyzer and change the default database for the user
> you are using to login from SQL EM.
> sp_defaultdb 'user', 'db'
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Shimon Sim wrote:
> I can't connect using QA either.
> Thanks,
> Shimon.
Log in as a different user in QA... one with admin rights. Then change
the default database.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thanks
I connected using Visial Studio
Shimon.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:u6P6UNmYFHA.2264@.TK2MSFTNGP10.phx.gbl...
> Shimon Sim wrote:
> Connect from Query Analyzer and change the default database for the user
> you are using to login from SQL EM.
> sp_defaultdb 'user', 'db'
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Hi Shimon,
Thanks for your posting!
From your descriptions, I understood you are not able to connect SQL Server
via SQL Server Enterprise Manager. Have I understood you? If I have
misunderstood your concern, please feel free to point it out.
First of all, would you please help me clarify the words "I connected using
Visial Studio"? You have said you are working wiht your Enterprise Manager?
When do you meet the error message "Can't access user's default database"?
More detailed informaiton, I believe, will make us closer to the
resolution. Please help me collecting the information by answering the
questions below
What account you are using to connect this SQL Server?
The SQL Server machine is in LAN or Internet?
You may refer the Knowledge Base article below
How to troubleshoot connectivity issues in SQL Server 2000
http://support.microsoft.com/kb/827422
BTW, if this issue is urgent, I would like to recommand you opening an
incident with PSS team direcly and there will be a dedicated Support
Professional working for you. Please be advised that contacting phone
support will be a charged call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/defaul...US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a w to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Michael
Thanks for your response.
I resolved the issue.
What happen I deleted my default database. And all the users for the SQL
Server had that database as default. So every program (EM,QA) that uses
default database in order to operate was throwing errors that they can't
login to the server.
So I decided to create database project in VS that uses specifies database
for login and not default and changed default database for all the users.
Thanks again.
Shimon.
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:NIh58$oYFHA.2476@.TK2MSFTNGXA01.phx.gbl...
> Hi Shimon,
> Thanks for your posting!
> From your descriptions, I understood you are not able to connect SQL
> Server
> via SQL Server Enterprise Manager. Have I understood you? If I have
> misunderstood your concern, please feel free to point it out.
> First of all, would you please help me clarify the words "I connected
> using
> Visial Studio"? You have said you are working wiht your Enterprise
> Manager?
> When do you meet the error message "Can't access user's default database"?
> More detailed informaiton, I believe, will make us closer to the
> resolution. Please help me collecting the information by answering the
> questions below
> What account you are using to connect this SQL Server?
> The SQL Server machine is in LAN or Internet?
> You may refer the Knowledge Base article below
> How to troubleshoot connectivity issues in SQL Server 2000
> http://support.microsoft.com/kb/827422
> BTW, if this issue is urgent, I would like to recommand you opening an
> incident with PSS team direcly and there will be a dedicated Support
> Professional working for you. Please be advised that contacting phone
> support will be a charged call.
> To obtain the phone numbers for specific technology request please take a
> look at the web site listed below.
> http://support.microsoft.com/defaul...US;PHONENUMBERS
> If you are outside the US please see http://support.microsoft.com for
> regional support phone numbers.
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a w to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/te...erview/40010469
> Others: https://partner.microsoft.com/US/te...upportoverview/
> If you are outside the United States, please visit our International
> Support page: http://support.microsoft.com/common/international.aspx
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi Shimon,
You are welcome and it's great to hear you have resolved this!
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a w to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

EL 3.1 and logging to sql server 2005

How do I set up EL to log information to a sql server 2005 DB? I have created the the Database Trace Listener through the configuration utility, but do I need to run some script on the DB to create the tables, sprocs etc? I can't find any script though...

Thanks

Found it in if anyone is interested

\EntLib3Src\App Blocks\Src\Logging\TraceListeners\Database\Scripts

edition requirements for log shipping

I know that Enterprise Ed is required for Log Shipping. But is that on both
boxes or just the primary? Also, any links to people that have wrote they're
own LS would be appreciated.
Chris,
have a look at this article:
http://support.microsoft.com/default...b;en-us;314515
HTH,
Paul Ibison

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.