Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Using Certificates to Sign Stored Procedures

    Judy Scheinuk (6/21/2010)


    I am trying to allow a non-sysadmin user to run the create login command. Is this possible? I have done the steps in your article but...

  • RE: Sins of SQL: The Time Table

    eshandeepak (6/1/2010)


    When I executed this statement

    SELECT * FROM [MyDB].[dbo].[fn_GetTimestampRange] (DateAdd(YY,-10,GETDATE()), GETDATE(), 1)

    it returned 8726399 records in 2.29 mins and then gave error as

    "The statement terminated. The...

  • RE: Use Dynamic SQL to Improve Query Performance

    Jeff Mason-256568 (5/20/2010)


    What about security?

    If you use stored procedures as a security method, this approach will fail. Some applications use only stored procedures for DB access and completely remove...

Viewing 3 posts - 1 through 3 (of 3 total)