Well, I figured it out, although I don't know why it works this way.

I had to set the @Count value to an initial value before I could add another value...

That worked. Thanks.

Seems like it should work the other way too, but I'm obviously mistaken there.

Chris

I'd also like to be able to figure out where my package is running from, the actual location of the package file. this is so I know where to write...

Further research on the Internet has revealed that you must use a workaround, which is putting the tasks you want to work as one unit, as far as checkpoints go,...

Sure, I'd LOVE to have dedicated disk(s), but I'd also like to have space on a server so I don't have to do this on my company-issued notebook.

But this is...

To be clear, you can kill a shrink any time with no ill effect, except that the DB or log file will still be large. It will stop with no...

It's already limited to 1G, as I only have 4G of RAM here also. The problem is the OS is giving SQL Server disk activity priority over everything else, and...

I tried going the other way:

While 1=1 --Set up a loop.

Begin

Exec('Update RecipEligToVendorErr

Set InsertedDateTime = ''1/1/1900'' --Default date for records that have nothing here.

Where InsertedDateTime Is Null')

If @@ROWCOUNT = 0

Break

End

And...

Nope, didn't work.

Here's my code:

If Not Exists(Select column_name From information_schema.columns

Where column_name = 'InsertedDateTime'

And table_name = 'RecipEligToVendorErr')

Begin

Begin Transaction

Exec('Alter Table RecipEligToVendorErr

Add InsertedDateTime DateTime')

Commit Transaction

End

--Make sure the field has a...

Found the problem, although I don't necessarily understand yet why it happened. The job step had "dbo" in the "Run As User" text box in Advanced properties of the...

I am not familiar...

Oh so curious behavior.

Perhaps I'm not holding my mouth right:

Use Master

Go

Exec ('exec sp_cycle_errorlog')

As user = 'dbo';

As login = 'sa';

Msg 15247, Level 16, State 1, Procedure sp_cycle_errorlog,...

Steve Jones - Editor (12/14/2009)

---

You could argue that when you dbs are TB sized, they might be more valuable and more in need of protection. I just added 4TB to...

I have been considering TDE, but nixed the idea when I read that once the data is encrypted you have little or no ability to compress it. If your DB...

I did in the first post, Here it is again:

Restore FileListonly from disk = 'G:\SQLBak\VITA_Vikings-FULL-20091209-184349.BAK'

Really simple, standard command.

Version of destination SQL 2005 box:

Microsoft SQL Server 2005 - 9.00.4035.00 (X64) ...