More not in issue

Hi,
I have three tables, one is the client information table (T1) contain an
uniqueid for the client, the other is client address table (T2), which
contains different type of address for the client (e.g. business address,
home address) and the different type of address is identified by addtype_c,
and it is link to T1 via clientid. The third table (T3) contains the media
request from the clients and the address (add_c) they want the media sent to
.
and of course, it has the fields clientid.
I need to generate the mailing lable for the client according to the address
that the client want the materials sent to. However, how can I create a
query to alert me that the address type that the clients want the materials
sent to is not in the address table.
Thanks in advance.One option change your business logic to require a ship-to address when the
client is filling in this information. Or add a WHERE clause to your query
to exclude NULL addresses or if you use a DEFAULT to exclude addresses = to
the DEFAULT.
HTH
Jerry
"qjlee" <qjlee@.discussions.microsoft.com> wrote in message
news:421420FC-090A-499F-9715-32A63D9A2930@.microsoft.com...
> Hi,
> I have three tables, one is the client information table (T1) contain an
> uniqueid for the client, the other is client address table (T2), which
> contains different type of address for the client (e.g. business address,
> home address) and the different type of address is identified by
> addtype_c,
> and it is link to T1 via clientid. The third table (T3) contains the
> media
> request from the clients and the address (add_c) they want the media sent
> to.
> and of course, it has the fields clientid.
> I need to generate the mailing lable for the client according to the
> address
> that the client want the materials sent to. However, how can I create a
> query to alert me that the address type that the clients want the
> materials
> sent to is not in the address table.
> Thanks in advance.
>|||On Fri, 30 Sep 2005 07:16:04 -0700, qjlee wrote:

>Hi,
>I have three tables, one is the client information table (T1) contain an
>uniqueid for the client, the other is client address table (T2), which
>contains different type of address for the client (e.g. business address,
>home address) and the different type of address is identified by addtype_c,
>and it is link to T1 via clientid. The third table (T3) contains the media
>request from the clients and the address (add_c) they want the media sent t
o.
>and of course, it has the fields clientid.
>I need to generate the mailing lable for the client according to the addres
s
>that the client want the materials sent to. However, how can I create a
>query to alert me that the address type that the clients want the materials
>sent to is not in the address table.
>Thanks in advance.
>
Hi qjlee,
Since you didn't post DDL and sample data (www.aspfaq.com/5006), I'll
have to make some wild assumptions about your tables.
SELECT T3.ClientID, T3.add_c
FROM T3
WHERE NOT EXISTS
(SELECT *
FROM T2
WHERE T2.ClientID = T3.ClientID
AND T2.AddressType = T3.AddressType)
or
SELECT T3.ClientID, T3.add_c
FROM T3
LEFT JOIN T2
ON T2.ClientID = T3.ClientID
AND T2.AddressType = T3.AddressType
WHERE T2.ClientID IS NULL
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

monitoring sql server 2000 for problems

I've developed and am deploying a very important enterprise wide app for a
client. This app controls virtually everything the client does, and has
been thoroughly tested. However, I am a bit concerned about sql server
2000.
I noticed just the other day - still testing - that the server, when opened
in EM, said 'suspect'. I had been doing some fooling around and I know what
caused it. But my concern is, how can I monitor the server for this or
other failures to be able to react quickly - with a backup when necessary -
whenever something serious occurs? Is there a way, either inside vb .net or
by other means of continually polling the server for its health?
Thanks for any recommendations.
Regards,
Bernie Yaeger
Start a service application to continously run SELECT
DATABASEPROPERTYEX('pubs', 'Status') and check it's results?
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
news:WaqAc.39196$0b.10585827@.news4.srv.hcvlny.cv.n et...
> I've developed and am deploying a very important enterprise wide app for a
> client. This app controls virtually everything the client does, and has
> been thoroughly tested. However, I am a bit concerned about sql server
> 2000.
> I noticed just the other day - still testing - that the server, when
opened
> in EM, said 'suspect'. I had been doing some fooling around and I know
what
> caused it. But my concern is, how can I monitor the server for this or
> other failures to be able to react quickly - with a backup when
necessary -
> whenever something serious occurs? Is there a way, either inside vb .net
or
> by other means of continually polling the server for its health?
> Thanks for any recommendations.
> Regards,
> Bernie Yaeger
>

monitoring sql server 2000 for problems

