Viewing 15 posts - 46 through 60 (of 189 total)
eric.simbozel-943459 (10/13/2009)
Do you have a Spaceanalysis.sln for BIDS 2005 please
No just 2008, the reports are fairly simply and mainly created from SSRS wizard and then changed to use the stored...
October 13, 2009 at 10:06 am
smthembu (10/13/2009)
HiWhen i execute spaceanalysis.job it fails with the below or is it me
Msg 206, Level 16, State 2, Procedure sp_add_jobstep, Line 0
Operand type clash: int is incompatible with uniqueidentifier
October 13, 2009 at 10:03 am
shashi kant (10/13/2009)
Supurb Article, I was looking for such article.Do you have SQL Server 2000 scripts for the same
Regards
Shashi Kant Chauhan
The code works and has been tested against 2000, 2005...
October 13, 2009 at 8:44 am
Somehow I left out the two creation statements for the procedures from the download. The definition for both procedures db_space_capacity_sp and vol_space_capacity_sp are included in the article. I've corrected the...
October 13, 2009 at 6:07 am
Jackie,
I'm glad it worked out. My process for creating articles or blog posts start from something I've implemented at work. This approach requires I remove or account for customizations needed...
October 8, 2009 at 5:18 am
jackie.jones (10/7/2009)
I think I did that bit right because when I looked in the table dt_dim where it had previously had Nulls for the weekends, it now has the...
October 7, 2009 at 3:58 pm
jackie.jones (10/6/2009)
I've tried to change it so that it picks up the backups over the weekend but I've failed miserably!
Could you advise what I need to do to modify...
October 6, 2009 at 3:20 pm
I would agree on the buy decision and I've often wondered why anyone would build their own monitoring system. And if I couldn't buy a solution I would look at...
September 14, 2009 at 1:32 pm
Seems like a lot of trouble to go through. A better option would be to stand up a new 2008 test/upgrade environment on another server to allow developers to continue...
August 13, 2009 at 6:00 am
Thanks for sharing this tip. I can confirm that this works having created a single node cluster 3 years ago on SQL 2005. However, I only had a single node...
June 17, 2009 at 5:36 am
Rui Nogueira (6/4/2009)
Good article, Backup Monitoring and ReportingThere is a mistake in it:
msdb.baclkupset -> msdb.backupset
Thank You
Thanks -- I made a few spelling and grammar corrections, it...
June 5, 2009 at 5:28 am
sanderstad (6/5/2009)
Exception calling "WriteToServer" with "1" argument(s): "Violation of PRIMARY K EY constraint 'PK_backupset_dim'....
June 5, 2009 at 5:17 am
george sibbald (5/5/2009)
In DR scenario my AD administrators will update the DNS entry to point to the DR IP instead of the primary server IP. So in effect, I am...
May 5, 2009 at 4:26 pm
george sibbald (5/4/2009)
sorry to bang on but I need to clarify some points. you are using SQL clusters yes? Because mine are standalone...
May 4, 2009 at 7:00 pm
Viewing 15 posts - 46 through 60 (of 189 total)