I too got 1,1 in sql server 2008 :w00t:

Actullay the answer shoul be

this is an exception

id

-----------

1

2

4

5

I think raj is correct, for 2005 = 250 and 2008 = 1000

Please check this URL for 2005

http://msdn.microsoft.com/en-us/library/ms188783(SQL.90).aspx

Returns the date of the most recent update for statistics on a table or indexed view.

so it may be a table or indexed view

Atlast we found that this is known bug from sql server 2005 sp1 :w00t:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=365876

Hi Suresh,

Even create type also throwing same deadlock error

We have some set of deployment scripts if a script contains user defined data type, that UDD is used in some create...

Thanks Abhijit More for your effort

I tried in a different ways

begin tran

exec sp_addtype 'Udd_dummy','int'

go

create table dummy_tbl

(name Udd_dummy)

go

rollback

begin tran

exec sp_addtype 'Udd_dummy','int'

go

create proc dummy_sp

as

begin

Declare @Dummy Udd_dummy

select @dummy

end

go

rollback

both are working fine in...

I am getting this problem only in Sql server 2008(SP1) server, when I try the same script in Sql server 2005 it was working fine

Here is the Deadlock graph

<deadlock-list>

<deadlock victim="process17b390">

<process-list>

<process...

webrunner (11/4/2009)

---

Hello,

We have a SQL 2005 64-bit (SP2) SQL Server where the Minimum server memory (in MB) is set to 10240 MB.

But in Task Manager, when I just checked, the...

Instaead of using replace function why don't you use where clause

like

Update #temp

set fullname = 'bill'

where fullname = 'billy'

I think if you use this way you can avoid calling replace...

I hope you have Window server 2003 Enterprise Edition

/PAE enabled in boot.ini?

Have you Enabled the Lock Pages in Memory Option (Windows)?

Please check the below URL for more details about Enabling...

What is you Operating system Edition?

Is your system is 32 Bit or 64 Bit?

Use DBCC USEROPTIONS to know the database isolation level

Hi Melton,

If OS version(standard edition) doesn't support more than 4GB even if you enable /PAE switch, how the sql server will(AWE) addersss the windows extention on 32 bit server?

Please help...

what you have done is well and good, while setting up max memery we should not consider the virual memroy.