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

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

i don't think this was the problem, or have i misunderstood.

isn't the problem making them HIDDEN, so that users don't get confused with so many choices

I recommend the Osborne (mcGraw Hill) books, and also the microsoft press books, although they might be a bit heavy for beginners.

your most important areas for SQL server are understanding...

in that case (depending on the qty of data and the read/write ratio)

i'd place the data on the raid 5 and the T-logs on the raid 1

although beware, if you...

Alex,

there are several issued here. cost and good design.

i recommend the following

system drive -Mirrored (place Sql server system databases on this drive also)

data drive - Mirrored and striped...

i know in crystal reports there are plenty of options for filtering out system views, stored procedures etc etc...

are there such options in business objects? sounds like you coud escalate...

you checked all the database roles?

including DENY_DATA_READER and DENY_DATA_WRITER

this sounds like the problem

you only need to grant them the single role of Database_owner and they have all the permissions you...