Lock Information

Looking under Locks/Object I noticed the following items:
master.dbo.spt_values
tempdb.dbo.##lockinfo75
The lock mode is X (Exclusive Insert/delete or update)
Process details show 'sa' as the user
The Databases are all working okay (with 80+ users)
Is there any way of checking what this is (presumably a temp table was created as part of the process) ?
Also what is spt_values used for ?
thanks
Gerry
This is a temp table used by one of the stored procedures EM calls when you
look up information such as locks. It's nothing to worry about.

Andrew J. Kelly
SQL Server MVP
"Gerry" <anonymous@.discussions.microsoft.com> wrote in message
news:6F9059D0-29EF-4B05-B8FF-92388071AC37@.microsoft.com...
> Looking under Locks/Object I noticed the following items:
> master.dbo.spt_values
> tempdb.dbo.##lockinfo75
> The lock mode is X (Exclusive Insert/delete or update)
> Process details show 'sa' as the user
> The Databases are all working okay (with 80+ users)
> Is there any way of checking what this is (presumably a temp table was
created as part of the process) ?
> Also what is spt_values used for ?
> thanks
> Gerry

Lock Information

Looking under Locks/Object I noticed the following items:
master.dbo.spt_values
tempdb.dbo.##lockinfo75
The lock mode is X (Exclusive Insert/delete or update)
Process details show 'sa' as the user
The Databases are all working okay (with 80+ users)
Is there any way of checking what this is (presumably a temp table was creat
ed as part of the process) ?
Also what is spt_values used for ?
thanks
GerryThis is a temp table used by one of the stored procedures EM calls when you
look up information such as locks. It's nothing to worry about.
Andrew J. Kelly
SQL Server MVP
"Gerry" <anonymous@.discussions.microsoft.com> wrote in message
news:6F9059D0-29EF-4B05-B8FF-92388071AC37@.microsoft.com...
> Looking under Locks/Object I noticed the following items:
> master.dbo.spt_values
> tempdb.dbo.##lockinfo75
> The lock mode is X (Exclusive Insert/delete or update)
> Process details show 'sa' as the user
> The Databases are all working okay (with 80+ users)
> Is there any way of checking what this is (presumably a temp table was
created as part of the process) ?
> Also what is spt_values used for ?
> thanks
> Gerry

Locate Database Object Given The Page

Hi Folks,

Getting the following error after a DBCC CHECKDB

Server: Msg 8906, Level 16, State 1, Line 1
Page (3:15010) in database ID 9 is allocated in the SGAM (3:3) and PFS (3:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.

Trying to located the object that the allocation has gone to pot over.

Any quick way to resolve a datbase object using a page ID?

Thank In Advancewhoops. not enough coffee.|||"database ID 9" relates to the the entry in master.dbo.sysdatabases

I need to know what object within this database the page is allocated to.

Thanks

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
>