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...

how about

create 3 additional fields - year and yearidentifier and autonumber

then create a trigger on the table

create trigger t1 on mytable for insert as

if @rowcount=1

declare @myval integer

set @myval=(select max(cast...

you need to create a trigger on table 1

something along the lines if

create trigger t1 on table1 for INSERT,UPDATE as

if @rowcount=1

begin

if (select count from table2 where x=(select...

create a view based on syscomments.

then create an update trigger on the view to add to an audit table the relevant contents of the text field from syscomments when ever...

also is it SQL server 7?

this is a common bug in SQL server 7 (look up SQL server orphaned process on http://www.micrososft.com)

if it is an orphaned process then...

then you need to review the permissions granted to that username for that database and all server roles.

you say the problem is not there for new users.

how about deleteing...

is it an NT username that is a member of domain Admins or local admins?

modify the permissions for the public role and place a DENY (red cross in enterprise manager) on the delete section of this table.

is this user also a member of...

how slow?

is this from notification or using XP_Sendmail directly?

revoke command does the same as having no permissions set in enterprise manager.

using the permissions in EM is the same as issuing GRANT,REVOKE and DENY commands, they won't...