Forum Replies Created

Viewing 15 posts - 4,171 through 4,185 (of 4,477 total)

  • RE: Blocking tables issue

    If you have blocking with read uncommitted, this could be due to DDL operations.

    When you have the blocking, check the request_mode of sys.dm_tran_locks and check for schema stability locks....

    December 6, 2016 at 10:53 am

    #1916312

  • RE: How to use a script to update the data source used for connections

    You shouldn't do it using the tables in the ReportServer database. You need to go through the web service. One option listed here:

    https://ask.sqlservercentral.com/questions/98177/modify-multiple-reports-in-ssrs-for-a-specified-da.html

    There are a several powershell scripts...

    December 6, 2016 at 5:53 am

    #1916189

  • RE: SQL Agent Job Manager

    AndrewL65 (12/6/2016)

    Hi Sue,

    I've tried this in the past and couldn't get it to work. I didn't think that creating a proxy would enable non sysadm users to modify any job.

    Regards,

    Andrew

    If...

    December 6, 2016 at 5:32 am

    #1916188

  • RE: Troubleshooting

    tarr94 (12/5/2016)

    Hello,

    I'm not a DBA, but I'm trying to learn more about SQL Server database administration. I'm hoping someone can help me out with this.

    Every month, we track the...

    December 5, 2016 at 10:20 am

    #1916049

  • RE: SQL Agent log Backup job failed

    G Sunny (12/5/2016)

    Hi,

    SQL agent log backup job is failing intermittently in one of our Prod server,

    In job history i can not see the exact issue why it has failing...i can...

    December 5, 2016 at 10:07 am

    #1916045

  • RE: db growth

    kevaburg (12/2/2016)

    JasonClark (12/1/2016)

    you may use this command SP_TRACK_GROWTH

    Where did you get this? I am not aware that this even exists.....

    It doesn't, not as a built in function anyway....

    December 2, 2016 at 2:25 pm

    #1915840

  • RE: the target principal name is incorrect cannot generate sspi context

    New Born DBA (12/1/2016)

    I am able to login and access the DB when I login into the server but when I use SSMS which is installed on my machine, I...

    December 2, 2016 at 2:12 pm

    #1915838

  • RE: Database/Schema Permissions

    RonMexico (12/2/2016)

    I have a feeling this will end up being an easy answer but I'm struggling with it at the moment. We have a database in dev that has...

    December 2, 2016 at 1:44 pm

    #1915829

  • RE: SQL Agent Job Manager

    AndrewL65 (12/1/2016)

    I have a team of developers who have traditionally managed their own agent jobs. I'm now trying to remove their sysadm access to the live servers but this will...

    December 1, 2016 at 12:42 pm

    #1915558

  • RE: SSPI handshake error from 127.0.0.1

    Did you also check the security event log on the server - especially around the time of the errors?

    Sue

    November 30, 2016 at 10:37 am

    #1915242

  • RE: SQL Server 2008 R2/2012/2014

    SQL-DBA-01 (11/27/2016)

    Hello,

    How to check whether the SQL Server reporting service is using :-

    Reporting services Native mode,

    or

    Reporting Services Sharepoint Integrated Mode

    It's listed in the Reporting Services Configuration Manager.

    Or you can...

    November 28, 2016 at 10:25 am

    #1914786

  • RE: LsAlert job is failing on Primary Instance

    Have you verified all the backup logs are in the shared folder?

    Have the latest logs been applied to the secondary?

    Are there issues with the copy, restore jobs?

    Sue

    November 1, 2016 at 3:08 pm

    #1910010

  • RE: Monitor Activty on Cube

    quinn.jay (10/31/2016)

    Hello, what is the best way to see any users and/or current/active connections to a SSAS Cube? Or, if not there, to the SSAS server, to be able to...

    October 31, 2016 at 2:17 pm

    #1909745

  • RE: The backlog is: (null)

    Mindy Hreczuck (10/31/2016)

    I'm comfortable with traces, just which events to trace might be the question. I can't readily reproduce the behavior either. The server ran fine for days after the...

    October 31, 2016 at 1:32 pm

    #1909735

  • RE: SqlQueryNotificationStoredProcedure

    Rechana Rajan (10/31/2016)

    Sue_H (10/27/2016)

    I usually see them with apps that are using SqlDependency and service broker.

    Sue

    Thanks Sue.

    Can i delete those procedures? Its creation date is showing 1 year old.

    Typically...

    October 31, 2016 at 1:10 pm

    #1909728

Viewing 15 posts - 4,171 through 4,185 (of 4,477 total)