Lock /objects in Enterprise manager**

Hi
when I come to lock/objects branch in enterprise manager I find out so many
tables and views name there ,does it mean that all these are locked? or does
it mean all these are using by some users,but we can use it too?
any help would be thankfulYou can get more information with sp_who and sp_who2 system stored procs
Dishan Fernando
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||http://msdn.microsoft.com/library/d...y/en-us/adminsq
l/ad_perfmon_6ofn.asp
DishanF
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

LocalReport: Object-in-Object as DataSource not working?

Hi,
I have a Report (VB.NET 2005), and I'm using Objects as DataSource.
I have the object objCompany, which contains a public property MyAdress
(instance of objAdress). objAdress has a propert Street.
When I add objCompany as a DataSource, I want to be able to show the
Street-property of MyAdress. So I do a drag-and-drop of that property from
the Data Sources - Window to the Report. Everything seems fine: I get a
textbox on my report with Value "=First(Fields!Street.Value,
"MyApplication_objCompany")".
But when I run the report, it doesn't show any value in it...
Does anybody knows why this happens? I somehow think because of the fact
that Street isn't directly on MyApplication_objCompany, but when I change it
into MyApplication_objCompany_MyAdress is complains about the fact that it
doesn't exist...
How should I do this?
Thanks a lot in advance,
PieterI found the solution here for nested objects and reporting services
localreport in the reportviewer:
http://www.gotreportviewer.com/objectdatasources/index.html
Apparently I have to do something like "=First(Fields!MyAdress.Value.Street,
"MyApplication_objCompany")".
It gave me these 2 errors:
The Value expression for the textbox 'Adresse' refers to the field
'ReportAdresse'.
Report item expressions can only refer to fields within the current data set
scope or, if inside an aggregate, the specified data set scope.
The Value expression for the textbox 'textbox19' has a scope parameter that
is not valid for an aggregate function.
The scope parameter must be set to a string constant that is equal to either
the name of a containing group, the name of a containing data region, or the
name of a data set.
But sddenly it started to work...
strange... :-/
"Pieter" <pietercoucke@.hotmail.com> wrote in message
news:u64%23GAkiGHA.1204@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a Report (VB.NET 2005), and I'm using Objects as DataSource.
> I have the object objCompany, which contains a public property MyAdress
> (instance of objAdress). objAdress has a propert Street.
> When I add objCompany as a DataSource, I want to be able to show the
> Street-property of MyAdress. So I do a drag-and-drop of that property from
> the Data Sources - Window to the Report. Everything seems fine: I get a
> textbox on my report with Value "=First(Fields!Street.Value,
> "MyApplication_objCompany")".
> But when I run the report, it doesn't show any value in it...
> Does anybody knows why this happens? I somehow think because of the fact
> that Street isn't directly on MyApplication_objCompany, but when I change
> it into MyApplication_objCompany_MyAdress is complains about the fact that
> it doesn't exist...
> How should I do this?
> Thanks a lot in advance,
> Pieter
>

local packages

How can I export in one other server my local packages?(and scheduled job)
DTS go only for the objects in a database?Design the package in question, and choose Save As, specify the other server
name.
Good DTS resource at sqldts.com
--
HTH
Ryan Waight, MCDBA, MCSE
"killer" <matteo.milano@.katamail.com> wrote in message
news:hwxhb.24679$vO5.881056@.twister1.libero.it...
> How can I export in one other server my local packages?(and scheduled job)
> DTS go only for the objects in a database?
>|||Please do not post the same question to multiple groups. See my answer in
.programming.
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"killer" <matteo.milano@.katamail.com> wrote in message
news:hwxhb.24679$vO5.881056@.twister1.libero.it...
> How can I export in one other server my local packages?(and scheduled job)
> DTS go only for the objects in a database?
>