Thanks - that's the only thing I can think of as well.

Cheers

Thanks Steve. An open transaction / connection is the only thing I can think of but I was worried in case I was missing something else - the delay...

We have a similar problem with large log files that are being shipped - we are contemplating compressing the files using xp_makeCAB and xp_unpackCAB. Does anyone know about these SPs...

Thanks for all the advice - MUCH appreciated!

Cheers

The DTSRUN is not encrypted, it's the rest of it that is - that's the bit I'm trying to unravel. The original authors just right-clicked and scheduled - so it's...

Forgot about this classic!!

"C:\, C:\Dos\Run, C:\Windows\Crawl"

There was once a young man who, in his youth, professed a desire

to become a "great" writer. When asked to define "great", this is...

Hi,

Had two different occurances at two different companies. Both SQL 2000 one was with McAfee and other with Symantec.

Cheers

As far as I can tell it's not the full scan that does the damage to performance - it's the realtime scan! We found a major performance problem with a...

Idera's SQLdm is one of the best - I've known it since it was SQL Probe (and a lot cheaper!! ). It has...

Hi,

You don't insert into the column at all if it is set as IDENTITY or AUTONUMBER so your statement would look like this:

INSERT INTO AttorneyMaster(AttorneyTypeId,AttorneyFName,AttorneyMName,......)

values (AttorneyTypeId,AttorneyFName,AttorneyMName,.....);

Cheers

If you want a summary per ACCT_NO you could do something like this:

SELECT  ACCT_NO as ACCOUNT_NUMBER,

            TRADE1 = SUM(CASE 

                          WHEN LDGR_NO = 800100 THEN LDGR_BAL_AM

                          ELSE 0

                          END),

           TRADE2 = SUM(CASE...

Hi,

Try the following using a derived table to get a skill count for the problem in question and matching it against the employee with the required number of skills per...

You don't say if this has suddenly happened or if it has been that way since you installed SQL, also the version you are running would be a help.

We used...

Sorry about that, you need to put the statements in with the EXEC - I was having the same problem - I was concentrating on the syntax!!!