Viewing 15 posts - 1 through 15 (of 37 total)
No it is not necessary to move that one.
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
May 26, 2020 at 4:50 pm
No there are not.
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
May 26, 2020 at 2:57 pm
@jim - I have updated the copy of the ssis package as the previous one was uploaded in error. You will need to create a new integration...
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
January 21, 2016 at 12:27 pm
@smthembu sorry here is the create script
CREATE TABLE [dbo].[SSIS_Errors](
[Server] [varchar](128) NOT NULL,
[TaskName] [varchar](128) NULL,
[ErrorCode] [int] NULL,
[ErrorDescription] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Also, I have updated...
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
January 21, 2016 at 12:25 pm
Jim,
I'm sorry I just now saw this post. Did you figure it out?
Kim
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
January 21, 2016 at 11:57 am
Yes parts of it. You can setup the SPROC, alert and job on each server you want to monitor. Then if you want to capture the data just...
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
July 24, 2013 at 1:36 pm
@terry! If you are copying/pasting out of the article, yes, I do believe formatting did get messed up by the publisher. There is a .sql file at...
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
July 24, 2013 at 6:09 am
If you are copying/pasting out of the article, yes, I do believe formatting did get messed up by the publisher. There is a .sql file at the end of...
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
July 24, 2013 at 6:07 am
@Ian - great addition! I will add this to my daily use. Thanks.
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
July 23, 2013 at 6:54 am
You could definately use the DMV for this info as well. I just like to have an alternative. I always set up a batch of reports for my...
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
July 23, 2013 at 6:31 am
I believe I said in my article that you can attach this to any alert you wanted, however good catch, i'll update my article.
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
July 23, 2013 at 6:30 am
Sorry, my bad! SQL Server 2008 R2 is what I have it running on.
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
July 23, 2013 at 6:27 am
Hi Jim,
Here is a word copy of my article and I added the instruction you asked for.
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
June 7, 2012 at 12:16 pm
Thanks for the feed back everyone! Yes the logs are also a useful way to collect this information. The intention of this article is for an alternative collection...
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
June 6, 2012 at 6:32 am
I don't think this is my issue - no code breaks.
Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
February 27, 2012 at 7:45 am
Viewing 15 posts - 1 through 15 (of 37 total)