I've developed and am deploying a very important enterprise wide app for a
client. This app controls virtually everything the client does, and has
been thoroughly tested. However, I am a bit concerned about sql server
2000.
I noticed just the other day - still testing - that the server, when opened
in EM, said 'suspect'. I had been doing some fooling around and I know what
caused it. But my concern is, how can I monitor the server for this or
other failures to be able to react quickly - with a backup when necessary -
whenever something serious occurs? Is there a way, either inside vb .net or
by other means of continually polling the server for its health?
Thanks for any recommendations.
Regards,
Bernie YaegerStart a service application to continously run SELECT
DATABASEPROPERTYEX('pubs', 'Status') and check it's results?
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
news:WaqAc.39196$0b.10585827@.news4.srv.hcvlny.cv.net...
> I've developed and am deploying a very important enterprise wide app for a
> client. This app controls virtually everything the client does, and has
> been thoroughly tested. However, I am a bit concerned about sql server
> 2000.
> I noticed just the other day - still testing - that the server, when
opened
> in EM, said 'suspect'. I had been doing some fooling around and I know
what
> caused it. But my concern is, how can I monitor the server for this or
> other failures to be able to react quickly - with a backup when
necessary -
> whenever something serious occurs? Is there a way, either inside vb .net
or
> by other means of continually polling the server for its health?
> Thanks for any recommendations.
> Regards,
> Bernie Yaeger
>

monitoring sql server 2000 for problems

I've developed and am deploying a very important enterprise wide app for a
client. This app controls virtually everything the client does, and has
been thoroughly tested. However, I am a bit concerned about sql server
2000.
I noticed just the other day - still testing - that the server, when opened
in EM, said 'suspect'. I had been doing some fooling around and I know what
caused it. But my concern is, how can I monitor the server for this or
other failures to be able to react quickly - with a backup when necessary -
whenever something serious occurs? Is there a way, either inside vb .net or
by other means of continually polling the server for its health?
Thanks for any recommendations.
Regards,
Bernie YaegerStart a service application to continously run SELECT
DATABASEPROPERTYEX('pubs', 'Status') and check it's results?
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
news:WaqAc.39196$0b.10585827@.news4.srv.hcvlny.cv.net...
> I've developed and am deploying a very important enterprise wide app for a
> client. This app controls virtually everything the client does, and has
> been thoroughly tested. However, I am a bit concerned about sql server
> 2000.
> I noticed just the other day - still testing - that the server, when
opened
> in EM, said 'suspect'. I had been doing some fooling around and I know
what
> caused it. But my concern is, how can I monitor the server for this or
> other failures to be able to react quickly - with a backup when
necessary -
> whenever something serious occurs? Is there a way, either inside vb .net
or
> by other means of continually polling the server for its health?
> Thanks for any recommendations.
> Regards,
> Bernie Yaeger
>

Monitor SQL Server?

Hello,
I have a request from a client to have monitoring of a specific
database in case any errors arise to help them isolate the problem.
Would using Profiler accomplish this? Is there a way to set it up so
it's only logged during working hours?
Yes, you can set a filter to only cature events for a given time period.
"JSM" wrote:

> Hello,
> I have a request from a client to have monitoring of a specific
> database in case any errors arise to help them isolate the problem.
> Would using Profiler accomplish this? Is there a way to set it up so
> it's only logged during working hours?
>
|||Hi
Look at creating a scheduled server side trace, although if there is alot of
activity you may be logging a significant amount of information. Jasper Smith
has a 1 hour trace http://www.sqldbatips.com/showcode.asp?ID=7 which you can
change to be (say) 9 hours and start before the beginning of the day in a SQL
Agent job.
John
"JSM" wrote:

> Hello,
> I have a request from a client to have monitoring of a specific
> database in case any errors arise to help them isolate the problem.
> Would using Profiler accomplish this? Is there a way to set it up so
> it's only logged during working hours?
>

Monitor SQL Server?

Hello,
I have a request from a client to have monitoring of a specific
database in case any errors arise to help them isolate the problem.
Would using Profiler accomplish this? Is there a way to set it up so
it's only logged during working hours?Yes, you can set a filter to only cature events for a given time period.
"JSM" wrote:

> Hello,
> I have a request from a client to have monitoring of a specific
> database in case any errors arise to help them isolate the problem.
> Would using Profiler accomplish this? Is there a way to set it up so
> it's only logged during working hours?
>|||Hi
Look at creating a scheduled server side trace, although if there is alot of
activity you may be logging a significant amount of information. Jasper Smit
h
has a 1 hour trace http://www.sqldbatips.com/showcode.asp?ID=7 which you can
change to be (say) 9 hours and start before the beginning of the day in a SQ
L
Agent job.
John
"JSM" wrote:

> Hello,
> I have a request from a client to have monitoring of a specific
> database in case any errors arise to help them isolate the problem.
> Would using Profiler accomplish this? Is there a way to set it up so
> it's only logged during working hours?
>

Monitor SQL Server?

