Forum Replies Created

Viewing 15 posts - 511 through 525 (of 1,518 total)

  • RE: Being alerted when a certain stored procedure is blocked

    dmoldovan (3/22/2010)

    See if these help:

    http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/04/06/event-notifications-monitoring-blocked-processes-and-other-events-end-to-end-how-to-set-it-up-and-make-it-work.aspx

    http://blogs.microsoft.co.il/blogs/dannyr/archive/2008/10/07/getting-blocking-info-in-sql-server-2005-amp-2008-the-easy-way.aspx

    http://www.sqlservercentral.com/articles/Blocking/64474/

    Thanks! I'll have a look at these links.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    March 22, 2010 at 3:48 am

    #1137463

  • RE: Deployment Error in Analysis Services Tutorial - The source attribute doesn't have the attribute hierarchy enabled

    denglishbi (3/12/2010)

    You can definitely set the AttributeHierarchyVisible property to False, but you must make sure that any attribute that is part of a user defined hierarchy has the AttributeHierarchyEnabled property...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    March 12, 2010 at 8:19 pm

    #1133101

  • RE: Managing SQL Analysis Service Objects with SSIS and AMO

    Marios Philippopoulos (2/26/2010)

    Thanks for the article.

    I'm trying to follow the steps in the article and I'm stuck at the point where we are adding the references in the script task.

    I'm...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 26, 2010 at 9:50 am

    #1125691

  • RE: Managing SQL Analysis Service Objects with SSIS and AMO

    Thanks for the article.

    I'm trying to follow the steps in the article and I'm stuck at the point where we are adding the references in the script task.

    I'm using SSAS...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 26, 2010 at 9:04 am

    #1125651

  • RE: Report on SSAS-cube role properties

    Is Analysis Management Objects (AMO) a good way to go?

    Anyone have any AMO code that does similar things that they could share?

    Also any other feedback on AMO would be appreciated.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 26, 2010 at 8:35 am

    #1125625

  • RE: Trying to Achieve Security and Audit-Trails

    Elliott W (2/24/2010)

    The MS provided tools are not the only tools and blocking them alone not really secure. Basically anything a user can do from SSMS can be done...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 25, 2010 at 11:20 am

    #1125130

  • RE: Trying to Achieve Security and Audit-Trails

    Elliott W (2/24/2010)

    You still haven't addressed the fundamental problem.. So we keep SSMS out, that is nice, but "programname" is set at the client, there are no controls on...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 24, 2010 at 10:38 am

    #1124390

  • RE: Trying to Achieve Security and Audit-Trails

    Elliott W (2/24/2010)

    mphilippopoulos (2/24/2010)

    You can use logon triggers for objectives 2 and 3:

    http://msdn.microsoft.com/en-us/library/bb326598.aspx

    Logon triggers won't help audit WHAT data was changed just that a user logged in and some metadata...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 24, 2010 at 8:40 am

    #1124306

  • RE: Automating SQL Reporting-Services (SSRS) Encryption-Key backups using RSKeyMgmt utility

    Edogg (2/23/2010)

    Stumbled across this link a while ago, it's a handy little trick.

    http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/8976dd8f-44a8-4fb7-b3ac-05b06f33f9f1/%5B/url%5D

    Thanks! That'll work...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 24, 2010 at 3:30 am

    #1124183

  • RE: Reporting Services Encryption Keys - how often should they be backed up?

    Anybody?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 23, 2010 at 11:09 am

    #1123773

  • RE: Preventing users whose logins have access to a database through an application from accessing the database through SQL Client tools

    sihaab (2/10/2010)

    Not at all...It is just a trigger and fires every time when user logs in.

    Believe me, if you are Operational DBA or Production DBA, you need this to...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 10, 2010 at 1:11 pm

    #1117159

  • RE: Preventing users whose logins have access to a database through an application from accessing the database through SQL Client tools

    sihaab (2/10/2010)

    This will help you to understand what is server wide log in audit..

    Link 1)

    Linke 2)

    You can control the user by host name, application and more...

    I Google my self on...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 10, 2010 at 12:01 pm

    #1117057

  • RE: Preventing users whose logins have access to a database through an application from accessing the database through SQL Client tools

    Thank you for the answers.

    The situation is like this: we have given access to the Windows accounts of members of our developer and business-analyst teams so they can provide application...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 10, 2010 at 11:23 am

    #1117039

  • RE: How to kill Rollback process

    GilaMonster (1/29/2010)

    rotkehlchen105-kak (1/29/2010)

    I don't know why people keep saying that the rollback will resume when restarting the server. That's BS

    Nope, it's fact. I can pull error log entries out to...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 3, 2010 at 2:52 am

    #1112717

  • RE: Strange error while doing backups - Error: 3041

    Thanks all for the responses.

    The command is syntactically correct, has run to completion many times before.

    I may have missed a comma or two in my earlier post, as I...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 1, 2010 at 11:53 am

    #1111858

Viewing 15 posts - 511 through 525 (of 1,518 total)