NetSend notifications

I received the error message listed below after stopping and restarting my
SQL Server 2005 database server.
Please help me resolve this error.
Thank You,
Errorlog Error Message:
[364] The Messenger service has not been started - NetSend notifications
will not be sent
Joe K. wrote:
> I received the error message listed below after stopping and restarting my
> SQL Server 2005 database server.
> Please help me resolve this error.
> Thank You,
>
> Errorlog Error Message:
> [364] The Messenger service has not been started - NetSend notifications
> will not be sent
>
Has the Messenger service been started?
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Why would you even consider starting the Messenger service on a Server?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:456F40A5.3040400@.realsqlguy.com...
> Joe K. wrote:
> Has the Messenger service been started?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
sql

NetSend notifications

I received the error message listed below after stopping and restarting my
SQL Server 2005 database server.
Please help me resolve this error.
Thank You,
Errorlog Error Message:
[364] The Messenger service has not been started - NetSend notifications
will not be sentJoe K. wrote:
> I received the error message listed below after stopping and restarting my
> SQL Server 2005 database server.
> Please help me resolve this error.
> Thank You,
>
> Errorlog Error Message:
> [364] The Messenger service has not been started - NetSend notificatio
ns
> will not be sent
>
Has the Messenger service been started?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Why would you even consider starting the Messenger service on a Server?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:456F40A5.3040400@.realsqlguy.com...
> Joe K. wrote:
> Has the Messenger service been started?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Arnie Rowland wrote:
> Why would you even consider starting the Messenger service on a Server?
>
Hey, I was just asking the obvious question based on the error
message... :-)
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||My response was not directed at you Tracy, I expect that you know better...
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:456F4A0E.7040100@.realsqlguy.com...
> Arnie Rowland wrote:
> Hey, I was just asking the obvious question based on the error message...
> :-)
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Agent has an option to alert an operator through NET SEND, which uses the Me
ssenger service. If the
service isn't started, then Agent will write this entry to the eventlog. The
messenger and Alerter
(used on the client which receives the message) is considered security risky
and are both disabled
with XP sp2. If you don't Alert operators though NET SEND you can ignore thi
s entry.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:A5124E41-B6AC-4A8F-8C8F-CFB93F4568F8@.microsoft.com...
> I received the error message listed below after stopping and restarting my
> SQL Server 2005 database server.
> Please help me resolve this error.
> Thank You,
>
> Errorlog Error Message:
> [364] The Messenger service has not been started - NetSend notificatio
ns
> will not be sent
>

Net send message

SQL Server 2000 SP3.
Is it possible to send a "net send" message to more than 1 operator in SQL
Server job Notifications ?. If not, is there a work-around ?.
We need to send a "Net Send" message when a job fails to more than 1
operator. How this can be possible ? I have defined multiple operators in
"SQL Server Agent--> Operators" but it is one or the other in the job's
Notifications.
T.I.A
Net Send is not an effective way to communicate/alert people. IMHO, it
shouldn't even have been included in the product. You'd be better off to send
an email. Or if you are monitoring your evenlogs, execute RAISERROR upon a
job failure to log an error in the app eventlog, and let your monitoring
system pick it up and alert you.
Linchi
"DXC" wrote:

> SQL Server 2000 SP3.
> Is it possible to send a "net send" message to more than 1 operator in SQL
> Server job Notifications ?. If not, is there a work-around ?.
> We need to send a "Net Send" message when a job fails to more than 1
> operator. How this can be possible ? I have defined multiple operators in
> "SQL Server Agent--> Operators" but it is one or the other in the job's
> Notifications.
> T.I.A
|||Thanks.................The problem is, server is in one domain (A secure
domain) and the monitoring will be done on another domain where 2 domains
don't see each other........
"Linchi Shea" wrote:
[vbcol=seagreen]
> Net Send is not an effective way to communicate/alert people. IMHO, it
> shouldn't even have been included in the product. You'd be better off to send
> an email. Or if you are monitoring your evenlogs, execute RAISERROR upon a
> job failure to log an error in the app eventlog, and let your monitoring
> system pick it up and alert you.
> Linchi
> "DXC" wrote:

Net send message

SQL Server 2000 SP3.
Is it possible to send a "net send" message to more than 1 operator in SQL
Server job Notifications ?. If not, is there a work-around ?.
We need to send a "Net Send" message when a job fails to more than 1
operator. How this can be possible ? I have defined multiple operators in
"SQL Server Agent--> Operators" but it is one or the other in the job's
Notifications.
T.I.ANet Send is not an effective way to communicate/alert people. IMHO, it
shouldn't even have been included in the product. You'd be better off to sen
d
an email. Or if you are monitoring your evenlogs, execute RAISERROR upon a
job failure to log an error in the app eventlog, and let your monitoring
system pick it up and alert you.
Linchi
"DXC" wrote:

