Forum Replies Created

Viewing 15 posts - 61 through 75 (of 109 total)

  • RE: error at connection at sql server

    Please post your SQL Server error log first

  • RE: Problem in DB mail.

    make sure your smtp server doesnt require any kind of extra authentication and the account you used has the permission to send email.

  • RE: TempDb free space

    use following script to query space used by objects, then figure out what happened.

    ----the tempdb space used by user and by internal objects

    Select

    SUM (user_object_reserved_page_count)*8 as...

  • May 22, 2012 at 2:22 am

    #1490908

  • RE: Log Shipping Restore operation "stuck" at 100% completion

    use sys.dm_exec_requests to check whether the job still running or stucked.

    And you could also check SQL Server errorlog whether any errors.

  • May 22, 2012 at 2:12 am

    #1490901

  • RE: SQL Server 2008 Install Error during New SQL Server Stand-Alone Installation...

    Did u install the SQL Server with local administrator?

    saw following information from setup log:

    -- Error 1402. Could not open key: UNKNOWN\Components\1FA18F7974E099CD0AF18C3B9B1A1EE8\607E70BC7DD53904381A41035D6BAF57. System error 5Verify that you have sufficient access...

  • May 22, 2012 at 2:09 am

    #1490900

  • RE: error at connection at sql server

    Can u connect successfully from local? Can you telnet port 1433?

  • May 22, 2012 at 2:02 am

    #1490891

  • RE: How to restore non-system stored procedure from 2000 Master database to 2000R2 Master database

    You may need do a fully testing to make these ExtendedStoredProcedure.

  • May 22, 2012 at 1:59 am

    #1490888

  • RE: SQL Browser Issues

    Could post Windows event log and SQL Errorl log?

  • May 4, 2012 at 1:49 am

    #1483419

  • RE: User receiving "The user does not have permission to perform this action."

    Have u ever checked windows event log and SQL Server error log? Found anything related?

  • May 4, 2012 at 1:32 am

    #1483412

  • RE: Reporting servcie stopped working and throw dump file

    Add more infomation:

    web config file line 25 <identity impersonate="true" />

  • April 23, 2012 at 11:31 pm

    #1477911

  • RE: Reporting Solution

    I think you may need data warehouse not single reporting and you could only ETL these objects you needed in report not everything. After that, you could optimize your DW...

  • April 18, 2012 at 10:07 pm

    #1475808

  • RE: Connection Timeout to 2005 Reporting Services instance through SSMS

    Open "Reporting Services Configuration" and check the database status.

  • April 18, 2012 at 1:46 am

    #1475184

  • RE: Can modify SQL Server default trace?

    Thanks Gail. I already implemented option 1.

  • December 20, 2011 at 2:09 am

    #1423486

  • RE: Can modify SQL Server default trace?

    Thanks Gail. I think it is better for us to modify max file size, so it could keep more information. And it shouldn't impact performance.

  • December 19, 2011 at 8:43 pm

    #1423372

    Viewing 15 posts - 61 through 75 (of 109 total)