Hello,

I had a problem with one database that does not allocate space although the autogrowth is set. The db is 65 GB and there is 98 GB of unallocated space...

Much cleaner, thanks!:w00t:

OK, it wasn't the NULL insert. It was incoming dates of 00000000. I found these by opening the Transform Data Task Properties, going to the 'Options' tab and creating an...

Thank you.

Hello,

I liked this function, but it returned NULL when a numeric value was sent.  After poking around a bit I found the @multiplier value is only set when IsNumeric is false. ...

Answers in order: Yes,Yes,No.  On one of the pkgs I altered the DTSRun to NOT use the encrypted string.  I was successful with that one.  So, I figure I will...

Greg,

I have used DTSBackup 2000 on a local server and have had great success with it.  I recently did a restore from a default instance to a named instance and...

The programmer has created his own indexer for web site searching(perl ?). I have yet to monitor the logs, as we are in the process of consolidating and this info was...

Thanks again Remi,

BTW are you related to our Governor? Christine Gregoire

Thx Old Hand,

I guess I just wanted to try the CASE n it backfired.  The IF worked fine.

Bill

Thx for your input. 

These records are historical comments posted to a clients case.  Every time someone makes a request for a comment, we have to...

IRS stuff ya know.  Every record (Type 50) every time for all time.  Every time the proc runs and every record that matches the type. Does that answer your...

In this one nothing is easy.  May have more than one row and write one audit per record found.  So initial request may return 90 records with...

Thanks SQLBill for your assistance. 

I am sure they made a differnce, but one of the main problems with the proc was the SET @ThruDate line. I needed the SELECT...

Sorry to be so gray about the ArchiveControl tables values

Here is an example of the db:

AreaName  Char(4),

ArchivedData  bit,

ThruDate Char(12)

PassOffCode Char(2)

Data:

SEGC,1,20011231,FC

SEAS,0,<<NULL>>,AH

SECC,1,12/31/2001

So the field data for this particular proc will always be in the...