Viewing 15 posts - 121 through 135 (of 205 total)
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
June 29, 2010 at 1:45 pm
That worked. Thanks.
Seems like it should work the other way too, but I'm obviously mistaken there.
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
June 16, 2010 at 6:36 am
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
June 10, 2010 at 6:46 am
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,...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 25, 2010 at 2:01 pm
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 7, 2010 at 12:52 pm
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 7, 2010 at 8:50 am
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 7, 2010 at 7:58 am
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 12, 2010 at 8:05 am
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 12, 2010 at 7:52 am
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 22, 2009 at 7:10 am
Steve Jones - Editor (12/14/2009)
Dell had some cheap ones, and you could check eBay for something used.You can use virtual servers and share the disks that way.
I am not familiar...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 15, 2009 at 5:40 am
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,...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 14, 2009 at 11:58 am
Steve Jones - Editor (12/14/2009)
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 14, 2009 at 9:31 am
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...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 14, 2009 at 8:27 am
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) ...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 11, 2009 at 12:00 pm
Viewing 15 posts - 121 through 135 (of 205 total)