> SQL Server 2000 SP3.
> Is it possible to send a "net send" message to more than 1 operator in SQL
> Server job Notifications ?. If not, is there a work-around ?.
> We need to send a "Net Send" message when a job fails to more than 1
> operator. How this can be possible ? I have defined multiple operators in
> "SQL Server Agent--> Operators" but it is one or the other in the job's
> Notifications.
> T.I.A|||Thanks.................The problem is, server is in one domain (A secur
e
domain) and the monitoring will be done on another domain where 2 domains
don't see each other........
"Linchi Shea" wrote:
[vbcol=seagreen]
> Net Send is not an effective way to communicate/alert people. IMHO, it
> shouldn't even have been included in the product. You'd be better off to s
end
> an email. Or if you are monitoring your evenlogs, execute RAISERROR upon a
> job failure to log an error in the app eventlog, and let your monitoring
> system pick it up and alert you.
> Linchi
> "DXC" wrote:
>sql

net send address fail

Hi ,
how do i actually sent a message via net send addr in SQL server
i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
using the local system acct
i tried to put in an ip addr that i can ping to into the Fail safe Operator
but SQL complains that it fail to net send
could anyone advise ?
tks & rdgs
First of all, make sure you can do that net send outside of SQL. Test at cmd
prmpt. If that doesn't work, obviously you need to TShoot there first.
Second, if SQL is going to be hitting the network at all, you should start
SQL under a domain user account.
Third, try creating a simple job that does xp_cmdshell 'net send <remote
machinename> ''test'' '
Note: those are all single quotes.
Donna Lambert
"maxzsim" wrote:

> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operator
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs
|||Sorry, for clarification - it's SQL AGENT that needs to run under the domain
user account if you are creating and scheduling a job.
Donna
"maxzsim" wrote:

> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operator
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs
sql

net send address fail

Hi ,
how do i actually sent a message via net send addr in SQL server
i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
using the local system acct
i tried to put in an ip addr that i can ping to into the Fail safe Operator
but SQL complains that it fail to net send
could anyone advise ?
tks & rdgsFirst of all, make sure you can do that net send outside of SQL. Test at cm
d
prmpt. If that doesn't work, obviously you need to TShoot there first.
Second, if SQL is going to be hitting the network at all, you should start
SQL under a domain user account.
Third, try creating a simple job that does xp_cmdshell 'net send <remote
machinename> ''test'' '
Note: those are all single quotes.
Donna Lambert
"maxzsim" wrote:

> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQ
L
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operato
r
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs|||Sorry, for clarification - it's SQL AGENT that needs to run under the domain
user account if you are creating and scheduling a job.
Donna
"maxzsim" wrote:

> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQ
L
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operato
r
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs

net send address fail

Hi ,
how do i actually sent a message via net send addr in SQL server
i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
using the local system acct
i tried to put in an ip addr that i can ping to into the Fail safe Operator
but SQL complains that it fail to net send
could anyone advise ?
tks & rdgsFirst of all, make sure you can do that net send outside of SQL. Test at cmd
prmpt. If that doesn't work, obviously you need to TShoot there first.
Second, if SQL is going to be hitting the network at all, you should start
SQL under a domain user account.
Third, try creating a simple job that does xp_cmdshell 'net send <remote
machinename> ''test'' '
Note: those are all single quotes.
Donna Lambert
"maxzsim" wrote:
> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operator
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs|||Sorry, for clarification - it's SQL AGENT that needs to run under the domain
user account if you are creating and scheduling a job.
Donna
"maxzsim" wrote:
> Hi ,
> how do i actually sent a message via net send addr in SQL server
> i am using SQL server 2000 sp3 on win2k server SP4 and i have set up my SQL
> using the local system acct
> i tried to put in an ip addr that i can ping to into the Fail safe Operator
> but SQL complains that it fail to net send
> could anyone advise ?
> tks & rdgs

Nested Tables

This is a multi-part message in MIME format.
--=_NextPart_000_000B_01C75C0A.08318580
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all
Wanting to create a report with a table inside another table. I've set = the dataset for each table to the relevant datasources. However when I = try set textboxes of the inner table to fields from dataset of the ineer = table, I get the following error message.
The value expression for the textbox 'textbox12' refers to the field = 'NAME'. Report item expressions can only refer to fields within the = current data set scope or, if inside an aggregate, the specified data = set scope.
I also get this error when trying to set a filter on the inner table to = a value on the outer table.
Not sure if this is the right newsgroup, if not someone please let me = know where I can get an answer
Using SQL Reporting services 2000, Visual Studio.NET 2003
Thanks
George
--=_NextPart_000_000B_01C75C0A.08318580
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi all

Wanting to create a report with a = table inside another table. I've set the dataset for each table to = the relevant datasources. However when I try set textboxes of the inner = table to fields from dataset of the ineer table, I get the following error message.

