(b60010eb08b2) in sp_lock

What does these values (b60010eb08b2) mean under the resource column for a
KEY type when one runs sp_lock ?Hassan
It's a hashed value of the key which is locked. There is no way to reverse
engineer to determine the value of the key.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e$Lt0gWDEHA.2908@.TK2MSFTNGP09.phx.gbl...
> What does these values (b60010eb08b2) mean under the resource column for a
> KEY type when one runs sp_lock ?
>|||Kalen,
I was going over through your e book on Locking and Blocking and was
confused on the % threshold before the lock escalates.
On page 46 , you said 40% and on page 40, you mentioned 3%. Am i not
following something here ? Please clarify
thanks
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eXhmYnXDEHA.712@.tk2msftngp13.phx.gbl...
> Hassan
> It's a hashed value of the key which is locked. There is no way to reverse
> engineer to determine the value of the key.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:e$Lt0gWDEHA.2908@.TK2MSFTNGP09.phx.gbl...
a
>|||i also wanna reverse the key value by hashed value ,
because i wanna know the keys locked !

>--Original Message--
>Hassan
>It's a hashed value of the key which is locked. There is
no way to reverse
>engineer to determine the value of the key.
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"Hassan" <fatima_ja@.hotmail.com> wrote in message
>news:e$Lt0gWDEHA.2908@.TK2MSFTNGP09.phx.gbl...
resource column for a
>
>.
>|||Not doable... sorry
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"rainbow" <anonymous@.discussions.microsoft.com> wrote in message
news:b6bd01c40d8e$1df948d0$a001280a@.phx.gbl...
> i also wanna reverse the key value by hashed value ,
> because i wanna know the keys locked !
>
> no way to reverse
> resource column for a|||Hi Hassan
If you read the entries sentences again, you'll see they see two separate
things. On page 40, it says 3% of memory, on page 46, it says 40% of buffer
pool.
The 40% figure is much more exact. (The 3% figure is just one that a dev
tossed at me when I asked when lock esacation occurs, and he said it was
related to the total memory used, something like 3%. So on page 40 I did say
ABOUT 3%.)
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uDT$S8XDEHA.3348@.TK2MSFTNGP11.phx.gbl...
> Kalen,
> I was going over through your e book on Locking and Blocking and was
> confused on the % threshold before the lock escalates.
> On page 46 , you said 40% and on page 40, you mentioned 3%. Am i not
> following something here ? Please clarify
> thanks
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:eXhmYnXDEHA.712@.tk2msftngp13.phx.gbl...
reverse
for
> a
>

"VFPOLEDB" for linked server reported an error. Access denied

Hi Cindy,
After hours (days?) researching this, your name keeps popping up, you must be the GOTO person for VFP. So:

We have a server that runs a VFP application and stores .dbf free tables in a directory shared as F:\apps\tele.

I am working on an XPPro box running SQL Server Express 2005 using Management Studio Express.

I am logged on as a user with administrator rights for the domain

We would like to be able to query this data and move it to our SQL tables as needed.

Here is what I have:

EXEC sp_addlinkedserver @.server = 'tele',
@.srvproduct = 'VFP',
@.provider = 'VFPOLEDB',
@.datasrc = 'F:\apps\tele',
@.provstr = 'VFPOLEDB.1'
GO

SELECT * FROM tele...PROSPECT_DIVU

Here is what I get:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "VFPOLEDB" for linked server "tele" reported an error. Access denied.
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB provider "VFPOLEDB" for linked server "tele".

I have tried:

exec sp_addlinkedsrvlogin
@.rmtsrvname = 'tele',
@.useself = false,
@.locallogin = NULL,
@.rmtuser = 'admin',
@.rmtpassword = NULL
go
Same result.

I have also tried:

EXEC sp_addlinkedserver
'tele2',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'F:\apps\tele',
NULL,
'dBase IV'
GO

When I run:

select * from tele2...prospect_divu

