Let's say I want to allow triggers to fire others:
Under server properties > Advanced > Allow Triggers to Fire Others = True
Then I have 2 tables (table_1 and table_2) where each will have an update
trigger that updates something in the other table:

I executed dbcc showcontig (with tableresults) into #ShowContg tmp table -
run query below & it shows > 100 tables with extent fragementation > 80%
The server is SQL 2005 - the database is in 80 compatibility. Is a Rebuild
Indexes Maint. Plan task which runs nightly. Why so much ...

I have a bcp process that runs from a perl file every morning. I have
been running this process for 3 years.
Each morning I import 10,000 records from a txt file into my sql table.
There are about 100 fields that are imported.

can I use update statements with DTS package ?  If yes, how can it be
done ?
Reg
vicky

SQL Express 2005
I delete the 31st day of data from my customers Production data to keep the
database at a manageble size.  I run the query below.
Delete

I have a process that gets customer activity based upon a shipdate. I get
the 3 previous months worth on data. I use the first month extract as a
driver to the other 2 previous months. The problem I have is I need a record
for each month and each type no matter if they had ...

Here is my SQL query in my Classic ASP page. Once I get my recordset, I
want to loop thru it. I have that working. But once I grab the first
row, I need to start another sql query grabbing data from another table
based on the result from row 1. I just need to know how to OPEN the

I have a big troupble with one MS SQL server. There is 4GB RAM and using is
about 2GB RAM.
I need registr .NET assembly system.web bec I need use httputilizie to
encode some special chars (e.g. space to  ).

I have about 1000 views, functions and stored procedures in my
database. They are encrypted for security reasons - my database is
used by a number of clients.  I have all the scripts held in separate
files on my PC.

2 questions. Obviously I am new to using parameters. I am switching over
all my old hackable sql queries to something more secure.
So, let me ask something.
I have something like

just just want someone to give me a deep understanding of indexes.
I have a table with no primaryKey (PK)
the table also has no clustered index (CI).
It only have a few non-clutered index.

DECLARE @TranName VARCHAR(20)
SELECT @TranName = 'MyTransaction'
BEGIN TRANSACTION @TranName
GO

here are my parameters:
CREATE Procedure dbo.ESIMonthly
(
    @ProcessDate DateTime = Null,

I have a new store procedure that is giving me 2 problems.
First, it is returning a value of 1 instead of the actual new identity.
Second, the TRAN is rolling back and I'm not sure why.  Any help is
appreciated.

I have a table that looks like this:
CREATE TABLE TBL(
    ID int IDENTITY(1,1) NOT NULL,
    ForeignKeyID int NOT NULL,