Forum Replies Created

Viewing 15 posts - 31 through 45 (of 63 total)

  • RE: Security for the Dev Team

    Ok, so now that I've gotten that out of the way, here's some of the details of the path I've started down:

    I created a db user [BuiltinAdminUser] in multiple databases....

    September 6, 2011 at 8:08 pm

    #1377765

  • RE: Security for the Dev Team

    Thanks for your replies and input, everyone. I realized after I made the post that it could quickly spiral out of control into a dba's vs developers free-for-all. ...

    September 6, 2011 at 8:06 pm

    #1377764

  • RE: TRY - CATCH with multiple errors

    BTW,

    I found this related submission on MS Connect: Incorrect error number passed to catch block

    Please go there and vote for it as an important issue. (You'll have to...

    December 14, 2010 at 11:07 am

    #1262373

  • RE: TRY - CATCH with multiple errors

    Derrick Smith (10/12/2010)

    In the step of the job on the Advanced tab, specify an output file (.txt). It will log all errors to that.

    Thanks, Derrick. That helps some.

    Ideally, what...

    October 12, 2010 at 3:07 pm

    #1235884

  • RE: TRY - CATCH with multiple errors

    Dave Mason (10/8/2010)

    Msg 3002, Level 16, State 1, Line 1

    Cannot BACKUP or RESTORE a database snapshot.

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    Does SQL Server record...

    October 12, 2010 at 2:25 pm

    #1235868

  • RE: Disabling Indexes

    I guess you could say I'm a little late to the party. 🙂 But thanks, Andy! And thanks to those who have commented.

    You all helped...

    May 26, 2010 at 2:54 pm

    #1173033

  • RE: Using INSERT INTO…SELECT to Bulk Load Data with Minimal Logging

    Followup...

    I'm really reluctant to drop and recreate indexes. Let's say another dba or developer changes the index (add/remove columns to/from the index, change the FILLFACTOR, etc). My code...

    May 26, 2010 at 2:46 pm

    #1173027

  • RE: SQL Server Agent - No Notifications Via Page

    Jack Corbett (3/24/2010)

    I always ask this , but hesitated since other email is getting through, but check your anti-virus settings. Sometimes it blocks email mass mailing worms.

    The only other...

    March 24, 2010 at 3:11 pm

    #1139268

  • RE: SQL Server Agent - No Notifications Via Page

    MeltonDBA (3/23/2010)

    Quick note...I would take that email reference out of your post. Don't think you want alot of people emailing your phone all of the sudden 😀

    Thanks, Shawn. ...

    March 24, 2010 at 3:04 pm

    #1139263

  • RE: SQL Server Agent - No Notifications Via Page

    Jack Corbett (3/23/2010)

    Can you send pages to the pager from your email client (Outlook)?

    In a word, yes.

    March 24, 2010 at 2:55 pm

    #1139252

  • RE: Can't Backup Transaction Log

    Dave Mason (3/1/2010)

    The last time the database was restored was nearly 3 months ago (2009-12-12 15:16:04.330)...

    It looks like I was wrong. The database was restored yesterday from the snapshot....

    March 1, 2010 at 12:45 pm

    #1126655

  • RE: RESTORE VERIFYONLY

    Dave Mason (2/9/2010)

    It appears that there is no return value like you would get from a stored proc or function, just a message that looks like the output of a...

    February 12, 2010 at 3:34 pm

    #1118337

  • RE: Creating A Backup Plan

    Thank you all for your input. It has been very helpful. I made my initial posting after I created some documentation for our backup/DR plan. As I...

    February 9, 2010 at 11:56 am

    #1116310

  • RE: Deleting Backup Info From MSDB

    I stumbled upon this stored proc (which should meet my needs quite nicely): msdb.dbo.sp_delete_backuphistory

    Is this the sp you were referring to, Homebrew?

    January 29, 2010 at 12:15 pm

    #1110934

  • RE: Deleting Backup Info From MSDB

    Thanks, Steve.

    I'm not using SSMS for backups or restores, so I don't think that will be an issue.

    My personal preference is to use tsql to do the the...

    January 29, 2010 at 11:03 am

    #1110891

Viewing 15 posts - 31 through 45 (of 63 total)