i did this

select 'DBCC '+name+char(10)+char(13)+' GO ' from sysobjects

and got

DBCC sysobjects

GO

DBCC sysindexes

GO

DBCC syscolumns

GO

DBCC systypes

GO

DBCC syscomments

ok - have you installed something like XP service pack 2? this apparently tightens security - i wonder if it's done something stupid like block port 1434 or 1433

if not...

too many '

here's the corrected version

select 'DBCC '

+tablename

+char(10)

+char(13)

+' GO ' from TableList

also worth checking if any new software has been installed on your machine and if windows update has been run.

maybe the MDAC has been changed in some way?????

can you post the whole of the who2 command - your process is not being blocked, but i wonder if there is something else being blocked??

are other users struggling to...

why are you doing a count(0) ?

DOH!

just ignore everything i said - let me get more coffee and start again.

what if your minimum priority for that user is not 1?

also try connecting to the server using Query analyser and run the command

SP_WHO2

this should show you if anything is blocking your request.

what type of authentication are you using? i assume its SQL server authentication?

is it the sa username ?

has anyone been messing with your permissions on the target server?

if...

how about

delcare @namepart integer

declare curs1 cursor for select distinct namepart from mytable

open curs1

fetch next from curs1 into @namepart

while @@fetch_status=0

begin

delete from mytable where namepart=@namepart and priority not in (select min...

select sysobjects.name,syscomments.text from sysobjects,syscomments where syscomments.text like '%--changed%' and sysobjects.id=syscolumns.id

if you run this is query analyser with the destination output to text (not to grid) then you should get all...

you say datalength is taking too long ? do you mean the query takes too long or the whole process of going through them takes too long?

i assume your doing...

the unexpected results are because you are returning 3 fields in the (from recordset) - these are only grouped by 2 fields, one row for each sr.eid is being returned....

i'm not sure what you're trying to acheive here that can't be done with the existing functions and tables?

sureley assiging permissions to a database and then using sql servers native...