The same question is asked by Steves on 7th may,2014. Of course, You have mentioned in that forum that you have almost same QOTD

Being sysadmin, I have worked with my own windows login authentication permissions and tried giving authentication off/on to a particular database, and got the answers correctly.

good question andy..

Thanks for the reply Luis, but I have come to know that the query is built using hibernate. so it automatically creates the query in the application.

I am not sure...

I have executed DBCC UPDATEUSAGE ('db_name','dead_lock_info')

but the rebuilding the clustered index did the trick,

Now I have data, index_size everything zero

Thank you all for your support

Jason,

when I have run the query...

Please find the results after dbcc checktable

DBCC results for 'dead_lock_info'.

There are 0 rows in 405853 pages for object "dead_lock_info".

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

please find the results as below

nameindex_idtype_descnamerowstype_desctotal_pagesused_pagesdata_pages

dead_lock_info1CLUSTEREDpk_dead_lock_info0LOB_DATA000

dead_lock_info1CLUSTEREDpk_dead_lock_info0IN_ROW_DATA411713407826405853

my apologies, I have to run your script in 2005 version, so I have no data about data_compression_desc

yes Gail,

please find the create table syntax for that table

CREATE TABLE [dead_lock_info](

[Dead_Lock_Info_Id] [bigint] IDENTITY(1,1) NOT NULL,

[LogDate] [datetime] NULL,

[ProcessInfo] [varchar](30) NULL,

[Dead_Lock_Log] [varchar](max) NULL,

CONSTRAINT [pk_dead_lock_info] PRIMARY KEY CLUSTERED

(

[Dead_Lock_Info_Id] ASC

)

)

Thanks for the question Richard. Learnt something new

Thanks for the question steve. The selection of answer should have been check boxes 🙂

apologies for the duplicate post

The selection of answer should have been check boxes 🙂

yahoo.... i got it right..

I have created a heap table and inserted data 50,00,000 records and then deleted

Observed the below points

1. page count is reduced before and after the...

twin.devil (5/16/2014)

---

Koen Verbeeck (5/16/2014)

---

Am I the only one who thought the question was worded a bit strange?

Anyway, as...

I am also confused :w00t: :unsure:

After reading all these articles, I felt the anwer is

"change the compatibility to 120 and test to work new CE"

Please find the below...

i am not sure if the above link is taking to the proper page or not , but pls copy the below

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/02/09/drop-failed-for-login-since-it-has-granted-one-or-more-

permission-s.aspx

Found good explanation in the below link

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/02/09/drop-failed-for-login-since-it-has-granted-one-or-more-permission-s.aspx">

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/02/09/drop-failed-for-login-since-it-has-granted-one-or-more-permission-s.aspx