Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 1,518 total)

  • RE: TRY/CATCH not working as expected

    When wrapping the whole thing in a transaction, it works and the CATCH block is reached!

    BEGIN TRAN

    BEGIN TRY

    EXEC LINKSERV.DBNAME.dbo.sprocName

    END TRY

    BEGIN...

    __________________________________________________________________________________
    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 14, 2008 at 2:31 pm

    #789900

  • RE: TRY/CATCH not working as expected

    Thank you GSquared, this was very informative.

    __________________________________________________________________________________
    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 14, 2008 at 12:42 pm

    #789837

  • RE: TRY/CATCH not working as expected

    GSquared (3/14/2008)

    I would tend to think that the problem is that it's running the called proc on SQL 2000, which doesn't have Try/Catch. But that's just a guess based...

    __________________________________________________________________________________
    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 14, 2008 at 12:35 pm

    #789830

  • RE: TRY/CATCH not working as expected

    I did the exact same test on the sql 2000 instance - the linked-server instance - and got the same output:

    Msg 50000, Level 11, State 2, Procedure test_TRY_CATCH, Line 17

    ERROR:...

    __________________________________________________________________________________
    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 14, 2008 at 12:20 pm

    #789813

  • RE: TRY/CATCH not working as expected

    Matt Miller (3/14/2008)

    I can't help but think that somehow it's happening in a different context, or that somehow it's raising an error on the "wrong server". There are a...

    __________________________________________________________________________________
    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 14, 2008 at 12:17 pm

    #789809

  • RE: TRY/CATCH not working as expected

    Come on guys, no takers on this? :w00t:

    __________________________________________________________________________________
    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 14, 2008 at 7:31 am

    #789614

  • RE: CLR object to return Windows groups that a Win acct is a member of

    Todd Engen (2/9/2008)

    The BOL topic Getting Started with CLR Integration is a good place to begin. That will take you through editing, compiling and deploying a CLR stored procedure.

    As...

    __________________________________________________________________________________
    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 13, 2008 at 12:10 pm

    #789251

  • RE: How to grant such a permission?

    Steve Jones - Editor (3/2/2008)

    You cannot add the user to master without them being a member of public.

    Steve,

    Sorry, I'm missing the point, can you elaborate? What are...

    __________________________________________________________________________________
    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 3, 2008 at 1:23 pm

    #784656

  • RE: SQL Server

    I have worked both with ORACLE and with SQL Server, and I must say, my user experience with ORACLE has been abysmal. I have no beef with the database engine...

    __________________________________________________________________________________
    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 3, 2008 at 12:41 pm

    #784624

  • RE: CLR / SQL Server Login Permissions

    demmets (2/28/2008)

    Hi,

    I am a DBA new to CLR and I have a developer who would like to start using CLR. I have started to research CLR but I have...

    __________________________________________________________________________________
    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 2, 2008 at 8:45 am

    #784226

  • RE: How to grant such a permission?

    Sugesh Kumar (2/28/2008)

    No don't create it in the model database as this acts as a template for user DBs to be created and your procedure will be created in all...

    __________________________________________________________________________________
    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 2, 2008 at 8:40 am

    #784225

  • RE: To Test the SQL Email via Query Anaylizer

    If you are referring to SQL mail - not database mail - then just run xp_startmail.

    If SQL mail is working it will simply give you a warning that mail...

    __________________________________________________________________________________
    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 27, 2008 at 12:25 pm

    #782805

  • RE: Database performance

    While SQL Profiler and Perfmon are and will always be valuable tools, a SQL Server 2005 instance already stores a huge amount of information on its operational details in memory...

    __________________________________________________________________________________
    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 27, 2008 at 11:57 am

    #782776

  • RE: How to grant such a permission?

    SQL ORACLE (2/26/2008)

    Here is the scenario.

    A user is a database owner, but has no access at all to master database. Now, the user would like to execute one stored procedure...

    __________________________________________________________________________________
    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 27, 2008 at 10:47 am

    #782726

  • RE: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

    I've had the same error message using Reporting Services:

    see Post #449612 (the 2nd post),

    http://www.sqlservercentral.com/Forums/Topic449604-147-1.aspx

    I haven't been able to resolve this issue yet.

    __________________________________________________________________________________
    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 27, 2008 at 10:27 am

    #782707

Viewing 15 posts - 1,396 through 1,410 (of 1,518 total)