We checked sql profiler and the execution log and the data retrieval is fine. However, the processing of the report is the killer in R2. It is...

Think I found the issue.  This occured in our test database server.  It seems that one of our developers was messing around with Replication and tried to replicate a dbase...

Well, if anything, I appreciate everyone's replies because it always gives me insight on other issues and is a good way to enhance my SQL knowledge - which I think...

I'm sorry, it's not a three column update, it's at least a 30 column update and I already found a separate solution that would cover this, sometimes I just like...

Interesting... that is probably the policies that we will have to follow going forward if we have any issues.  Thanks for all your help!

The start-up account is not using the local system account, but a separate domain account.  It connects the server using SQL Server authentication.  However, I can't just remove builtin/administrators -...

Thanks for all your input - It's strange that when I deny access to the Builtin\Admins then I can't start the SQL Server Agent. Probably because the user that starts...

The stored procedure is a good idea since it would only truncate the table specified in the stored proc.  We have DTS Packages that run throughout the day to truncate...

Thanks for the reply!

I think the main issue with the connection is that a Connector must always have two connections.

So, if I didn't set up Referential Integrity on the tables...

One quick question on the transactions (I'm a newbie), if I do the following:

begin tran A1

insert into table_hist(.....) select ... from tableA where something = 'something'

if @@error <> 0 goto...

Thanks for all your responses.

To Antares686:  I'm sorry for the messy example, I just copied and pasted and made some modifications to get the general idea of the cursor, and...

My comments use the prefix, $

DECLARE mod1 CURSOR

   FOR SELECT EMP_NUM, PAY_WEEK, sum(Ult_ProHrs) as Ttl_ProHrs, sum(Hours) as Ttl_Hrs  FROM TABLEA WHERE SUBMIT = 'Y'  GROUP BY EMP_NUM, PAY_WEEK HAVING SUM(ULT_PROHRS) <>...

Thanks for your responses - it gave me alot to think about.

The records in the table that I'm archiving won't be changed while this procedure is running.  My main concern...

Shoot...

Off the top of your head, do you know another way in SQL loop through a result set and perform operations?? The Cursor was the only thing I can think of to...

Worked great!

Thanks for the info!