Problem getting information regarding the application connected to

I am using MSDE 2000 ,
I would like to get information from master..sysprocesses table
to see what programs are connected to the database.
I would to verfy how many times a particular program is connected to the
database
Lets say i would like to check the number of times program X is connected to
the
database.
The select statement is like Select * from master..sysprocesses where
program_name ='X'
but unfortunately whenever i connect using programX , the Program_name field
is Empty.
So I am unable to compare against the program name. Is there any other table
from which
i can gather consistent information? Any workaround would also be welcome.
Thanks in advance
Prakash
hi Prakash,
Prakash wrote:
> I am using MSDE 2000 ,
> I would like to get information from master..sysprocesses table
> to see what programs are connected to the database.
> I would to verfy how many times a particular program is connected to
> the database
> Lets say i would like to check the number of times program X is
> connected to the
> database.
> The select statement is like Select * from master..sysprocesses where
> program_name ='X'
> but unfortunately whenever i connect using programX , the
> Program_name field is Empty.
> So I am unable to compare against the program name. Is there any
> other table from which
> i can gather consistent information? Any workaround would also be
> welcome.
> Thanks in advance
> Prakash
ADO automatically provides this kind of information to SQL Server, where
SQL-DMO requires you to explicitely set it like
objServer.ApplicationName = App.EXEName
can you please check your data access model?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Problem creating Page Header

I'm trying to create a page header in a report. The report is a simple list
of participants in one of our training programs. I'm trying to put the title
of the training program in the header of the report. According to
directions, I placed the field textbox in the body of the report. eg.
=First(Fields!Event_Title.Value, "EventListHeader"). I then placed an empty
text box into the header section of the report. I then right click the empty
text box and in the expression builder type
=First(ReportItems!Event_Title.Value, "EventListHeader"). After I save this
and recompile, I get the following error message:
The value expression for the textbox â'textbox4â' uses a scope parameter for
an aggregate function. The scope parameter cannot be used in page headers or
footers.
I would appreciate any help with this. I'm just learning and I can't find
any documentation on this error message.
--
MelissaIn the page header, you need to reference the textbox name, not the dataset
field. Which textbox is named textbox4?
"Melissa" wrote:
> I'm trying to create a page header in a report. The report is a simple list
> of participants in one of our training programs. I'm trying to put the title
> of the training program in the header of the report. According to
> directions, I placed the field textbox in the body of the report. eg.
> =First(Fields!Event_Title.Value, "EventListHeader"). I then placed an empty
> text box into the header section of the report. I then right click the empty
> text box and in the expression builder type
> =First(ReportItems!Event_Title.Value, "EventListHeader"). After I save this
> and recompile, I get the following error message:
> The value expression for the textbox â'textbox4â' uses a scope parameter for
> an aggregate function. The scope parameter cannot be used in page headers or
> footers.
> I would appreciate any help with this. I'm just learning and I can't find
> any documentation on this error message.
>
> --
> Melissa|||Thank you, DAW. You pointed me in the right direction. For anyone else who
is encountering the same problem, here's the solution. The text box in the
report header (e.g. textbox4) should reference the textbox name that holds
the field value you want in the report header (e.g. Event_Title_1). This
field value text box must exist in the report body. In the report header
textbox (e.g. textbox4), create an expression using the global collection
(ReportItems). Here is the syntax for my solution
=(ReportItems!Event_title_1.Value)
--
Melissa
"Melissa" wrote:
> I'm trying to create a page header in a report. The report is a simple list
> of participants in one of our training programs. I'm trying to put the title
> of the training program in the header of the report. According to
> directions, I placed the field textbox in the body of the report. eg.
> =First(Fields!Event_Title.Value, "EventListHeader"). I then placed an empty
> text box into the header section of the report. I then right click the empty
> text box and in the expression builder type
> =First(ReportItems!Event_Title.Value, "EventListHeader"). After I save this
> and recompile, I get the following error message:
> The value expression for the textbox â'textbox4â' uses a scope parameter for
> an aggregate function. The scope parameter cannot be used in page headers or
> footers.
> I would appreciate any help with this. I'm just learning and I can't find
> any documentation on this error message.
>
> --
> Melissa