Hello,
I have a request from a client to have monitoring of a specific
database in case any errors arise to help them isolate the problem.
Would using Profiler accomplish this? Is there a way to set it up so
it's only logged during working hours?Yes, you can set a filter to only cature events for a given time period.
"JSM" wrote:
> Hello,
> I have a request from a client to have monitoring of a specific
> database in case any errors arise to help them isolate the problem.
> Would using Profiler accomplish this? Is there a way to set it up so
> it's only logged during working hours?
>|||Hi
Look at creating a scheduled server side trace, although if there is alot of
activity you may be logging a significant amount of information. Jasper Smith
has a 1 hour trace http://www.sqldbatips.com/showcode.asp?ID=7 which you can
change to be (say) 9 hours and start before the beginning of the day in a SQL
Agent job.
John
"JSM" wrote:
> Hello,
> I have a request from a client to have monitoring of a specific
> database in case any errors arise to help them isolate the problem.
> Would using Profiler accomplish this? Is there a way to set it up so
> it's only logged during working hours?
>

Monitor Network traffic

I would like to know how much network traffic I am using between my client
and SQL Server. What would be a good tool to capture the total amount of
traffic?
thanksHi,
Network Performance Counters
One of the best ways to monitor if you have a network bottleneck is to watch
the "Network Interface Object: Bytes Total/Sec" counter. This counter
measures the number of bytes that are being sent back and forth between your
server and the network. This includes both SQL Server and non-SQL Server
network traffic. Assuming your server is a dedicated SQL Server, then the
vast majority of the traffic measured by this counter should be from SQL
Server.
There is no hard and fast "correct" number for this counter as it measures
the actual traffic. To help you decide if your server has a network
bottleneck, one way to use this number is to compare it with the maximum
traffic supported by the network connection your server is using. Also, this
is another important counter to watch over time. It is important to know if
your network traffic is increasing regularly. If it is, then you can use
this information to help you plan for future hardware needs.
If your SQL Server is experiencing network bottlenecks, consider these
possible solutions:
a.. Add faster network cards.
b.. Add additional network cards.
c.. Server network card should be attached to switches.
d.. Network cards should be running in full duplex mode.
e.. Tune your application so that it does not require unnecessary network
trips. Do this by returning only the required data and used stored
procedures.
f.. Remove all unnecessary network protocols from the server.
g.. Use TCP/IP as the network library on the client and server.
Before you can use the network performance counters, the Network Monitor
Agent service must be installed on your server. After installing it, you
will have to reboot. Also, don't forget to rerun the latest NaT service pack
to update the files added during the installation process.
Take a look into the MS tools available
http://msdn2.microsoft.com/en-us/library/ms179428.aspx
Thanks
Hari
SQL Server MVP
"John Grant" <JohnGrant@.discussions.microsoft.com> wrote in message
news:950901AE-F368-4B9A-A523-47E1D5A8FD87@.microsoft.com...
>I would like to know how much network traffic I am using between my client
> and SQL Server. What would be a good tool to capture the total amount of
> traffic?
> thanks

MOM Report Integration with Sharepoint Portal

All,
I work for a partner, and we use MOM 2005 in a "managed services" scenario
to monitor client environments, and are attempting to develop client-facing
sites within Sharepoint portal to display various reports and alert information.
This effort spawned the following question:
What would be the best way to provide a MOM "State View" (green/yellow/red)
within a Sharepoint site. I cannot find the state data within the Onepoint
database (nor any reference in the MOMSDK), nor any existing SPS web part
to fit the bill.
Any pointer to where in the database this data lies or opinions on the best
way to address the challenge would be appreciated.
Thanks,
PetMOM 2005 comes with a range of Reporting Services reports, probably
including the one you want. With Reporting Services SP 2, there comes 2 web
parts for SharePoint, the Report Explorer and the Report Viewer. So what you
can do is to set up Reporting Services, and then install the two RS Web
parts to your SharePOint site, and point the reports you want to see. I
think you can use the Report Viewer to show just one report, so you don't
show everyone all the other MOM reports.
Kaisa M. Lindahl
"Pete Zerger" <pete.zerger@.nospam.gmail.com> wrote in message
news:7e9e9bb33a01d8c792709c6ecd86@.msnews.microsoft.com...
> All,
> I work for a partner, and we use MOM 2005 in a "managed services" scenario
> to monitor client environments, and are attempting to develop
> client-facing sites within Sharepoint portal to display various reports
> and alert information. This effort spawned the following question:
> What would be the best way to provide a MOM "State View"
> (green/yellow/red) within a Sharepoint site. I cannot find the state data
> within the Onepoint database (nor any reference in the MOMSDK), nor any
> existing SPS web part to fit the bill.
> Any pointer to where in the database this data lies or opinions on the
> best way to address the challenge would be appreciated.
>
> Thanks,
> Pete
>