Hello does Bulk Insert in SQL 2000 require SA rights?  Is there any
rights that I can provide for a user without giving them SA rights to my
system?  TIA

Okay... obviously this only applies to DML triggers, and not DDL or database
triggers?
Is there some way, in a trigger, that I can get the actual SQL DML statement
which fired the trigger in the first place?

hey all,
what's the best way to get a column of sequential numbers in a memorty table?
for instance,
1, any data1

I'm writing a database to store and process sales data from Second Life (not
my usual area, but since its the holidays, I figured I'd knock something
together for a friend who apparently makes money selling their
designs/builds there).

Take a case a where user does not have insert access to a table T1,
but user has stored procedure execute access.
Can inserts be done to table T1 using the stored procedure?
Can user be the owner of table T1 and still insert access can be

In the place i work we user Read commeted transaction isolation level.
I discovered that on that isolation level if two or more quries inserts data
to the same table the first row that will commeted is the fastest one and
not the one who started first.

I have 2 different types of data that is pretty much the same thing (live
events and special events). The only difference between the 2 is that live
events requires an address and special events does not. They hold the exact
same data and everything. How should I manage this? ...

Any suggestions on these programming?

How I use BETWEEN to query a table for orders placed between certain dates.
I get an error that says cannot convert to smalldatetime if I do this:
SELECT * FROM orders WHERE Datereceived between 20090101 AND 20080101
Thank you for your help.

I'm trying to select something like the below:
RRTT.TName + ' ' + ltrim(rtrim(app.AName))
problem i'm having is RRTT.TName is always populated but app.AName is
not, there are times when it is NULL, but doing that select above is

I'm just getting to the point of moving some of my logic from the client
program to the SQL Server. I'm beginning to write a few more "sophisticated"
stored procedures. My intention below is to receive a component part, if the
component part has a status anything else but "BH" ...

I've been scratching my head on this one for a few hours now. I'm not quite
sure what's the best way to handle this.
SQL 2005 (and sql 2005 compatible db) but I have a column that I need to
deal wiht in a trigger that is a TEXT type that I cannot change to

The table I am trying to update has an index preventing the occurrence
of duplicate values.The columns making up the index are "name","idspn"
and "idcategory". I need to change all idcategory 1s to idcategory 11s
as demonstrated by the sql below.

I have a table with 16.5 K records with an XML field.
In my select (group by, where, min) I use .value.
my reference to the xml data is like:
xmlField.value('(//errortime)[1]','datetime'))

I want to know that how we use Stored procedure In Sample Of Query
Notification .
Or Can we use  Stored procedure In Query Notification ?