I'm working on a trigger in sql 2000.
This trigger is like this, the tb1 gets insert from web form, then this
trigger will fire to insert the record to other tables in the database.
When I used "After update", the trigger doesn't fire, when I changed it to

Trying to figure out SQL 2005.
1) Can you create a relationship between 2 tables when neither has a Primary
Key?  Both columns have no Null.
2) Using the GUI in SSMS, how do I set another column as UNIQUE? If I set 2

My database has 10 datafiles spread across 10 drives. We designed it a year
back anticipating heavy traffic but it didn't turn out that way. Now, I need
to give all those extra SAN space back and so need to put 9 datafiles to a
single drive.

I have a need to have an ID --which is a sequential number-- that starts
over at 0 each day; however, I obviously also need to have a unique way
of identifying each individual record.  You can think of it as being
similar to the registers at some fast food restaurants where each ...

SQL 2000 Std SP4
There is a complex view that contains over a dozen INNER JOINs, couple
of filters and subqueries.
This view is a source for subsequent, more complex analysis.

I have a query that already has 5 Inner Joins that lookup values in another
database, I now need the same query to check a different database as well.
I was going to do this with 2 IF statements, but this would mean duplicating
a large part of the code, so I was wondering if its ...

I have an access adp project that contains 2 tables where the first and last
name fields reside in a table called "users" and another table called
"accounts" that contain user login names and emails. Because of other
requirements, I had to layout the table relationships that way ...

Can I not do this?
WHERE DateDiff( d, [COCUS].[DATEINVOICE], getdate()) @LessOrGreater @X_Days
It's telling me
"Msg 102, Level 15, State 1, Procedure CIT_FA_NoSalesIn_X_Days, Line 21

I need to do a query for a view. The query involves 3 tables, let call
them A, B, C. There is ItemID column in table A that match either
ItemID column on table B or C (but not both, because ItemIDs in table
B and C are assigned in a way that they cannot be the same)

How do you get the last count of rows affected by a query in a stored
procedure? thanks!

I'm trying to backup my database using the option "file and filegroups" in
the enterprise manager but this option is unavailable...
Why it happens?...
Thank for all your help.

I have a backup service i've created using SQLDMO / C#.NET.
Can I create a folder on the sql server using this? I don't see a relevant
method. I can enumerate folders on the sql server, but not create.
Thanks

We use two different SQL 2000 servers, one for test and one for operation.
Sometimes we would like to refresh our test data by copying some (but not
all) tables from operation to test.
Of course some tables use primary keys with identity, timestamp columns,

If you want to execute a stored procedure into a temporary table you
first need to create a temp table then execute the procedure into that
temp table...
CREATE TABLE #tmp(

Using sql 2000 sp4
I'm trying to catch the bulk insert error and would like to continue to the
next file in Directory while, logging the failed file for later use?
@@error doesn't seem to do it?