Forum Replies Created

Viewing 15 posts - 16 through 30 (of 313 total)

  • RE: Script DB Level Permissions v4

    My apologies to those replying and leaving feedback for this script.  I am reviewing them and will get an update posted with the provided enhancements.  Also, many thanks for some...

  • RE: T-Log Backup/Restore with Date & Time

    Iwas Bornready (5/17/2016)


    Thanks for the script.

    Welcome, glad you found it useful 🙂

  • RE: Script DB Level Permissions

    sanjay s sarsambi (5/2/2016)


    Steve,The script is really helpful.It runs perfect on SQL 2012, when I run it on SQL SERVER 2008 getting the below error. Can you help...

  • RE: Guess the RTM Build

    13.0.1600.19

  • RE: Script DB Level Permissions v4

    sar99 (3/22/2016)


    Thanks for the script, you may add the CREATE ROLE as well for user defined roles before you add the role member

    Good idea, thanks for the suggestion. Will...

  • RE: Script DB Level Permissions v4

    Andrew G (3/22/2016)


    Thanks S. Kusen, great script.

    You might also want to add SET NOCOUNT ON and update the URL in the comments to this new V4 article.

    Thanks...

  • RE: Script DB Level Permissions

    For those still following this thread, the script was moved to http://www.sqlservercentral.com/scripts/login/138379/[/url] as this particular script/page could not be edited any longer. The admins couldn't figure out why, so...

  • RE: Script DB Level Permissions

    gaganlamba059 (2/26/2016)


    Hi Steve,

    This is an excellen script. However, when I try to use this on SQL Server 2008 R2, It gives me an error:

    "

    Msg 207, Level 16, State 1, Line...

  • RE: Script DB Level Permissions

    salil.dixit1984 (1/14/2016)


    Can we use this script with 'sp_msforeachdb' ? so that we can get a output for all databases on instance level ?

    You could give it a shot. I...

  • RE: Path for sqlservr.exe - Query?

    sqlbuddy123 (1/7/2011)


    Pls Check this ,

    Declare @path nvarchar(100) ...

  • RE: Check SQL Error Logs using Powershell

    Learn_something_new_everyday (11/18/2015)


    Jim Breffni or anyone, anyway to add logic to include/exclude events per server. Example if we have a misbehaving server that has bogus errors how can we exclude the...

  • RE: SQL Server 2008 Build List

    Steve Jones - SSC Editor (10/9/2015)


    My understanding is that you would either install the GDR or QFE, depending on where you were before this. If you look at the KB,...

  • RE: SQL Server 2008 Build List

    Anyone know if the QFE and GDR patches need to be installed "in order" or if the bigger build number includes the other update (a la a mini CU)?

    Meaning, does...

  • RE: Script DB Level Permissions

    Thanks for the feedback. I will review and get an update posted.

  • RE: NoSQL and Getting Involved with It / Or is it a fad?

    RTaylor2208 (7/1/2015)


    I wouldn't say its a fad, but its definitely still in the infancy period. We currently use DynamoDB in Amazon Web Services and MongoDB in on site...

Viewing 15 posts - 16 through 30 (of 313 total)