Do somebody know how long (in chars) script(command) can be solved by SQL Command?

Do somebody know how long (in chars) script(command) can be solved by SQL Command?
ThanksIn the case of SQL Server, your total command length must be no more than 8000 characters. It does indeed use sp_executesql, which imposes this limitation.

Do nto send scheduled report when no data is present

Dear Friends:

Could somebody please help me to stop sending scheduled report when no data is present in the report? Actually I have a daily report which is sent to the client and in a week, two or three days, data will not be there and thus it delivers blank report to the client.

So how can I stop sending blank mails to the client?

Thanks in Advance

Emmanuel Mathew

One possibility would be creating a data-driven subscription with query that returns an empty list of recipients if no data for the report is available.sql

DMZ, MSDTC and Windows Server 2003 SP1

Hi, did somebody know a checklist or Q-Article how to configure MSDTC
between
two SQL Server in two separate DMZ (Firewall Ports) ?
Further, I must find out which impact has Windows Server SP1 on MSDTC or
better
on a BizTalk 2004 Server.
Thanks for all Infos.
Hi
Check out "INFO: Configuring Microsoft Distributed Transaction Coordinator
(DTC) to Work Through a Firewall" http://support.microsoft.com/kb/250367/
Service Pack 1 enforces tighter security, if you can test the installation
on another system it would help but not guarantee there will not be issues.
You may want to run MBSA to see what it throws before you install the service
pack as these may be potential problem areas.
John
"MV" wrote:

> Hi, did somebody know a checklist or Q-Article how to configure MSDTC
> between
> two SQL Server in two separate DMZ (Firewall Ports) ?
> Further, I must find out which impact has Windows Server SP1 on MSDTC or
> better
> on a BizTalk 2004 Server.
> Thanks for all Infos.
>
>

DMZ, MSDTC and Windows Server 2003 SP1

Hi, did somebody know a checklist or Q-Article how to configure MSDTC
between
two SQL Server in two separate DMZ (Firewall Ports) ?
Further, I must find out which impact has Windows Server SP1 on MSDTC or
better
on a BizTalk 2004 Server.
Thanks for all Infos.Hi
Check out "INFO: Configuring Microsoft Distributed Transaction Coordinator
(DTC) to Work Through a Firewall" http://support.microsoft.com/kb/250367/
Service Pack 1 enforces tighter security, if you can test the installation
on another system it would help but not guarantee there will not be issues.
You may want to run MBSA to see what it throws before you install the service
pack as these may be potential problem areas.
John
"MV" wrote:
> Hi, did somebody know a checklist or Q-Article how to configure MSDTC
> between
> two SQL Server in two separate DMZ (Firewall Ports) ?
> Further, I must find out which impact has Windows Server SP1 on MSDTC or
> better
> on a BizTalk 2004 Server.
> Thanks for all Infos.
>
>

DMZ, MSDTC and Windows Server 2003 SP1

Hi, did somebody know a checklist or Q-Article how to configure MSDTC
between
two SQL Server in two separate DMZ (Firewall Ports) ?
Further, I must find out which impact has Windows Server SP1 on MSDTC or
better
on a BizTalk 2004 Server.
Thanks for all Infos.Hi
Check out "INFO: Configuring Microsoft Distributed Transaction Coordinator
(DTC) to Work Through a Firewall" http://support.microsoft.com/kb/250367/
Service Pack 1 enforces tighter security, if you can test the installation
on another system it would help but not guarantee there will not be issues.
You may want to run MBSA to see what it throws before you install the servic
e
pack as these may be potential problem areas.
John
"MV" wrote:

> Hi, did somebody know a checklist or Q-Article how to configure MSDTC
> between
> two SQL Server in two separate DMZ (Firewall Ports) ?
> Further, I must find out which impact has Windows Server SP1 on MSDTC or
> better
> on a BizTalk 2004 Server.
> Thanks for all Infos.
>
>

Divide by Zero error

With the following sql I get a divide by zero error. Can somebody help me
with the syntax to fix this?
Thanks in advance
SUM(CASE WHEN (p.SecondaryCapacity/p.SecondaryWatts) < (m.SecondaryEERSpec -
(-1 * (@.LowerSpec * m.SecondaryEERSpec))) OR
(p.SecondaryCapacity/p.SecondaryWatts) > (m.SecondaryEERSpec +
(@.UpperSpec * m.SecondaryEERSpec)) THEN 1 Else 0 END) as SecondaryEERFailure
sHow about checking for p.SecondaryWatts first?
SUM(
CASE WHEN (p.SecondaryWatts =0) THEN -1
WHEN (p.SecondaryCapacity/p.SecondaryWatts) <
(m.SecondaryEERSpec - (-1 * (@.LowerSpec * m.SecondaryEERSpec)))
OR
(p.SecondaryCapacity/p.SecondaryWatts) > (m.SecondaryEERSpec +
(@.UpperSpec * m.SecondaryEERSpec))
THEN 1 Else 0 END
) as SecondaryEERFailures
"StvJston" wrote:

> With the following sql I get a divide by zero error. Can somebody help me
> with the syntax to fix this?
>
> Thanks in advance
> SUM(CASE WHEN (p.SecondaryCapacity/p.SecondaryWatts) < (m.SecondaryEERSpec
-
> (-1 * (@.LowerSpec * m.SecondaryEERSpec))) OR
> (p.SecondaryCapacity/p.SecondaryWatts) > (m.SecondaryEERSpec +
> (@.UpperSpec * m.SecondaryEERSpec)) THEN 1 Else 0 END) as SecondaryEERFailu
res
>|||Kevin,
Thanks for your reply. I just got it figured out and did just what you
suggested.
SUM(CASE WHEN p.SecondayWatts = 0 THEN 0
ELSE CASE WHEN (p.SecondaryCapacity/p.SecondaryWatts) <
(m.SecondaryEERSpec - (-1 * (@.LowerSpec * m.SecondaryEERSpec))) OR
(p.SecondaryCapacity/p.SecondaryWatts) > (m.SecondaryEERSpec +
(@.UpperSpec * m.SecondaryEERSpec)) THEN 1 Else 0 END END) as
SecondaryEERFailures,
"Kevin Bowker" wrote:
> How about checking for p.SecondaryWatts first?
> SUM(
> CASE WHEN (p.SecondaryWatts =0) THEN -1
> WHEN (p.SecondaryCapacity/p.SecondaryWatts) <
> (m.SecondaryEERSpec - (-1 * (@.LowerSpec * m.SecondaryEERSpec)))
> OR
> (p.SecondaryCapacity/p.SecondaryWatts) > (m.SecondaryEERSpec +
> (@.UpperSpec * m.SecondaryEERSpec))
> THEN 1 Else 0 END
> ) as SecondaryEERFailures
> "StvJston" wrote:
>