I get:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "tele2" returned message "The Microsoft Jet database engine could not find the object 'prospect_divu'. Make sure the object exists and that you spell its name and the path name correctly.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "tele2". The provider supports the interface, but returns a failure code when it is used.

What would you suggest?

FOR SQL MSExpress

In object explored drill down

Server Objects

Linked Servers

Providers

VFPOLEDB

Right Click Select Properties

Check "Allow Inprocess"

Click OK

DONE

|||

Hi JC,

I've created a new thread with your post. Here's some content I've posted several times in the NNTP groups:

"What permissions does the SQL Server local system account have? I'm ok on my laptop with the SQL Server started with "local system account" and my Windows login being MachineName\Cindy. When I tried against my SQL Express instance which was started using the "NT AUTHORITY\NetworkService" I had the same errors you report. "

Basically, the account the SQL Server runs under needs to have permissions to the directory where the DBFs are stored.

Your error with Jet may stem from the fact that the structure of Fox DBFs has changed over time and the changes aren't compatible with the dBase IV format that Jet recognizes.

|||In addition to Cindys recommondation I would add that you try to use a common query to identity if the connection is working to the dbf file. I am not familiar with the dbf file schema, but there could be an object (table etc.) which always exists in the schema which you could query to eliminate other problems (like in SQL Server the sysobjects object). I also guess that the problem is based upon file access security. Depengin on the settings of the linked server you connect with the "users context" or with SQL server service account security (which can be in some case not priviledged anough to access / modify the datafiles.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi

I am still fighting with this as well. But one thing I have noticed "Select *" it does not like, "Select col1, col1, col3" it is ok with and the error I was get with "*" was the access denyed. You will probably notice that in addition to the Messages tab with the errors that you also have a Results tab with only the column headings.

Other then that I am still having issues connecting to a UNC as the data source. Like \\dispatch\dispatchtables\

Hope it helps you some.

Paul

"Out of memory." Error in SSIS

Hi!

I am currently encountering an error of testing an SSIS package in the server.

The package runs fine on my laptop, but not in the server.

I appreciate it for any of your input, comments, and suggestions.

The package is to populate records (150k rows) from a DB2 table and insert them into

another DB2 table (12,754,715 rows).

The server,

Windows Server 2003 Enterprise

SQL server 2005 sp1

8 CPUs

6 GB RAM

Native OLE DB\IBM OLE DB Provider for DB2

My laptop,

Windows 2000 Professional

SQL server 2005 sp1

2 CPUs

2 GB RAM

Native OLE DB\IBM OLE DB Provider for DB2

It fails on the insertion part (see the error message at the bottom). I have been playing with "DefaultBufferMaxRows" and "DefaultBufferSize" properties, but still no luck so far.

For the testing purpose, I even only select 2 rows from the source table, but it still fails with the same error message. And strangely, it still takes a very long time to process (for just two rows). In my laptop, it only takes few second to finish.

I have been really pulling my head to try to figure it out. Any of your help/input is highly appreciated! Thanks!

======================

Error Message

[POLICY [1683]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007000E. An OLE DB record is available. Source: "Microsoft Cursor Engine" Hresult: 0x8007000E Description: "Out of memory.".

Strange...

Check the available memory with task manager...

check If datasource has indexes in database

Avoid using transforms like union all, aggregate, ...

but in your example importing only 2 rows is to strange.. :-(

give me more details...

Regards.

|||

Thanks for your reply.

All information came from Task Manager, (I am not good at monitoring system performance and resources by any mean)

Before the process ran,

Memory Usage: 0.9 GB (~5.1+ GB physical memory available)

Right before the process failed,

Memory Usage: 3.1 GB (~2.5+ GB physical memory available)

DefaultBufferMaxRows: 100

DefaultBufferSize: 1048576

Both tables (source and destination) have indexes.

The data transformation is very straight forward. OLEDB source to OLEDB destination (table to table).

For any further information for diagnosing this issue, please let me know.

Thanks.