The value expression for the = textbox =91textbox12=92 refers to the field =91NAME=92. Report item = expressions can only refer to fields within the current data set scope or, if inside an = aggregate, the specified data set scope.
I also get this error when trying to = set a filter on the inner table to a value on the outer table.

Not sure if this is the right = newsgroup, if not someone please let me know where I can get an answer

Using SQL Reporting services 2000, = Visual Studio.NET 2003

Thanks

George
--=_NextPart_000_000B_01C75C0A.08318580--On Feb 28, 9:00 pm, "_george" <none@.nojne@.none> wrote:
> Hi all
> Wanting to create a report with a table inside another table. I've set the dataset for each table to the relevant datasources. However when I try set textboxes of the inner table to fields from dataset of the ineer table, I get the following error message.
> The value expression for the textbox 'textbox12' refers to the field 'NAME'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
> I also get this error when trying to set a filter on the inner table to a value on the outer table.
> Not sure if this is the right newsgroup, if not someone please let me know where I can get an answer
> Using SQL Reporting services 2000, Visual Studio.NET 2003
> Thanks
> George
You might have to explicitly reference the dataset. For example, if
the inside table is table 2, you might have to use an expression like
the following:
=Max(Fields!NAME.Value, "dsTable2sDataSetName")
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Tried that. Still same error. I suppose I'm asking if this is possible?
Thanks
George
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1172720239.500267.94860@.s48g2000cws.googlegroups.com...
> On Feb 28, 9:00 pm, "_george" <none@.nojne@.none> wrote:
>> Hi all
>> Wanting to create a report with a table inside another table. I've set
>> the dataset for each table to the relevant datasources. However when I
>> try set textboxes of the inner table to fields from dataset of the ineer
>> table, I get the following error message.
>> The value expression for the textbox 'textbox12' refers to the field
>> 'NAME'. Report item expressions can only refer to fields within the
>> current data set scope or, if inside an aggregate, the specified data set
>> scope.
>> I also get this error when trying to set a filter on the inner table to a
>> value on the outer table.
>> Not sure if this is the right newsgroup, if not someone please let me
>> know where I can get an answer
>> Using SQL Reporting services 2000, Visual Studio.NET 2003
>> Thanks
>> George
>
> You might have to explicitly reference the dataset. For example, if
> the inside table is table 2, you might have to use an expression like
> the following:
> =Max(Fields!NAME.Value, "dsTable2sDataSetName")
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>sql

nested ifs in custom code

Is it not possible to have nested ifs in a custom code function? I keep getting an error message when I try it.Never mind. Sorry!

Nested Database Transactions in Forms

This should be a fairly simple question. It's based on this error message:

"Transaction count after EXECUTEindicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.Previous count = 1, current count = 0."

I get this when executing a stored procedure upon processing a form. This error happens when I intentionally provide input to the stored procedure that I know should cause it to error out. I catch the exception, and it contains the error message, but it also contains the above message added on to it, which I don't want.

I won't post the entire stored procedure. But I'll list a digest of it (Just those lines that are significant). Assume that what's included is what happens when I provide bad input:

BEGIN

BEGIN TRY
BEGIN TRANSACTION
RAISERROR('The item selected does not exist in the database.', 16, 1);
COMMIT -- This won't execute when the RAISERROR breaks out to the CATCH block
END TRY

BEGIN CATCH
ROLLBACK
DECLARE @.ErrorSeverity INT, @.ErrorMessage NVARCHAR(4000)
SET @.ErrorSeverity = ERROR_SEVERITY()
SET @.ErrorMessage = ERROR_MESSAGE()
RAISERROR(@.ErrorMessage, @.ErrorSeverity, 1)
END CATCH

END

Okay, so that works fine. The problem is when I execute this with an SqlCommand object, on which I've opened a transaction. I won't include the entire setup of the data (with the parameters, since those seem fine), but I'll give my code that opens the connection and executes the query:

con.Open();
SqlTransaction transaction = con.BeginTransaction();
command.Transaction = transaction;

try
{
command.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
finally
{
con.Close();
}

I'm calling the stored procedure listed above (which has its own transaction), using a SqlCommand object on which I've opened a transaction. When there is no error it works fine. But when I give the stored procedure bad data, it gives me that message about the transaction count.

Is there something I need to do in either my SQL or my C# to handle this? The entire message found in the Exception's Message is a concatenation of the message in my RAISERROR, along with the transaction count message I quoted at the beginning.

Thanks,

-Dan

In playing around with it, I've come to learn that the Exception.Message is the concatenation of any messages the exception holds. So, my CATCH block could contain this instead:

Label.Text = String.Format("Error: {0}", ex.Errors[0].Message);

That only gives the first error, which is the one I want (the one specified in RAISERROR). I just don't know if this is what I should do. Is that transaction count message something I should be concerned about, or will that always happen? Should I just use the first message in the exception?

Thanks.