Is there a way to tell who or what process deleted a record in a SQL table.
I know you can setup triggers or Profiler - but is there a way to see how a
record was deleted if you DO NOT have a trigger or Profiler already running?
This is SQL 2000 Standard, sp3a with default options ...

select no_dossier from dbo.membre where date_MAJ = GETDATE()
select no_dossier from dbo.membre where date_MAJ = '2005-07-21'
Both should give me the same result, yes or no?
thanks

From Enterprise Manager I get
   [SQL-DMO] CreateFile error.......
Whenever I try to Generate SQL Script!!!
Why??

I have this problems during the debug of a stored procedure:
1) In the immediate windows variabile are not set (these are nulls)
2) The step by step don't highilight the current line in yellow but
highlight some empty lines

On the other database types, there is an audit capability in that you
record such items as
failed login attempts
attemtped access to tables user is not authroized to

I am developing an application that uses SQLServer 2000 as its data
repository.
I have a varchar field in one of my tables, and when I do:
update PolicyInfo

I have recently decided to upgrade my programs to enable users to have mssql
databases instead of access.
I have since then run into many incompatibilities between their sql:
access has IIF(x>y,a,b) whereas mssql hase case when (this already means

Is there a way that SQL can automatically look at each users'
connection and make sure it is still connected through the third party
application?  The problem is that when a connection to this application
is not terminated properly, the SQL server is not notified of the

I am new to SQL and I would like to create a small database application
where I can store the data on a network drive and have about 10 users access
the data from their desktop. I want to use SQL Express to do this, any ideas
/ examples of how to get this done, especially dealing ...

I have an identical SQL database on two machines (my machine and a web
server) that links to a database on a third server (S3). When I execute
a stored procedure on my machine that accesses a database on S3, it
always runs without a problem. However, when I run the same stored

my code is using ADODB connection to connect to SQL (Virtual) Server.
the way it being done is (c++):
ADODB::_ConnectionPtr m_dbConn;
ADODB::_RecordsetPtr  m_dbRst;

I have a user who would like to connect to a SQL Server database using SAS (a
statistical application) and have the system tables not be displayed
Currently, when the user connects they are shown all of the tables
(including system table).  We have inquired on the SAS side and ...

Is there any reason to use set xact_abort on OR set xact_abort off as a
rule in my stored procedures?

I am using the following code to insert records into a destination table
that has a three column primary key i.e. (PupilID, TermID &
SubjectGroup).  The source table records all the pupils in a school with
(amongst other things) a column (about 50) for each subject the pupil

This is driving me crazy.
I need to create a UDF that would return a TRUE/FALSE (bit) value based
on a comparison it does.
CREATE FUNCTION dbo.SelectedByApplication